Senior Database Administrator
Intercontinental Exchange
- Atlanta, GA
- Permanent
- Full-time
- 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
- 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
- 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.