Database Developer

Experience : 4+yrs

Job Location : Gurugram, Haryana

Role Expectations:

Total experience 5 years or above, Postgres experience of at least 2-3 years, should have OPS experience and must have worked on performance optimization

JOB RESPONSIBILITIES: -

• Expertise in SDLC from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
• Extensive experience in using database tools like Postgresql, SQL*PLUS, SQL, TOAD and PL/SQL.
• Actively involved in Project Execution Process, Coding Standards and Best Practices.
• Strong knowledge and Experience developing PL/SQL Stored procedures, Functions, Packages, Database Triggers, Cursors, Exception Handlers and Dynamic SQL.
• Strong knowledge and Experience in Collections, Records and Object Types.
• Identifying performance bottlenecks for PL/SQL applications using DBMS_PROFILER.
• Strong knowledge and Experience in optimize performance for PL/SQL applications using Bulk Collect, FORALL, Bulk Bind and Bulk Exception handling.
• Extensive experience in Performance Tuning and Query Optimization using Explain Plan and re-designing of poorly designed process flow of data.
• Extensive experience in SQL*LOADER to Load Data from flat files into Tables and External Tables.
• Involved in error tracking and troubleshooting complex product issues using various debugging techniques.
• Developing and implementing MongoDB queries
• Monitoring performance and optimizing query response times
• Mentoring and training other developers on MongoDB best practices
• Code versioning tools like Git, SVN, and Mercurial
• Ability to configure schema and MongoDB data modeling
• Experience in Database security management
• Knowledge of MongoDB administration and installation in AWS and Red Hat
• In-depth understanding of MongoDB architecture

Interested candidates can share their resume to angela.r@intense.in