Company:
Intercontinental Exchange Holdings, Inc.
Location: Atlanta
Closing Date: 04/12/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Overview:
Job Purpose
The Successful candidate will be a part of the Global MSSQL DBA team with 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.
Responsibilities
Deep knowledge of SQL Server internals
Expert skills in writing advanced T-SQL, window functions, set operators, pivoting/unpivoting, grouping sets, as well as building complex stored procedures
In-depth knowledge on analyzing query plans, can optimize and fine tune complex queries and stored procedures
Ability to operate in the high-pressure environment and troubleshoot complex issues quickly, and successfully handle multiple priorities.
Excellent programming and problem solving skills with an aptitude to learn and apply new technology skills
Work closely with Developers and provide guidance on T-SQL coding
Troubleshoot database-related application performance issues and recommend solutions
Provide production support for on-prem and cloud database environment in accordance with agreed service levels, standards, and processes
Cover all aspects of Availability, Scalability, Performance and Security for Databases.
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
Knowledge sharing and training to other team members
Knowledge and Experience
10+ years of experience in administering SQL Server databases on Windows Platforms
7+ years SQL Server development (2008-2019).
7+ years experience with database and system internals and performance tuning.
7+ years SQL Server development covering SQL & T-SQL code.
5+ years experience in automation and scripting (Powershell, shell)
3+ years of experience working with Microsoft SQL Server Replication
3+ years of experience working with Microsoft SQL Server Always On Availability Gropup
B.S. in Computer Science, Computer Engineering or equivalent experience.
Proven experience in writing, tuning and analyzing queries and stored procedures
Experience with managing and troubleshooting databases in high performance, multi-user applications.
Proficient in Microsoft SQL Server (2016, 2019) and ability to apply SQL Server capabilities to business challenges
Proven experience in database design for performance, security and scalability.
Strong working knowledge of Windows Server, VMs, Network, all aspects of infrastructure supporting MSSQL Server
Excellent technical problem-solving skills and aptitude to learn new technologies and methodologies.
Professionalism, positive outlook, respect and courtesy to customers and all associates.
Strong verbal and written communication skills.
Documentation skills for processes and procedures (creating KBs, runbooks, topology, etc.)
Demonstrate proficiency in managing large and complex data sets within databases
Experience with MS SQL production support is essential. The candidate should be motivated, hands on, sensitive to risks and controls, work well under pressure and possess solid problem analysis/troubleshooting/design/performance & tuning skills
Experience in working in a 24/7 team managing large data centers
Schedule
This role offers work from home flexibility of 1 day per week.
Intercontinental Exchange, Inc. is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin or ancestry, age, disability or veteran status, or other protected status.
#LI-FL1
#LI-Hybrid
Job Purpose
The Successful candidate will be a part of the Global MSSQL DBA team with 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.
Responsibilities
Deep knowledge of SQL Server internals
Expert skills in writing advanced T-SQL, window functions, set operators, pivoting/unpivoting, grouping sets, as well as building complex stored procedures
In-depth knowledge on analyzing query plans, can optimize and fine tune complex queries and stored procedures
Ability to operate in the high-pressure environment and troubleshoot complex issues quickly, and successfully handle multiple priorities.
Excellent programming and problem solving skills with an aptitude to learn and apply new technology skills
Work closely with Developers and provide guidance on T-SQL coding
Troubleshoot database-related application performance issues and recommend solutions
Provide production support for on-prem and cloud database environment in accordance with agreed service levels, standards, and processes
Cover all aspects of Availability, Scalability, Performance and Security for Databases.
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
Knowledge sharing and training to other team members
Knowledge and Experience
10+ years of experience in administering SQL Server databases on Windows Platforms
7+ years SQL Server development (2008-2019).
7+ years experience with database and system internals and performance tuning.
7+ years SQL Server development covering SQL & T-SQL code.
5+ years experience in automation and scripting (Powershell, shell)
3+ years of experience working with Microsoft SQL Server Replication
3+ years of experience working with Microsoft SQL Server Always On Availability Gropup
B.S. in Computer Science, Computer Engineering or equivalent experience.
Proven experience in writing, tuning and analyzing queries and stored procedures
Experience with managing and troubleshooting databases in high performance, multi-user applications.
Proficient in Microsoft SQL Server (2016, 2019) and ability to apply SQL Server capabilities to business challenges
Proven experience in database design for performance, security and scalability.
Strong working knowledge of Windows Server, VMs, Network, all aspects of infrastructure supporting MSSQL Server
Excellent technical problem-solving skills and aptitude to learn new technologies and methodologies.
Professionalism, positive outlook, respect and courtesy to customers and all associates.
Strong verbal and written communication skills.
Documentation skills for processes and procedures (creating KBs, runbooks, topology, etc.)
Demonstrate proficiency in managing large and complex data sets within databases
Experience with MS SQL production support is essential. The candidate should be motivated, hands on, sensitive to risks and controls, work well under pressure and possess solid problem analysis/troubleshooting/design/performance & tuning skills
Experience in working in a 24/7 team managing large data centers
Schedule
This role offers work from home flexibility of 1 day per week.
Intercontinental Exchange, Inc. is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin or ancestry, age, disability or veteran status, or other protected status.
#LI-FL1
#LI-Hybrid
Share this job
Useful Links