Principal - Database Administrator

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

- Be part of their Agile Squad planning, understand the priorities & roadmap
- 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
- 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

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

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

**Certifications**:
**Category**:
Information Technology