Sr Support Engineer 2

Job Description

As a SQL Server Database Administrator, you will be responsible for managing and optimizing enterprise-scale SQL Server environments, with a strong emphasis on Azure SQL Database. Your role will cover the full spectrum of database administration, including design, security, performance optimization, and support for large-scale cloud production workloads. You will be instrumental in strategic planning and architectural decisions, driving automation, modernization, and compliance initiatives. Additionally, you will provide leadership, mentoring, and guidance to the DBA team, establishing and upholding best practices across hybrid database platforms.

Our Current Technical Environment

• Database Design & Architecture (Advanced): Design robust, scalable database solutions aligned with business needs.
• Performance Tuning & Optimization (Advanced): Analyze and optimize queries and database structures for peak performance.
• Security Management (Advanced): Implement security protocols to ensure data integrity and privacy.
• Backup & Recovery (Advanced): Develop and execute reliable backup and recovery strategies.
• High Availability & Disaster Recovery (Advanced): Ensure database availability through solutions like Always On and replication.
• Azure SQL Management (Advanced): Manage Azure SQL Databases and leverage Azure services for enhanced operations.
• Automation & Scripting (Proficient): Utilize PowerShell and T-SQL for automating routine database tasks.
• Monitoring & Troubleshooting (Advanced): Set up monitoring systems and efficiently resolve database issues.

Tools & Technologies

• Azure Portal & Azure CLI (Proficient)
• PowerShell & T-SQL (Proficient)

What You’ll Do

• Lead the architecture, design, and implementation of SQL Server environments (on-premises and Azure Cloud).
• Design and implement scalable, cost-optimized Azure SQL Database solutions, including elastic pools and serverless models.
• Enforce database governance, standards, and best practices across the organization.
• Perform capacity planning, performance tuning, and cost optimization for Azure SQL workloads.
• Lead and oversee HA/DR implementations (Always On, Clustering, Log Shipping, Replication, cloud-based DR).
• Define and implement database security, auditing, and compliance measures.
• Provide expert performance tuning and query optimization for mission-critical systems.
• Lead migration projects from on-prem SQL Server to Azure SQL Database (PaaS).
• Automate complex administrative and monitoring tasks using T-SQL, PowerShell, or DevOps pipelines.
• Manage backup/restore strategies and disaster recovery drills for enterprise databases.
• Collaborate with architects, application teams, and infrastructure leaders to align database solutions with business needs.
• Mentor, coach, and provide technical guidance to mid-level and junior DBAs.
• Act as the primary escalation point for critical production incidents.
• Stay current with industry trends and recommend emerging technologies for continuous improvement.

What We Are Looking For

• Bachelor’s degree in IT/Computer Science/Electronics (preferred) or equivalent diploma.
• 8 - 12 years of progressive experience as a SQL Server DBA in enterprise environments (OnPrem and Azure SQL).
• Deep expertise in SQL Server 2012/2014/2016/2017/2019/2022 administration and Azure SQL Database features (DTU/vCore models, Elastic Pools, Serverless, Hyperscale).
• Experience with Azure SQL HA/DR options (Geo-Replication, Failover Groups).
• Proven experience with large-scale database environments (VLDBs, high concurrency systems).
• Proficiency in monitoring, alerting, and troubleshooting using Azure Monitor, Log Analytics, and Query Store.
• Advanced knowledge of HA/DR architectures and performance tuning at scale.
• Proven problem-solving and decision-making abilities, with a focus on driving results and delivering high-quality software solutions.
• Strong experience in High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
• Experience refining and automating regular processes, tracking issues, and documenting changes.
• Experience planning, preparing, and executing upgrades and migrations.
• Experience performing production and non-production restores/refreshes (Private Cloud and Azure).
• Experience managing capacity planning (Disk and Compute).
• Experience with GitHub and repositories.
• Passion for technology, innovation, and staying up-to-date with industry trends.
• Team player, fast learner, ability to work in a fast-paced environment, and share knowledge.
• Hands-on experience with database monitoring, profiling, and performance tools (e.g., Redgate, SQLSentry, SolarWinds, Idera).
• Strong proficiency in scripting and automation (T-SQL, PowerShell, CI/CD tools).
• Expertise in database security, encryption, auditing, and compliance.
• Experience managing end-to-end migration projects (on-prem ↔ cloud).
• Solid understanding of Windows Server, storage, networking, and virtualization technologies.
• Strong communication, stakeholder management, and leadership skills.
• This role involves rotational shifts, including night shifts, to provide 24/7 application support.
• Flexibility to work weekends and public holidays as per shift schedule.
• Ability to handle responsibilities independently during off-hours. (ID103)