Returning Candidate?

Database Migrations Specialist

Database Migrations Specialist

Job ID 
US-MO-Virtual Location - Missouri
Posted Date 
Amazon Web Services, Inc.
Position Category 
Recruiting Team 

Job Description

** This position is to be based out of St. Louis, MO **
Are you an experienced database or a data warehousing architect? Do you like to solve the most complex and high scale data challenges in the world today? Do you want to have an impact in the development and use of new data analytics technologies? Would you like a career that gives you opportunities to help organizations understand and use cloud computing web services to do big new things faster, at lower cost?

You will collaborate with our customers and partners on key engagements and will develop and deliver proof-of-concept projects, technical workshops, and support implementation projects.

Our professional services engagements will focus on customer solutions such as high volume OLTP environments, batch data processing, designing and deploying future state petabyte-scale data warehouse service and building and/or designing reference configurations to enable our customers and influence AWS RDS, Aurora, and Redshift adoption.

You will:

· Employ customer facing skills to represent AWS well within the customer’s environment and drive discussions with senior personnel regarding trade-offs, standard methodologies, project management and risk mitigation
· Work closely with AWS RDS, Aurora and Redshift teams to help ensure the success of project consulting engagements with customer
· Work directly with customers’ technical resources to devise and recommend solutions based on the understood requirements
· Help design and implement AWS RDS, Aurora and/or Redshift architectures and configurations for customer
· Think strategically about business, product, and technical challenges in an enterprise environment
· Analyze on premise transactional database environments such as Oracle, SQL Server, MySQL and/or Postgres, evaluate and plan migrations to AWS RDS, Aurora
· Migrate load processes from Appliance DWH system (e.g. Netezza, Teradata) to AWS Redshift
· 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
· Extended travel to customer locations may be required to sell and deliver professional services as needed, though location is St. Louis.

Amazon aims to be the most customer centric company on earth. Amazon Web Services (AWS) provides a highly reliable, scalable, low-cost infrastructure platform in the cloud that powers critical applications for hundreds of thousands of businesses in 190 countries around the world.

Basic Qualifications

· 8+ years of experience in DBA or application DBA activities
· Bachelor's degree in Computer science or equivalent experience
· Experience working with high availability and server tuning including parameters, resources, contention, etc.
· Experience with Backup/Restore and Disaster Recovery
· Experience with data warehousing and columnar DB architecture
· Experience with migrating database environments from one platform to another
· Experience with OLTP and OLAP data administration needs

Preferred Qualifications

Experience with migrating database environments from one platform to AWS desired
· Experience in optimization techniques such as projections and partitioning desired
· Able to write, tune SQL queries desired
· Scripting language (bash, Perl, python) desired
· Experience with databases of 1-10TB in size across multiple database platforms (e.g. Oracle, SQL Server, MySQL, Postgres, Netezza, Teradata, Vertica, etc.) desired
· Experience in ETL/ELT workflow management desired
· Understanding and ability to participate in all phases of the SDLC including requirements gathering, business analysis, configuration management and quality control desired