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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database Architect / DesignerEmployement Type: Full time