What are the responsibilities and job description for the Oracle PL/SQL Developer (HCM) position at Cognitive Medical Systems?
solid experience in creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle 12C and later versions of Oracle
- Proven expertise in monitoring, performance, and index tuning
- Experience performing other basic Oracle database management activities like space management, schema import/exports, Oracle scheduler job management , database backups etc.
- Understand the Oracle database backup and recovery, database security issues, transaction management
- Oracle database development experience on Oracle 12C or later versions is required
- Experience in using below Oracle client tools is essential -
o SQL*Plus
o The SQL*Loader
o Oracle Data Pump technology
o The Data Pump Export Utility
o The Data Pump Import Utility
- Experience using Toad for Oracle is a plus
- Proven expertise in Oracle database design including partition table design
Web Developer
Oracle Middleware Test Company -
Sacramento, CA
Jr. DBA / SQL Developer
Opeeka, Inc. -
Folsom, CA
SQL Developer & DBA
Conch Technologies, Inc -
Woodland, CA