Position Overview:The position is responsible for managing, maintaining, and optimizing Microsoft SQL Server and Azure SQL databases within an organization. They play a critical role in ensuring the performance, availability, security, reliability and automation of the database systems. Their duties include database design, installation, configuration, troubleshooting, backup and recovery, performance tuning, security management, and ensuring data integrity.
- * In order to be considered for this position you MUST have strong, in-depth experience with Azure SQL as a Database Administrator, Automation and specifically have worked with Cloud Native solutions.
- While
I thank you for interest in this position, if this experience is not present you will not be considered for this role. Essential Responsibilities:
- Collaborate with application developers and system architects to design and implement efficient and scalable database structures.
- Create and maintain database schemas, tables, indexes, views, and stored procedures.
- Deploy, manage, automate and secure Azure SQL databases
- Install, configure, and upgrade on prem Microsoft SQL Server instances, including applying patches and service packs.
- Configure database settings and options to optimize performance and ensure security.
- Monitor database performance using built-in tools and third-party monitoring solutions.
- Identify and resolve performance bottlenecks through query optimization, indexing strategies, and server configuration adjustments.
- Participate in rotating
On-Call coverage or emergency response, as needed.
- Develop and implement backup and recovery strategies to safeguard critical data.
- Perform regular backups, test restores, and maintain backup integrity.
- Develop disaster recovery plans and participate in recovery drills.
- Implement and enforce security policies and access controls to protect sensitive data.
- Manage user permissions, roles, and privileges.
- Monitor for security vulnerabilities and apply security patches and updates.
- Diagnose and resolve database-related issues, including connectivity problems, performance degradation, and data corruption.
- Conduct root cause analysis and implement preventive measures to mitigate future incidents.
- Estimate future database growth and plan for scalability requirements.
- Optimize resource utilization to accommodate increasing workloads.
- Maintain accurate documentation of database configurations, procedures, and processes.
- Generate reports on database performance, availability, and security compliance.
Required Qualifications \& Skills:
- Bachelor's degree in computer science, Information Technology, or a related field; a combination of training and experience may be considered in lieu of degree.
- A minimum of 3 years of experience in design, implementation and support of Azure SQL and proficiency in Azure services.
Intermediate to advanced level knowledge of Microsoft Azure
- A minimum of seven (7) years of experience in design, implementation and support of Microsoft SQL Server in Windows Server environments
- Strong understanding of relational database concepts and SQL query language.
- Experience with performance tuning, indexing, and query optimization.
- Familiarity with backup and recovery procedures, disaster recovery planning, and high availability solutions (e.g., clustering, replication, AlwaysOn).
- Experience supporting production and pre-production environments across multiple locations and the technologies to support them.
- Ability to troubleshoot database-related issues and perform root cause analysis.
- Advanced knowledge of PowerShell working with database environments
- Excellent communication and collaboration skills for working with cross-functional teams.
- Understanding of ITIL and SDLCPreferred Qualifications \& Skills:
- Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Management and Analytics (SQL Server).
- Azure DevOps experience
- Azure Data Factory (ADF) and Azure Synapse
- PostgreSQL, and MySQL are a plus.
