SQL DBA

Work Environment: First 60 days are fully onsite then goes to 3/2 hybrid - last interview will be in person so no relocation
ALL CANDIDATES MUST BE WITHIN 45-60 MINUTES COMMUTE
High Level Notes:
Need T-SQL, ETL, PowerShell, and Azure Cloud (firm requirement)
CLIENT JD:
SQL Database Administrator (DBA) - On-Premises and Azure/Cloud Experience
Job Summary:
We are seeking a highly skilled and experienced SQL Database Administrator (DBA) with expertise in both on-premises and Azure/cloud environments to join our dynamic team.

• Responsible for managing and maintaining our SQL Server databases in both traditional on-premises infrastructure and cloud-based platforms.
• Ensuring the availability, performance, security, and scalability of our database systems while collaborating with cross-functional teams to support and optimize our applications.

• Design, implement, and maintain SQL Server databases in both on-premises and Azure/cloud environments, considering factors such as performance, scalability, security, and high availability.
• Perform database installation, configuration, and upgrade activities in both on-premises and cloud environments, ensuring adherence to best practices and industry standards.
• Implement backup, recovery, and disaster recovery strategies for SQL Server databases, leveraging both on-premises solutions and cloud services such as Azure SQL Database, Azure SQL Managed Instance, and Azure Backup.
• Monitor and optimize database performance in both on-premises and cloud environments, analyzing query execution plans, identifying bottlenecks, and recommending and implementing performance tuning strategies.
• Proactively manage database security, including user access management, data encryption, and vulnerability assessments, following best practices for both on-premises and cloud environments.
• Collaborate with development teams to assist in the design and optimization of database schema, indexes, and queries to ensure efficient data retrieval and storage.
• Troubleshoot and resolve database-related issues, such as connectivity problems, performance degradation, and data integrity concerns, ensuring minimal downtime and impact on business operations.
• Stay updated with the latest trends, technologies, and best practices in SQL Server, on-premises infrastructure, and cloud platforms (particularly Azure), and propose and implement improvements to enhance database performance, reliability, and security.
• Create and maintain database documentation, including data models, database schemas, and configuration details, ensuring accuracy and completeness.
• Collaborate with cross-functional teams, including developers, system administrators, and network engineers, to support application deployments, upgrades, and integrations .

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a SQL Database Administrator (DBA), with hands-on experience in managing SQL Server databases in both on-premises and Azure/cloud environments.
• In-depth knowledge of SQL Server database administration, including database design, installation, configuration, performance tuning, backup and recovery, and security.
• Strong understanding of on-premises infrastructure, as well as experience working with cloud platforms, particularly Azure.
• Familiarity with Azure SQL Database, Azure SQL Managed Instance, Azure Backup, and other Azure services relevant to database administration.
• Also, experience with TSQL, ETL, PowerShell; familiarity with VMWare to do some basic functionality for call coverage;
• Experience with hybrid environments, managing SQL Server databases that span on-premises and cloud infrastructure.
• Strong analytical and problem-solving skills, with the ability to troubleshoot complex database issues in diverse environments.
• Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams.
• Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Azure Solutions Architect Expert, are a plus.
• Continuous learning mindset to stay updated with evolving technologies and industry trends related to on-premises and cloud-based database administration.