Senior Cloud Database Engineer

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;
• 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.

We offer:

• Variety of domains;
• Full stack of technologies;
• Professional and highly interactive team environment;
• Management style based on openness and trust;
• Stable support in personal education and growth;
• Worthy compensation;
• Active community with regular knowledge sharing;
• Flexible work conditions;
• Huge office with extra space for work & leisure.

Experience:

• Python: 3 years (preferred)
• AWS: 5 years (preferred)
• Terraform: 3 years (preferred)