Consultant II - DBA

Mastek Limited; Indiana (PA); On-site; USD 95,000 - 150,000; Full time

Job summary

Mastek Limited is seeking a Consultant - Oracle DBA to manage Oracle databases across on-premises and Oracle Cloud Infrastructure (OCI). The role emphasizes high availability, performance tuning, security, and compliance for business-critical applications.

Candidates should have 3 to 6 years of hands-on Oracle DBA experience with OCI exposure, RMAN backups, Data Guard/RAC, and scripting skills; willingness to work shifts/on-call as needed.

Qualifications

• 3–6 years hands-on Oracle DBA experience.
• Solid Oracle Cloud Infrastructure (OCI) exposure.
• Proficient RMAN backups, Data Guard, RAC, and security practices.

Responsibilities

• Install, configure, and administer Oracle databases across on-prem and OCI.
• Manage performance tuning, SQL optimization, and resource management.
• Implement and maintain backup/recovery strategies using RMAN.
• Monitor health, capacity, and performance; resolve issues to ensure uptime.
• Perform patching, upgrades, and security hardening per best practices.
• Support migrations to OCI including planning and post-migration stabilization.
• Collaborate with app, infra, and security teams to design scalable DB architectures.
• Troubleshoot incidents and provide root-cause analysis and preventive measures.
• Establish and manage high availability and disaster recovery solutions (Data Guard, RAC).
• Create and maintain DB operation runbooks and SOPs.
• Provide guidance on DB design, capacity planning and performance considerations.

Skills

Oracle DBA exp

Analytical skills

Communication

On-call readiness

Education

Bachelor's degree in CS/IT/Engineering

Tools

OCI (Oracle Cloud Infrastructure)

Job description

Select how often (in days) to receive an alert:

Job Title

Consultant - Oracle DBA (Oracle Cloud / Oracle Core DBA )

Expected Work Experience

3 to 6 Years

Job Summary

Candidate must have relevant experience of 3 to 6 Years.

The role focuses on providing end-to-end database administration, optimization, and support for Oracle databases hosted on-premises and on Oracle Cloud Infrastructure (OCI), ensuring high availability, performance, security, and compliance for business-critical applications.

Key Responsibilities

• Install, configure, and administer Oracle databases across on-premises and Oracle Cloud environments, including creation, cloning, and migration of databases.
• Manage and optimize Oracle Core DBA activities such as performance tuning, query optimization, indexing strategies, and resource management.
• Implement and maintain backup and recovery strategies using RMAN and other Oracle-native tools to ensure minimal data loss and rapid restoration.
• Monitor database health, capacity, and performance, proactively identifying and resolving issues to maintain optimal uptime and reliability.
• Perform database patching, upgrades, and security hardening in line with organizational and vendor best practices.
• Support database migrations to Oracle Cloud Infrastructure, including assessment, planning, execution, and post-migration stabilization.
• Collaborate with application, infrastructure, and security teams to design scalable and resilient database architectures.
• Troubleshoot complex database incidents and provide root cause analysis and preventive measures.
• Implement and manage high availability and disaster recovery solutions such as Data Guard, RAC, and other Oracle technologies where applicable.
• Create and maintain technical documentation, standard operating procedures, and runbooks for database operations.
• Provide consultation and best-practice guidance to stakeholders on database design, capacity planning, and performance considerations.
• Support audits and compliance activities by ensuring database configurations and operations adhere to organizational policies and regulatory requirements.

Other Capabilities

• Strong analytical and problem-solving skills with the ability to handle complex technical issues under time pressure.
• Ability to work effectively in a multicultural environment and collaborate with cross-functional teams and business stakeholders.
• Good communication skills to explain technical concepts to both technical and non-technical audiences.
• Proactive, self-driven, and able to manage priorities across multiple concurrent initiatives.
• Willingness to work in shifts or provide on-call support for critical production environments, as required.

Qualifications and Skills

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent professional experience).
• 3 to 6 years of hands-on experience as an Oracle DBA with strong exposure to Oracle Core DBA activities.
• Solid experience with Oracle Cloud Infrastructure (OCI) or similar cloud platforms for hosting and managing Oracle databases.
• Proficiency in Oracle database administration, including installation, configuration, patching, and upgrades.
• Strong skills in performance tuning, query optimization, and troubleshooting using Oracle tools and views.
• Experience with backup and recovery using RMAN and implementation of disaster recovery strategies.
• Knowledge of high availability solutions such as Data Guard, RAC, and related Oracle technologies.
• Understanding of database security, user management, roles, privileges, and encryption features.
• Familiarity with scripting (such as Shell, Python, or PL/SQL) to automate routine DBA tasks.
• Relevant Oracle certifications (e.g., Oracle Certified Professional, Oracle Cloud certifications) are an added advantage.