Position: PL/SQL Developer
Experience: 5+ Years of software development experience utilizing PL/SQL
Location: 100% remote
Degree: Bachelor’s degree in Computer Science
MUST HAVE: Healthcare experience will be looked at first
Job Responsibilities Include:
- Develop PL/SQL code Data Access Layers for use by client applications
- Experience in creating, modifying database objects such as Table, Index, Views, Triggers, Constraints and more
- PL/SQL programs required to retrieve data using cursors and exception handling.
- Manage reference data stored in Oracle DBs
- Involve in creating and managing tables, indexes, db links and privileges.
- Coordinate with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks
- Used subversion tools, SVN version management to manage various versions of the procedures and functions of the application.
- Schedule jobs to automate different database relate activities including backup, monitoring database health, disk space, backup verification.
- Work on the oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views, cursors.
- Implement procedures to install and deploy large numbers of Linux / Unix servers.
- Create database tables, create various db queries and assist in data mapping/testing activities in support of project.
- Modify and develop new scripts in LINUX to provide the same functionality as that are provided in UNIX.
- Develop Perl and shell scripts for parsing the incoming file’s data and loading them into the database.
- Used JIRA for the requirement tracking, planning and building.
- Work closely with development teams to ensure successful implementation
- Provide post implementation and on-going production support
Preferred Skills:
- Demonstrate excellent communication skills including the ability to effectively communicate with internal and external customers.
- Ability to use strong industry knowledge to relate to customer needs and dissolve customer concerns and high level of focus and attention to detail.
- Strong work ethic with good time management with ability to work with diverse teams and lead meetings
- Preferable experience in Health Plan Implementation in Healthcare Domain