Associate Technical Specialist - Database Reliability Engineer

Wiley
11 days ago
tie
0 Applied
Expires on: Jun 03 2024
tie

Ref.No 00003191

Description
  • Have 5-7 years of PowerShell/ Windows command line scripting experience, especially with troubleshooting production systems.
  • Have 3-5 years of experience in building, configuring, and managing SQL Server clusters. Experience with other relational and non-relational databases such as MySQL, Oracle, MongoDB and CouchDB is desirable but not mandatory.
  • Have 1-2 years of experience using cloud database services such as Amazon RDS.
  • Have Exposure to DEV-OPS configuration management system automation using tools such as Terraform, Ansible, CloudFormation, Chef etc.
  • Have extensive hands-on experience with Continuous Integration/Continuous Delivery & Deployment techniques and tools such as Jenkins and GitHub.
  • Have experience with containerization (Docker) and a container orchestration system (ECS/Kubernetes).
  • Have effective communication skills - both verbally and in writing.
  • Can document the processes and procedures involved.


  • Drive technology initiatives by taking the lead and providing guidance to team members.
  • Designing, building, and maintaining large-scale production relational backends primarily using Microsoft SQL Server, both on-premises and in the cloud (with a particular emphasis on Relational Database Service in Amazon Web Services).
  • 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.
  • 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
MySQL
Oracle
MongoDB
Cloud technology
PowerShell/ Windows
Industry Sector