Senior Database DevOps Engineer

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

Full time