Database Developer - Oracle DB/PL-SQL (3-5 yrs)

Responsibilities :

- Collaborate with developers, project managers, business analysts, and business users in conceptualizing, estimating, and developing new software applications and enhancements.

- Assist in defining software development project plans, including scoping, scheduling, and providing time estimates for programming tasks and implementation plans.

- Assist in the definition, development, and documentation of software's objectives, business requirements, deliverables, and specifications in collaboration with internal users and departments.

- Develop technical documentation to define the system components, development environment, and implementation planning/strategies.

- Prepare and dispense work assignments, provide guidance, and/or review the work of other team members.

- Collaborate with the QA team to define test cases, and metrics, and resolve questions about test results.

- Recommend business process flow improvements and communicate problem/resolution process to project management.

- Develops and implements solutions by policies and procedures.

- Facilitate the design and implementation process for new products/projects, informing senior executives of alternatives.

- Administer full project documentation efforts by policy and procedure.

- Perform root cause analysis (RCA).

- Work with cross-functional teams during crises to address and resolve complex incidents and problems in addition to assessment, analysis, and resolution of cross-functional issues.

- Recognizes and identifies potential areas where existing policies and procedures associated with development require improvement and helps in the process improvement activity.

- Update/create Knowledge Base Articles and case studies as necessary. Assist in the creation and improvement of Knowledge Management.

Requirements :

- Developer with 3-5 years of experience required.

- Excellent skills in Oracle databases and PL/SQL.

- Ability to design and implement solutions that are reliable, scalable, and perform at a high level to meet the service levels associated with mission-critical Oracle-based solutions.

- Knowledge of database architecture and best practices for Oracle SQL and PL/SQL coding style and application tuning.

- Experience designing and developing complex enterprise applications (ERP, CRM, etc. ) on large Oracle databases using SDLC methodologies (agile, waterfall).

- Excellent in impact analysis and root cause analysis.

- Stored Proc Optimization / Fine-tuning, Performance Improvement of Queries.

- Proven analytical and problem-solving abilities with the ability to anticipate and avoid problems.

- Experience in performance tuning, application monitoring, and support of production applications with distributed teams.

- Ability to define and implement migration strategies from legacy systems to new architecture and technologies.

- Ability to work well within a team environment that includes geographically distributed team members.

- Ability to work within tight deadlines and effectively prioritize and execute tasks in a high-pressure environment.