We are seeking an experienced and highly motivated Database Administrator (DBA) with strong expertise in Microsoft SQL Server (MSSQL) and hands-on experience in cloud-based database deployments on Microsoft Azure. The ideal candidate will play a key role in designing, developing, deploying, and maintaining secure, high-performance database systems tailored to support business-critical applications in both development and production environments.
Key Responsibilities
Database Design & Implementation
- Lead the design, development, and deployment of MSSQL database instances in Azure Cloud, ensuring scalability, performance, and security.
- Collaborate with software engineers, architects, and Azure development teams to define database requirements and best practices.
Data Migration
- Plan and execute the seamless migration of application data from on-premise databases to cloud-based platforms using Azure DMS tools and other proven methodologies.
- Perform pre-migration analysis, risk assessment, testing, and validation to ensure data integrity throughout the process.
Database Maintenance & Monitoring
- Conduct daily checks to ensure system health, stability, and optimal performance of development and production databases.
- Monitor database activities and proactively resolve issues related to performance, availability, or security.
Security & Compliance
- Implement and maintain robust database security protocols and user access controls in compliance with organizational and industry standards.
- Ensure regular patching and updating of database software and associated tools.
Performance Tuning & Optimization
- Perform in-depth performance tuning of both MSSQL and PL/SQL queries, indexes, and stored procedures.
- Work closely with development teams to identify and implement performance enhancements for critical applications.
Backup & Recovery
- Manage backup and disaster recovery strategies using both Azure-native tools and traditional backup solutions.
- Regularly test recovery procedures to ensure minimal data loss and quick recovery in the event of failure.
Incident & Problem Management
- Provide on-call support for production databases and resolve high-priority issues as they arise.
- Conduct root cause analysis (RCA) for recurring incidents and implement long-term solutions to prevent future occurrences.
Scripting & Automation (Good to Have)
- Knowledge of scripting languages such as VBScript, Microsoft JScript, PowerShell (built on .NET CLR), REXX, Perl, and Python is highly desirable.
- Automate routine administrative tasks and reports to enhance operational efficiency.
Required Skills & Experience
- Strong experience with Microsoft SQL Server in both on-prem and cloud environments (preferably Azure).
- Proficiency in Azure Database Services, Database Migration Services (DMS), and cloud deployment patterns.
- Excellent troubleshooting and problem-solving skills in production environments.
- Demonstrated expertise in database performance tuning, monitoring, and maintenance.
- Hands-on experience with backup and recovery strategies in cloud and traditional environments.
- Strong analytical mindset and ability to work in a fast-paced, mission-critical setting.
This role demands a solid understanding of both on-premises and cloud infrastructure, as well as experience with data migration strategies using Database Migration Services (DMS). The candidate must have proven abilities in database monitoring, performance tuning, and troubleshooting complex issues in high-availability environments.