About the position
The Successful candidate will be a part of the Global MSSQL DBA team with focus on performance tuning, development, troubleshooting and design 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
- 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
- Ability to operate in the high-pressure environment and troubleshoot complex issues quickly, and successfully handle multiple priorities
- Work closely with Developers and provide guidance on T-SQL coding
- Analyze dynamic queries and provide resolution for slow performing queries
- Deep knowledge of SQL Server internals
- In-depth knowledge on analyzing query plans
- Troubleshoot database-related application performance issues and recommend solutions
- Experience with data modeling - relational database design concepts (OLTP and data warehouse), data modeling languages and specialized software
- Familiarity with normalization - normal forms, denormalization vs no-normalization
- Knowledge of advanced T-SQL programming techniques - window functions, set operators, pivoting/unpivoting, grouping sets
- Automate self service solutions for the database platform
- Work closely with infrastructure personnel, providing technical input to application design of solutions for business and infrastructure projects
Requirements
- 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 nice to have
- 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)
- B.S. in Computer Science, Computer Engineering or equivalent experience
- Documentation skills for processes and procedures (creating KBs, runbooks, topology, etc.)
Nice-to-haves
- Experience with MS SQL production support
Benefits
- Hybrid work flexibility (in-person/remote)
- Work from home flexibility of one day per week
