Intercontinental Exchange Holdings, Inc.

Senior Database Administrator

• Posted 18 days ago • Updated 18 days ago

Full Time

On-site

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

Data Storage
Security Management
Leadership
Warehouse
Stored Procedures
Writing
Service Level
Status Reports
Data Analysis
Policies and Procedures
Documentation
Trend Analysis
Process Reengineering
Interfaces
Research
Computer Science
Information Systems
Training
Testing
Microsoft SQL Server
Management
Microsoft
Clustering
Data Centers
Database Design
Backup
Recovery
Database Administration
Encryption
TDE
TLS
Storage
Network
Database
FOCUS
Communication
Customer Satisfaction
Transact-SQL
Windows PowerShell
Amazon Web Services
Remote Desktop Services
Amazon RDS
SQL
Microsoft Azure
Cloud Computing
SaaS
RDBMS
Scripting
Problem Solving
Conflict Resolution
Supervision
Microsoft Exchange

Summary

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
- 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.
- Ensures service level agreements are met for internal and external clients
- Automate the mundane process using T-SQL or PowerShell scripts.
- 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
- Experience in setting up, managing Distributed Availability groups (DAG) across multiple domains.
- 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
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

Preferred Knowledge and Experience

- 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

-

Intercontinental Exchange, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to legally protected characteristics.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 90922487
Position Id: 23702696
Posted 18 days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Senior Database Administrator

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs