NITS Solutions - Senior Software Engineer - Database System

Description : - 4+ years of overall design and development experience with large-scale database systems in a 24X7 Production environment. - 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.