Oracle PLSQL developer with Performance tuning

Act creatively to develop applications by selecting appropriate technical options optimizing application development maintenance and performance by employing design patterns and reusing proven solutions. Account for others developmental activities; assisting Project Manager in day to day project execution.

Outcomes:

1. Interpret the application feature and component designs to develop the same in accordance with specifications.
2. Code debug test document and communicate product component and feature development stages.
3. Validate results with user representatives integrating and commissions the overall solution.
4. Select and create appropriate technical options for development such as reusing improving or reconfiguration of existing components while creating own solutions for new contexts
5. Optimises efficiency cost and quality.
6. Influence and improve customer satisfaction
7. Influence and improve employee engagement within the project teams
8. Set FAST goals for self/team; provide feedback to FAST goals of team members

Measures of Outcomes:

1. Adherence to engineering process and standards (coding standards)
2. Adherence to project schedule / timelines
3. Number of technical issues uncovered during the execution of the project
4. Number of defects in the code
5. Number of defects post delivery
6. Number of non compliance issues
7. Percent of voluntary attrition
8. On time completion of mandatory compliance trainings

Outputs Expected:

Code:

1. Code as per the design
2. Define coding standards
   templates and checklists
3. Review code - for team and peers

Documentation:

1. Create/review templates
   checklists
   guidelines
   standards for design/process/development
2. Create/review deliverable documents. Design documentation
   requirements
   test cases and results

Configure:

1. Define and govern configuration management plan
2. Ensure compliance from the team

Test:

1. Review/Create unit test cases
   scenarios and execution
2. Review test plan created by testing team
3. Provide clarifications to the testing team

Domain relevance:

1. Advise software developers on design and development of features and components with deeper understanding of the business problem being addressed for the client
2. Learn more about the customer domain and identify opportunities to provide value addition to customers
3. Complete relevant domain certifications

Manage Project:

1. Support Project Manager with inputs for the projects
2. Manage delivery of modules
3. Manage complex user stories

Manage Defects:

1. Perform defect RCA and mitigation
2. Identify defect trends and take proactive measures to improve quality

Estimate:

1. Create and provide input for effort and size estimation and plan resources for projects

Manage knowledge:

1. Consume and contribute to project related documents
   share point
   libraries and client universities
2. Review the reusable documents created by the team

Release:

1. Execute and monitor release process

Design:

1. Contribute to creation of design (HLD
   LLD
   SAD)/architecture for applications
   features business components and data models

Interface with Customer:

1. Clarify requirements and provide guidance to Development Team
2. Present design options to customers
3. Conduct product demos
4. Work closely with customer architects for finalizing design

Manage Team:

1. Set FAST goals and provide feedback
2. Understand aspirations of the team members and provide guidance
   opportunities
   etc
3. Ensure team members are upskilled
4. Ensure team is engaged in project
5. Proactively identify attrition risks and work with BSE on retention measures

Certifications:

1. Obtain relevant domain and technology certifications

Skill Examples:

1. Explain and communicate the design / development to the customer
2. Perform and evaluate test results against product specifications
3. Break down complex problems into logical components
4. Develop user interfaces business software components
5. Use data models
6. Estimate time and effort resources required for developing / debugging features / components
7. Perform and evaluate test in the customer or target environments
8. Make quick decisions on technical/project related challenges
9. Manage a team mentor and handle people related issues in team
10. Have the ability to maintain high motivation levels and positive dynamics within the team.
11. Interface with other teams designers and other parallel practices
12. Set goals for self and team. Provide feedback for team members
13. Create and articulate impactful technical presentations
14. Follow high level of business etiquette in emails and other business communication
15. Drive conference calls with customers and answer customer questions
16. Proactively ask for and offer help
17. Ability to work under pressure determine dependencies risks facilitate planning handling multiple tasks.
18. Build confidence with customers by meeting the deliverables timely with a quality product.
19. Estimate time and effort of resources required for developing / debugging features / components

Knowledge Examples:

