Skip to main content

Sr. Oracle Database Administrator

Apply now
Primary Location: Mexico City, Mexico Additonal Locations: Noida, India,IND Full time R1281974

Job description

Job Overview
Senior Oracle Database Administrator will be responsible for the management of production and non- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases; Setup and manage data replication; Support release/code deployment activities; perform query tuning and optimization
Essential Functions 
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
•    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

IQVIA is a leading global provider of advanced analytics, technology solutions and clinical research services to the life sciences industry. We believe in pushing the boundaries of human science and data science to make the biggest impact possible – to help our customers create a healthier world. Learn more at https://jobs.iqvia.com

Apply now

Join our Global Talent Network

Let’s stay connected. Join our Global Talent Network to receive alerts when new opportunities become available that match your career ambitions.

Join our network
Top of page