Intercontinental Exchange
Database Administrator IV
Intercontinental Exchange, Jacksonville, Florida, United States, 32290
Overview
Job PurposeProvides 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.ResponsibilitiesProvide strategic engineering leadership to drive technology improvementsTake ownership of projects to ensure successful implementation including Tech-Stack upgrade effortsFoster relationship and act as a technical liaison between the DBA Team and the Lines of BusinessPerforms 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 requirementsOptimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and costEnsures service level agreements are met for internal and external clientsProvides status reports that detail issues for escalation to managementPerforms configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systemsPerforms data analysis to provide management with timely and accurate information and predict future requirementsDevelops, 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 capacityReview database storage utilization to ensure proper whitespace allocationsReview and develop trend analysis for incident remediation and preventionParticipates in continuous business process redesign to improve internal operationsInterfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational supportTroubleshoots issues and recommends solutionsResearch and evaluate new RDBMS for possible implementationPerforms other duties as requiredKnowledge and ExperienceBachelor's Degree in Computer Science, Information Systems or the equivalent combination of education, training, or work experienceRequires 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 rotationExpert level knowledge of SQL Server database management systems (2012, 2014, 2017, & 2019 [SQL 2022 is a plus])Expert level knowledge SQL performance and tuningExpert level knowledge of Microsoft GEO-Clustering and Always-On Availability Groups in local and geographically dispersed data centersExtensive knowledge of task automationStrong database design and analysis skillsKnowledge of backup and recovery operations for database management systemsKnowledge of database encryption such as Always Encrypted, Protegrity, TDE, and TLSKnowledge of OS, storage, and network layers for troubleshooting purposesKnowledge of relational database concepts and terminologyAbility to monitor and tune databases and instancesAbility to maintain and monitor availability, security, and integrity of databasesAbility to focus on production and customer needs and deliverablesAbility to adapt to the use of new software tools as they are acquired or adopted within ITStrong written and verbal communication skillsMust be self-motivated, a team player, and have a strong track record in customer satisfactionDemonstrated experience with successful system and project implementations
PreferredKnowledge of PowerShell Scripting and AutomationKnowledge of AWS - RDS SQLKnowledge of Microsoft Azure RDBMSKnowledge of Cloud SaaS RDBMSKnowledge of OLA Hallengren maintenance plansExperience with scripting languagesStrong problem-solving skillsAbility to work independently and in a team environment with minimal supervisionAbility to learn and apply new skills in a constantly changing technical environmentScheduleThis role offers work from home flexibility of one day per week.Intercontinental Exchange, Inc. is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin or ancestry, age, disability or veteran status, or other protected status.P
Job PurposeProvides 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.ResponsibilitiesProvide strategic engineering leadership to drive technology improvementsTake ownership of projects to ensure successful implementation including Tech-Stack upgrade effortsFoster relationship and act as a technical liaison between the DBA Team and the Lines of BusinessPerforms 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 requirementsOptimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and costEnsures service level agreements are met for internal and external clientsProvides status reports that detail issues for escalation to managementPerforms configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systemsPerforms data analysis to provide management with timely and accurate information and predict future requirementsDevelops, 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 capacityReview database storage utilization to ensure proper whitespace allocationsReview and develop trend analysis for incident remediation and preventionParticipates in continuous business process redesign to improve internal operationsInterfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational supportTroubleshoots issues and recommends solutionsResearch and evaluate new RDBMS for possible implementationPerforms other duties as requiredKnowledge and ExperienceBachelor's Degree in Computer Science, Information Systems or the equivalent combination of education, training, or work experienceRequires 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 rotationExpert level knowledge of SQL Server database management systems (2012, 2014, 2017, & 2019 [SQL 2022 is a plus])Expert level knowledge SQL performance and tuningExpert level knowledge of Microsoft GEO-Clustering and Always-On Availability Groups in local and geographically dispersed data centersExtensive knowledge of task automationStrong database design and analysis skillsKnowledge of backup and recovery operations for database management systemsKnowledge of database encryption such as Always Encrypted, Protegrity, TDE, and TLSKnowledge of OS, storage, and network layers for troubleshooting purposesKnowledge of relational database concepts and terminologyAbility to monitor and tune databases and instancesAbility to maintain and monitor availability, security, and integrity of databasesAbility to focus on production and customer needs and deliverablesAbility to adapt to the use of new software tools as they are acquired or adopted within ITStrong written and verbal communication skillsMust be self-motivated, a team player, and have a strong track record in customer satisfactionDemonstrated experience with successful system and project implementations
PreferredKnowledge of PowerShell Scripting and AutomationKnowledge of AWS - RDS SQLKnowledge of Microsoft Azure RDBMSKnowledge of Cloud SaaS RDBMSKnowledge of OLA Hallengren maintenance plansExperience with scripting languagesStrong problem-solving skillsAbility to work independently and in a team environment with minimal supervisionAbility to learn and apply new skills in a constantly changing technical environmentScheduleThis role offers work from home flexibility of one day per week.Intercontinental Exchange, Inc. is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin or ancestry, age, disability or veteran status, or other protected status.P