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> 68 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
