Database Reliability Engineer - Cloud Engineering

About the Role

As a DBE you will be responsible for supporting Workday Planning Cloud database infrastructure, working with technologies like AWS Aurora PostgreSQL, Google Cloud SQL , Oracle Database. You will ensure the Cloud Database platform can effectively meet performance & SLA requirements while supporting capacity planning/sizing exercises and new initiatives. The role requires you to participate in database infrastructure automation using Terraform, Chef, Jenkins, Python and Golang. You will get the opportunity to work closely with a wide range of teams, as you are involved in planning and carrying out complicated technical projects that interact with a variety of other teams. You will build and respond to production monitors: triage, fix and resolution, and perform Root cause analysis. You will gain good experience at problem solving and complexity analysis on the large distributed systems and maintaining operational runbooks. Other duties will include supporting the deployment of cloud database solution software during and off regular office hours and being responsible for implementation, configuration, maintenance, and performance of system health for high-concurrency PostgreSQL, Oracle database systems ensuring the availability and consistent performance, supporting product development teams. The team provides support for both Linux and Windows systems.

• Note: This role includes a rotational weekend shift. While it is not possible to be definitive, as it depends on business needs, the maximum frequency we would expect is one week in four.
•  

About You

The ideal candidate will have strong hands-on experience in designing, developing and managing enterprise level database systems with sophisticated interdependencies and key focus on high-availability, Disaster Recovery, Fail-over, clustering, partitioning, security, performance, and scalability requirements.

• 3 to 5 Years of PostgreSQL database administration, or related Operations and support experience.
• Demonstrated ability working directly with AWS Aurora PostgreSQL services; AWS Certification preferred; solid understanding of AWS services and security required.
• 2+ Years Experience with at least one programming language like: Go, Python, Bash, Perl
• Experience developing databases with an Agile development process including scrums, planning events, backlog grooming, retrospectives and demos.
• Experience in Design and implementing scalable database schemas and configurations, File system layout, Physical partitioning, Sharding and Replication, incremental backups, Restores, and recovery models.
• Deep understanding of systems performance of PostgreSQL, and advanced knowledge of Postgres internals
• Experience with Infrastructure automation (Terraform, Ansible, etc.), CI/CD pipelines (GIT, Jenkins etc.), and configuration management tools (Ansible, Chef etc.).
• Splunk, Nagios, Elasticsearch, Kibana, CloudWatch and Logstash and ways to scale these systems.
• Experience working with private and public clouds (IAAS, GCP, AWS, etc.) and capacity management, Cost Optimization principles.

Other Qualifications:

2+ years of experience in the following:

• Orchestration tools like Kubernetes and solid understanding of containerization (Docker).
• Working knowledge of Google Cloud SQL or Oracle Database.
• Source control management such as Git, GitHub
• Knowledge of web servers and Cloud load balancers such as Apache HTTP Server, NGINX, HA-Proxy, AWS ELB/NLB.
• Effective communication of complex technical concepts.
• Bachelor’s in computer science or equivalent