Sr. Oracle Developer

Gurugram, India

Job Description

    Overview

    The aim of the Sr. Oracle Developer is to work within a team of developers in the delivery of current and emerging business requirements. You will bring your knowledge, expertise and work ethic in the fast paced environment using Agile/Scrum methodology. This is a hands-on role requiring in-depth knowledge in Oracle Database Server development, project experience and project life cycle.

    Specific emphasis will be on:

    • Solution Development
    • Oracle Server Database technology
    • Effective team & communication skills

Roles & Responsibilities

  • Key Accountabilities and main responsibilities

  • Strategic Focus

    • To strive for continuous improvement of both technical and business knowledge
    • To assist with the development of new team standards, methodologies and processes to increase both the quality and efficiency of the development work 


    Operational Management

    • Responsibility to develop quick to market, high quality IT solutions within an agile environment
    • This will require full project exposure from start up to completion
    • Extremely adaptable and quick to pick up new business concepts within a unique business environment
    • Engage proactively with stakeholders and other cross-functional team members in the development of IT solutions


    People Leadership

    • Work within a team of developers assisting in:
    • time estimates
    • task allocations
    • problem solving
    • Provision of regular feedback, mentoring, coaching and assistance to the team’s development needs


    Experience & Personal Attributes

    • 5+ years development experience with Oracle Database version 9i /10g / 11g /12c
    • Manage all phases of the SDLC from analysis, design, development, testing, implementation and maintenance.

Required Skills

  • Primary Skills:
    • Create and maintain indexes, constraints, tables, PL/SQL store procedures & packages and produce queries to answer business questions.
    • Create numerous simple to complex queries involving self joins, correlate sub-queries, functions, cursors, dynamic SQL.
    • Strong knowledge of T-SQL / PL-SQL
    • Package creation and maintenance
    • Using system-supplied packages
    • Database triggers
    • Networking
    • Tablespace management
    • Oracle database tools
    • Database backup and recovery
    • DECLARE, BEGIN & EXCEPTION clause
    • Designing databases and ensuring their stability, reliability, and performance. 
    • Design, create, and implement database systems based on the end user's requirements. 
    • Improve application's performances. 
    • Prepare documentations for database applications. 
    • Memory management for database systems.
    • Develop database schemas, tables and dictionaries. 
    • Ensure the data quality and integrity in databases. 
    • Fix any issues related to database performance and provide corrective measures. 
    • Create complex functions, scripts, stored procedures and triggers to support application development.
    • Take regular database backup.
    • Test databases and perform bug fixes.
    • Provide authentication and authorizations for Database
    • Develop best practices for database design and development activities.
    • Good understanding of data modelling and database schema design principals
    • Data normalization
    • Knowledge of database optimization techniques
    • Exceptional analytical skills in order to analyze and interpret business needs, and to provide constructive input into the development and technology solutions
    • Experience with Agile/Scrum methodology


    Secondary Skills:

    • Exposure to cloud technologies, e.g. Microsoft Azure, AWS
    • Excellent interpersonal skills with the ability to develop effective inter-departmental and organizational relationships
    • Sound organizational skills, with the ability to prioritize conflicting tasks in order to meet strict deadlines
    • Self-motivated with a strong team spirit. Strong work ethic.