SIGNUP

Job Opportunities

Find jobs near you, whether onsite, hybrid, or remote.
  • Similar Jobs to: Senior Database Administrator
XX
Senior Database AdministratorIce Services • Atlanta, Georgia, United States
Apply Now
XX

Senior Database Administrator

Ice Services
  • US
    Atlanta, Georgia, United States
  • US
    Atlanta, Georgia, United States
Apply Now

About

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.
Responsibilities
Manage and support our 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.
Ability to operate in the high-pressure environment and troubleshoot complex issues quickly, and successfully 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
Knowledge of advanced T-SQL programming techniques - window functions, set operators, pivoting/unpivoting, grouping sets
Provide production support for database environment in accordance with agreed service levels, standards, and processes
Expert skills in writing advanced T-SQL, leveraging functions, building stored procedures and optimizing SQL queries
Excellent programming and problem-solving skills with an aptitude to learn and apply new technology skills
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
Low tolerance for inefficiency and the burning desire to automate anything that can be automated
Knowledge And Experience
B.S. in Computer Science, Computer Engineering or equivalent experience.
10+ 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, shell)
3+ years of experience working with Microsoft SQL Server Replication
3+ years of experience working with Microsoft SQL Server Always On Availability Group
3+ years of experience working with MongoDB database
Documentation skills for processes and procedures (creating KBs, SOPs, Runbooks, topology, etc.)
Experience with managing and troubleshooting databases in high performance, multi-user web applications.
Proficient in Microsoft SQL Server (2016, 2019).
Proficient in applying Microsoft SQL Server capabilities to business problems.
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
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
Knowledge in MongoDB database administration is a plus.
Equal Opportunity Statement Intercontinental Exchange, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to legally protected characteristics.
#J-18808-Ljbffr
  • Atlanta, Georgia, United States

Languages

  • English
Notice for Users

This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.