SUMMARY:

• Seeking position as ORACLE DBA utilizing my knowledge and experience in the installation, maintenance, upgrade, troubleshooting of Global Corporate ORACLE databases running mission critical applications as Oracle certified Professional (OCP).

TECHNICAL SKILLS:

• Install, configure & test 12c Grid Infrastructure
• Upgrade Oracle 11g to 12c Database in Linux/VMware
• Create/Upgrade/Clone 11gR2 RAC instances
• Oracle 11g R1/2, 12c Database Administration
• Performance Tuning & Capacity Monitoring in quarter nodes Exadata
• Supporting OLTP/Compress/reorg and DSS system environments
• Data Security, Backup & Recovery (RMAN)
• Oracle Utilities: Data Pump Import/Export, SQL* Loader, Golden Gate 11g/12c
• Tools: Erwin/OEM/TOAD, OBIEE/SQL Developer, Grid Control - 11g/OEM-12c
• SQL Tuning of Exadata using AWR/ADDM/ASH/EXPLAIN PLAN/TKPROF
• Shell scripts automation for database maintains and notification schedules

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Oracle DBA

Responsibilities:

• Senior level production & development databases administrations - all platforms
• Build Oracle databases using BDA tool with (CONT) standby sync with active Dataguards
• A dmin/maintain Grid Control, Foglight, OS watcher and other databases monitoring tools etc.
• Perform regularly database import/export to refresh DEV, QA & UAT databases
• Setup Cron jobs to monitor & backup database, clean archive log files & delete out of date backups
• Golden Gate Replications 11gR2/12c: Active/Passive & Active/Active
• Using ETL Integration/Repository (Informatica PowerCenter) tool to Extract Data from sources, Transform Data by mapping, filtering, profiling, and Load to target databases
• Using Erwin to create & document conjecture, logical data design to physical design, and transform Entry to table, and attributes to column.
• Using Erwin to create Dimension models for Fact/Dimension table s mappings
• Hands-on experience in creation and usage of 3 rd Normal Form & Star schemas for OLTP with Models
• Working with BI team for ETL performance issues as well as design implementations
• Performance tuning with applications using Toad software 11.6, 12c clouds etc
• Diagnostic evaluation (ADDM, AWR, ASH), tuning (advisors, SQL tuning, indexing, partitions, etc)
• Maintain & test RAC in DR environments /Disaster Recovery Failover/Switchover
• Experience with VMware, Linux and Windows operating systems
• Proficiency in UNIX/Linux OS in database tuning, design, security, backup, recovery and HA/DR solutions
• PSU patching installation/upgrade in primary/standby management
• Experience with Automatic Storage Environment (ASM)
• Design, Install and admin/maintain Oracle Real Application Clusters (RAC)
• Expert DBA level knowledge of UNIX fundamentals and shell scripting
• Backup and Recovery (RMAN, Cloning, Data Guard, Export/Import)
• Resource Monitoring (CPU, memory, I/O, RAC/ASM, etc)
• Oracle patch provisioning, performance tuning of AWR/ASH Reports
• Strong communication skills both verbal and written

Confidential, Southfield, MI

Oracle DBA

Responsibilities:

• Strong experience with Oracle Database in RAC & Non - RAC environment
• Experience with migration of Oracle Database into Exadata
• 11gR2/12c Golden Gate Replication for database migrations
• Proven experience with migration paths into Exadata
• Experience with Rman backup of databases
• Experience with implementing & administration Oracle RAC DB on Exadata
• Strong experience includes DB Administration, Backups, Testing, Test case scenarios
• Perform & execute HCC in Exadata machine for two nodes RAC
• Extract/Replicate data using Golden Gate from source DB to Target DB manage user migration including Citrix Users/oracle users/PC users/No-company users
• Batch cycles verifications from source DB to UAT & Stress tests on UAT environments
• Prod Parallel set up and Dress Rehearsal including Tidal CR/inbound/outbound interfaces implement
• Variances/test Validations and File coparisons/CFT test Run via Tidal
• Deployment Planning & P-cut preparation
• SQL Tuning using AWR/ADDM/ASH/EXPLAIN PLAN/TKPROF implementing and maintain Lawson Financial information system
• Install & test upgrade/patches 11gR2/12c container DBs and VMware implementing and maintain Lawson Financial information system
• Oracle scripts automation for passwords change notification & recertification
• Migration/Clone DB & applications using Data pump in Aix/Linux environments
• Create database related project tasks with duration estimates and resource planning (DDL & DML).
• Rman backup/recovery, performance tuning and upgrade planning
• Experience with HP Unix/Linux System
• Execute infrastructure projects ensuring that all DBA and Project checkpoints have been addressed
• Provide Oracle database expertise on database-only projects and served as a virtual team member (VTM)
• Oracle security and auditing, monitor high profile/regular users by audit trail
• Part of DBA rotation team to provide after-hours support for production environments

