Senior Cloud Database Engineer (offline)

Smart Tek Solutions is a leading IT service provider that serves Fortune 500 companies in the US. Our goal is to become a leading employer in Europe, and now we are looking for a talented and experienced Senior Cloud Database Engineer.

Responsibilities

- Plan database capacity, including sizing estimation of computing and storage requirements for databases by monitoring usage and trends;

- Monitor and analyze information and database systems and evaluate their performance to discover ways of enhancing them;

- Design and implement Highly Available cloud-based database systems;

- Design and implement policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets;

- Determine security requirements, and the need for network and security controls;

- Implement cloud-based database authentication and authorization;

- Design and execute Premise-to-Cloud and Cloud-to-Cloud database migrations, including dependency identification and cross-team coordination with the application owners;

- Create standard build guide parameters and configuration for all database platforms;

- Create migration plans for Production servers with near zero downtime;

- Develop database installation, data migration and upgrade scripts, which are part of CI/CD;

- Install, build, configure and deploy cloud database solutions based on technical and business requirements;

- Implement database performance monitoring, fault monitoring and security monitoring in AWS cloud;

- Manage production testing and QA database environments;

- Troubleshoot complex data-related problems and database errors;

- Provide documentation as appropriate including design documentation;

- Create and maintain point-to-point integrations between systems/environments.

Requirements:

- Technical knowledge of AWS Cloud computing architecture/design/best practices;

- 5+ years of experience in design, building and managing secured, highly available database Cloud solutions for enterprise customers;

- 5+ years of experience in database management, maintenance, optimization and performance tuning supporting medium/large global infrastructures;

- Experience building roadmaps, strategy for migrating legacy data solutions to AWS infrastructure;

- 5+ years of DBA experience, including system migrations of SQL Server, MySQL, PostgreSQL, and Oracle;

- Knowledge of database security best practices from design to implementation and operations;

- Experience with cloud database backup and recovery;

- Experience implementing High Availability and Disaster Recovery infrastructure, including familiarity with Always On, and data replication;

- Experience with AWS Aurora (MySQL/Postgres);

- Knowledge of CloudWatch, IAM configurations;

- Experience with implementing operational best practices around change management, escalations, uptime, etc;

- 5+ years of SQL scripting experience;

- 3+ years of Python experience;

- 3+ years of Terraform experience;

- Bachelor's degree in Computer Science, engineering, statistics, informatics, information systems, or a similar quantitative field.

Will be a plus:

- MS or higher degree in Computer Science, Engineer, Statistics, Informatics, Information Systems or in a similar quantitative field;

- Experience using CI/CD tools and automation for database deployments in AWS;

- Liquibase experience;

- Experience with Snowflake;

- Experience with DocumentDB and DynamoDB;

- Experience with AWS DMS;

- SSIS experience.