PLSQL Developer

Position Summary

Working in an agile software development environment, the Oracle PL/SQL developer is responsible design and documentation at an application level for wide variety of applications/services. The candidate would utilize engineering and programming skills focused on participating with Architecture, Operations and Enterprise Delivery PPM teams within Agile processes. The role will include systems and solution design within the existing architecture, as well as design/implementation of improvements to meet business needs. The candidate will work collaboratively with the Development, IT Operations, and QA teams both onshore and offshore in implementing software configuration management best practices to accelerate and optimize delivery methodologies. The candidate is responsible for preparing value stream mapping and look for continuous improvement.

The ideal candidate will be a team player and a self-starter who enjoys a fast-paced job, thrives on problem solving, and is committed to delivering seamless product availability to large enterprises.

Key Responsibilities

Responsible for maintaining the tools and processes for a large, enterprise level system in a fast-paced, agile, service-oriented environment.

Good understanding of the full stack software development (databases, user interface).

Work with team members to manage and administer enterprise-wide development tools GIT, GitHub, SVN (Subversion), SonarQube, Confluence.

Automate build, packaging, testing and deployment processes using DB scripts.

Responsible for continuous integration and continuous deployment for multiple initiatives across all products.

Work with production release team to identify and implement methodology for highly flexible and responsive releases (weekly, biweekly, monthly and bimonthly).

Automate end to end build processes, patching, and production product deployments.

Structure and maintain the software configuration management to build very secure and high availability systems.

Scale infrastructure to meet rapidly increasing demand. Monitor site stability and performance and troubleshoot site issues.

Working closely with Delivery teams to engineer solutions for production/enterprise automation efforts across all lines of business within Enterprise Delivery PPM.

Work with various stakeholders to set-up required lower level and production environments including the deployment of application developer database upgrades.

Review deployment procedures and execute deployments that ensure environment reproducibility.

Incorporate software testing automation at multiple levels (component, configuration item, subsystem, system) and monitor results.

Emphasize automation, implement processes, procedures and best practice guidelines for code management.

Manage cross-functional requirements working with Engineering, Product, Services, and other departments.

Guide teams with development best practices, including improved scalability, performance, reliability, and speed to market.

RELEVANT EXPERIENCE, SKILLS, ABILITIES & EDUCATIONAL REQUIREMENTS

Masters or bachelor’s in engineering in IT/ Electronics / Communication / Computer Science / Information Systems.

5+ years’ of Oracle Database Development experience with latest development skills on Oracle

Experience using the PLSQL Developer or Toad software packages

Experience with writing adhoc scripts and stored procedures

Experience developing queries, procedures, and reports for enterprise Oracle environment

Strong knowledge on oracle collections

Performance analysis with large data sets

Experience in designing and maintaining logical and physical data models

Experience performing SQL and PL/SQL tuning

Familiarity with Enterprise Oracle DB deployments.

Experience with collaborative version control systems (Git/ GitHub/ Subversion/ Bitbucket).

CI/CD Project Management Tools: JIRA, Confluence

Experience in BI tools like ETL (Informatia, SQL Loader), SAP-BO, Crystal and Tableau reporting would be helpful.

Experience in any of these programming areas helpful: Java or .Net

Ability to learn and quickly absorb new material, Strong error handling, troubleshooting skills.

Experience developing applications embracing Agile principles.

Professional with ability to properly handle confidential information.

Excellent written and verbal communication skills.

Ability to work well independently and in a team environment.

Ability to handle multiple tasks, prioritize and meet deadlines.

Experience in health care industry is a plus.

Strong work ethic and ability to work with minimal supervision.

Attention to detail and accuracy.

Self-motivated and willing to "do what it takes" to get the job done

Flexible schedule to work evenings and weekends, as needed.

Must be able to sit and use a computer keyboard for extended periods of time.

Must have ability to positively handle/manage stress, such as high work volume and frequent change.

Must have flexibility and willingness to participate in the work processes of an international organization, including conference calls scheduled to accommodate global time zones.