Senior Database Migration Consultant (PostgreSQL)

Senior Database Migration Consultant (PostgreSQL) at EDB in Boise, Idaho, United States Job Description A Little About Us EDB provides a data and AI platform that enables organizations to harness the full power of Postgres for transactional, analytical, and AI workloads across any cloud, anywhere. EDB empowers enterprises to control risk, manage costs and scale efficiently for a data and AI led world. Serving more than 1,500 customers globally and as the leading contributor to the vibrant and fast-growing PostgreSQL community, EDB supports major government organizations, financial services, media and information technology companies. EDB's data-driven solutions enable customers to modernize legacy systems and break data silos while leveraging enterprise-grade open source technologies. EDB delivers the confidence of up to 99.999% high availability with mission critical capabilities built in such as security, compliance controls, and observability. For more information, visit JOB SUMMARY We are looking for a customer-focused Senior Migrations Consultant supporting our North America region who can work with our global EDB Enterprise customers to deliver EDB Migration technical services. The ideal candidate has a strong blend of people skills and in-depth knowledge of Oracle database migrations, database deployments, and delivering migration deployments. The Senior Migration Consultant can translate customer business requirements into actionable technical requirements and has very strong communication skills. In this role, the Senior Migration Consultant may lead an Oracle migration to Postgres or EDB Postgres from inception to completion, deliver conversion and migration services, and coach and mentor team members. In addition to delivering technical migration services, this role supports sales and sales engineering in a pre-sales capacity for scoping and creating level of effort estimates for new migration business opportunities. Candidate's Note : This role is 100% remote. We are only looking for candidates located in the United States (East Coast preferred). There is an expectation of potential travel to customer sites as requested. What your impact will be: + 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. + 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 What you will bring: + 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 + Obtain certification in EDB Software including EDB Enterprise Postgres Advanced Server and EDB Postgres Distributed software + Have foundational cloud experience with AWS and/or Azure + Be 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 What will give you an edge: + 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, (Ubuntu, Centos, Redhat, or Debian), 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 the following tools will be beneficial: Jira, Confluence, Git, Ora2PG #LI-REMOTE EDB is committed to supporting our employees' overall well being by offering a range of benefits and resources to promote a healthy work-life balance and wellness. We provide access to Modern Health to aid employees in health and wellness tips and practices, as well as Wellness Fridays extending to December 2024 Check out our career site for more information on perks and benefits and reach out to our Talent Acquisition team for region specific benefits. We know it takes a unique mix of people and skills to help us in our mission to supercharge Postgres, and we understand that not everyone will check every box. We'd love to hear from you and we want you to apply EDB is proud to be an equal opportunity workplace. We celebrate diversity and are committed to creating an inclusive environment for all employees. EDB was built on a commitment to trust and respect each other and to embrace an array of people and ideas. These values remain at the center of our culture and are key to our company's integrity. EDB does not seek or accept unsolicited resumes or CVs from recruitment agencies. EDB and its affiliates are not responsible for, and will not pay, any fees, commissions, or any other similar payment related to unsolicited resumes or CVs except as required in a written signed agreement between EDB and the recruitment agency or party requesting payme To view full details and how to apply, please login or create a Job Seeker account