| Postgres Developer |Remote at Remote, Remote, USA |
| Email: [email protected] |
| From: Dharmasastha.M, Vysystems [email protected] Reply to: [email protected] Must have : K8s , PROD database workloads in a container environment , the monitoring tools like Grafana Prometheus , DAP, storage, containers, ArgoCD JD : 10+ 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 DBAs and development team of other SQL and NoSQL databases Keywords: procedural language Postgres Developer |Remote [email protected] |
| [email protected] View all |
| Wed May 08 03:56:00 UTC 2024 |