Postgres Developer

About PersistentWe are a trusted Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create a unique competitive advantage for our clients by giving them the power to see beyond and rise above. We work with many industry-leading organizations across the world, including 14 of the 30 most innovative US companies, 80% of the largest banks in the US and India, and numerous innovators across the healthcare ecosystem.Our disruptor’s mindset, commitment to client success, and agility to thrive in the dynamic environment have enabled us to sustain our growth momentum by reporting $300.6M revenue in Q3FY24, delivering 13.7% Y-o-Y growth. Our 23,000+ global team members, located in 21 countries, have been instrumental in helping the market leaders transform their industries. We’re also pleased to share that Persistent has been recognized as the “Most Promising Company” of the Year at the 2023 CNBC-TV18 India Business Leader Awards and named a Leader in Everest Group’s Talent Readiness for Next-Generation IT Services PEAK Matrix® 2023. We also won four 2023 ISG Star of Excellence™ Awards, reflecting the highest standard of customer service excellence. Throughout this market-leading growth, we’ve maintained strong employee satisfaction - over 94% of our employees approve of the CEO, and 89% would recommend working at Persistent to a friend.

About Position:Role: Postgres DeveloperLocation: RemoteExperience: 8+Job Type: Contract

What You'll Do:Must have : Postgres , K8s , PROD database workloads in a container environment , the monitoring tools like Grafana Prometheus , DAP, storage, containers, ArgoCD8+ years of Postgres database development experience in various phases of software development including Analysis, Design, Development, Testing and Implementation.Experience of Postgres version 9 and above (Open Source version or EDB or Percona Postgres flavor)Candidate should be able to independently and implement data models. Solid Postgres SQL development experience using PL/pgSQLKnowledge and experience of database development using Oracle SQL PLSQL will be added advantages. Strong experience in creating Postgres database objects such as tables, nested tables, synonyms, triggers, indexes, stored procedures, functions etc. Experience in scheduling scripts using a scheduler like pgAgentStrong experience in developing, debugging and understanding complex stored procedures and functions in PL/pgSQLShould be independently able to analyze Postgres SQL plans and apply fixes to the long running SQLs Performance tuning of postgres SQL queries and PL/pgSQL functions.Enforced data integrity using integrity constraint and database triggers.Experience in Stored procedure optimization and Performance Tuning.Very good experience in full software development life cycle of development, maintenance & enhancement projects in both Traditional and Agile environments.Experience with version control tool SVN and CVS, GitLab.Good experience in Unit Testing, Integration Testing and Performance Testing.Exposure and knowledge of designing logical and physical Data Model in Relational Database Management System (RDBMS).Expertise in batch processing, Unix shell scripting or PowerShell scripting. Candidate should have a strong understanding of SQL (Oracle, MySQL, Postgres, SQL Server) and NoSQL database (MongoDB, Cassandra etc) , should be independently talk to the DBA’s and development team of other SQL and NoSQL databases

Expertise You'll Bring:8+ years of Postgres database development experience in various phases of software development including Analysis, Design, Development, Testing and Implementation.Experience of Postgres version 9 and above (Open Source version or EDB or Percona Postgres flavor)Candidate should be able to independently and implement data models.Solid Postgres SQL development experience using PL/pgSQLKnowledge and experience of database development using Oracle SQL PLSQL will be added advantages.Strong experience in creating Postgres database objects such as tables, nested tables, synonyms, triggers, indexes, stored procedures, functions etc. Experience in scheduling scripts using a scheduler like pgAgentStrong experience in developing, debugging and understanding complex stored procedures and functions in PL/pgSQLShould be independently able to analyze Postgres SQL plans and apply fixes to the long running SQLsPerformance tuning of postgres SQL queries and PL/pgSQL functions.Enforced data integrity using integrity constraint and database triggers.Experience in Stored procedure optimization and Performance Tuning.Very good experience in full software development life cycle of development, maintenance & enhancement projects in both Traditional and Agile environments.Experience with version control tool SVN and CVS, GitLab.Good experience in Unit Testing, Integration Testing and Performance Testing.Exposure and knowledge of designing logical and physical Data Model in Relational Database Management System (RDBMS).Expertise in batch processing, Unix shell scripting or PowerShell scripting.Candidate should have a strong understanding of SQL (Oracle, MySQL, Postgres, SQL Server) and NoSQL database (MongoDB, Cassandra etc) , should be independently talk to the DBA’s and development team of other SQL and NoSQL databases

Benefits:Competitive salary and benefits packageCulture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certificationsOpportunity to work with cutting-edge technologiesEmployee engagement initiatives such as project parties, flexible work hours, and Long Service awardsAnnual health check-upsInsurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parentsOur company fosters a values-driven and people-centric work environment that enables our employees to:· Accelerate growth, both professionally and personally· Impact the world in powerful, positive ways, using the latest technologiesEnjoy collaborative innovation, with diversity and work-life wellbeing at the coreUnlock global opportunities to work and learn with the industry’s best

Let’s unleash your full potential at Persistent - persistent.com/careers“Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.”

Key Skills

• PostgreSQL