Database Administrator

All qualified applicants will receive consideration for employment without regard to legally protected characteristics.

Responsibilities

• Job Purpose Designs and architect’s database solutions.
• Triage at level 3 to find out solutions of medium very complex issues.
• Act as SME for the application supports to provide in depth database needs of databases from design, performance, deployment.
• Automate any mundane tasks.
• Bring new skills and technology to help supporting applications uses latest and greatest design and features.
• Exposure to any of cloud database technologies and free RDBMS/No-SQL experience is an added advantage.
• Responsible for standards and design of physical data storage, maintenance, access, and security administration.
• Responsibilities Designs and architect’s database solutions.
• Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance, and cost.
• Performs data analysis to provide management with timely and accurate information and predict future requirements.
• Ensures service level agreements are met for internal and external clients.
• Provide strategic engineering solutions to drive technological 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 Monitors database performance, availability, and capacity.
• Participates in continuous business process redesign to improve internal operations.
• 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
• Perform troubleshoot Service broker queues, messages flow, and stuck messages flow.
• Perform BizTalk SQL server support and SME to support messages SLA.
• 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
• Expert level knowledge of SQL Server database management systems (2012, 2014, 2017, & 2019 and 2022 [SQL 2025 is a plus]) Expert level knowledge SQL performance and tuning

Requirements

• 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 Microsoft Distributed Availability Group (DAG), Always-On Availability Groups in local and geographically dispersed data centers
• Extensive knowledge of task automation Strong database design and analysis skills
• Expert level Knowledge of backup and recovery operations for database management systems
• Expert level Knowledge of database encryption such as Always Encrypted, Protegrity, TDE, and TLS Expert level
• Knowledge of OS, storage, and network layers for troubleshooting purposes
• Expert level 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 Experience with Service Broker and BizTalk SQL Server integration
• Familiarity with Mainframe flat file ingestion architecture and cross-platform data workflows

Preferred

Familiarity with DB2 to SQL Server migration

• Knowledge and Experience Knowledge of Scripting and Automation Knowledge of Microsoft Azure RDBMS Knowledge of OLA Hallengren maintenance plans 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
• Knowledge of leveraging AI for SQL server admin and support. #LI-JW1 ---------- Intercontinental Exchange, Inc. is an Equal Opportunity Employer.