Senior Oracle Database Administrator

Employment Type :
Full-time

Experience :
5 to 15 Years

Required Skills :

• Bachelor’s degree in Computer Science or a related discipline, or equivalent experience with Oracle or similar relational database technologies
• At least 10 years of Oracle DBA experience
• Must be an Oracle Certified Professional
• Thorough knowledge of Oracle technology, such as CDB/PDB, RAC, DataGuard, Exadata, Goldengate, and Grid Control
• Understanding of advanced physical database design concepts like database partitioning, denormalization, buffer pool tuning, and index optimization.
• Strong knowledge of at least one scripting language
• Excellent knowledge of SQL, PL/SQL, Packages, and Stored Procedures
• Knowledge and experience with DynamoDB, PostgreSQL, or AWS Aurora is a plus
• Good communication skills and must work well in a team environment
• Required to provide 24/7 production support on a rotation schedule

Responsibilities :

• Provide expertise to DBAs to address a specific issue or a project
• Solve complex production issues to closure
• Upgrade databases from version 12c to 19c
• Migrate and convert Oracle databases to PostgreSQL
• Migrate on-prem Oracle databases to AWS Aurora
• Migrate Oracle databases from legacy hardware to Oracle Exadata machines
• Implement database encryption, compression, and resource management plans
• Create replication between databases, whether on-prem or in a cloud environment
• Apply database patchsets as required by Infosecurity requirements
• Assist application teams in deployments and release work
• Serves as a strong technical resource and works independently with systems management, project managers, etc.