Postgress DB Developer

Looking for a SQL 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 , Postgres

SQL 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 as Git / Mercurial / SVN/ Git Hub

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

Must work in 2 to 11 P.M IST shift