01 Nov
|
Pracyva Consulting Services
|
India
01 Nov
Pracyva Consulting Services
India
## Job highlights
- Expertise in MS SQL Server (2016-2022), T-SQL programming, SQL query optimization, database design, Git version control, and DevOps automation tools
- Design, develop, and optimize SQL Server databases; build and maintain CI/CD pipelines; automate deployments; monitor database health and troubleshoot issues Dear Candidates, Greetings of the day We are seeking a skilled MS SQL Developer with DevOps knowledge to design, develop, optimize, and maintain SQL Server databases while supporting CI/CD automation and deployment processes. The ideal candidate should have robust expertise in SQL Server development, database performance tuning, release management, and DevOps practices.
Key Responsibilities
SQL Development & Database Management
- Design, develop, and maintain complex SQL Server database objects including Stored Procedures, Functions, Views, Triggers, and Indexes.
- Develop and optimize T-SQL queries for high performance and scalability.
- Perform database performance tuning, query optimization, and troubleshooting.
- Design database schemas and support data modeling activities.
- Implement database security, backup, recovery, and disaster recovery solutions.
- Support production incidents, root cause analysis, and defect resolution. DevOps & Automation
- Build and maintain CI/CD pipelines for database deployments using Azure DevOps, GitHub Actions, Jenkins, or similar tools.
- Automate database deployment, schema migration,
and release processes.
- Manage source control repositories using Git.
- Implement Infrastructure as Code (IaC) concepts using PowerShell, YAML, ARM Templates, or Terraform.
- Collaborate with Development, QA, and Infrastructure teams to streamline release management. Monitoring & Support
- Monitor database health, performance, and availability.
- Troubleshoot deployment failures and production issues.
- Create operational documentation, deployment guides, and runbooks.
- Support change management, release management, and ITIL-based processes. Required
Skills:
Mandatory Technical Skills
- Microsoft SQL Server 2016/2019/2022
- T-SQL Programming
- Stored Procedures, Functions, Views, Triggers
- SQL Query Optimization & Performance Tuning
- Database Design & Data Modeling
- Git Version Control
- PowerShell or SQL Scripting
- Release Management & Database Deployment Automation *If your intersted kindly pls share me below details: with your photo soft copy
* *Current CTC:
* *Expected CTC:Market standards
* *Any Offer in Hand (if yes, Offer amount):
* *Notice Period:
* *Total
Experience:
* *Relevant
Experience:
* *Current
location:
* *Preferred
location:
* *Current Job
responsibilities:
* *Reason for Change:
* *PAN NO :
* *DOB :
* *Ambika Bora
* *Senior Recruiter
* *
[email protected]
* *mob (phone hidden)*
📌 Devops Engineer with SQL skills (India)
🏢 Pracyva Consulting Services
📍 India