Mastek—Consultant II - DBA

Job description

Description: Job Title Consultant - Oracle DBA (Oracle Cloud / Oracle Core DBA) Expected Work Experience 3 to 6 Years Job Summary Oracle DBA - Oracle Cloud - Oracle Core-DBA (Technical) Consultant-Oracle. 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.