Experience
10 - 15 yrs
Job Location
Hyderabad, India
Vacancy
1
Designation
Senior Oracle Database Administrator
Job Type
Not specified
Job Description
- 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.