Senior Database Administrator

Intercontinental Exchange Holdings, Inc. • Jacksonville, FL

78d

About The Position

The position provides support to and maintains multiple production and/or non-production databases of significant and/or strategic impact across the enterprise. The role is responsible for standards and design of physical data storage, maintenance, access, and security administration.

Requirements

• 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

Nice To Haves

• Knowledge of T-SQL, PowerShell 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

Responsibilities

• 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
• Perform backup and recovery on Database Management Systems, configure database parameters and prototype designs against logical data models, and define data repository requirements, data dictionaries and warehousing requirements
• Optimize database access and allocate/re-allocate 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 PowerShell scripts
• Ensure service level agreements are met for internal and external clients
• Automate the mundane process using T-SQL or PowerShell scripts
• Provide status reports that detail issues for escalation to management
• Perform configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systems
• Perform data analysis to provide management with timely and accurate information and predict future requirements
• Develop, implement and test database backup and recovery policies and procedures
• Create and maintain documentation for database policies, procedures, and processes
• Perform/schedule routine maintenance on databases to keep them running at peak performance
• Monitor database performance, availability, and capacity
• Review database storage utilization to ensure proper whitespace allocations
• Review and develop trend analysis for incident remediation and prevention
• Participate in continuous business process redesign to improve internal operations
• Interface with user departments remotely and on-site to assist in the implementation of work requests and provide operational support
• Troubleshoot issues and recommend solutions
• Research and evaluate new RDBMS for possible implementation
• Experience in setting up, managing Distributed Availability groups (DAG) across multiple domains
• Perform other duties as required

What This Job Offers

• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees