Pl/SQL Developer - Oracle to PostgreS Migration and Refactoring

At NAVISITE - Part of Accenture, celebrating our employees and investing in their well-being and development is not just a priority or an initiative - it's woven directly into our company fabric. Our mantra and unofficial corporate hashtag #SoMuchGood is all about recognizing our team's commitment and achievements, both inside and outside the office. It's that theme that has driven a host of programs at Navisite - it's who we are. What we do is simple: We work hard, we have fun, we give back to the community and we never take our eye off the goal - creating a modern cloud MSP with a global, talented team of employees. Join us and be part of our team!!

Position: PL/SQL Developer (Oracle to Postgres, SQL Server to Postgres Migration/Refactoring)

Job Overview:

We are seeking an experienced PL/SQL Developer to join our team for a critical project involving the migration and refactoring of database systems from Oracle to PostgreSQL and from on-prem to AWS. Anticipated projects also include migrating from SQL Server to Postgres for both AWS and Azure platforms. The ideal candidate will have a strong background in PL/SQL development, in-depth knowledge of Oracle databases, cloud-based database services such as Amazon RDS for PostgreSQL/Aurora or Azure database for PostgreSQL, migrating tools like ora2pg, SCT, DMS and substantial experience with PostgreSQL. Candidates must exhibit strength resolving complex refactoring challenges due to heavy usage of advanced Oracle techniques and packages. Candidates should be capable of automating straightforward refactoring activities, for example by creating libraries of scripted solutions for specific scenarios. This role requires excellent problem-solving and communication skills, attention to detail, and the ability to work collaboratively in a dynamic environment, with a very strong focus on system performance and quality. Successful candidates must be able to work quickly and accurately.

Key Responsibilities:

Migration Planning and Execution: Develop and execute comprehensive plans for migrating databases from Oracle to PostgreSQL, ensuring data integrity and minimal downtime. PL/SQL to PL/pgSQL Conversion: Refactor and optimize PL/SQL code to PL/PgSQL, ensuring equivalent functionality, high quality, and performance improvements. Design, develop, and test non-PL/PgSQL solutions as needed to ensure functional equivalency, for example by invoking Lambdas. Database Schema Transformation: Convert Oracle database schemas, including tables, indexes, views, triggers, functions, and stored procedures to PostgreSQL. Performance Tuning and Optimization: Analyze and optimize database performance post-migration, addressing any issues related to query performance, indexing, and data retrieval. Testing and Validation: Develop and implement rigorous testing protocols to validate the success of the migration, including unit tests, integration tests, and performance tests. Documentation and Training: Create detailed documentation of the migration process and provide training to internal teams on new database structures and best practices. Collaboration and Support: Work closely with cross-functional teams, including software developers, data analysts, and system administrators, to ensure seamless integration and operation of the new PostgreSQL database.

Required Qualifications:

Education: Bachelor’s degree in computer science, Information Technology, or a related field.

Experience:

Minimum of 7 years of experience as a PL/SQL Developer. Proven experience in migrating databases from Oracle to PostgreSQL. Strong understanding of both Oracle and PostgreSQL database architectures.

Technical Skills:

High proficiency in PL/SQL and PL/pgSQL. Expertise in Oracle and PostgreSQL database design, development, and optimization. Strong experience with database migration tools and techniques (SCT, DMS, ora2pg, AWS Lambda). Expertise in SQL performance tuning and optimization. Knowledge with scripting languages (e.g., Python, Bash) for automation.

Soft Skills:

Excellent problem-solving abilities. Strong analytical skills and attention to detail. Effective communication and documentation skills. Ability to work independently and as part of a team. Ability to work efficiently on large-scale projects.

Preferred Qualifications:

Experience working on AWS Cloud Platform with good domain knowledge on services such as EC2, S3, IAM, EBS, SQS, etc. Experience with cloud-based database services such as Amazon RDS for PostgreSQL or Azure database for PostgreSQL. Knowledge of migrating tools like SCT and DMS. Knowledge of database security best practices. Experience with agile development methodologies. Knowledge of other databases like Microsoft SQL and MySQL is a plus. Knowledge of data warehousing concepts and ETL processes. Experience with database design, data modeling, and schema normalization. Familiarity with database administration tasks such as backup and recovery, replication, and high availability configurations.

NAVISITE - Part of Accenture, is an equal opportunity employer. We celebrate diversity and we are committed to creating an inclusive environment for all employees. Navisite does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, parental status, military service, or other non-merit factor.

Internal Applicants – No sponsorship available / External Applicants – Sponsorship not guaranteed. Any potential sponsorship depends on a number of factors, including but not limited to the local candidate pool and can vary from year to year.

You must ensure compliance with data protection legislation under the DPA, EU GDPR, any other applicable data protection legislation .

Key Skills

• PostgreSQL