Programmer Analyst Resume Pickerington, OH - Hire IT People

OBJECTIVE
Mutually rewarding professional affiliation in which I may apply and expand my expertise in Systems Technology Consultant or information management that will offer me a challenge and advancement career.

PROFILE

Over 12 years of increasingly responsible experience in all aspects of Oracle Database Administration in fast growing environment. I am US citizen, motivated, personable business professional with multiple college degrees and a successful track record of work ethics. Talent for quickly mastering technology, trouble shooting, problem solving tactful with professionals and non-professionals at all levels. I am also flexible and versatile, able to maintain a sense of humor under pressure, poised and competent with demonstrated ability to easily transcend cultural differences, thrive in deadline-driven environments and excellent team-building skills.

Skills Summary

Oracle 8i, 9i & 10g Database Administration
Performance Tuning & Capacity Monitoring
Data Security
RMAN Backup & Recovery
Oracle Partitioning
Standby/Failover
SQL*Plus
PL/SQL
SQL Tuning
OEM
RMAN
Visio
Oracle STREAMS
ERWin
TOAD
IGNITE
Project Management
Unix Shell Scripting
Secured FTP
ETL

Project Management

Develop the architecture roadmap for all aspects of project life cycle.
SDLC Methodologies
Gather Business Requirements
Analyze and design problem or new request resolution
Code modules according to specifications and client standards
Develop program and system documentation
Conduct program and system implementation
Maintain application production environment

WORK

Confidential Columbus, OH

EXPERIENCE

CONSULTANT, DATA ENG/ADMI 3/1998-6/2009

Worked as team leader in database design.
Managed data center migration project from Cleveland to Columbus.
Responsible for project planning, requirement analysis and technical specifications.
Developed database backup and recovery plan using RMAN
Worked with application teams to support the front end.
Constructed entity relationship diagram (ERD) for data modeling using ERWin and Visio.
Documented logical database design and physical database design using ERWin.
24/7 On-call responsibilities.
Involved in Requirement Analysis, Design, Development and implementation during datacenter migration and projects.
Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports, and materialized views.
Rebuild entire database in Oracle 8i, 9i & 10g
Performed SQL tuning using Ignite and OEM
Involved in root cause analysis and proactively identified alternative corrective solutions.
Monitored database performance and 24/7 availability.
Monitored storage availability.
Design and development of Application & Admin Modules
Monitored space usage of application objects using TOAD
Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.
Identified performance bottlenecks like queries utilizing high CPU, internal lock waits, row locks, redo log buffer waits and etc using OEM.
Responsible in recovering from user and application errors.
Monitors database at system and application level using TOAD.
Implemented many stored procedures, packages and triggers for extracting data to the warehousing database.
Data modeling and daily management of schema objects.
Involved in system/application/user level auditing.
Unix shell scripting.
Server / Database consolidation to save costs.
Identified performance bottlenecks using Oracle Enterprise Manager (OEM) and Ignite.

01/97-03/98 Confidential Madison, WI
Programmer Analyst

Maintained Oracle databases
Dealt with third party software vendor
Maintained vendor database in Access
Programmed in Natural, Cobol and JCL
Personal Oracle 7.3, Mainframe, Windows NT, MS Office
Little bit involvement in developing Oracle Reports and Forms

05/96 - 1/97 Confidential Winnebago, WI
Internship, LTE 3

Responsible for updating old spread sheets, data base and word processing files into related MS Office
Created MIS Inventory by using Access
Assisting users with software and hardware related problems
Provided more organized programs without any redundancy or no need of retyping
Setting up follows up and survey program for recovering patients

EDUCATION
MBA

Bachelor of Science, Computer Science
Bachelor of Science, Physics

CERTIFICATESFROM ORACLE EDUCATION

Introduction to Oracle: SQL & PL/SQL Using Procedure Builder
Database Administration
Backup and Recovery
OCP 8i Certified, 2004

OTHER CERTIFICATES ( Classes offered by Nationwide Insurance Enterprise )

Understanding TCP/IP
Shell Programming
PL/SQL
Advanced JAVA Programming
Hypertext Markup Language ( HTML )

AVAILABILITY Open

REFERENCES Available upon request.

We provide IT Staff Augmentation Services!

Programmer Analyst Resume

Pickerington, OH

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship