Technical Specialist - DBRE

Wiley
10 days ago
0 Applied
Expires on: Oct 20 2022

Ref. No 00001198

Description

At Wiley, the Database Reliability Engineer (DBRE) – which is an extension or subset of the SRE model, just specializing in database technologies but with the same underlying DevOps principle, will be a lead strategic partner in building and maintaining a Database as a Service Platform to help software engineers build, deploy, and monitor applications with an emphasis on automation. This is an engineering discipline that combines software and systems engineering to build and run large-scale, massively distributed, fault-tolerant systems.

At Wiley, DBRE is responsible for the availability and reliability of our most critical database platform services, and ensures they meet the requirements of our internal and external users. The hosting platforms will be in Wiley’s on-prem servers as well as public clouds such as AWS/Azure.

  • Have 5-7 years Linux/Unix shell experience, especially with troubleshooting production systems.
  • Have 3-5 years in building, configuring, and managing clusters of relational and/or non-relational databases.
  • Have 1-2 years using cloud database services such as Amazon RDS .
  • Exposure to DEV /OPS configuration management system automation using tools such as Chef, CloudFormation, Ansible, Terraform etc.
  • Extensive hands-on experience with Continuous Integration/Continuous Delivery & Deployment techniques and tools (Jenkins, TravisCI, Argo CD, GitLab, etc.)
  • Experience with containerization (Docker) and a container orchestration system (ECS/Kubernetes)
  • Have good communication skills - both verbally and in writing.
  • Are able to document processes and procedures.
Responsibilities
  • Drive technology initiatives by taking the lead and providing guidance to team members
  • Building and maintaining large-scale production relational backends such as MySQL, MS SQL, Oracle - whether on-prem or in one of the major public cloud offerings.
  • Involve with design build, maintain and monitor CI/CD pipelines and all deployments up to production
  • Creating automated repeating database tasks and deployments (such as migrations, replication, restoring backups and spinning up new clusters)
  • Handling performance tuning, backup, and recovery.
  • Developing and automating best practices and repeatable procedures for deploying and scaling databases.
  • Providing production and lower-environment support for assigned applications as relates to their back-end databases.
  • Developing processes and automation for optimizing database security around our customers' private and confidential information (e.g. data masking, encryption).
  • Building and maintaining High Availability (HA) and Disaster Recovery (DR) design/implementation for complex mission-critical environments.
  • Translating business requirements into application database architecture needs.
  • Help with design and implementation of infrastructure assets using cloud services, OSS systems and platforms
  • Participate in code and design reviews, teaching and learning from other engineers
  • Identify improvement opportunities on existing systems, build plans and execute improvements
  • Research of automation related technologies
  • Diagnosing and troubleshooting database errors, including participating in an on-call rotation and available for on-call support as needed, working over weekends if required.
Skills
cloud database services
DEV /OPS configuration management system
Continuous Integration/Continuous Delivery
Linux/Unix shell
Amazon RDS
containerization (Docker)
communication
Industry Sector