ARCHITECT - Oracle

Happiest Minds Technologies; Bengaluru; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Happiest Minds Technologies invites an experienced Oracle Database Engineer (DBA) to join our Bengaluru team. You will plan, coordinate and administer Oracle databases, ensuring performance, security, and availability for OLTP/OLAP environments.

The role involves automation, documentation, and collaboration with global DBA teams to align with ITIL processes. You will work on upgrades, migrations, data protection, and multi-tenant environments, while mentoring developers and end-users and

Qualifications

• 10+ years of Oracle database management experience (19c & 23ai).
• Strong problem-solving, troubleshooting and analytical skills.
• Experience with DevOps practices and CI/CD tools such as Azure DevOps or Jenkins.

Responsibilities

• Ensure performance, security, and availability of all databases.
• Implement backup, recovery, and migration via automation.
• Collaborate with development teams to design scalable DB structures.
• Provide root-cause analysis for incidents and proactive monitoring.
• Prepare SOE and Runbook documentation and specifications.
• Support on-call rotations in a global DBA environment.

Skills

Problem solving

Communication

Collaboration

CI/CD practices

Resource planning

Scripting

PL/SQL skills

Oracle database tuning

Education

B.S./M.S. in CS/CE or related

Oracle certifications (OCA/OCP/OCM)

Tools

Azure DevOps

Jenkins

Git

Bitbucket

GitHub

GitLab

Ansible

Salt

Chef

PowerShell DSC

Job description

Oracle Database EngineerJob Description

As an Oracle Database Engineer (DBA) you will plan, coordinate and administer database functions, documentation, upgrades, lifecycle, long-range requirements, operational guidelines and data protection. In this role you will regularly work with Business Units to ensure solutions meet or exceed business requirements. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users.

Responsibilities and Tasks

• Ensure performance, security, and availability of all databases.
• Implement common database procedures, such as upgrade, backup, recovery, migration through automation practices.
• Create well designed infrastructure automation deliverables using a variety of tools and approaches.
• Investigate and fix database-related issues, including connectivity problems, performance degradation.
• Partner with development teams to design efficient and scalable database structures.
• Provide timely resolution and root cause analysis for incidents.
• Provide technical guidance and support to developers and end-users.
• Profile server resource usage.
• Prepare SOE and Runbook documentation and specifications.
• Collaborate with database team members, stakeholders, and architects to ensure solutions that are aligned with the global service environment.
• Participate in setting objectives, strategies, plans, programs, performance standards/measures and procedures.
• Understanding and alignment of ITIL change and incident management processes.
• Required to work in 8/5 shift support and weekend rotational On-Call support in collaboration with global DBA teams.

Qualifications / Experience

• At least 10+years of related experience in managing Oracle databases at versions 19c & 23ai
• Excellent problem-solving, troubleshooting and analytical skills
• Good communication and collaboration abilities
• Familiar with devops practices and continuous integration and continuous delivery (CI/CD) tools such as Azure DevOps, or Jenkins.
• Knowledge of version control systems such as Git, Bitbucket, Github, or Gitlab. Ability to work with multiple repositories, branching, and pull request workflows.
• Experience with configuration management tools such as Ansible, Salt, Chef, or Powershell DSC in a GitOps driven environment.
• Ability to plan resource requirements and break down projects from high-level specifications to sub-tasks.
• Apply knowledge and experience in implementation and maintenance of large-scale OLTP and OLAP systems in critical environments including, but not limited to, Oracle Multitenant, Oracle RAC, Oracle Data Guard, RMAN, Oracle Partitioning, Oracle Data pump, Oracle Internet Directory and Oracle Enterprise Manager Cloud Control (OEM)
• Hands-on experience in Oracle Database Performance Tuning
• Solid experience in database upgrades and host migrations
• Proactive and reactive performance analysis, monitoring, troubleshooting and root-cause analysis of database related issues in support of critical day-to-day business operations
• Experience and good knowledge in user management and tablespace management
• Ability to work in a constantly evolving environment and willingness to learn other database technologies (Oracle, InfluxDB, PostgreSQL, MySQL, MSSQL, etc.)
• Experience in designing and automating repetitive processes
• Good hands-on scripting
• Basic understanding of PL/SQL stored procedures and packages is a plus.
• Oracle Certified Associate, Professional or Master (OCA, OCP, OCM) certification is a plus.

Education

B.S. or M.S. degree in Computer Science, Computer Engineering, other technical disciplines, or equivalent work experience.