Oracle Dba / Consultant Resume
Kansas, StatE
SUMMARY
- Oracle Database Administrator wif over 7 years of DBA experience. Experience on multiple platforms and environments including production, development and testing. Strong experience leading migration, high availability and disaster recovery initiatives.
- Adept at all stages of System Development Life Cycle, from business requirements and technical definitions to development, Unit testing, user acceptance testing (UAT), documentation, production support, and completion.
TECHNICAL SKILLS
Platform: Red Hat Linux 5/6, UNIX, Windows XP/7/8, Windows 2003/2008 Server, VMWARE, Oracle Solaris
Database: Oracle RDBMS 10g and 11gR2 RAC, MS Access
Tools: SQL*Plus, SQL, PL/SQL, UNIX Shell Script, SQL*Loader, TOAD, Recover Manager (RMAN), Oracle Enterprise Manager (OEM), Grid/Cloud Control, Data Pump, Automated Workload Repository (AWR), ADRCI, Oracle Scheduler, SQL Developer, Statspack, TKPROF, SFTP, SSH, TCP/IP
Software: SAP Procurement and Logistics, Subversion (SVN), Microsoft Office (Word, Excel, Power Point, Outlook, Access), SecureCRT, Remedy, Putty, MobaXterm
Soft Skill: Energetic self - starter wif excellent analytical and organizational skills. Strong people, leadership and team building skills; excellent interpersonal, verbal and written communications skills
PROFESSIONAL EXPERIENCE
Oracle DBA / Consultant
Confidential, Kansas State
Responsibilities:
- Installed, configured, tuned, and troubleshot Oracle database 10g/11g
- Performed Oracle Database maintenance; base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository (AWR)/ Automatic Database Diagnostic Monitor (ADDM) to generate performance reports. Strong Knowledge on RMAN, RAC & Data Guard
- Clone environments to support development or when required to replicate and test fix for a production problem
- Assisted in the establishment of procedures and processes for Backup/Recovery, Database Maintenance, Patch Management
- Use OEM Grid Control Diagnostic and tuning packs to tune the application and Database Migration
- Wrote UNIX and Shell Scripting.
- Worked wif Developer group to debug PL/SQL programs and review, test and install Oracle recommended patches to fix Oracle Applications issues/bugs
- Created, modified and maintained Oracle database objects and storage structures including tablespaces, tables, users, roles, profiles, directories and indexes.
- Documenting benchmarks and procedures needed to optimize database performance.
- Experience in logical backup using Oracle data pump and SQL*Loader.
Oracle Database Administrator
Confidential, Atlanta, GA
Responsibilities:
- Performed daily and weekly database backup using RMAN for multiple clients
- Monitored the database environment, ensured dat the database met performance standards
- Performed technical health checks for our client's servers
- Monitored the alert log for database errors, Database Migration
- Monitored database connectivity, database growth and allocated space
- Configured, installing and administrating oracle database systems
- Created user accounts, roles, and assigned privileges
- Wrote SQL queries, Unlock accounts and reset password
Database Analyst
Confidential, Atlanta, GA
Responsibilities:
- Updating new material data generated by Master data team in the pallet tagging and quality wif 99.9% compliance wif SAP tools (MARA, TABLE)
- Identified interdependencies, tracked critical milestones and evaluate risks and prepared contingency plan.
- Provided full spectrum leadership from inception to completion and report project status to upper management.
- Participated in project phase review and managed the change control process.
- Builds and maintains up-to-date schedules, co ordinate and monitor supply chain pallet tagging database project, and TEMPhas a keen understanding of project management methodology, principals, methods, and techniques. Generated quality metric data report for Business Units across the United States and Canada.
Senior Quality Assurance Technician
Confidential, Montgomery, AL
Responsibilities:
- Monitored Quality Operation Systems process adherence control and reaction plans.
- Supervised and trained new hired microbiological process, statistical process control adherence, Quality Process Sheets, sensory analysis, pest control, Product Quality data analysis, lab equipments calibrations, microbiological analysis, and water treatment adherence both internally and wif external suppliers.
- Product parameters analytical skills, Microbiological sampling, plating and counting skills.
- Implemented training course for new recruits.
- Lab Equipments such as HPLC, Density meters, Gauges, pH meter, Thermometers, Turbidity meter, and Auto Titrator calibration skills.
