NTT Data has flagged the SQL Server Database Administration Specialist Advisor job as unavailable. Let’s keep looking.

Job Description:

Job Title ; Lead - Database Administration

The Purpose of This Role

Associate will be part of Data Operations COE group within Fidelity Data Architecture & Engineering Division that primarily provides DBA support for multiple RDBMS like Oracle, Oracle E-Business Suite, DB2, PostgreSQL, MongoDB, SQL Server, Netezza & 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 Snowflake Admin Support

The Value You Deliver

Work closely with CTG 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 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 and restore policy
  • Managing Database Security Audit violations & resolving them
  • DB User/Access/Roles management
  • Troubleshooting & fixing production DB/SQL performance issues
  • Providing Oncall support (12/7), working with vendor on DB issues, bugs & provide solution
  • Schedule and Co-ordinate various maintenance activities with Support teams.
  • 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
  • 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 & managing RDS 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

  • AWS or relevant cloud technology experience on DB migration to public AWS/Azure from on-prem.
  • Open Source Database like Maria DB or MySQL etc.
  • Knowledge on NO-SQL DB’s like MongoDB or Cassandra
  • Working experience on Snowflake Cloud Datawarehouse DB
  • Python Programming for Automation or Oracle Apex for building dashboards
  • Basic knowledge on Tableau/PowerBI for reporting

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

The Expertise we’re looking for

  • 5 to 8 years of Oracle DBA (IT) experience
  • 2 + years of experience on Oracle DB/SQL Performance Tuning
  • 1 to 2 years’ experience on managing other databases like PostgreSQL, YugaByte/Cockroach, Snowflake, MS SQL Server, & RDS on AWS would be plus
  • Experience on automation using shell scripting or python programming or Oracle APEX
  • 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

Shift timings: 11 AM to 8 PM

Certifications:

Category:

Information Technology

Read Full Description
Confirmed 11 hours ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles