Postgres DB Developer

Role description

Postgres Db Developer , MSSQL , Oracle - ' 3-4 month short term requirement'

Looking for a Postgres developer who will be responsible for designing databases.

Responsibilities :

Ensure performance, security, and availability of databases

Prepare documentations and specifications

Handle common database procedures such as upgrade, backup, recovery, migration, etc.

Profile server resource usage, and optimize and tweak as necessary

Collaborate with other team members and stakeholders

Perform Code reviews

Take part in software and architectural development activities.

Strong proficiency with SQL and its variation among popular databases MS SQL Server, Oracle, Postgres etc. Activities include – but not limited to

Advanced database development experience (SQL & PLSQL)

Create, Maintain and Optimize Stored Procedures, Functions and Packages.

Familiar with database management programs ( SQL Developer, PL/SQL Developer)

knowledge of MSSQL , Oracle , PostgresSQL support for JSON

Good Grasp of ETL concepts

In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)

Good experience in performance tuning- table partitioning and best practices dealing with the datbases.

Capable of troubleshooting database issues

Proficient understanding of code versioning tools such asGit / Mercurial / SVN/ GitHub

Excellent Analytical Skills

Ability to plan resource requirements from high level specifications

Carry out Impact Analysis , Estimate the work

Be a problem solver, go -getter and self driven

Lead a team of 1-2 member - 80% Individual Contribution & 20% Lead activities

Must work in 2 to 11 P.M IST shift.

Skills Required
Svn, Git, Github, Mssql, Etl, Postgres, Mercurial, Sql, Plsql, Oracle, Sql Developer, Pl Sql Developer