Senior Database Migration Consultant (PostgreSQL)

Edb - Lincoln, NE

Full-time - Senior

Remote - Lincoln, NE

Food and Beverage Retailers

About the position

As a Senior Migrations Consultant at EDB, you will play a pivotal role in supporting our North America region by delivering technical migration services to our global EDB Enterprise customers. This position is designed for a customer-focused individual who possesses a strong blend of interpersonal skills and in-depth knowledge of Oracle database migrations and deployments. Your primary responsibility will be to lead Oracle migrations to Postgres or EDB Postgres from inception to completion, ensuring that customer business requirements are translated into actionable technical requirements. You will also be expected to deliver conversion and migration services while coaching and mentoring team members throughout the process. In this role, you will become an expert in the use and application of EDB migration tooling, methodology, and technology, which will enable you to proficiently apply these tools to customer Oracle migrations. You will lead the scoping efforts for schema and data migrations, providing level of effort estimates for migration implementations and contributing to professional services proposals and statements of work. Your expertise will be crucial in assessing customer schemas and DDLs to determine migration compatibility between Oracle and EDB Postgres, as well as performing actual migrations from Oracle databases to PostgreSQL and EDB Postgres Advanced Server. Additionally, you will be responsible for developing internal enablement materials, evaluating customer deployments of Postgres, and making recommendations for improvements. You will also need to have familiarity with programming languages such as C, C++, PHP, Python, Java, and Ruby to guide customers in developing custom Postgres-based applications. Performance tuning, upgrading applications to the latest version of Postgres, and setting up high availability configurations will also be part of your responsibilities. Throughout the project, you will document all work clearly and concisely in runbooks and project deliverables, ensuring effective communication with customers.

Responsibilities

• Become expert in the use and application of EDB migration tooling, methodology, and technology to proficiently apply to Customer Oracle Migrations.
• Lead the scoping effort of schema and data migrations to provide level of effort estimates for migration implementations and provide input, content, and reviews for professional services proposals and statement of works.
• Assess customer schemas/DDLs to determine the migration compatibility between Oracle and EDB Postgres software for the purpose of estimating migration efforts for schemas and data.
• Perform Oracle database migrations to PostgreSQL and EDB Postgres Advanced Server.
• Learn how to perform database migrations from SQL Server, MySQL, DB2 or other non-Postgres databases as needs arise.
• Develop internal enablement material as needed and requested.
• Coach and mentor teammates in migration strategy, approaches, tools, techniques, best practices and 'how to' instruction.
• Evaluate customer deployments of Postgres, and associated tools, and make recommendations on how to improve them and document the required technical steps.
• Have familiarity with programming languages like C, C++, PHP, Python, Java and/or Ruby to guide customers in the development of custom Postgres-based applications.
• Perform performance tuning for new and/or existing Postgres or EDB Postgres database deployments.
• Work with customers to upgrade their application to the latest version of Postgres and configure, update, and/or change their application to take advantage of new features.
• Set up High Availability configurations using PostgreSQL, EDB Postgres, and the appropriate recommended tooling.
• Evaluate database security needs by customer and make best practice and customer focused recommendations.
• Define and design Postgres/EDB Postgres Target architectures.
• Understanding and implementing application requirements.
• Install, configure, test, and deploy Postgres/EDB Postgres on Target architecture.
• Define and implement data migration strategies to migrate non-Postgres databases to Postgres/EDB Postgres.
• Document all work clearly and concisely in runbooks, project deliverables, and all customer communications throughout the project.
• Design and implement Postgres/EDB Postgres backup strategies and perform upgrades and patching.

Requirements

• Prior experience in consulting services, being able to consult with and advise customer through their Postgres adoption journey.
• Strong critical thinking and active listening skills, must be able to assess and evaluate customer pains and translate to technical Postgres solutions.
• Strong verbal and written communication skills, bold in your confidence to enable, teach, and guide customers successfully through their Postgres journey highlighting the best practices and 'gotchas' along the way.
• Ability to break down technical points and present them to different audiences.
• Obtain certification in EDB Software including EDB Enterprise Postgres Advanced Server and EDB Postgres Distributed software.
• Foundational cloud experience with AWS and/or Azure.
• Well-versed in SQL and Procedural Languages (PL/PSQL or Pl/PgSQL).
• Exercise strong time management skills, and the ability to balance multiple coincident demands.

Nice-to-haves

• Possess a Bachelor or Master of Science Degree in Computer Science/Computer Engineering or equivalent experience.
• Possess a strong understanding of the procedural languages PL/SQL, T-SQL, and Pl/PgSQL.
• Have general system administration and performance skills for Linux, including facility with scripting.
• Be confident in working independently on projects as well as perform and contribute as team member on a project.
• Pay meticulous attention to detail.
• Relish a fast paced, dynamic and exciting work environment.
• Be willing to learn new Postgres AI skills if asked/requested/needed.
• Experience with tools such as Jira, Confluence, Git, Ora2PG.

Benefits

• Access to Modern Health for health and wellness tips and practices.
• Wellness Fridays extending to December 2024.
• Range of benefits and resources to promote a healthy work-life balance and wellness.