MS SQL Database Administrator

As a Database Administrator at our company, you will be responsible for managing and supporting SQL Server databases on mission-critical high volume OLTP production systems. You will need to possess a database development background and current experience as a production SQL Server database administrator. Your proactive and self-motivated approach will be essential in taking ideas and turning them into well-defined user stories, ensuring successful implementation. **Responsibilities:** - Configure and maintain database servers and processes, monitoring system health and performance to ensure high levels of performance, availability, and security - Troubleshoot and resolve performance issues - Perform SQL Server performance tuning, including analyzing query execution plans, SQL server profiling, index design and tuning, and index maintenance strategies - Manage database backup and recovery processes - Undertake database administration related projects as required - Respond to critical and non-critical production alerts and be available for an on-call rotation schedule to provide production support during critical issues - Create requested database objects and assist with production releases **Qualifications:** - 4-6 years of SQL Server experience, with 2+ years of SQL Server development experience and 3+ years in Database Administration - Bachelor's degree in Computer Science or a related major - Experience with SQL Server 2016 and 2019 is required - Familiarity with Azure - Proficiency in writing SQL queries and stored procedures - Expertise in optimizing queries and database objects, including advanced skills in index design and maintenance - Knowledge of SQL Server Service Broker, SQL Server in a Windows Cluster environment, and AlwaysOn Availability Groups - Experience with encryption methods like TDE and Always Encrypted - Familiarity with monitoring tools such as SQL Monitor, Zabbix, SolarWinds, Idera, and System Center - Strong problem-solving skills and effective research abilities - Dedication and flexibility to work alternative schedules when necessary - Excellent verbal and written communication skills - Self-motivated with the ability to work both independently and as part of a team - Experience supporting enterprise-level production systems in a fast-paced, high availability server environment **Desired Qualifications:** - Experience in PostgreSQL is a plus Our company has transformed into an inclusive environment where individuals are valued for their talents and empowered to reach their fullest potential. We are dedicated to building a diverse, inclusive, and authentic workplace. If you are excited about our roles and believe in our values but do not perfectly align with every qualification listed, we encourage you to apply anyway. We particularly welcome applicants from traditionally under-represented groups as part of our commitment to increasing workforce diversity and providing fair opportunities for all.,