SQL Developer

Job Description

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.

Responsibilities

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.

Qualifications

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.

About Us

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.