About This Role
Designing and architecting database solutions is the core of this role, which also involves triaging complex issues at level 3 and acting as a subject matter expert for application support. The administrator will provide in-depth database expertise from design to performance and deployment, automate mundane tasks, and bring new skills and technology to support applications with the latest designs and features. Exposure to cloud database technologies and free RDBMS/No-SQL experience is an added advantage. This position is responsible for the standards and design of physical data storage, maintenance, access, and security administration.
Responsibilities
- Design and architect database solutions
- Optimize database access and allocate/re-allocate database resources for optimum configuration, database performance, and cost
- Perform data analysis to provide management with timely and accurate information and predict future requirements
- Ensure 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 relationships and act as a technical liaison between the DBA Team and the Lines of Business
- Monitor database performance, availability, and capacity
- Participate in continuous business process redesign to improve internal operations
- 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
- Provide status reports that detail issues for escalation to management
- Perform configuration, scripting, analysis, installation, monitoring, administration, and tuning for database management systems
- Perform troubleshoot Service Broker queues, message flow, and stuck message flow
- Perform BizTalk SQL server support and act as SME to support message SLA
- 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
- Review database storage utilization to ensure proper whitespace allocations
- Review and develop trend analysis for incident remediation and prevention
- 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
- Perform other duties as required
Requirements
- 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 and 2022)
- Expert level knowledge of SQL performance and tuning
- 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
- Familiarity with DB2 to SQL Server migration
Nice to have:
- SQL 2025 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
About the Company
Intercontinental Exchange, Inc. is an Equal Opportunity Employer.