• Appropriate software programs / modules
  1. Functional & technical designing
  2. Programming languages - proficient in multiple skill clusters
  3. DBMS
  4. Operating Systems and software platforms
  5. Software Development Life Cycle
  6. Agile - Scrum or Kanban Methods
  7. Integrated development environment (IDE)
  8. Rapid application development (RAD)
  9. Modelling technology and languages
  10. Interface definition languages (IDL)
  11. Broad knowledge of customer domain and deep knowledge of sub domain where problem is solved
  
  

  Job Description Designs, develops, modifies, adapts and implements short- and long-term solutions to technology needs through new and existing applications, systems architecture, network systems and applications infrastructure. Reviews system requirements and business processes; codes, tests, debugs, documents and implements software solutions. Provides application software development services typically in a defined project. Develops program logic for new applications or analyzes and modifies logic in existing applications. Ensures that system improvements are successfully implemented. May test new software code and typically works in a highly efficient ("Agile") development environment. Bachelors Degree with 10 - 12 years of relevant experience as Oracle PLSQL developer Primary Skills DataBase Developer with strong SQL programming, SQL queries, PL/SQL functions, Scripting Hands on experience as analyze, Design and Code development for medium to larger requirements using Oracle SQL, PL/ SQL, XML DB, JSON, Performance Tuning, etc. , Writing effective and tuned SQL queries, PL/SQL functions, stored procedures, triggers, cursors, materialized views Trouble shooting the production issues in lower environment with strong debugging skills. Knowledge of database performance improvement techniques to make decisions or suggest designs based on the requirements and challenges Participate into Production Issue triage Bridge Calls and providing the solutions. Understanding of Agile methodologies and maintain the Jira Hygiene. Able to trouble shoot issues in production environment / strong debugging skills. Thorough Unit Tests along with evidence and automating the Unit Tests using Ruby Cucumber. Database environment setup - generating scripts for creating and amending tables and other objects in data dictionary. Interacting with business users / counterparts to assist them with problem investigation. Interacting with front end developers as part of the development process Collaborating with Production L2 Support and ensuring the defect backlogs are within threshold. Generating scripts for creating and amending tables and other objects in data dictionary. Interacting with business users / counterparts to assist them with problem investigation. Interacting with Front End Developers, Business Analysts and QA as part of the development process. Assigned Tasks executed Independently. Daily status exchange internally with team and email communications to counterparts / Bank. Conducting/Participating the scrum call and Retrospection meetings. Performing the code reviews for team. Participating into innovative initiatives. Roles & Responsibilities: Closely working with the team, ensuring the team concerns/issues are resolved and motivated them to provide the effective deliverables. Forecast the project resourcing requirement and ensuring the effective end-2-end hiring and onboarding / offboarding. Conduct feedback review sessions, recognitions and appraisals for the team. Timely highlighting the team pulse to leadership and taking the required actions. Lead and Manage a team of developers, Business Analyst and QA. Responsible for Leading multiple delivery streams to deliver successful product outcomes. Planning and scheduling the delivery process, including defining project scope, milestones, and timelines. Identify and manage the risks to the delivery, including developing contingency plans to mitigate potential issues. Communicate with stakeholders, including team members, clients, and other stakeholders, to ensure that everyone is informed about the progress of the delivery. Track the progress and making adjustments as needed to keep the delivery on track. Provide guidance and mentorship to team members to ensure that they have the skills and support they need to complete their tasks. Provide the technical leadership and guidance to team Working with clients or other stakeholders to meet their needs and expectations. Work with L2 Support and Client Service Management team to ensure NPS. Participate into Production Incident Bridge calls and providing suggestions/solutions. Ensuring the Jira Hygiene and ensure team is following the best practices. Conducting sprint retrospection meetings and actions on outcome of it. Participating in scrum of scrums and cross squad meetings to discuss, highlight dependencies across systems. Qualification: B. Tech Nice to have: Experience into ReactJS and WebAPI Experience in Cloud based systems. Exposure to tools like GIT, JIRA, Messaging Services / Camel Java. Agile practitioner Knowledge or experience with AWS, Splunk, Cucumber etc. Knowledge of investment Banking and corporate actions domain