SQL Developer

• About the Role

We are looking for a highly competent and detail-oriented Database Administrator with 3–5 years of experience in SQL Server environments.

The ideal candidate should have hands-on experience with performance tuning, backup strategies, query optimisation, and maintaining

high availability. You will play a critical role in ensuring database stability, scalability, and security across business applications.

• Key Responsibilities

Manage and maintain Microsoft SQL Server databases (2016 and later) across development, UAT, and production environments.

·        Monitor and improve database performance using Query Store, Extended Events, and Dynamic Management Views (DMVs).

·        Design and maintain indexes, partitioning strategies, and statistics to ensure optimal performance.

·        Develop and maintain T-SQL scripts, views, stored procedures, and triggers.

·        Implement robust backup and recovery solutions using native SQL Server tools and third-party backup tools (if applicable).

·        Ensure business continuity through high-availability configurations such as Always On Availability Groups, Log Shipping, or Failover Clustering.

·        Perform database capacity planning and forecast growth requirements.

·        Ensure SQL Server security by managing logins, roles, permissions, and encryption features like TDE.

·        Collaborate with application developers for schema design, indexing strategies, and performance optimization.

·        Handle deployments, patching, and version upgrades in a controlled and documented manner.

·        Maintain clear documentation of database processes, configurations, and security policies.

Required Skills & Qualifications

·        Bachelor’s degree in Computer Science, Engineering, or related field.

·        3–5 years of solid experience with Microsoft SQL Server (2016 or later).

·        Strong command of T-SQL including query optimisation, joins, CTEs, window functions, and error handling.

·        Proficient in interpreting execution plans, optimising long-running queries, and using indexing effectively.

·        Understanding of SQL Server internals such as page allocation, buffer pool, and lock escalation.

·        Hands-on experience with backup/restore strategies and consistency checks (DBCC CHECKDB).

·        Experience with SQL Server Agent Jobs, alerts, and automation scripts (PowerShell or T-SQL).

·        Ability to configure and manage SQL Server high-availability features.

·        Exposure to tools like Redgate SQL Monitor, SolarWinds DPA, or similar is a plus.

• Nice to Have

·        Exposure to Azure SQL Database or cloud-hosted SQL Server infrastructure.

·        Basic understanding of ETL workflows using SSIS.

·        Microsoft Certification: MCSA / Azure Database Administrator Associate or equivalent.

·        Experience with database deployments in CI/CD pipelines.

• Key Traits

·        Analytical and structured problem-solver.

·        High attention to detail and data consistency.

·        Proactive mindset with ownership of deliverables.

·        Strong verbal and written communication skills.