PostgreSQL Developer – Oracle Migration, PL/pgSQL & NoSQL
- Bengaluru - Thanissandra (BCIT); Pune - Hinjewadi (Ascendas)
- Full-time
- Posted
Skills
Job description
Job Summary
Synechron is seeking an experienced PostgreSQL Developer with strong expertise in database development, performance optimization, Oracle-to-PostgreSQL migration, and NoSQL databases.
The role will focus on designing, developing, maintaining, and optimizing PostgreSQL database solutions. The PostgreSQL Developer will support database migration, query conversion, stored procedure development, performance tuning, backup and recovery, production support, and database governance.
This position will contribute to business objectives by improving database reliability, scalability, availability, performance, migration outcomes, and the efficiency of application data services.
Software Requirements
Required Software Skills
•PostgreSQL: 8 years of database development experience, including database design, development, maintenance, monitoring, and troubleshooting.
•SQL: Strong experience developing, analyzing, and optimizing complex SQL queries.
•PL/pgSQL: Strong experience developing and maintaining stored procedures, functions, triggers, and database logic.
•NoSQL databases: Strong working knowledge and development experience with NoSQL database concepts and technologies.
•Oracle-to-PostgreSQL migration: Proven experience converting stored procedures, packages, SQL queries, and related database components to PostgreSQL.
•Database performance tools: Experience analyzing query performance, execution plans, indexing, database workload, and resource utilization.
•Backup and recovery tools: Experience implementing and supporting database backup, recovery, maintenance, and availability strategies.
•Database monitoring tools: Experience monitoring database health, capacity, performance, availability, and production issues.
•Agile and DevOps tools: Familiarity with tools and practices that support Agile delivery, source control, automation, testing, deployment, and operational support.
Preferred Software Skills
•Experience with database migration, schema comparison, validation, and reconciliation tools.
•Exposure to cloud-based PostgreSQL and NoSQL database services.
•Familiarity with database automation, deployment pipelines, and infrastructure management tools.
•Experience with database observability, alerting, and performance-reporting solutions.
•Knowledge of tools supporting data quality, governance, lineage, and compliance.
Version and Experience Guidance
•Specific software versions are not mandated in the requirements.
•Candidates should have experience with current, production-supported versions of PostgreSQL, PL/pgSQL, SQL, and relevant NoSQL technologies.
•Candidates should be able to assess compatibility, manage database upgrades, apply version control, and support migration between technology versions.
•Experience should include hands-on development and production support in enterprise environments.
Overall Responsibilities
•Design, develop, maintain, and enhance PostgreSQL database solutions.
•Develop and optimize complex SQL queries, PL/pgSQL procedures, functions, triggers, and database objects.
•Lead and support Oracle-to-PostgreSQL migration activities, including stored procedures, packages, schemas, queries, and database logic conversion.
•Design and support NoSQL database solutions based on application and data requirements.
•Analyze and improve database performance, scalability, reliability, and availability.
•Review execution plans, indexing strategies, query patterns, database configuration, and resource utilization.
•Implement database backup, recovery, maintenance, monitoring, and operational support strategies.
•Monitor database health and troubleshoot development, test, and production issues.
•Collaborate with application development, infrastructure, DevOps, testing, and delivery teams to integrate database solutions.
•Validate data integrity, migration results, schema changes, query behavior, and application compatibility.
•Create and maintain technical documentation, database standards, migration procedures, and operational runbooks.
•Follow database governance, security, change management, and release management standards.
•Identify opportunities to improve database efficiency, resource utilization, automation, sustainability, and operational cost.
•Contribute to measurable outcomes such as improved query response time, migration accuracy, database availability, recovery readiness, and production stability.
Technical Skills (By Category)
Programming Languages
Essential
•Strong SQL development experience.
•Strong PL/pgSQL development experience.
•Ability to develop stored procedures, functions, triggers, views, scripts, and database utilities.
•Ability to analyze and convert procedural database logic during migration activities.
•Ability to write maintainable, testable, and performance-conscious database code.
Preferred
•Experience with scripting languages used for database automation and migration activities.
•Experience developing automation scripts for deployment, validation, monitoring, backup, and recovery.
•Exposure to programming languages used by application teams for database integration.
Databases/Data Management
Essential
•Strong PostgreSQL database development experience.
•Strong knowledge of SQL, PL/pgSQL, relational database design, normalization, indexing, constraints, transactions, and data integrity.
•Strong expertise in NoSQL database concepts and implementation.
•Proven Oracle-to-PostgreSQL migration experience.
•Experience converting stored procedures, packages, SQL queries, schemas, and database logic.
•Understanding of database backup, recovery, maintenance, monitoring, and availability.
•Ability to validate data completeness, accuracy, consistency, and integrity during migration and release activities.
•Experience supporting structured and semi-structured data management requirements.
Preferred
•Experience with high-availability database architectures and replication.
•Exposure to partitioning, sharding, caching, and distributed data patterns.
•Experience with data archival, retention, reconciliation, and lifecycle management.
•Familiarity with database governance, data lineage, and data quality practices.
•Experience supporting cloud-based PostgreSQL and NoSQL deployments.
Cloud Technologies
Essential
•Understanding of database deployment, configuration, monitoring, and support in enterprise or cloud environments.
•Understanding of scalability, availability, backup, recovery, access management, and resource utilization for database platforms.
•Ability to support database environments across development, testing, staging, and production.
Preferred
•Experience deploying and managing PostgreSQL or NoSQL databases on public cloud platforms.
•Familiarity with managed database services, cloud storage, networking, identity, and security controls.
•Experience with cloud migration, database modernization, and resource optimization.
•Understanding of sustainable database operations, including efficient storage, workload optimization, and capacity management.
Frameworks and Libraries
Essential
•PostgreSQL database platform and associated development tools.
•SQL and PL/pgSQL development frameworks and utilities.
•NoSQL database technologies and data-access patterns.
•Database migration and conversion tools or equivalent development approaches.
•Database monitoring, query analysis, execution-plan, backup, and recovery utilities.
•Tools supporting source control, database change management, and deployment automation.
Preferred
•Database schema comparison and data validation tools.
•Database observability, performance analysis, and alerting frameworks.
•Data integration and migration libraries.
•Tools supporting automated database testing and release validation.
Development Tools and Methodologies
Essential
•Experience across the database development lifecycle, including requirements analysis, design, development, testing, deployment, monitoring, troubleshooting, and support.
•Experience with Agile development methodologies.
•Familiarity with DevOps methodologies and collaborative delivery practices.
•Experience using source control and change management processes for database objects and scripts.
•Ability to create database designs, migration plans, test cases, performance reports, operational procedures, and technical documentation.
•Experience validating schema changes, queries, procedures, functions, data conversions, and application integrations.
•Experience supporting root-cause analysis, incident resolution, release activities, and continuous improvement.
Preferred
•Experience with database CI/CD pipelines and automated deployment.
•Familiarity with automated database testing, regression testing, and migration validation.
•Experience with infrastructure as code and environment automation.
•Exposure to Agile planning, estimation, backlog management, and iterative delivery.
•Experience creating database monitoring dashboards and operational metrics.
Security Protocols
Essential
•Understanding of database access control, authentication, authorization, roles, privileges, and least-privilege principles.
•Ability to protect sensitive data during development, migration, testing, backup, recovery, and production operations.
•Understanding of secure database configuration, credential management, encryption, auditing, and controlled access.
•Ability to follow database governance, privacy, security, and change management requirements.
•Awareness of risks related to unauthorized access, SQL injection, excessive privileges, data exposure, and insecure backup handling.
Preferred
•Experience supporting database security reviews, audit activities, and compliance controls.
•Familiarity with encryption at rest and in transit, secrets management, and database activity monitoring.
•Experience applying security checks to database deployment and migration processes.
•Knowledge of masking, tokenization, or controlled data access for non-production environments.
Experience Requirements
•Overall experience: 8 years of professional experience in PostgreSQL development, database engineering, database administration, or a related technical role.
•PostgreSQL experience: Strong hands-on experience developing, maintaining, optimizing, and supporting PostgreSQL databases.
•Migration experience: Proven experience with Oracle-to-PostgreSQL migration projects, including stored procedures, packages, SQL queries, schemas, and data validation.
•NoSQL experience: Strong knowledge and practical experience with NoSQL databases and related data-management approaches.
•Performance experience: Experience with database performance tuning, query optimization, execution-plan analysis, indexing, capacity planning, and resource management.
•Operations experience: Experience with backup, recovery, maintenance, monitoring, troubleshooting, availability, and production support.
•Delivery experience: Familiarity with Agile and DevOps methodologies, collaborative development, version control, release management, and continuous improvement.
•Industry preference: Experience supporting enterprise-scale, high-volume, regulated, or operationally critical database environments is preferred.
•Alternative experience pathways: Equivalent combinations of relevant professional experience, technical training, substantial migration projects, open-source contributions, or demonstrated production implementations may be considered.
•Outcome evidence: Candidates should demonstrate measurable contributions to migration accuracy, database performance, system availability, operational efficiency, data integrity, recovery readiness, or production stability.
Day-to-Day Activities
•Develop, review, test, and optimize PostgreSQL SQL queries, PL/pgSQL procedures, functions, triggers, sche