Azure Sql Data Base Administrator

enterprise environments.

The ideal candidate will have 10+ years of experience in database administration, with deep expertise in Microsoft SQL Server and working knowledge of Oracle and MongoDB. This role requires a strong blend of hands-on technical skills, database development knowledge (T-SQL / PL-SQL), and leadership capability to manage complex database environments supporting business-critical applications.

Key Responsibilities

Database Administration & Support

• Install, configure, upgrade, and maintain SQL Server databases across on-premises and cloud platforms (Azure preferred).
• Provide operational support for Oracle (L2 level) and MongoDB environments.
• Monitor database systems, logs, and scheduled jobs to ensure availability and successful execution of processes.
• Manage database access controls, user roles, and security configurations.
• Experience with database migration projects, including migration of on-premises Microsoft SQL Server to Azure SQL platforms covering assessment, schema conversion, data migration, application compatibility, cutover planning, validation and post-migration optimization

Performance Tuning & Optimization

• Perform advanced performance tuning using tools such as SQL Profiler, execution plans, and DBCC utilities.
• Optimize database performance through query tuning, indexing strategies, and workload optimization.
• Identify and resolve performance bottlenecks, blocking, and deadlock issues.

High Availability & Disaster Recovery

• Design, implement, and support HA/DR solutions including Always On Availability Groups, clustering, and replication.
• Manage database backup, restore, and recovery processes.
• Conduct DR drills and ensure adherence to defined RPO/RTO objectives.

Database Development & Automation

• Support development teams with efficient T-SQL and PL/SQL scripting and optimization.
• Review stored procedures, triggers, and database code for performance and best practices.
• Develop automation scripts using T-SQL and PowerShell for routine DBA activities.
• Manage data integration tasks using SSIS, BCP, and data transformation tools.

Platform Management & Integration

• Configure and manage Linked Servers and cross-platform data transfers.
• Support integrations across heterogeneous database systems.
• Work with reporting and analytics tools such as SSRS and SSAS.

Security & Compliance

• Implement database security best practices including authentication, authorization, encryption, and auditing.
• Ensure compliance with enterprise security and governance standards.

Leadership & Collaboration

• Act as a technical lead and subject matter expert (SME) for database technologies.
• Lead troubleshooting efforts and perform root cause analysis (RCA) for critical issues.
• Mentor junior DBAs and provide technical guidance to team members.
• Collaborate with application, infrastructure, and cloud teams for seamless service delivery.
• Participate in on-call support as required.

Required Skills & Experience

Primary Expertise

• Strong hands-on experience with Microsoft SQL Server (2014 / 2016 / 2019 / 2022)
• Expertise in:
• Performance tuning and query optimization
• Always On and HA/DR implementations
• Backup, recovery, and database maintenance
• Advanced proficiency in T-SQL scripting

Secondary Skills

• Working knowledge of Oracle DBA (L2 level)
• Experience with PL/SQL development and troubleshooting
• Exposure to MongoDB (basic administration, replication concepts)

Additional Skills

• Experience with Azure SQL Database / Managed Instance (preferred)
• Familiarity with AWS or other cloud platforms is a plus
• Strong understanding of:
• Data modeling (relational and dimensional)
• Database security and compliance
• Job scheduling and maintenance planning

Qualifications

• Bachelors degree in Computer Science, IT, or related field
• 10+ years of total experience, with 6–8 years in SQL Server administration
• Proven experience managing large-scale production databases

Preferred Certifications

• Microsoft certifications (MCSA / MCSE / Azure Database Administrator)
• Oracle DBA certification (good to have)

Key Competencies

• Strong analytical and troubleshooting skills
• Ability to manage business-critical production environments
• Leadership and mentoring capability
• Excellent communication and stakeholder management skills
• Proactive approach toward automation and continuous improvement