Senior Database Administrator

Intercontinental Exchange - Atlanta, GA

Full-time - Mid Level

Remote - Atlanta, GA

5,001-10,000 employees

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The successful candidate will be a part of the Global MSSQL DBA team with a focus on performance tuning, troubleshooting, design, deployment, and production support of Microsoft SQL Servers in a fast-paced and dynamic environment. This role requires a technology enthusiast with strong technical, organizational, and analytical skills. You will be responsible for ensuring that the SQL Database is performant, secure, and stable. You will be expected to troubleshoot and resolve incidents and problems across the IT architecture. This role will help design and implement future database and application solution strategy, technical design, architecture, and support for carrying out the implementation of current firm strategies. The role provides a hybrid work flexibility (in-person/remote) as per ICE policy, which is an appropriate balance between our belief that in-person collaboration is valuable and the reality that new ways of working are possible. You will manage and support our Microsoft SQL Server on On-Prem, Public Cloud & Private Cloud environments, covering all aspects of Availability, Scalability, Performance, and Security for Databases. You will also automate self-service solutions for the database platform and participate in a global on-call rotation and weekly maintenance windows. In this position, you will work closely with Developers, providing guidance on T-SQL coding, analyze dynamic queries, and troubleshoot database-related application performance issues. You will be expected to optimize and fine-tune complex queries and stored procedures, assist in the evaluation, planning, and delivery of the migration and upgrade of existing database applications, and demonstrate a low tolerance for inefficiency with a burning desire to automate anything that can be automated.

Responsibilities

• Manage and support Microsoft SQL Server on On-Prem, Public Cloud & Private Cloud environments.
• Cover all aspects of Availability, Scalability, Performance, and Security for Databases.
• Automate self-service solutions for the database platform.
• Troubleshoot complex issues quickly in a high-pressure environment and handle multiple priorities.
• Participate in a global on-call rotation and weekly maintenance windows.
• Work closely with Developers and provide guidance on T-SQL coding.
• Analyze dynamic queries and provide resolution for slow performing queries.
• Troubleshoot database-related application performance issues and recommend solutions.
• Write advanced T-SQL, leveraging functions, building stored procedures, and optimizing SQL queries.
• Provide production support for the database environment in accordance with agreed service levels, standards, and processes.
• Optimize and fine-tune complex queries and stored procedures.
• Work closely with infrastructure personnel, providing technical input to application design of solutions for business and infrastructure projects.
• Assist in the evaluation, planning, and delivery of the migration and upgrade of existing database applications.

Requirements

• 5+ years of experience in administering SQL Server databases on Windows Platforms.
• 5+ years experience with database and system internals and performance tuning.
• 5+ years SQL Server development covering SQL & T-SQL code.
• 5+ years experience in automation and scripting (Powershell).
• 3+ years of experience working with Microsoft SQL Server Replication, Log shipping.
• 3+ years of experience working with Microsoft SQL Server AlwaysOn Availability Group.
• Proficient in Microsoft SQL Server (2016, 2019).
• Proven experience in database design for performance, security, and scalability.
• Strong working knowledge of Windows Server.
• Strong verbal and written communication skills.
• Excellent technical problem-solving skills and aptitude to learn new technologies and methodologies.
• Professionalism, positive outlook, respect, and courtesy to customers and all associates.
• Demonstrate proficiency in managing large and complex data sets within databases.
• Proven experience in writing, tuning, and analyzing queries and stored procedures.

Nice-to-haves

• Knowledge of advanced T-SQL programming techniques - Windows functions, set operators, pivoting/unpivoting, grouping sets.
• Documentation skills for processes and procedures (creating KBs, SOPs, Runbooks, topology, etc.).

Benefits

• Work from home flexibility of one day per week.