SQL Developer

Highly skilled Senior SQL Developer who possesses strong, practical exposure to SQL Server Database Administration (DBA). In this role, you will lead the architecture, development, and optimization of complex transactional and analytical databases. Additionally, you will bridge the gap between development and infrastructure teams by maintaining environment stability, overseeing security, and proactively troubleshooting database health issues.

Core Responsibilities

Database Development & Architecture (75%)

• Write Advanced T-SQL: Design and build high-performance stored procedures, functions, triggers, views, and complex queries.
• Data Modeling: Create scalable, normalized relational schemas (OLTP) and denormalized structures for data warehousing (OLAP).
• Performance Optimization: Analyze query execution plans, resolve locking/blocking conflicts, and implement advanced indexing and partitioning plans.
• Code Review Leadership: Audit database code written by application teams to ensure it adheres to corporate standard best practices.

SQL Server DBA Operations (25%)

• Health & Monitoring: Proactively track server resource metrics using DMVs, SQL Profiler, Extended Events, or third-party tools like Redgate.
• Backup & Recovery: Configure, maintain, and test disaster recovery policies, backup schedules, and point-in-time restores.
• High Availability Configuration: Understand and help troubleshoot database clusters, log shipping, replication, and AlwaysOn Availability Groups.
• Security Administration: Manage instances, database-level security parameters, schemas, object credentials, and permission groups.
• Job Automation: Automate routine database maintenance tasks and health check alerts through PowerShell and SQL Agent Jobs.

Required Qualifications & Skills

• Experience: 7–10+ years of dedicated professional experience working with Microsoft SQL Server.
• T-SQL Master: Expert-level mastery of advanced T-SQL programming and Query Optimizer inner mechanics.
• Hybrid Skill Set: Deep development skills with documented hands-on exposure to core operational DBA tasks.
• Diagnostics: Strong background using execution plans, Profiler, and Performance Monitor to kill performance bottlenecks.
• Tools Suite: Proficiency with SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), and source control systems like Git.
• Education: Bachelor’s degree in Computer Science, Information Systems, or equivalent engineering disciplines.