Senior Oracle Database Administrator

Softility; Hyderabad; On-site; INR 2,000,000 - 3,000,000; Full time

Job summary

A technology solutions company located in Hyderabad is looking for an experienced Oracle DBA with a strong background in Oracle technologies and database design. The successful candidate will have over 10 years of experience, and hold an Oracle Certified Professional status. Responsibilities include database upgrades and migrations, as well as providing 24/7 production support. Excellent communication skills and the ability to work in a team are essential for this role.

Qualifications

• 10+ years of experience as an Oracle DBA.
• Oracle Certified Professional status is mandatory.
• Good communication skills and must work well in a team.

Responsibilities

• Provide expertise to DBAs for project-related issues.
• Solve complex production issues.
• Upgrade Oracle databases from version 12c to 19c.
• Migrate Oracle databases to AWS Aurora.
• Implement database encryption and resource management.

Skills

Oracle DBA experience

Understanding of advanced physical database design concepts

Excellent knowledge of SQL and PL/SQL

Strong knowledge of at least one scripting language

Communication skills and teamwork

Education

Bachelor’s degree in Computer Science or related discipline

Tools

Oracle

PostgreSQL

AWS Aurora

DynamoDB

Job description

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.