SQL Server Administrator - (Software Systems Specialist III), Remote - ITS-OPS-TechSrvs

Minimum Qualifications:

Bachelor's degree or equivalent in a related field and three years of related experience.

Preferred Qualifications:

• Bachelor’s degree in Computer Science or 5 years of SQL Server Administration experience.
• Experience with cloud-based database solutions (e.g., Azure SQL, AWS RDS).
• Knowledge of ETL processes and data warehousing concepts.
• Microsoft Certified: Azure Database Administrator Associate or similar certification is highly desirable.

Job Summary:

To provide the technical skills and expertise required in developing and maintaining computer operating system software of the most complex nature.

Job Duties:

As a SQL Server Administrator, you will be responsible for the design, implementation, maintenance, and performance tuning of our SQL clusters/databases. You will work closely with IT teams and other departments to support data-driven decision-making and ensure the availability and reliability of our critical healthcare systems. You will be part of a team that is responsible for providing compute resources across the institution, which includes Enterprise Storage, Server Virtualization, Active Directory, Citrix, M365 workloads, Cloud Resources (Azure and AWS), Enterprise Printing, and Enterprise backups.

• Design, install, configure, and maintain SQL Servers (default, named & clustered instances) SQL Server 2012 to 2022.
• Experience upgrading and migrating SQL instances (in-place & separate server scenarios).
• Monitor database performance and troubleshoot issues to optimize performance, using Extended Events, DMVs, Performance & Activity Monitor, SQL Profiler, etc.
• Experience with High Availability & Disaster Recovery technologies, methods & best practices (TL Shipping, Availability Groups, etc.).
• Implement backup and recovery strategies to ensure data integrity.
• Collaborate with developers to create and maintain database schemas, stored procedures, custom SQL jobs, ETL processes, linked servers, etc.
• Ensure compliance with data security standards and regulations in the healthcare sector.
• Perform regular database maintenance tasks, including updates and patches, ad-hoc backups & restores, granting access via AD Groups, Windows & SQL logins to various SQL Servers & their databases
• Proficient in automating tasks \ solutions, PowerShell, T-SQL, DBATools, etc.
• Assist in data migration and integration projects as needed.
• Develop and maintain documentation for database systems and procedures.
• Provide support and training to end-users as necessary.
• On-Call duty.

Knowledge/Skills/Abilities:

• Proven experience as a SQL Database Administrator, preferably in a healthcare environment.
• Strong knowledge of SQL Server, including performance tuning and query optimization.
• Experience with database backup and recovery procedures.
• Familiarity with healthcare regulations (e.g., HIPAA) and data privacy standards.
• Excellent problem-solving skills and attention to detail.