We are seeking a highly skilled Senior DevOps Engineer with strong expertise in Database Administration, SQL Server, SSIS Automation, CI/CD, and Cloud Technologies.
The candidate will be responsible for automating database deployment processes, managing ETL workflows, optimizing SQL Server environments, and implementing DevOps best practices across application and data platforms.
The ideal candidate should possess hands-on experience in SQL Server Integration Services (SSIS), database release automation, infrastructure automation, cloud environments, and production support for enterprise-scale systems.
Key Responsibilities
Database Administration & Automation
Design, implement, and maintain Microsoft SQL Server environments.
Automate database deployments and schema changes using DevOps pipelines.
Manage database backups, restores, performance tuning, and disaster recovery.
Monitor database health, availability, and capacity planning.
Implement database version control and release management processes.
SSIS & ETL Automation
Design, develop, deploy, and support SSIS packages.
Automate ETL workflows and data integration processes.
Troubleshoot data load failures and ETL performance issues.
Develop and maintain SQL Agent Jobs and automated scheduling processes.
Optimize large-scale data migration and transformation processes.
DevOps & CI/CD
Build and maintain CI/CD pipelines for database and application deployments.
Automate build, test, release, and deployment activities.
Implement Database DevOps practices using Azure DevOps, Jenkins, GitHub Actions, or GitLab.
Manage deployment strategies for production and non-production environments.
Infrastructure as Code
Automate infrastructure provisioning using Terraform, ARM Templates, CloudFormation, or Ansible.
Manage configuration consistency across environments.
Support containerized workloads and orchestration platforms.
Cloud Administration
Manage SQL workloads on:
AWS RDS SQL Server
Azure SQL Database
Azure Managed Instance
EC2-hosted SQL Servers
Optimize cloud database performance and cost management.
Monitoring & Support
Implement monitoring solutions using:
SQL Monitoring Tools
Prometheus
Grafana
Splunk
Azure Monitor
CloudWatch
Perform root cause analysis (RCA) and incident resolution.
Provide production support and participate in on-call rotations.
Required Technical Skills
Database Technologies
Microsoft SQL Server 2016/2019/2022
T-SQL Development
Stored Procedures
Functions
Triggers
Query Optimization
SQL Agent Jobs
Performance Tuning
ETL & Data Integration
SSIS (SQL Server Integration Services)
ETL Design and Development
Data Migration
Data Warehousing Concepts
Data Transformation and Validation
SSRS (Preferred)
SSAS (Preferred)
DevOps Tools
Azure DevOps
Jenkins
GitHub Actions
GitLab CI/CD
Octopus Deploy
Source Control
Git
GitHub
Azure Repos
Bitbucket
Infrastructure & Cloud
AWS
Azure
Terraform
Ansible
Scripting & Automation
PowerShell
Python
Bash
T-SQL Scripting
Operating Systems
Windows Server
Linux Administration
Contact Details:
Happiest Minds Technologies Limited Recruitment Team