Peersight
Employers
Jobs
Companies
Top Cities
Log In
Jobs
Software Engineer Senior Database Developer Sales and Merchandising Representative Sales Management Trainee advertising specialist Driver Administrative Associate Independent Contractor - Local BUSINESS SALES CONSULTANT Junior Accounts Receivable Specialist - Driver Jr Engineer Jr Software Engineer Cybersecurity Engineer Territory Sales Representative FRONT END DEVELOPER Mobile Developer Senior React Developer 5G Software Validation Developer Supervisor Developer Services CoE Senior Programmer Analyst Learning Assistance Teacher Front-End Web Developer DAHES Educational Assistant 5 Substitute Teacher - PROGRAM Software Engineer Intern - Chicago Developer Specialist Jr Junior Software System Engineer Temporary Junior Web Designer Front-End Developer Software Engineer Software Engineering Intern - Summer Software Engineering Summer Internship Front End Solutions Developer Outside Sales Associate outside sales representative Outside Sales Representative Relationship Manager Director Entry Level Digital Marketing Specialist Career Centre Program Assistant Data Scientist CNC Mill Machinist and Programmer Account Manager - Premium Accounts CNC Programmer Setup Operator IV Mobile iOS Developer Django Software Developer - Contractor Python Developer Software Engineer Newest Jobs
Companies
Yelp Two Sigma CareGuide Sterling-Turner AsteroidX LowCostWebDesignFirm.com Clearbanc Aecom Exact Media First Convenience Bank WeWork Aerotek The Youth Connection Shopify Recovhub AT&T mappedin American Income Life Amazon Flex Insight Global Clickworker Paylocity Scotiabank Vector Marketing Creative Circle TD Bank Microsoft Jane Street Desjardins Top Hat Unbounce Hootsuite SnapTravel GoParkr JUUL Labs autoTRADER.ca Doordash UnitedHealth Group Checkout 51 ContactMonkey 51talk Walgreens Zillow CIBC Instacart Hatchways Intel Mobeewave ScribbleLive CGI Group, Inc. All Companies
Top Cities
Chicago, Illinois Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs New York, New York Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Toronto, Ontario Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Vancouver, British Columbia Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Calgary, Alberta Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs San Francisco, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Montréal, Quebec Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs Los Angeles, California Sales Jobs Engineering Jobs Marketing Jobs Product Jobs Design Jobs Customer Support Jobs
Navigation
My Profile Log Out

Senior Database Administrator At Amazon.com

Location: Vancouver, British Columbia

Job Description

Job Description

Expand your career beyond Oracle. We are looking for a senior Database Administrator with 5+ years of Redshift, PostgreSQL or MySQL experience to help move 1000+ Oracle databases to AWS (Amazon Web Services). This position offers the opportunity to manage petabytes scale data lakes and become an expert on AWS persistence technologies, including RedShift, Aurora PostgreSQL and Aurora MySQL. We provide interfaces for our internal customers to access and query the data hundreds of thousands of times per day, using Amazon Web Service’s (AWS) Redshift. We build scalable solutions that grow with the Amazon business.
BDT is growing, and the data processing landscape is shifting. Our data is consumed by thousands of teams across Amazon. We are also supporting Redshift clusters for our customers so they never had to maintain, monitor, and optimize their own compute resources. We support operation/management services of Redshift clusters, allowing customers to focus on their analytics. AWS Solutions Architect certification is a plus, if you don’t have it, you will be given the opportunity to achieve it. The Amazon Big Data Technologies (BDT) team manages the databases that run Amazon.com, our DBAs support thousands of performance critical, highly available, massively concurrent, distributed Oracle databases on a UNIX/Linux platform.

The Database Administrator must be familiar with all aspects of database administration in a large scale Oracle environment, including but not limited to being able to install, upgrade, administer, maintain, and customize Redshift, MySQL, PostgreSQL and Oracle databases for both analytical and transactional environments. The Database Engineer will work with application teams to migrate existing Oracle databases to a variety of AWS persistence technologies. Redshift, Aurora PostgreSQL, and Aurora MySQL to name a few. They will also mentor junior members of the BDT Database services team.

Basic Qualifications

  • xperience in managing petabytes scale data lakes
  • Provide expert technical support for technologies including Redshift, MySQL, PostgreSQL and Oracle.
  • Demonstrated strength in data modeling, ETL development, and data warehousing
  • Experience using big data technologies (Redshift, S3, Hive, Hbase, Spark, EMR, etc.)
  • Knowledge of distributed systems as it pertains to data storage and computing
  • Perform database monitoring, maintenance, reorganizations, resource management, schema management, and capacity planning and performance tuning for the company's databases.
  • Provide technical architecture and design as required.
  • Work with application owners to support database consolidation, migration and virtualization.
  • Work with developers and analysts to support development efforts.
  • Work with various internal teams such as server, storage, backup & network administration teams to coordinate and troubleshoot infrastructure related issues.
  • Provide after-hours support as required and be part of on-call rotation.

Preferred Qualifications

  • Experience with additional database engines and technologies (RedShift, MySQL, PostgreSQL and Oracle)
  • Interface with other technology teams to extract, transform, and load data from a wide variety of data sources
  • Implement data structures using best practices in data modeling, SQL, Redshift
  • Design, implement, and support a platform providing ad-hoc access to large data sets
  • Experience with Data Conversion Strategies on various databases (Redshift, PostgreSQL, Oracle).
  • Experience with Database Partitioning Strategies on various databases (Redshift, PostgreSQL, Oracle).
  • Extensive knowledge of performance tuning techniques for heterogeneous database system (Redshift, PostgreSQL, Oracle).
  • Good organization and communications skills.
  • Strong analytical thinking and excellent troubleshooting.
  • Must possess excellent written and oral communications skills and the ability to clearly define projects, objectives, goals, schedules and assignments.
  • Requires strong interpersonal and organizational skills, including the ability to meet deadlines.
  • Redshift/PostgreSQL/Oracle DBA experience in a 24x7 production environment.
  • Experience with Redshift, Postgres system metrics and optimization strategies.
  • Expertise in one or more of: Python, Perl, Bash or other scripting language.
  • Knowledge of AWS technologies a plus.