Database Engineer II - AMZ9674698

Amazon•Seattle, WA

52d

About The Position

Own the design, implementation, operation, and support of large-scale databases that are crucial to the successful operation of our global E-commerce platform. Support and administer multiple MySQL & PostgreSQL databases for performance-critical, highly available, massively concurrent, distributed systems on a Unix/Linux platform, including participating in operational support. Support various layers of databases, including operating systems, hardware, storage, and network configurations. Troubleshoot complex technical problems, and assess and mitigate risks by conducting performance tuning, backup/recovery, and scalability/capacity planning using Linux, system calls, memory management, and debugging. Establish and maintain security and integrity controls, and formulate and monitor policies, procedures relating to data management. Establish and calculate optimum database parameters and specify users and user access levels. Migrate software systems to MySQL & PostgreSQL from other software platforms and deploy MySQL & PostgreSQL software in performance-critical, high availability environments. Provide support for system upgrades and new system releases, and perform database monitoring using SQL, PL/SQL, Unix shell scripting, and Python or Perl, security monitoring, troubleshooting, and resolution of system failures. Work with the Software development team to deliver highly available, low latency services. Gather requirements, model, design, develop, test, implement, support, and tune high availability data. Participate in design reviews with software teams, and drive feedback on architecture, design, system integration, performance, and scalability issues as it pertains to developing long-term department database technology strategies and influence cross company database engineering processes and standards.

Requirements

Bachelor's degree or foreign equivalent degree in Computer Science, or a related field and four years of experience in the job offered or a related occupation.
Must have four years of experience in the following skills: (1) designing, architecting, implementing, and optimizing database solutions while providing technical guidance on database technologies and best practices across multiple teams; (2) writing and reviewing database code, stored procedures, and data models while establishing standardized design patterns that can be adopted across teams; (3) administering and supporting multiple MySQL and PostgreSQL databases for performance-critical, highly available systems on Unix or Linux platforms; (4) performing data modeling, conducting performance tuning, managing backup and recovery processes, and handling scalability and capacity planning; and (5) utilizing SQL, Unix shell scripting, Python or Perl, and related technologies.

Nice To Haves

Please see job description and the position requirements above.

Responsibilities

Own the design, implementation, operation, and support of large-scale databases that are crucial to the successful operation of our global E-commerce platform.
Support and administer multiple MySQL & PostgreSQL databases for performance-critical, highly available, massively concurrent, distributed systems on a Unix/Linux platform, including participating in operational support.
Support various layers of databases, including operating systems, hardware, storage, and network configurations.
Troubleshoot complex technical problems, and assess and mitigate risks by conducting performance tuning, backup/recovery, and scalability/capacity planning using Linux, system calls, memory management, and debugging.
Establish and maintain security and integrity controls, and formulate and monitor policies, procedures relating to data management.
Establish and calculate optimum database parameters and specify users and user access levels.
Migrate software systems to MySQL & PostgreSQL from other software platforms and deploy MySQL & PostgreSQL software in performance-critical, high availability environments.
Provide support for system upgrades and new system releases, and perform database monitoring using SQL, PL/SQL, Unix shell scripting, and Python or Perl, security monitoring, troubleshooting, and resolution of system failures.
Work with the Software development team to deliver highly available, low latency services.
Gather requirements, model, design, develop, test, implement, support, and tune high availability data.
Participate in design reviews with software teams, and drive feedback on architecture, design, system integration, performance, and scalability issues as it pertains to developing long-term department database technology strategies and influence cross company database engineering processes and standards.