Pl/SQL Developer

Job Title: 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:

-Should have 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.