Oracle Database Admin Resume

SUMMARY

To obtain a contract or full time position that will allow me to utilize my SQL and PL/SQL programming skills to develop databases and to allow me to continue to expand my skill set by

having exposure to additional computer languages. Currently studying LINUX shell scripting.

TECHNICAL SKILLS

Proficient in Microsoft Office (Access, Excel, PowerPoint and Word), VBA, SQL, XHTML, HTML, CSS, VISIO, JAVA, PHP, JavaScript, VB.NET, and IBM RequisitePro

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Admin

Program provides training leading to obtaining a certification of the following relationaldatabase systems: SQL, T SQL, PL/SQL, SSMS 2012, Oracle12c and SQL Developer
Relevant program work includes: designing tables using Third Normal Form while ensuring
Relationships and Referential Integrity; utilizing SQL to Update, Insert, Delete tables; usingadvanced Select statements, Sub Queries and Joins; utilizing Conditional Statements, Case,
Unions and Loops; creating Indexes for efficient and accurate queries; utilizing Cursors to iterate through code; developing Functions and Stored Procedures for common queries; creating
Triggers to fire before or after an event occurrence. Creating Packages to house Procedures andFunctions.

Confidential

Data Analyst

Developed a program to track all incidents and breaches of Public Health Information.
The requirements for this database were to track type of security breach, the employee responsible for investigation and the end resolution.
Designed user interface of program, wrote VBA script to define a unique password per user, used access to split database to allow for customized privileges by user role and created email macro to communicate status of incident.
Manager level users could generate customized access reportsbased upon custom button developed in access using VBA that allowed customizable reporting to meet their needs.

Onboarding/Off boarding Database:

Created database to track new employees, employees that left, and employees that moved to a different manager.
Developed code to match employee ID against human resource repository to generate listing of current employee statusas well as assigned department and manager.
Developed VBA script to send bulk email to all managers for those employees that had an unresolved status for resolution.
Wrote error notification rules to notify manager that all required data was entered prior to closing.
Used VBA to auto populate current employee status entered by manager to update human resource records.

Database:

Repository was developed to track positive health choices by Highmark employees.
Developed interactive user interface to allow employees to enter their health activities, including multi select check boxes, text boxes, combo boxes and other data entry tools.
Developed multiple subforms to simplify the users’ entry of health activities into the tool.
Wrote VBA script to allow management to run user defined queries and reporting.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship