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, as well as other leaves of absence to support physical, financial, and emotional well-being
- Flexible / hybrid model : 3 days 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 critical database administrative support for all DTCC environments, including Development, QA, client test, and our high-availability production and disaster recovery (DR) data centers.
The role requires extensive knowledge of MSSQL database administration and the ability to support additional database platforms, including Aurora PostgreSQL and Oracle.
This DBA will play a key role in the creation of new processes and solutions, ensuring optimal performance, data security, and reliability within a mission-critical Financial Services infrastructure environment.
What You'll Do
Install, configure, and maintain SQL Server instances (both on-premises and cloud-based)Implement and manage high-availability solutions such as Always On Availability Groups and clusteringSupport development, QA, PSE, and production environments using ServiceNow ticketing systemReview production performance reports for variances from normal operationOptimize SQL queries and indexes for better efficiencyAnalyze queries and recommend tuning strategiesMaintain database performance by calculating optimum values for database parameters and implementing new releasesPerform database backup and recovery strategy using tools like SQL Server backup, log shipping, and other technologiesProvide 3rd-level support for DTCC's critical production environmentsParticipate in root cause analysis for database issuesSupport database functions by designing and coding utilitiesConduct training for users, provide information, and resolve problemsMaintain quality service by establishing and enforcing organizational standardsSetup and maintain database replication and clustering solutionsStay updated with professional knowledge by attending educational workshops, reviewing professional publications, and participating in professional societiesShare responsibility for off-hour support and provide leadership and direction for the Architecture, Design, Maintenance, and Level 1, 2, and 3 (L1, L2, L3) support of a 7x24 global infrastructureMaintain documentation on database configurations and proceduresEducation
Bachelor's degree preferred, or equivalent work experienceTalents Needed for Success
Strong knowledge of Oracle (19c, 21c, 22c)Minimum 7+ years of relevant experienceProficiency in MSSQL Server and Aurora PostgreSQL databasesStrong knowledge of Python and AngularWorking knowledge of Oracle's GoldenGate Replication technologyHands-on experience with Python, Ansible, and other scripting languages to automate tasksAbility to work independently with minimal guidance, while adhering to established processes and proceduresStrong understanding of how databases fit into systems and how application changes influence database performancePrimary Skills
Proven experience as a Microsoft SQL Server Database Administrator (2016 or later)Experience as an L2 and L3 Engineer or higher in managing large-scale MSSQL, Oracle, and PostgreSQL environmentsStrong expertise in performance tuning and optimization in MSSQL, PostgreSQL, and Oracle databasesExtensive experience with High Availability and Disaster Recovery (HA / DR) solutions for SQL ServerIndependent task and project management with minimal guidanceProficient in backup and restore processesExperience with PowerShell scripting for automationExcellent communication skills and ability to coordinate with various stakeholdersFamiliarity with Change Management, Incident Management, and Problem Management best practicesAbility to work as part of a global team and collaborate effectivelyWillingness to work with emerging technologiesDemonstrated ability to solve complex systems and database issuesAbility to determine business and customer needs and provide effective solutionsSecondary Skills
Strong knowledge of AWS cloud technologiesKnowledge of ITIL processes is an added advantageUnderstanding of interrelated technologies like networking and applications , and their impact on databasesSkills Required
Postgresql, Sql Server, Dbms, Oracle Server, Python, Angular, Performance Tuning