Job Description:
Job Title – Principal - 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, Ec2/RDS 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 Analytical Platform (Snowflake) Admin/Operational Support
The Value You Deliver
Work closely with CTG & EDAI BU in supporting their databases ensuring the stability, performance & help migrate them to public cloud as part of the organization data strategy by partnering with Product teams & Architects
Core duties include:
Work closely with the product development team from the design phase of application & throughout their Agile development journey, the future enhancements & releases
Be part of their Agile Squad planning, understand the priorities & roadmap
Participate in the application stress/load test & proactively identify & resolve the DB performance (batch/OLTP) issues that can potentially breach the SLA’s when the code moves to production
Highlight the new DB features to the product teams that could be used in the application as future enhancements & releases
Support the Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards
Provide DB Capacity Analysis & provide insights to product teams on future storage & hardware requirements based on the current data growth & overall system performance
Identify aging data, propose/develop/implement data archiving, purging & partitioning solutions to manage the data growth
Handling Database/Schema Refreshes for the lower database environments
Understand the RTO/RPO requirements for the application & databases to define the database backup, restore policy & solutioning the MAA (Maximum Availability Architecture)
Managing Database Security Audit violations & resolving them
DB User/Access/Roles management
Troubleshooting & fixing production DB/SQL performance issues (CPU intensive & long running)
Providing Oncall support (12/7), working with vendor on DB issues, bugs & provide solution
Schedule and Co-ordinate various maintenance activities with Support teams.
Data Replication design and implementation using Golden Gate
Work on any new DB technology/new-features, POC requirements from application team
Help the application team in migrating their databases to public cloud (AWS).
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 & basic Data modelling concepts
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 & partitioning.
Analyze Oracle 19c database workloads with emphasis on I/O-intensive & long running SQL queries
Review execution plans, table/index statistics, and storage usage
Identify performance bottlenecks due to full table scans, large table joins, and high-latency disk operations & fine tune the system
Strong on PL/SQL Programming
Working experience on Oracle Golden Gate for Data Replication
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
AWS or relevant cloud technology experience on DB migration to public AWS/Azure from on-prem.
Open-Source Database like PostgreSQL etc.
Knowledge on NO-SQL/Distributed DB’s like MongoDB or Cassandra & Yugabyte or Cockroach.
Basic knowledge on Tableau/PowerBI/Oracle Apex for building dashboards
AWS/Azure/OCI cloud Certified
How Your Work Impacts the Organization
Helping the product teams to migrate their databases to public cloud & achieving the organization’s data strategy on having 70% applications migrated to cloud by 2024 & also providing a stable & highly performing DB environment
The Expertise we’re looking for
8 to 13 years of Oracle DBA (IT) experience
4 + years of experience on Oracle DB & SQL Performance Tuning using various Oracle tools is a must.
1 to 2 or experience in PL/SQL Development & strong in writing effective SQL Queries
Experience on automation using shell scripting or python programming or Oracle APEX
Certification in Oracle or other RDBMS
Location: Bangalore – Manyata
Shift timings: 11 AM to 8 PM