About Company
Papigen
is a fast-growing global technology services company, delivering innovative digital solutions through deep industry experience and cutting-edge expertise. We specialize in technology transformation, enterprise modernization, and dynamic areas like Cloud, Big Data, Java, React, DevOps, and more. Our client-centric approach combines consulting, engineering, and data science to help businesses evolve and scale efficiently. We support flexible engagement models including Time & Material, Staff Augmentation, and SoW-based Managed Services
Job Overview
We are urgently seeking an experienced and detail-oriented
PL/SQL Developer
with a strong background in
Oracle PL/SQL
,
SQL
, and
PostgreSQL
development. The ideal candidate will have hands-on experience in
database development, data migration, and performance optimization
within an
Agile SDLC environment
. The role requires a proactive professional capable of designing complex queries, writing optimized procedures, and ensuring data accuracy and integrity across systems.
Key Responsibilities
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Design, develop, and optimize PL/SQL procedures, functions, packages, triggers, and views to support enterprise applications.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Analyze existing SQL/PLSQL code and perform query optimization and performance tuning.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Develop and maintain database logic for data migration, transformation, and validation processes.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Collaborate with cross-functional Agile teams for requirement analysis, sprint planning, and delivery.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Implement robust and secure data migration strategies between complex database systems (Oracle, PostgreSQL, or Azure SQL).
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Support and automate processes using Azure Functions, Azure Key Vault, and integration with dynamic APIs if required.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Ensure data quality, security, and compliance with organizational standards and policies.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Troubleshoot database-related issues, identify root causes, and apply timely fixes.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Maintain proper technical documentation, schema definitions, and deployment scripts.
Required Skills & Experience
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> 6–8 years of hands-on experience in Oracle PL/SQL and SQL development.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Strong knowledge of PostgreSQL and experience in data migration and transformation.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Expertise in writing complex queries, stored procedures, functions, and triggers for high-volume transactional systems.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Sound understanding of database design, normalization, and data modeling principles.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Practical experience in performance tuning and query optimization techniques.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Exposure to Azure ecosystem tools such as Azure PostgreSQL, Azure Functions, and Azure Key Vault.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Ability to work effectively in an Agile/Scrum environment with sprint-based delivery.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Strong analytical, debugging, and documentation skills.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Excellent verbal and written communication skills for technical discussions and stakeholder collaboration.
Preferred Qualifications
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Hands-on experience in data migration projects from legacy to modern SQL-based systems.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Working knowledge of ETL concepts or tools like SSIS, Pentaho, or Azure Data Factory.
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Familiarity with cloud-based database architecture and automation pipelines (CI/CD).
- p]:pt-0 [&>p]:mb-2 [&>p]:my-0"> Certifications in Oracle SQL/PLSQL or Azure Database Solutions will be an added advantage.
Skills: agile,sql,oracle sql developer,postgresql,azure,pl/sql,data migration
