Job Description
: Summary: As a Senior Microsoft SQL Server Database Administrator (DBA), you will play a critical role in managing and optimizing our SQL Server environments, both on-premises and in Azure. This role requires extensive experience in SQL Server administration, including Azure SQL, VM installations, managed instances, infrastructure management, performance tuning, query tuning, data modeling, logging and monitoring, backup and restore, and migration. Responsibilities: 1. SQL Server Administration: - Install, configure, and maintain SQL Server instances across various environments, including on-premises and Azure. - Manage SQL Server databases, including creating, modifying, and optimizing database objects. 2. Azure SQL Management: - Deploy and manage Azure SQL Database instances, including single databases, elastic pools, and managed instances. - Implement and optimize Azure SQL features such. as scalability, high availability, and disaster recovery. 3. Infrastructure Management: - Manage SQL Server infrastructure, including virtual machines (VMs), storage, networking, and security configurations. - Collaborate with infrastructure teams to ensure optimal performance and availability of SQL Server environments. 4. Performance and Query Tuning: - Monitor and analyze SQL Server performance metrics to identify and resolve performance bottlenecks. - Tune SQL queries and database configurations for improved performance and resource utilization. 5. Data Modeling: - Design and implement logical and physical data models to support application requirements. - Optimize data structures and schemas for efficiency and scalability. 6. Logging and Monitoring: - Implement logging and monitoring solutions to track database activity, performance metrics, and security events. - Set up alerts and notifications to proactively identify and address potential issues. 7. Backup and Restore: - Develop and maintain backup and restore strategies to ensure data integrity and availability. - Test and validate backup and restore procedures regularly to mitigate data loss risks. 8. Migration: - Plan and execute database migration projects, including upgrades, platform migrations, and cloud migrations. - Assess compatibility and performance considerations for migrating databases to Azure SQL. Qualifications: - Bachelor's degree in Computer Science, Information Technology, or related field. - Proven experience as a Microsoft SQL Server Database Administrator, with a focus on senior-level responsibilities. - In-depth knowledge of SQL Server administration, including installation, configuration, and maintenance. - Strong expertise in Azure SQL, including deployment, management, and optimization. - Experience with VM installations, managed instances, and infrastructure management. - Proficiency in performance tuning, query optimization, and data modeling techniques. - Familiarity with logging and monitoring tools for SQL Server environments. - Hands-on experience with backup and restore procedures, including disaster recovery planning. - Demonstrated ability to plan and execute database migration projects effectively. - Excellent problem-solving skills and attention to detail. - Strong communication and collaboration skills, with the ability to work effectively in a team environment. Preferred Certifications: - Microsoft Certified: Azure Database Administrator Associate - Microsoft Certified: Azure Solutions Architect Expert - Microsoft Certified: Data Engineer Associate - Microsoft Certified: Azure Administrator Associate
Employement Category:
Employement Type: Full time
Industry: IT
Role Category: IT Services & Consulting
Functional Area: Not Applicable
Role/Responsibilies: Senior Sql Database Administrator
Keyskills:
SQL Server Administration
Infrastructure Management
Data Modeling
Migration
Azure SQL Management
Performance
Query Tuning
Logging
Monitoring
Backup
Restore