Senior Database DevOps Engineer
On-site Amman, Amman Governorate, Jordan IT Management Full time
Description
As a Senior Database DevOps Engineer, you'll spearhead the integration of database management practices with DevOps methodologies, particularly focusing on Oracle and Microsoft SQL Server (MSSQL) environments. Your role entails orchestrating seamless automation, optimization, and security of database infrastructure while aligning closely with development and operations teams to foster a culture of collaboration and innovation.
Responsibilities
+ DevOps Integration: Lead the convergence of database management practices with DevOps principles, ensuring continuous integration, delivery, and deployment of database changes. Collaborate with DevOps teams to integrate database workflows seamlessly into CI/CD pipelines.
+ Database Automation: Architect and implement automated workflows for database provisioning, configuration, patching, and upgrades using infrastructure as code (IaC) tools like Ansible, Puppet, or Chef. Automate schema migrations and data transformations to streamline development and release cycles.
+ CI/CD Pipeline Enhancement: Enhance CI/CD pipelines to support automated testing, validation, and deployment of database changes. Implement version control for database schema and data scripts, facilitating rollbacks and traceability.
+ Performance Optimization: Monitor and optimize the performance of Oracle and MSSQL databases, leveraging query tuning, indexing strategies, and resource allocation optimization. Collaborate with development teams to optimize database access patterns for improved application performance.
+ High Availability and Disaster Recovery: Design and implement robust high availability and disaster recovery solutions for Oracle and MSSQL databases, ensuring data integrity and business continuity. Implement automated failover and replication mechanisms to minimize downtime.
+ Security and Compliance: Enforce stringent security controls and compliance measures to safeguard sensitive data stored in Oracle and MSSQL databases. Implement access controls, encryption, and auditing mechanisms to ensure regulatory compliance and data protection.
+ Monitoring and Alerting: Set up comprehensive monitoring and alerting systems to proactively detect and respond to database issues. Monitor database health, performance, and capacity metrics using tools like Prometheus, Grafana, or Datadog, and implement automated alerting mechanisms for rapid incident response.
+ Backup and Recovery Automation: Develop and automate backup and recovery procedures for Oracle and MSSQL databases to mitigate data loss and corruption risks. Regularly test backup and restore processes to ensure data recoverability and compliance with recovery objectives.
+ Collaboration and Knowledge Sharing: Foster collaboration across development, operations, and database administration teams to align database infrastructure with organizational objectives. Share expertise, best practices, and lessons learned through documentation, training sessions, and knowledge sharing forums.
Requirements
+ Bachelor’s degree in Computer Science, Information Technology, or related field. Master’s degree preferred.
+ 5+ years of experience in database administration, DevOps, or related roles, with a strong focus on Oracle and MSSQL database technologies.
+ Proficiency in scripting and automation using Python, PowerShell, or SQL.
+ Hands-on experience with infrastructure as code (IaC) tools like Ansible, Puppet, or Chef.
+ Experience with CI/CD pipelines, version control systems (e.g., Git), and continuous integration tools (e.g., Jenkins, GitLab CI).
+ Strong understanding of DevOps principles and practices, with a focus on automation, collaboration, and continuous improvement.
+ Excellent analytical, problem-solving, and communication skills, with the ability to work effectively in cross-functional teams.
