Description:

We are seeking a highly skilled and experienced Senior Microsoft SQL Database Administrator  to join our dynamic team. The ideal candidate will be is responsible for the design, implementation, configuration, performance tuning, and maintenance of Microsoft SQL Server databases, alongside cloud computing and system engineering expertise. This role will involve ensuring the availability, security, and performance of mission-critical databases, providing high-level expertise and support to the organization’s data infrastructure, and driving best practices for SQL Server database management as well as overseeing cloud infrastructure, and ensuring the seamless integration between on-premises systems and cloud-based platforms.  

Key Responsibilities:

1. Database Management:
Install, configure, and maintain Microsoft SQL Server instances, databases, and associated services.
Perform database migrations, upgrades, and patching.
Manage and configure database clustering, replication, and other high-availability solutions (AlwaysOn Availability Groups, Mirroring, Log Shipping).
Ensure databases are properly optimized for performance and scalability.
2. Performance Tuning:
Monitor and analyze database performance, identify bottlenecks, and implement solutions for optimization.
Optimize complex SQL queries, indexing, and server configurations to ensure efficient data retrieval and minimize latency.
Establish and implement database performance monitoring tools and strategies.
3. Backup and Recovery:
Implement and manage robust backup and disaster recovery strategies to safeguard critical data.
Perform regular database backups, test recovery procedures, and ensure adherence to recovery objectives (RTO/RPO).
Troubleshoot and resolve any backup or restore issues.
4. Security:
Implement database security policies and procedures, ensuring data protection and compliance with industry standards.
Manage user roles, permissions, and security settings within SQL Server to maintain secure access.
Regularly audit database security and enforce data privacy regulations
5. Troubleshooting and Support:
Provide second and third-line support for SQL Server-related incidents, troubleshooting issues, and resolving them in a timely manner.
Act as a subject matter expert on SQL Server and collaborate with development and infrastructure teams to resolve complex issues.
6. Database Design and Architecture:
Collaborate with development teams to design and implement optimized database schemas, tables, and indexes.
Ensure the integrity, normalization, and scalability of database architectures.
Participate in capacity planning and future-proofing database environments to accommodate growth and evolving business requirements.
7. Automation and Scripting:
Develop and maintain automation scripts to streamline routine DBA tasks (backup, performance monitoring, reporting).
Write T-SQL and PowerShell scripts for database management and troubleshooting.
8. Documentation and Reporting:
Document database configurations, procedures, and best practices for internal use.
Prepare and present reports on database performance, capacity, and health to management and stakeholders.
9. Mentorship and Training:
Provide mentorship and guidance to junior DBAs and database developers.
Help improve team processes and foster a culture of continuous learning in the database administration team.

Required Qualifications & Skills:

• SQL Server certifications (e.g., Microsoft Certified: Azure Database Administrator Associate).
• Certifications in cloud computing or system engineering (e.g., Azure Solutions Architect, AWS Certified Solutions Architect).
• Minimum of 5-7 years of experience working as a Microsoft SQL Server Database Administrator with a strong understanding of high availability, disaster recovery, and performance tuning.
• Advanced knowledge of SQL Server architecture, clustering, replication, and high-availability solutions.
• Strong expertise in T-SQL, stored procedures, and database design.
• Experience with SQL Server performance tuning and optimization techniques.
• In-depth knowledge of database backup, recovery, and disaster recovery best practices.
• Strong experience with SQL Server Management Studio (SSMS), SQL Profiler, and other SQL Server tools.
• Proficiency in scripting languages such as PowerShell, Python, or batch scripts for automation tasks.
• Familiarity with cloud-based database solutions (Azure SQL Database, AWS RDS) is a plus.

• Experience with SQL Server integration with other data platforms and services.
• Experience with DevOps practices, database CI/CD pipelines, and automation tools (e.g., Azure DevOps, Jenkins).
• In-depth knowledge of cloud platforms, particularly Microsoft Azure and AWS, with a focus on SQL services (Azure SQL Database, SQL Managed Instance, AWS RDS).
• Experience in system administration (Windows/Linux), virtualization, and cloud infrastructure management (VMware, Hyper-V, Azure, AWS).
• Proficiency in scripting languages such as PowerShell, T-SQL, and Python for automation and troubleshooting.
• Experience with database migration, replication, and cloud transition processes.
• Familiarity with monitoring tools (SQL Server Management Studio, Azure Monitor, Redgate, or similar).

Soft Skills:

• Strong problem-solving and analytical skills.
• Excellent communication skills, with the ability to explain technical concepts to non-technical stakeholders.
• Strong attention to detail and organizational skills.
• Ability to work independently and in a collaborative team environment.
• Ability to manage multiple projects and priorities in a fast-paced environment.

 

Work Environment:

• Onsite work options based on business needs.
• Occasional on-call availability for critical database and or system related issues.
• Collaborative and fast-paced environment, working with cross-functional teams including development, operations, and security.