5-7 years in working with production enterprise relational database systems such as MySQL, MS SQL Server, and Oracle.
DUTIES AND RESPONSIBILITES
Building and maintaining large-scale production relational backends such as MySQL, MS SQL, Oracle - whether on-prem or in AWS' RDS environment.
Integrating No-SQL environments where required.
Designing and automating complex processes.
Utilizing databases containers such as Kubernetes.
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.
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.
Willingness to provide timely reporting in support of data security with an emphasis on the US Sarbanes-Oxley requirements.
Good communication skills - both verbally and in writing.
Ability to document processes and procedures.
QUALIFICATIONS AND REQUIREMENTS
5-7 years in working with production enterprise relational database systems such as MySQL, MS SQL Server, and Oracle.
2-3 years in working with NoSQL environments such as Couchbase and DocumentDB.
3-5 years in building, configuring, and managing clusters of relational and non-relational databases.
2-3 years using AWS services such as RDS.
5-7 years with an object-oriented programming language such as Python, Ruby, Java etc.
5-7 years utilizing SQL in the context of application performance and how to guide engineers to arrive at the optimal solution.
5-7 years Linux/Unix shell experience, especially with troubleshooting production systems.
2-3 years in configuration management system automation using tools such as Chef, Puppet, Ansible, or Terraform.