Overview
Skills
Job Details
Position Overview:
The position is responsible for managing, maintaining, and optimizing SQL Server and Azure SQL databases within an organization. They play a critical role in ensuring the performance, availability, security, and reliability of the database systems. Their duties include database design, installation, configuration, troubleshooting, backup and recovery, performance tuning, security management, and ensuring data integrity.
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.
Install, configure, and upgrade 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.
Participates 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 seven (7) years of experience in an Enterprise Windows environment and proficiency with currently supported editions of Microsoft SQL Server
Strong understanding of relational database concepts and SQL query language.
Intermediate to advanced level knowledge of Microsoft Azure
Experience of Azure PaaS SQL
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 SDLC
Preferred Qualifications & Skills:
Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified: Data Management and Analytics (SQL Server).
DevOps experience
Azure Synapse, Snowflake, PostgreSQL, and MySQL are a plus.