Job Title IT Operations / EDP / MIS
Category Software Developers, Applications
Associate Consultant:At AWS, we are looking for a DB Migration Specialist, with a successful record in producing high quality deliverables and achieving customer outcomes by designing and developing complex and highly available database systems.Professional Services engage in a wide variety of projects for customers and partners, providing collective experience from across the AWS customer base and are obsessed about strong success for the Customer. Our team collaborates across the entire AWS organization to bring access to product and service teams, to get the right solution delivered and drive feature innovation based upon customer needs.RESPONSIBILITIES: 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. Primary competency in SQL Server. Identity workarounds for specific issues and corner scenarios observed during migration Automate solutions for repeatable problems Develop test plan and testcases 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 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, 7+ years of experience in database development/migration using SQL Server. 5+ years of hands-on experience with Database Administration, SQL Performance Tuning and DB Migrations. Exposure with SQL Server Migration tools 2+ years of hands-on experience on PostgreSQL Experience Migrating databases of 1-10TB in size across multiple database platforms (e.g. PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, etc.) Experience with heterogeneous database migrations mostly dealing with SQL Server Workloads Experience in performance optimization techniques Bachelor's degree in Computer science or equivalent High end Troubleshooting and Communication skills AWS Solutions Architect Certified Scripting language (bash, Perl, python) Strong SQL skills, Performance Tuning and Scripts development. Experience in Database Administration backup/restore, replication, etc. Experience in ETL workflow management Experience in non-relational databases DynamoDB, Mongo, etc.