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
Skills Required
Database Engineer