Database Infrastructure Specialist

Database Administrator Position Summary:

• This is a full-time, permanent role for a Database Administrator.
• The successful candidate will be responsible for providing database administrative support for all environments.
• They will ensure optimal performance, data security and reliability of our database infrastructure.
• Responsibilities include software installation, configuration and maintenance of SQL server instances, implementing and managing high availability solutions, and supporting development, QA, PSE and production environments using ServiceNow ticketing system.

Key Responsibilities:

• 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

Requirements:

• Bachelor's degree or equivalent experience
• 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

Preferred Qualifications:

• 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

Additional Information:

• Actual salary is determined based on the role, individual experience, skills, and other considerations
• Role: Other
• Industry Type: Financial Services
• Department: Other
• Employment Type: Full Time, Permanent
• Role Category: Other