SR SQL SERVER DATABASE ADMINISTRATOR
ABOUT THE COMPANY
Improving experiences is why InMoment exists. Our mission is to help our clients improve experiences at the intersection of value—where customer, employee, and business needs come together. The heart of what we do is connect our clients with what matters most through a unique combination of data, technology, and human expertise. With our hyper-modern technology platform, decades of domain authority, and global teams of experts, we uniquely deliver a focus on Experience Improvement (XI) to help our clients own the moments that matter. Take a moment and learn more at inmoment.com
At InMoment, we believe inclusion and diversity is essential to our success. Our favorite core value is “human” and demonstrating respect and open-mindedness toward others is central to our culture.
Simply put, Leave Your Mark is the brand of InMoment’s culture, but it’s also more than that—it’s a selfless way of living in all areas of life. Every moment offers a new opportunity to make an impact. We take deliberate action to make the lives of our families, teammates, clients, and community better within every interaction. The question is, what mark will you choose to leave?
POSITION SUMMARY
The Senior SQL Server Database Administrator is responsible for maintaining, administering and ensuring the security and stability of InMoment’s SQL Server implementations.
Duties include analyzing, troubleshooting and resolving complex problems involving databases, operating systems and applications. This position requires participation in the development, deployment and support of infrastructure and technology solutions, both from an architectural and operational perspective. This also requires advanced level knowledge and application of High Availability technologies including FCI and Availability Groups. The DBA is challenged to work with architects, application development and operations to help achieve a state-of-the-art environment that meets current and future needs.
KEY RESPONSIBILITIES
- Provide technical guidance during all phases of database related development process
- Work with vendors in evaluating and implementing new technologies
- Present technical information to peers and project teams
- Support other technology and automation projects
- Database installation, configuration, patching, monitoring, maintenance and version upgrades
- Problem isolation, root cause analysis and solution implementation
- Provide technical support, on call and excellent customer service
- Work closely with management, developers, project managers, technical staff and end-users to ensure successful project implementation and deliverables
- Database solution design, performance monitoring, analysis and tuning
- Backup, recovery and DR testing and planning
- Develop, implement and enforce procedures, security policies, standards and best practices to support the operation of database systems
- Ensure high availability and optimum performance of database systems
- Installing and maintaining Failover Clustered Instances and Availability Groups for HA and scale-out reads.
- Clustering, SSIS, data transfers, replication, TSQL
- Research and test new database technologies, share knowledge
- Determine database structural requirements, analyze client operations, applications, review objectives with clients, evaluate current systems
- Be the subject matter expert for all database related projects and initiatives
- Remain current with emerging technologies and suggest adoption when appropriate
SKILLS AND EXPERIENCE
- 5+ years of SQL DBA experience using SQL Server 2008 all the way through to SQL 2019, supporting large-scale production systems with multiple TB of data and providing technical expertise
- Bachelor's degree in related field or equivalent work experience
- Strong understanding of database structures, theories, principles, and practices
- Experience standing up and supporting large MS-SQL Clusters and Availability Groups
- Knowledge and understanding the use of Query Store for tuning, etc.
- Excellent interpersonal, written and oral communication skills
- Work independently and as a team member
- Manage and prioritize multiple assignments, projects and requests
- Be flexible and work analytically in a problem-solving environment
- Excellent organizational, time-management skills and attitude
- Self motivated, process/quality oriented with attention to detail
- Results-oriented nature and a desire to provide excellent customer service
- Strong research, analysis, problem solving and troubleshooting skills
- Programming experience in addition to the other experience is a plus
- Able to prioritize and execute tasks in a high-pressure environment
At InMoment, diversity and inclusion is at the core of who we are. InMoment prides itself on an inclusive culture that promotes, encourages and supports the diverse voices of our employees and clients. We strive to create workplaces that reflect the communities we serve and believe that different perspectives, interests and backgrounds foster a stronger and more creative work environment.