EDB is looking for a Senior Migrations Consultant to support North America customers in migrating from Oracle to EDB Postgres, enabling them to harness the full power of Postgres for transactional, analytical, and AI workloads.
Requirements
- Be well-versed in SQL and Procedural Languages (PL/PSQL or Pl/PgSQL).
- Have foundational cloud experience with AWS and/or Azure
- Possess a strong understanding of the procedural languages PL/SQL, T-SQL, and Pl/PgSQL.
- Have general system administration and performance skills for Linux, (Ubuntu, Centos, Redhat, or Debian), including facility with scripting
- Experience with the following tools will be beneficial: Jira, Confluence, Git, Ora2PG
- 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.
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 Enterprise Postgres Advanced Server (EDB Postgres) software for the purpose of estimating migration efforts for schemas and data.
- Perform Oracle database migrations to PostgreSQL and Enterprise Postgres Advanced Server.
- Learn how to perform database migrations from SQL Server, MySQL, DB2 or other non-Postgres databases as needs arise.
- 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.
Other
- 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
- Be able to travel up to 50% to customer sites when required and work on site per customer’s direction as needed
- 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
