Senior Database Administrator

Overview Job Purpose

Provides support to and maintains multiple production and/or non-production databases of significant and/or strategic impact across the enterprise. Responsible for standards and design of physical data storage, maintenance, access and security administration.

• Provide strategic engineering leadership to drive technology improvements

• Take ownership of projects to ensure successful implementation including Tech-Stack upgrade efforts

• Foster relationship and act as a technical liaison between the DBA Team and the Lines of Business

• Performs backup and recovery on Database Management Systems, configures database parameters and prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements

• Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost

• Tune the stored procedures of simple to complex, assist the development team to optimize the application.

• Experience in writing or assisting the T-SQL and Power Shell scripts.

• Ensures service level agreements are met for internal and external clients

• Automate the mundane process using T-SQL or Power Shell scripts.

• Provides status reports that detail issues for escalation to management

• Performs configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systems

• Performs data analysis to provide management with timely and accurate information and predict future requirements

• Develops, implements and tests database backup and recovery policies and procedures.

• Creates and maintains documentation for database policies, procedures, and processes.

• Performs/schedules routine maintenance on databases to keep them running at peak performance.

• Monitors database performance, availability, and capacity

• Review database storage utilization to ensure proper whitespace allocations

• Review and develop trend analysis for incident remediation and prevention

• Participates in continuous business process redesign to improve internal operations

• Interfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational support

• Troubleshoots issues and recommends solutions

• Research and evaluate new RDBMS for possible implementation

• Experience in setting up, managing Distributed Availability groups (DAG) across multiple domains.

• Performs other duties as required

• Bachelor’s Degree in Computer Science, Information Systems or the equivalent combination of education, training, or work experience

• Requires nine (9) or more years of experience working with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environment.

• Required to participate in a 24x7 on-call rotation

• Expert level knowledge of SQL Server database management systems (2012, 2014, 2017, & 2019 [SQL 2022 is a plus])

• Expert level knowledge SQL performance and tuning

• Expert level knowledge of Microsoft Geo-Clustering, Always-On Availability Groups in local & geographically dispersed data centers, Distributed Availability groups (DAG) across multiple domains.

• Extensive knowledge of task automation

• Strong database design and analysis skills

• Knowledge of backup and recovery operations for database management systems

• Knowledge of database encryption such as Always Encrypted, Protegrity, TDE, and TLS

• Knowledge of OS, storage, and network layers for troubleshooting purposes

• Knowledge of relational database concepts and terminology

• Ability to monitor and tune databases and instances

• Ability to maintain and monitor availability, security, and integrity of databases

• Ability to focus on production and customer needs and deliverables

• Ability to adapt to the use of new software tools as they are acquired or adopted within IT

• Strong written and verbal communication skills

• Must be self-motivated, a team player, and have a strong track record in customer satisfaction

• Demonstrated experience with successful system and project implementations

• Knowledge of T-SQL, Power Shell Scripting and Automation

• Knowledge of AWS – RDS SQL

• Knowledge of Microsoft Azure RDBMS

• Knowledge of Cloud SaaS RDBMS

• Knowledge of OLA Hallengren maintenance plans

• Experience with scripting languages

• Strong problem-solving skills

• Ability to work independently and in a team environment with minimal supervision

• Ability to learn and apply new skills in a constantly changing technical environment

Intercontinental Exchange, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to legally protected characteristics.