віддалено
повна зайнятість
Рівень
Senior
24 дні тому
Про вакансію
Senior DevOps Engineer — Database Automation, SSIS & ETL
Engagement:
Full time
Responsibilities
Build, configure, and maintain Microsoft SQL Server environments across production and non-production systems.
Automate database deployments, schema updates, and release processes using CI/CD pipelines.
Manage backup and restore procedures, disaster recovery, capacity planning, and database performance optimisation.
Implement version control and structured release management practices for database changes.
Design, develop, deploy, and support SSIS packages and ETL workflows.
Automate data integration, transformation, migration, and scheduling processes.
Investigate and resolve ETL failures, data load issues, and performance bottlenecks.
Develop and maintain SQL Server Agent Jobs and other automated scheduling mechanisms.
Build and maintain CI/CD pipelines for database, ETL, and application deployments.
Automate build, testing, release, and deployment activities using tools such as Azure DevOps, Jenkins, GitHub Actions, or GitLab CI/CD.
Manage deployment processes across development, test, staging, and production environments.
Provision and manage infrastructure through code using Terraform, Ansible, ARM templates, CloudFormation, or comparable technologies.
Maintain consistent configuration across environments and support containerised workloads where required.
Administer SQL workloads running on AWS and Azure, including AWS RDS for SQL Server, Azure SQL Database, Azure SQL Managed Instance, and SQL Server hosted on EC2.
Optimise cloud-hosted database environments for performance, reliability, and cost.
Implement and maintain monitoring and alerting using tools such as Prometheus, Grafana, Splunk, Azure Monitor, and CloudWatch.
Perform root cause analysis, resolve production incidents, and contribute to ongoing operational improvements.
Provide production support and participate in an on-call rotation.
Requirements
6–10 years of overall professional experience.
At least 5 years of hands-on SQL Server administration experience, including 4+ years focused on performance tuning and 5+ years supporting production environments.
4+ years of hands-on experience developing and supporting SSIS solutions.
3+ years of experience with database automation and release management.
3+ years of practical experience with Azure DevOps, Jenkins, or comparable CI/CD platforms.
2+ years of experience working with AWS or Azure.
Strong SQL Server and T-SQL expertise, including stored procedures, functions, triggers, query optimisation, SQL Agent Jobs, and database performance tuning.
Experience designing and supporting ETL processes, data migrations, transformations, validation, and data warehouse solutions.
Hands-on experience with infrastructure-as-code tools such as Terraform, Ansible, ARM templates, or CloudFormation.
Strong scripting skills in PowerShell, Python, or Bash.
Experience managing mission-critical production databases, including incident response, troubleshooting, and root cause analysis.
Experience with Git-based source control, including platforms such as GitHub, Azure Repos, or Bitbucket.
Familiarity with Windows Server and Linux environments.
Strong communication skills and the ability to create clear technical and operational documentation.
Nice to have
Experience with SSRS and SSAS.
Experience with Octopus Deploy.
Knowledge of containerised workloads and orchestration platforms.
Relevant certifications such as Microsoft Azure DevOps Engineer Expert, Azure Database Administrator Associate, AWS Certified DevOps Engineer, Microsoft SQL Server certifications, or HashiCorp Terraform Associate.
Senior DevOps Engineer — Database Automation, SSIS in Warsaw – pracodawca: NETFORCE Group
NETFORCE Group to doskonały pracodawca, oferujący elastyczne warunki pracy w pełni zdalnej, co pozwala na idealne dopasowanie do europejskich stref czasowych. Nasza kultura pracy opiera się na współpracy i innowacyjności, a pracownicy mają możliwość ciągłego rozwoju zawodowego poprzez udział w projektach związanych z nowoczesnymi technologiami, takimi jak Azure, Terraform i Kubernetes.