SQL Database Administrator

As a Database Administrator, you will be responsible for configuring and maintaining database servers and processes. Your role will involve monitoring system health and performance to ensure high levels of performance, availability, and security. You will also troubleshoot and resolve performance issues, with a focus on SQL Server performance tuning. This includes analyzing query execution plans, SQL server profiling, index design and tuning, and index maintenance strategies. Additionally, you will be responsible for database backup management and recovery, as well as handling database administration related projects as needed. In this role, you will respond to critical and non-critical production alerts and be available to be on an on-call rotation schedule to provide production support when critical issues arise. You will also be involved in creating requested database objects and assisting with production releases. To be successful in this position, you should have 6-8 years of SQL Server experience, including 2+ years of SQL Server development experience and 3+ years in Database Administration. A Bachelor's degree in Computer Science or a related major is required. Experience with SQL Server 2016 and 2019 is necessary, along with familiarity with Azure. You should have extensive experience in writing SQL queries and stored procedures, as well as optimizing queries and database objects. Advanced skills in index design and maintenance are also essential. Experience with SQL Server Service Broker, SQL Server in a Windows Cluster environment, and AlwaysOn Availability Groups is preferred. Knowledge of encryption techniques such as TDE and Always Encrypted is beneficial. Experience with monitoring tools like SQL Monitor, Zabbix, SolarWinds, Idera, and System Center is desirable. Strong problem-solving and research skills are essential, along with dedication and willingness to work alternative schedules as necessary. Effective verbal and written communication skills are required for this role. You should be 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 is a plus. Desired qualifications include experience in PostgreSQL.,