Postgresql Developer- Concentrix - Bangalore

Level 2 Developer - 5-8 Year

Summary

The role of a Postgres/SQL Developer is to analyze and define, together with the business users, the IT solution for clients' data integration into our existing application landscape. The Postgres/SQL developer will

Develop and document complex Postgres/SQL processes and provide data integration solutions with other applications.

Follow best practices for Postgres/SQL development.

Receive accountability to manage your own sub-projects.

• Responsibilities
• Build, maintain, and enhance all objects procedures/functions in Postgres/SQL to support application process.
• Perform functions including SQL tuning, database application design, and developer support.
• Demonstrate experience working with huge, interdependent, complex datasets.
• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
• Write clear, concise, well organized technical documentation to maintain standards and procedures
• Understand the requirement and analyse on a technical feasibility and design.
• Coding the requirement and proper Check in / Checkout in Version control.
• Unit Test Cases Preparation and Execution
• Code Review and Checklist document preparation.
• QA, UAT and PROD Release Scripts/Package Preparation and Validation.
• Be a key contributor to initiatives that require technical expertise.
• Communicate with technical team and come up with solutions.
• Collaborate with the team to coordinate delivery of software application.

Technologies

• Languages: Postgres/SQL
• Databases: Postgres
• Platform: Heroku ( Will be added advantage).

Requirements

• Bachelor's degree in Science/IT/Computing or equivalent.
• 5-8 years' experience in Postgres database using PostgresSQL including stored procedures, functions, triggers and views.
• Ability to efficiently write database code without compromising data quality, privacy or security.
• Knowledge of database design principles, query optimization, index management, integrity checks and statistics.
• Ability to interpret requirements and technical specifications and translate then into visual representations of information
• Strong problem solving, analytical and interpersonal skills.
• Knowledgein multiple software development lifecycle phases, including design, construction, and testing
• Work in a fast-paced environment, under minimal supervision providing technical guidance to the team members.
• Other Competencies
• o Good communication skills and supportive attitude towards your colleagues and the business
• o Curious, open to changes and to new technologies of Fast learner and can think out-of-the-box
• o Should have creative visualization, critical thinking and deductive and pragmatic reasoning.