Perform on premise database dependency analysis, design and plan migration of SQL server databases to AWS RDS.
• Ensure AWS database resources are sized properly, and design appropriate structures and policies for optimal performance, monitoring, operation & maintenance
• Should interact and work with multiple infrastructure and IT groups for dependency assessment & validations, environment setup, maintenance and support
• Should update, create and troubleshoot T-SQL scripts, stored procedures, functions etc. during AWS migration.
• Should automate SQL server deployment through infrastructure as a code mechanism.
• Develop documentation & provide SME guidance for best practices on AWS cloud database infrastructure setup, operations, and upgrades.
Required Skills & Experience;
• Experience managing and administering on premise sql server databases with multiple versions (2008 to 2019) and at scale.
• Experience managing, administering databases in AWS database solutions such as Amazon RDS, Amazon Aurora, Amazon Redshift and Amazon DynamoDB.
• Experience in AWS services like IAM, S3, Athena, Glue, Data pipeline, Step, Data migration services, Cloud watch, Cloud trail, and Lambda.
• Experience migrating on premise SQL databases to AWS Cloud database platforms.
• Experience in database CI/CD pipelines, and DevOps is a must.
• Ability to work on multiple high priority tasks, and adjust to changes on priorities & deadlines.
Preferred Skills;
• Having an AWS specialty certification in big data, database or analytics is a plus.