Oracle Database Admin

The Depository Trust & Clearing Corporation (DTCC)

Hyderabad

Hybrid

INR 1,500,000 - 2,500,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Competitive compensation including base pay and annual incentive

Comprehensive health and life insurance

Pension / Retirement benefits

Paid Time Off and Personal/Family Care

Job summary

A leading financial services firm in Hyderabad is seeking an Oracle Database Administrator. The role involves providing comprehensive database administrative support across various environments including production. Candidates should have over 4 years of experience, a Bachelor's degree, and strong skills in Oracle database management and performance tuning. This position offers a competitive salary and flexible working arrangements.

Qualifications

4+ years of proven relevant experience in Oracle.
Experience in implementing database backup and recovery strategy.
Strong Oracle 19c/21c/22c experience
Knowledge of Python and Angular
Experience with Oracle GoldenGate replication and HA/DR for SQL Server/Oracle

Responsibilities

Provide database administrative support for all DTCC environments.
Software Installation, configure and maintain Oracle server instances.
Optimize SQL queries and indexes for better efficiency.
Participate in root cause analysis for database issues.
Perform backups and recovery strategies
Provide 3rd level support for DTCC production environments

Skills

Strong Oracle Experience of 19c, 21c and 22c

Solid experience in Oracle Database administration

Strong knowledge in Python

Strong knowledge in Angular

Demonstrate strong performance Tuning and Optimization skills in MSSQL, PostgreSQL and Oracle databases

Good Experience in High Availability and Disaster recovery (HA/DR)

Good experience in Backup and restore processes

Proficiency in power shell scripting for automation

Good interpersonal skills

Education

Bachelor's degree or equivalent experience

Tools

PowerShell

Oracle GoldenGate

SQL Server

PostgreSQL

Job description

Join to apply for the Oracle Database Admin role at The Depository Trust & Clearing Corporation (DTCC)

Are you ready to make an impact at DTCC?

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a growing internal community and are committed to creating a workplace that looks like the world that we serve.

Pay And Benefits

Competitive compensation, including base pay and annual incentive
Comprehensive health and life insurance and well-being benefits, based on location
Pension / Retirement benefits
Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

The Impact You Will Have In This Role

The Database Administrator will provide database administrative support for all DTCC environments including Development, QA, client test, and our critical high availability production environment and DR Data Centers. Extensive knowledge on all aspects of MSSQL database administration and the ability to support other database platforms including both Aurora PostgreSQL and Oracle. This DBA will have a high level of impact in the generation of new processes and solutions, while operating under established procedures and processes in a critically important Financial Services infrastructure environment. The Ideal candidate will ensure optimal performance, data security and reliability of our database infrastructure.

What You'll Do

Software Installation, configure and maintain Oracle server instances
Implement and handle High availability solutions including Always ON availability groups and clustering.
Support development, QA, PSE and Production environments using ServiceNow ticketing system.
Review production performance reports for variances from normal operation.
Optimize SQL queries and indexes for better efficiency. Analyze query and recommend the tuning strategies.
Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
Perform database backup and recovery strategy using tools like SQL server backup, log shipping and other technologies.
Provide 3rd level support for DTCC critical production environments.
Participate in root cause analysis for database issues.
Prepare users by conducting training; providing information; and resolving problems.
Maintains quality service by establishing and enforcing organizational standards.
Setup and maintain database replication and clustering solutions.
Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking innovative practices; participating in professional societies.
Will have shared responsibility for off-hour support.
Maintain documentation on database configurations and procedures.
Provide leadership and direction for the Architecture, Design, Maintenance and L1, L2 and L3 Level Support of a 7 x 24 global infrastructure.

Qualifications

Bachelor's degree or equivalent experience

Talents Needed For Success

Strong Oracle Experience of 19c, 21c and 22c.
A minimum 4+ years of proven relevant experience in Oracle
Solid experience in Oracle Database administration
Strong knowledge in Python and Angular.
Working knowledge of Oracle’s Golden gate Replication technology
Demonstrate strong performance Tuning and Optimization skills in MSSQL, PostgreSQL and Oracle databases.
Good Experience in High Availability and Disaster recovery (HA/DR) options for SQL server.
Good experience in Backup and restore processes.
Proficiency in power shell scripting for automation.
Possess Good interpersonal skills and ability to coordinate with various stakeholders.
Follow standard processes on Organizational change / Incident management / Problem management.
Demonstrated ability to solve complex systems and database environment issues.

Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform crucial job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Seniority level