Postgres developer
Job details
Job description, work day and responsibilities
Job highlights
Identified by Google from the original job post
Qualifications
JD :An ideal candidate should have a Bachelor of Engineering degree with 10+ years of experience in Postgres database development
Candidate should have experience and should be able to demonstrate the below skills during the interview and while on the job
Professional Summary :10+ years of Postgres database development experience in various phases of software development including Analysis, Design, Development, Testing and Implementation
Experience of Postgres version + 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
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 ManagementSystem (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
Oracle 12c and above, MySQL 8, SQL Server 2012 above
Another noSQL database knowledge
MongoDB, CassendraCloudAWS/Azure/GCPDatabase LanguagesSQL, PLSQL, Pl/PgSQL , Unix /Shell scripting , PythonToolsSQL Client tools e.g
DBever, Rapid SQL, Git, SQL Browser,pgAdmin etc
Responsibilities
Enforced data integrity using integrity constraint and database triggers
Job description
JD :An ideal candidate should have a Bachelor of Engineering degree with 10+ years of experience in Postgres database development. Candidate should have experience and should be able to demonstrate the below skills during the interview and while on the job. Professional Summary :10+ years of Postgres database development experience in various phases of software development including Analysis, Design, Development, Testing and Implementation.Experience of Postgres version + 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 ManagementSystem (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 databasesDesired CertificationPostgres Associate developer / Oracle SQL/PLSQL DeveloperToolsCore Database SkillsPostgres Version + and AboveAnother Database knowledgeOracle 12c and above, MySQL 8, SQL Server 2012 aboveAnother noSQL database knowledgeMongoDB, CassendraCloudAWS/Azure/GCPDatabase LanguagesSQL, PLSQL, Pl/PgSQL , Unix /Shell scripting , PythonToolsSQL Client tools e.g. DBever, Rapid SQL, Git, SQL Browser,pgAdmin etc
Company address
You will be redirected to another website to apply.
Offer ID: #1037941,
Published: 3 weeks ago,
Company registered: 7 months ago