Senior DevOps Engineer (Database, ETL & Automation) ? 6 to 10 Years Experience
Position
Senior DevOps Engineer ? Database Automation & SSIS
Experience: 6 to 10 Years
Employment Type: Full-Time
Job Summary
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
Preferred Certifications
Microsoft Certified: Azure DevOps Engineer Expert
Azure Database Administrator Associate
AWS Certified DevOps Engineer
Microsoft SQL Server Certifications
Terraform Associate Certification
Key Competencies
Strong database troubleshooting and performance tuning expertise.
Experience implementing Database DevOps and Continuous Delivery.
Strong understanding of ETL architecture and SSIS package deployment.
Ability to automate repetitive operational tasks.
Excellent stakeholder communication and documentation skills.
Experience handling mission-critical production databases.
Desired Experience Profile
Area
Experience
SQL Server Administration
5+ Years
SSIS Development & Support
4+ Years
Database Automation
3+ Years
Azure DevOps/Jenkins
3+ Years
Cloud Platforms (AWS/Azure)
2+ Years
Production Support
5+ Years
Performance Tuning
4+ Years
Ideal Candidate
A DevOps Engineer who can bridge the gap between Database Administration, ETL/SSIS Development, and Modern DevOps Practices, driving automation, reliability, and continuous delivery across enterprise data platforms. This profile is highly suitable for banking, telecom, government, utilities, healthcare, and large enterprise environments
