NITS Solutions - Senior Software Engineer - Database System

Description :

- 3+ year experience working with Writing Complex Queries, Procedures, Functions, Triggers, Basic SQL, Ref Cursors, Collections.

- 3+ year experience working with Unix/Linux. Strong Unix shell scripting skills.

- Must have strong experience in PostgreSQL Queries, Analytical Functions, Joins, DDL, DML, TCL, Types, Object, Views, Index, and Sequence.

- Good knowledge of Python with Pandas.

- Candidates should have experience above PostgreSQL v10.

- Good understanding of the PgAdmin tool and PostgreSQL Architecture.

- Proficiency with Table Design, Performance Tuning, troubleshooting & debugging skills.

- Strong experience in PostgreSQL with strong internal knowledge.

- Knowledge of Aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, packaging, and support/maintenance.

- Develop and support the routine and ad-hoc data query jobs.

- Experience on Data Loading from text file, external table etc.

- Oracle JSON knowledge required.

- Experience on debugging technical issues for DB objects etc.

- The individual must be self-sufficient problem solver but also a collaborative team player.

- Be equally comfortable working with management, business SMEs and hands-on development teams.

- Capable of functioning independently and as part of a team.

- Ability to interface with and drive work with team members at different levels.

- Be able to prototype or conduct trials on new technologies or software applications.