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. 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 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 Ensures service level agreements are met for internal and external clients 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 Performs other duties as required Knowledge and Experience Bachelor’s Degree in Computer Science, Information Systems or the equivalent combination of education, training, or work experience 9+ 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 #J-18808-Ljbffr Intercontinental Exchange