Consultant - Databases

• Employ customer facing skills to represent AWS well within the customer s environment and drive discussions with technical and business teams
• Analyze on premise transactional database environments such as Oracle, SQL Server, MySQL and/or Postgres, evaluate and plan migrations to AWS RDS, Aurora
• Develop/Enhance database T-SQL scripts to migrate from source database to target database
• Identity workarounds for specific issues and corner scenarios observed during migration
• Automate solutions for repeatable problems
• Develop test plan and test cases to demonstrate database readiness post-migration
• Work closely with application teams to ensure business functionality and SLAs are met
• Help design and implement AWS RDS and Aurora architectures and configurations for customer
• Work closely with AWS RDS, Aurora, DMS, and SCT teams to help ensure the success of project consulting engagements with customer
• Consult for the optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance
• Develop innovative solutions to complex business and technology problems
• Conduct technical sessions for internal teams, partners, and customers

A day in the life

• You will collaborate with our customers and partners on key engagements and will develop and deliver proof-of-concept projects, technical workshops, feature comparisons, and execute migration projects.
• On Migration projects, you will define the migration solution, guide the migration team, implement the solution for critical components and support the testing/cut-over activities.
• You will pursue automation for repeatable tasks and leverage AWS products/services to solve customer challenges.
• Will collaborate internally and with customer teams to ensure seamless execution.

Basic Requirement:

• 6+ years of experience in database development/migration using T-SQL/PLSQL/PLpgSQL
• 3+ years hands-on experience on MS SQL Server
• Experience with databases of 1-10TB in size across multiple database platforms (e.g. PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, etc.)
• Experience with heterogenous database migrations from one database engine to another
• Experience in performance optimization techniques
• Bachelors degree in Computer science or equivalent
• AWS Solutions Architect Certified
• High-end Troubleshooting and Communication skills

Preferred Skills:

• Scripting language (bash, Perl, python)
• Experience in Database Administration - backup/restore, replication, etc.
• Experience in ETL workflow management
• Experience in non-relational databases - DynamoDB, Mongo, etc.
• Experience in MPP data warehouse solutions - Redshift, Greenplum, etc.