Senior Ms Sql Developer + Dba
- Zensar
- 7 - 12 years
- Hyderabad
- 4 days ago
- Email to a friend
- Report this job
Job Description
Role & 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.
Preferred candidate profile
Experience: 710+ 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: Bachelors degree in Computer Science, Information Systems, or equivalent engineering disciplines
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Project & Program ManagementRole Category: Technology / ITRole: Technology / IT - OtherEmployement Type: Full timeContact Details:
Company: ZensarLocation(s): Hyderabad
Keyskills: T-SQL Dba Skills Performance Tuning Ms Sql Development Query Optimization query SQL Server
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in