PostgreSQL DBE 4

Employment Type

: Full-Time

Industry

: Miscellaneous



Job Summary: A PostgreSQL Engineer is a professional, specialist position responsible for supporting the PostgreSQL database infrastructure. Knowledge of PostgreSQL best practices for performance and security purposes is a must. This contract position requires participation in complex migration projects to PostgreSQL as well as the maintenance of the PostgreSQL infrastructure on a day-to-day basis. This position requires several years of experience as a PostgreSQL DBA, with knowledge of data, objects and data type conversions. As part of the daily operations, this position requires to respond to service request and incidents. Qualifications: Education: Bachelor's degree in related field or equivalent professional experience Work Experience: 6+ years relevant experience 3+ years of experience in PostgreSQL Demonstrated Skills & Abilities: Experience with open-source migration tools like ora2PG, db_migrator (ora_migrator extension), OraFce Great troubleshooting skills Advanced knowledge of engineering best practices for PostgreSQL Excellent knowledge on how to configure, maintain and monitor backups and security processes Advanced knowledge on how to configure, maintain and monitor database replication and high availability Possesses and applies a broad knowledge of principles, practices, and procedures of PostgreSQL to the completion of difficult assignments Experience with migration of medium/large Oracle databases with medium/high level of complexity into PostgreSQL on-prem is a requirement Experience with Change, Incident, and Problem management processes Strong interpersonal skills with ability to communicate technical content to general audiences Strong interpersonal skills to work under pressure This job operates in a professional office environment To successfully perform the essential functions of the job there may be physical requirements which need to be met such as sitting for long periods of time and using computer monitors/equipment Preferred Qualifications: Master's degree Experience supporting data services and integrations in virtual environments Experience with both transactional and analytical data processing Knowledge on PostgreSQL solutions in AWS/Azure and migration process for AWS/Azure Experience working in an operational and in a structured large-scale environment Responsibilities: Participate in a team that engineers the on-prem PostgreSQL solution to replace the Oracle on-prem infrastructure. Assist in the creation of standards for the on-prem PostgreSQL database solution Assist in the creation of standards and procedures to operate and maintain the PostgreSQL infrastructure Thoroughly document all the engineering process defined to configure the on-prem PostgreSQL infrastructure Ability of determine configuration requirements for PostgreSQL on-prem that will help to a later migration to the Cloud Anticipate, understand and respond to the needs of internal and external clients Comply with policy, standards, and regulatory requirements EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at employeeservices@apexsystemsinc.com or 844-463-6178.

Launch your career - Create your profile now!

Create your Profile