Senior Oracle Database Administrator (Oracle DBA) | AWS| PostgreSQL |

Allegis Global Solutions (AGS); Bengaluru; On-site; INR 2,000,000 - 3,500,000; Full time

Job summary

Allegis Global Solutions (AGS) is seeking a Senior Database Administrator to join the Data Operations COE in Bengaluru. The role focuses on DBA support across Oracle, PostgreSQL, and cloud databases on AWS, with emphasis on stability, performance, and cloud migration as part of the data strategy.

You will work with CST/ETGS BUs and product teams to ensure SLA compliance. The candidate should have strong Oracle DBA skills (12c/19c), RAC, Data Guard, PL/SQL, and shell scripting, plus experience

Qualifications

• Core Oracle DBA skills (Oracle 12c/19c), RAC & Data guard.
• Strong in Oracle Internals & DBA_ Dictionary views.
• Oracle DB/SQL Performance Tuning with relevant tools (SQLTRACE, TKPROF, AWR, ADDM, SQL PROFILE).
• Understanding of access methods, indexes, wait events, and execution plans.
• Experience with GoldenGate for data replication and managing RDS/Databases on AWS.

Responsibilities

• Collaborate with product teams from design through full Agile lifecycle.
• Participate in Agile ceremonies and sprint planning.
• Lead and support application stress and load testing; resolve DB performance bottlenecks.
• Recommend new database features and capabilities for product enhancements.
• Support migrations and version upgrades per lifecycle management.
• Plan capacity and growth analysis for storage, compute, and hardware.

Skills

Oracle DBA

RAC

Data Guard

Oracle Internals

PL/SQL

Shell scripting

SQL Performance Tuning

AWS/Azure/OCI

PostgreSQL

GoldenGate

Education

Bachelor's degree in IT/CS

Tools

Oracle GoldenGate

AWS RDS

Job description

Location: Bangalore

Skillset : Oracle DBA, Oracle Database Administration, AWS, PostgreSQL, Golden Gate (good to have)

Note Mandatory: Shortlisted candidates must be available to attend the 1st Round of Face-to-Face (F2F) interview at the Bangalore location.

Job Description:

Job Title

Senior Database Administrator

The Purpose of This Role

Associate will be part of Data Operations COE group within Enterprise Data & AI Division that primarily provides DBA support for multiple RDBMS like Oracle, Oracle E-Business Suite, DB2, PostgreSQL, MongoDB, SQL Server, RDS & Ec2 on AWS. In addition, this team is also responsible for Data Lake Operations on Cloud that supports Nifi (ELT Tool), Collibra Data Governance, Alation Data Catalogue Enterprise Tools & Platform Engineering (Informatica, Middleware), Data Masking (TDM) & Enterprise Snowflake Platform Support

The Value You Deliver

Work closely with CST/ETGS BUs in supporting their databases, ensuring stability, performance & help migrate them to public cloud as part of the organization data strategy by partnering with Product teams & Architects

The Core duties include:

• Partner closely with product development teams from the design phase through the full Agile development lifecycle, including future enhancements and production releases.
• Actively participate in Agile squad ceremonies, including sprint planning, to understand product priorities, roadmaps, and delivery timelines.
• Lead and support application stress and load testing, proactively identifying and resolving database performance bottlenecks (OLTP and batch) to ensure SLA compliance before production releases.
• Proactively recommend and evangelize new database features and capabilities that can be leveraged by product teams for future enhancements.
• Support database migrations and version upgrades as part of Technology Lifecycle Management, ensuring compliance with organizational and audit standards.
• Perform database capacity planning and growth analysis, providing insights on future storage, compute, and hardware requirements based on data growth trends and performance metrics.
• Identify aging and high-volume data and design, develop, and implement data archiving, purging, and partitioning strategies to efficiently manage database growth.
• Manage and execute database and schema refreshes for lower (non-production) environments.
• Define and implement backup, recovery, and restore strategies aligned with application RTO/RPO requirements.
• Address and remediate database security audit findings, ensuring adherence to security, compliance, and governance standards.
• Manage database users, access controls, roles, and privileges in line with least-privilege and compliance principles.
• Troubleshoot and resolve production database and SQL performance issues, ensuring high availability and system stability.
• Provide 12x7 on-call support, collaborate with vendors on database-related issues and bugs, and drive issues to resolution.
• Plan, schedule, and coordinate database maintenance activities with application and support teams to minimize operational impact.

The Skills that are Key to this role

Technical / Behavioral

• Core Oracle DBA skills (Oracle 12c/19c), RAC & Data guard
• Strong in Oracle Internals & DBA_ Dictionary views
• Oracle DB/SQL Performance Tuning & relevant tools (SQLTRACE, TKPROF, AWR, ADDM, SQL PROFILE, SQL BASELINES)
• Good understanding on Access Methods, Joins, different Indexes & its usage, Index scans, interpreting EXECUTION PLANS, Table/Index Statistics, Histograms, wait events etc
• Working experience on Oracle Golden Gate for Data Replication, PostgresDB, Azure SQL MI & managing RDS/Databases on AWS
• Strong on PL/SQL Programming
• Working experience on Shell scripting for Automation
• Problem solving and good analytical skills
• Communication, teamwork and negotiation skills
• Ability to work in tight deadlines under pressure
• Flexible and adaptable to changing business/technology requirements
• A sense of ownership that drives quality in everything you do
• A forward-looking attitude that keeps you aware of the latest in database & cloud technology space

The Skills those are good to have for this role

• Knowledge of distributed databases like Yugabyte, Cockroach DB, etc
• Experience on Snowflake Cloud Datawarehouse DB
• Basic knowledge BI tools Tableau/PowerBI for reporting

How Your Work Impacts the Organization

Enabling stable, highperforming database environments while delivering an exceptional customer experience

The Expertise we’re looking for

• 5 to 9 years of DBA (IT) experience
• 2 + years of experience on Oracle DB/SQL Performance Tuning
• 1 to 2 years’ experience on managing other databases like MS SQL Server, PostgresDB, Snowflake & cloud
• Experience Automation skills using Shell scripting, Python etc
• Bachelor’s degree in any technology related field (e.g, Engineering, Computer Science, Maths, etc.) required.
• Oracle Certification or other RDBMS certifications
• AWS/Azure/OCI cloud Certified.

Regards,

Franklin.A

Talent Acquisition