Confidential, Danville, PA

Oracle DBA

Responsibilities:

• Install & test upgrade/patches 11gR2 DBs and Vmware
• Oracle database PSU patching in 11gR2 for PSU 2014
• Service level UNIX shell script development for automating
• Strong experience with Oracle Database in RAC & Non - RAC environment
• Perform Rman backup, DEV/QA databases replications
• Perform DB Administration, Backups, Testing, Test case scenarios manage user migration including Citrix Users/oracle users/PC users/No-company users
• Batch cycles verifications from source DB to UAT & Stress tests on UAT environments
• Prod Parallel set up and Dress Rehearsal including Tidal CR/inbound/outbound interfaces implement
• SQL Tuning using AWR/ADDM/ASH/EXPLAIN PLAN/TKPROF
• Oracle scripts automation for passwords change notification & recertification
• Migration/Clone DB & applications using Data pump in Aix/Linux environments
• Create database related project tasks with duration estimates and resource planning (DDL & DML).
• Operate oracle Data Guard for standby databases, performance switchover/failover practices
• Replicate by stream to transport source databases data to target databases
• Using shell script programming on Unix & Linux platforms
• Run job schedule programming using Cron Job
• Provide Oracle database expertise on database-only projects and served as a virtual team member (VTM)
• Oracle security and auditing, monitor high profile/regular users by audit trail

Confidential, Ann Arbor, Michigan

Oracle DBA consultant

Responsibilities:

• Install, configure and maintain oracle RAC databases on 11g in UNIX/Exadata environment
• Perform 11G upgrading, cloning, development and Production support
• Perform oracle databases character set conversion from US7ASCII to AL32UTF8
• Migrate databases using Data pump to import and export schemas compliance
• Performance SQL tuning using AWR/ASH/ADDM/SQL profile, Trace10046/TKPRO
• Performance tuning data warehouse in star schema with BI applications
• Install & testing databases in Susie Linux VMware with VNC server
• Monitor database security including adding and removing users, administering quotas etc
• Run Shell scripts on development and production using TOAD/SQL-developer
• Perform RMAN backup/recovery, clone database in same or remote servers
• Duplicate target database for standby from active database
• Create ASM disk groups & migrate no ASM File system to ASM system
• Flashback tables accountings SCN, timestamp and restore points

Confidential

Oracle DBA consultant

Responsibilities:

• Maintain and technically support company sales records
• Run PL/SQL Packages, Functions and Stored Procedures on TOAD in product databases
• Replicate by stream to transport source databases data to target databases
• Using shell script programing on Unix & Linux platforms
• Run job schedule programming using Crontab

Confidential, Los Angeles, CA

Oracle Consultant

Responsibilities:

• Proactively monitors PL/SQL performance and make CBO adjustments as necessary
• Serve customers inquiry on database for account receivable and payable
• Inquiry & testing development, test database before moving to production environments
• Run Oracle 9i/10g database with OEM in Linux/window environments
• Run performance tuning using Statspack, explain plan etc
• Follow database standards & participate in design reviews

Confidential, Columbus, Indiana

Oracle DBA consultant

Responsibilities:

• Apply multiple components in Oracle8i, 9i, 10g to consolidate distribution databases
• Response for specification, design and programming, documentation, and support of software
• Analyze business requirements, specify and develop new programs, maintain current program,
• Support end users; apply new technologies which could be used to meet current and future needs.

Confidential, Michigan

IT Developer

Responsibilities:

• Design, model, re-engineer databases and develop prototypes to reflect initial requirements
• Fine-tuned performance of Oracle Adapter applications through stored procedures
• Application testing using Win Runner, and loadRunner for quality insurance

Confidential, Columbus, Ohio

Oracle Developer/DBA/ UNIX admin

Responsibilities:

• Implemented the county real estate tax infrastructure with IT technology
• Performed unit testing with documentation.