Position Summary

　　The SQL Server Database Administrator (DBA) plays a crucial role in optimizing our operational and application database infrastructure. Working closely with developers and operation teams, the DBA is responsible for managing SQL Server databases, optimizing database performance, and ensuring seamless data manipulation and retrieval. Key responsibilities encompass deploying SQL scripts, handling schema changes, and monitoring performance, all while adhering to best practices for data management and security.

　　Essential Duties and Responsibilities

　　The essential functions include, but are not limited to the following:

　　Deploy SQL scripts, schema changes, data imports, data manipulation, and data quality fixes. Optimize query and database performance, conducting performance analysis and tuning. Design and implement database environments upgrades. Troubleshoot and resolve production issues, providing after-hours support based on an on-call schedule when necessary. Analyze and resolve database performance issues, including concurrency, locking, blocking, and deadlock challenges. Write and review SQL scripts, including T-SQL, PowerShell, and batch files. Update and maintain staging, QA, and production databases. Perform pre-deployment database testing, new feature testing, and capacity planning. Specify hardware requirements and conduct hardware evaluation/benchmarking, including CPU, Memory, and Storage assessments. Create and maintain documentation of all database-related components. Monitor database health metrics such as CPU, memory, and disk usage, backup, restore, and validation processes. Perform SQL server patching on a scheduled basis; review pending patches and notify development if there is a risk to applications/services. Assist in designing and implementing solutions for high availability and failover. Review SQL scripts for developers, report writers, and BI Engineers. Assist in developers' task planning and code review process. Research, evaluate, and design a migration plan from on-premises to cloud hosting of relevant databases. Available to respond and address production incidents, even after hours, based on an on-call schedule. Backup DBA Duties (Temporary, assisting the CIO):

　　o Set up, maintain, and monitor database/TLog backups/log shipping

　　o Automate backup/restores/validation

　　o Documentation and define SLAs

　　o Maintain the DB Backup Utility "Orchestrator" until an alternative is available

　　o Assist in storing DB Backups in Cloud storage (AWS)

　　o Assist in maintaining a disaster recovery site on a cloud environment (AWS)

　　Minimum Qualifications (Knowledge, Skills, and Abilities)

　　5+ years of experience in a DBA role, primarily with Microsoft SQL Server 2016 and later. Experience in OLTP environments and proficient in SQL server installations, administration, updates, and upgrades. Advanced skills in Windows administration. Demonstrable experience in troubleshooting and optimizing query execution plans and performance. Proven capability in resolving concurrency, locking, blocking, and deadlock issues. Exceptional problem-solving skills with a strong sense of ownership.

　　Preferred Qualifications

　　Experience with monitoring tools such as SolarWinds, Ignite, Nagios, etc. Strong written and verbal communication skills. Teamwork and adaptability. Ability to work under pressure and multitask. Detail-oriented with excellent organizational skills.