PostgreSQL Developer – Oracle Migration, PLpgSQL & NoSQL
Job Summary
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 schemas and database objects.
- Support Oracle-to-PostgreSQL migration activities NoSQL database development data validation performance analysis backup and recovery and production troubleshooting.
- Collaborate with application development infrastructure DevOps testing and delivery teams through planning sessions technical reviews release meetings and incident discussions.
- Deliver database code migration scripts performance reports technical documentation operational procedures and recommendations within the assigned scope.
Qualifications
- Bachelors degree in Computer Science Information Technology Engineering or a related discipline; equivalent relevant experience or demonstrated technical capability may be considered.
- Minimum 8 years of professional experience in PostgreSQL development database engineering database administration or a related technical field.
- Demonstrated expertise in PostgreSQL SQL PL/pgSQL NoSQL databases database performance tuning and Oracle-to-PostgreSQL migration.
- Relevant database cloud Agile DevOps or technology certifications are preferred but not mandatory unless required for a specific assignment.
- Commitment to continuous professional development through relevant training technical experimentation knowledge sharing and ongoing learning in PostgreSQL NoSQL database engineering performance optimization security and cloud technologies.
Professional Competencies
- Applies structured analytical thinking to investigate query performance migration issues data integrity concerns availability risks and production incidents.
- Collaborates effectively with application development infrastructure DevOps testing and delivery teams to achieve reliable database outcomes.
- Communicates database designs technical risks migration progress performance findings and recommendations clearly to technical and non-technical stakeholders.
- Adapts to changing database technologies application requirements delivery priorities migration constraints and operational conditions through continuous learning.
- Identifies practical opportunities to improve database performance scalability automation reliability maintainability security and sustainability.
- Manages time and priorities effectively across development migration production support performance tuning documentation maintenance and continuous improvement activities.
SYNECHRONS DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity Equity and Inclusion (DEI) initiative Same Difference is committed to fostering an inclusive culture promoting equality diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger successful businesses as a global company. We encourage applicants from across diverse backgrounds race ethnicities religion age marital status gender sexual orientations or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements mentoring internal mobility learning and development programs and more.
All employment decisions at Synechron are based on business needs job requirements and individual qualifications without regard to the applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.
Required Experience:
IC
About Company
Chez Synechron, nous croyons en la puissance du numérique pour transformer les entreprises en mieux. Notre cabinet de conseil mondial combine la créativité et la technologie innovante pour offrir des solutions numériques de premier plan. Les technologies progressistes et les stratégie ... View more