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

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 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