Responsibilities
- Design, develop, maintain, enhance, and optimize PostgreSQL database solutions.
- Develop and optimize complex SQL queries, PL/pgSQL procedures, functions, triggers, views, scripts, and database objects.
- Lead and support Oracle-to-PostgreSQL migration activities, including conversion of stored procedures, packages, schemas, queries, and database logic.
- Design and support NoSQL database solutions based on application and data requirements.
- Analyze execution plans, indexing strategies, query patterns, configuration, workloads, capacity, and resource utilization to improve performance and scalability.
- Implement and support database backup, recovery, maintenance, monitoring, availability, and production-support strategies.
- Validate data integrity, migration results, schema changes, query behavior, conversions, and application compatibility.
- Troubleshoot database issues across development, testing, staging, and production environments.
- Collaborate with application development, infrastructure, DevOps, testing, and delivery teams.
- Create technical documentation, database standards, migration plans, test cases, performance reports, operational procedures, and runbooks.
- Follow database governance, security, privacy, change-management, and release-management requirements.
- Identify opportunities to improve automation, reliability, operational efficiency, sustainability, and database cost.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline, or equivalent relevant experience or demonstrated technical capability.
- At least 8 years of professional experience in PostgreSQL development, database engineering, database administration, or a related technical field.
- Strong hands-on experience with PostgreSQL database design, development, maintenance, monitoring, troubleshooting, and optimization.
- Strong SQL and PL/pgSQL development experience, including stored procedures, functions, triggers, views, scripts, and database utilities.
- Proven Oracle-to-PostgreSQL migration experience involving stored procedures, packages, schemas, SQL queries, and data validation.
- Strong knowledge and practical experience with NoSQL databases and structured and semi-structured data management.
- Experience with database performance tuning, query optimization, execution-plan analysis, indexing, capacity planning, and resource management.
- Experience with backup, recovery, maintenance, monitoring, availability, production support, and incident resolution.
- Understanding of relational database design, normalization, constraints, transactions, data integrity, replication, partitioning, sharding, caching, and distributed data patterns.
- Familiarity with source control, database change management, deployment automation, Agile and DevOps delivery practices, and database lifecycle processes.
- Understanding of database access control, authentication, authorization, least privilege, encryption, auditing, credential management, and protection of sensitive data.
- Relevant database, cloud, Agile, DevOps, or technology certifications are preferred but not mandatory.
- Experience in enterprise-scale, high-volume, regulated, or operationally critical database environments is preferred.
- Experience with cloud-based PostgreSQL and NoSQL deployments, schema comparison, data validation, observability, alerting, governance, lineage, and data quality is preferred.
Benefits
- Synechron offers flexible workplace arrangements, mentoring, internal mobility, and learning and development programs.
- The company promotes an inclusive, equal-opportunity workplace and encourages applicants from diverse backgrounds.
Tech Stack
Categories
About Synechron
At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our Synechron Labs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,000+, and has 55 offices in 20 countries within key global markets. For more information on the company, please visit our website:www.synechron.com.