Job Details
About Persistent
We 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 Developer
Location: Remote
Experience: 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, ArgoCD
- 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/pgSQL
- Knowledge 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 pgAgent
- Strong experience in developing, debugging and understanding complex stored procedures and functions in PL/pgSQL
- Should 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/pgSQL
- Knowledge 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 pgAgent
- Strong experience in developing, debugging and understanding complex stored procedures and functions in PL/pgSQL
- Should 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
Benefits:
- Competitive salary and benefits package
- Culture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certifications
- Opportunity to work with cutting-edge technologies
- Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
- Annual health check-ups
- Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents
Our 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 technologies
- Enjoy collaborative innovation, with diversity and work-life wellbeing at the core
- Unlock 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.