IQVIA Jobs

Job Overview

Designs or modifies data models to solve complex database requirements considering business and application needs. Organizes metadata for use by teams.

Essential Functions

• Designs or modifies data models to solve complex database requirements considering business and application needs. Organizes metadata for use by teams.

• Plans, conducts and coordinates the design of state-of-the-art data model designs and metadata management.

• Provides application-level data modeling for project development teams.

• Assists with creating and maintaining enterprise-wide data standards.

• Participates in enterprise-wide logical data modeling and leads efforts on assigned data subject areas.

• Assists with the implementation of metadata management tools.

• Facilitates formal and informal discussions to support database designs.

• Participates in the implementation and management of the global metadata repository.

• Identifies metadata sources, develops metadata management capabilities, monitors metadata quality, and develops common data definitions.

• Coordinates testing and documentation of the global metadata repository and conducts user interviews to gather metadata requirements to insure business requirements are met.

Conduct the following for Oracle on Solaris and Linux and other related products as applicable and necessary

• Install/Configure/Setup/Administer and Maintain production and non-production environments

• Setup High-Availability and Disaster Recovery

• Plan, configure, maintain and test high availability and disaster recovery

• Configure and maintain DB replicas for either oracle (dataguard, golden gate)

• Identify and get necessary alerts setup to monitor database

events/situations/activities

• Create Users and assign/manage permissions based on the level of access

the user would need; ensure robust and full proof security of assets

• Resolve database integrity, performance, blocking, connectivity, and replication

issues.

• Detect and resolve database-related CPU, memory, I/O, disk space and other

contention issues.

• Perform and manage Database backup/recovery/restore and capacity

monitoring

• Refresh and cloning of production databases into test environments

• Maintain databases – Statistics, Indexes, fragmentation

• Conduct Performance tuning and optimization (Stored procedures, Views,

Functions, Queries, database etc) using Oracle Enterprise Manager Advanced,

AWR, DMVs

• Implement operational automation using scripts.

• Upgrade and maintain Oracle and related software (apply patches and

updates when necessary)

• Coordinate removal and/or archiving of data that is no longer required to be

available in the production databases.

• Design and create databases to support development initiatives

• Support release/code deployment activities

• Develop and maintain SunOS/Solaris/Linux Shell Scripts

• Develop and maintain and packages, materialized views

• Provide 24x7 support as necessary

• Mentor junior/new DBA team members

• Manage a team of DBAs if necessary

Qualifications

• Bachelor's Degree Computer Science, a related field, or equivalent experience

Req

• Database systems knowledge with a minimum of five (5) years IT with two (2) years experience in the data administration area. Req

• Expertise with Oracle version 10.x to latest, Oracle Enterprise Manager Advanced

• Expertise in SunOS/Solaris/Linux Redhat

• Advanced PL/SQL Programming and troubleshooting skills

• Advanced Expertise in RMAN and ASM

Q² Solutions, IQVIA’s laboratory business, creates connected intelligence by combining our expertise, technology and analytics - this fuels unparalleled research & development solutions. We uphold a deep commitment to patients, sites, customers, and each other. https://www.q2labsolutions.com/careers

We are committed to providing equal employment opportunities for all, including veterans and candidates with disabilities. https://jobs.iqvia.com/q2-solutions-eoe

Q² Solutions’ ability to operate and provide certain services to customers and partners necessitates Q² Solutions and its employees meet specific requirements regarding COVID-19 vaccination status. https://jobs.iqvia.com/q2-solutions-covid-19-vaccine-status

The potential base pay range for this role, when annualized, is $105,000.00 - $157,000.00. The actual base pay offered may vary based on a number of factors including job-related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part-time). Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.

IQVIA is a world leader in using data, technology, advanced analytics, and expertise to help customers drive healthcare – and human health – forward. Together with the companies we serve, we are enabling a more modern, more effective and more efficient healthcare system, and creating breakthrough solutions that transform business and patient outcomes.

To get there, it takes diverse skills and a curiosity to explore new possibilities. No matter your role, everyone at IQVIA, including our colleagues at Q² Solutions, contributes to our shared goal of improving human health. Thank you for your interest in growing your career with us.

EEO Minorities/Females/Protected Veterans/Disabled