Database Engineer

Job description

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 creation of new processes and solutions, while operating under established procedures and processes in a mission critical 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 SQL server instances (On-prem and cloud based)
• Implement and manage 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
• Supports database functions by designing and coding utilities
• 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 knowledge of 19c, 21c and 22c
• A minimum 3+ years of proven relevant experience
• Solid understanding in MSSQL Server and Aurora Postgres database
• Strong knowledge in Python and Angular
• Working knowledge of Oracles Golden gate Replication technology
• Hands on experience in python, Ansible and other scripting languages to automate the tasks
• Ability to work with a high degree of latitude while adhering to established process and procedures
• Good understanding in both how databases fit into systems and how application changes will influence database performance

Primary Skills:

• Proven experience as a Microsoft SQL server Database Administrator (2016 or later)
• Should have worked as a L2 and L3 Engineer or above in managing large scale MSSQL, Oracle and PostgreSQL environments
• 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
• Be able to handle tasks and projects independently with minimum guidance and directions
• 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 best practices on Organizational change / Incident management / Problem management
• Good teammate and should have worked with diverse global teams
• Willing to work on new technologies
• Demonstrated ability to solve complex systems and database environment issues
• Demonstrated ability to work in a complex environment to determine business and customer needs and provide the best solution needed
• Superb communication and collaboration skills

Secondary Skills:

• Strong knowledge on AWS cloud technologies
• Knowledge on ITIL, Processes would be an added advantage
• Should be able to understand interlaying technologies like Networking, Applications, and its impact to Database
• Actual salary is determined based on the role, location, individual experience, skills, and other considerations

Role: Other

Industry Type: Financial Services

Department: Other

Employment Type: Full Time, Permanent

Role Category: Other

Education

UG: Any Graduate

PG: Any Postgraduate

Required Skill Profession

Computer Occupations