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