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.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
