SUMMARY

• 7+ years of experience in Oracle Database Administration, including database design, administration, programming and software development.
• 4+ years of experience in MySQL Database Administration, including database design, administration and monitor MySQL using MySQL workbench.
• Database administration and design skills include logical and physical data modeling, database creation, performance turning, troubleshooting, routine maintenance, backup/recovery, table space compression, install and upgrades. Studying Oracle Business intelligent OBIEE to run, create and generate statists
• Excellent problem solving skills, Oracle11g Certified DBA IT Certifications, Training and Awards
• Oracle 11g Certified Professional Database Administrator
• MSQL Certified Database Administrator

TECHNICAL SKILLS

Operating Systems: UNIX (Sun Solaris, AIX, HP, Dell, DEC Ultrix), Linux, Red Hat, WindowsRDBMS: Oracle 12c/11g/10 g /9i/8i, MySQL, SQL, Real Application Cluster (RAC), Golden Gate.

Application Tools: Golden Gate 11g, Secure CRT, Secure FX, WINSCP, Text Pad, Oracle tools such as Data Guard/Standby,MySQL Workbench,OneNote,Source AnyWhere,Password Manger,Nagois Database, Grid Control, OEM, PeopleSoft, Toad, Putty, RAC, VM Ware, Exceed, Streams, RMAN, VM Ware, ASM, AIX, SQL Loader, AWK, PKPROF, Oracle Forms 4.5, Service manager

Languages: S QL, PL/SQL, C++, XML, Perl scripting, Shell Scripting, Enterprise Manager HP Database and Middleware Automation Solutions

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Created and maintained 50+ Oracle 10g/11g/12c databases. Some configurations use Oracle Data Guard for the DR/Standby solution and RAC in a SAN platform. Use RMAN for backup and recovery; use oracle tool AWR/ADDM and OSWatcher to diagnose database problems.
• Create and monitor 10+ plus MySQL Databases in Solaris, Linux using MySQL Workbench to monitor the databases.
• MySQL installed and worked on version 5.14, 5.15, 5.16 and 5.17.
• Database changes and implementations follow strict Change management process.
• Install patch and maintain all Oracle software.
• Configure, Install and Troubleshoot RAC environment.
• Configure and manager PeopleSoft reporting application in production environment for vendors reporting.
• Write PL/SQL script to pull detail information on production performance issues using explain plans.
• Monitor and configure RAC services and check alerts logs on the primary and standby database for error.
• Tune Oracle instance components including MySQL, SQL and PL/SQL.
• Design and implement backup and recovery systems.
• Implement Oracle failover technology Data Guard.
• Experience with OLTP, dimensional database design and code implementation.
• Work closely with the Developers in resolving performance issues and implementing process.
• Proactive personal with a proven track record of delivering responsibilities and task.
• Work closely with the Business Intelligent Team with home grown application RMS Application to resolve issues at the retail stores.
• User Golden Gate 11g for data replications and movement of large data from one platform to another platform with decision making...
• Managing up to 40 Oracle databases on different UNIX platforms in SAN environment: Sun Solaris, Linux Red Hat and AIX, HP and Dell. Administered in releases from 12c/11g/10g/9i. Task includes install, migrate and upgrade Oracle, create database, database maintenance, database security, performance tuning, backup and recovery. Provide 24x7 production supports for mission critical databases.
• Use and configure Rman for database backup and recovery.
• Use Enterprise manager to monitor database health and check logs files for error.
• Major Player in UNIX Disaster Recovery Upgrade project. Implemented new DR strategies for 9i, 10g, 11g, 12c and databases by using Oracle Standby database. Improved from the original 3 - day DR recovery requirement to 3 hours.
• Major DBA player in UNIX and Windows Servers on Demand project. (80% of DBA work load.) This project includes the setup of 12 Red Hat, Sun, AIX Servers, 65 Oracle installations, 55 database migration and upgrades.
• Created and maintained 22 Retail Wireless’ mission critical oracle 10g, 11g databases. Implement the Data Guard technology for DR.
• Major Player in Oracle utility server conversion project, involved in work coordination, Server configuration, Oracle Installation, database creation and administration. Setup the databases with the HA failover ability.
• All phases of production support for Chase's mission critical Oracle databases.
• Oracle database administration in Windows & UNIX environments includes database design, database tuning, and managing of database security, resources and storage. Managed 20 databases for 5 different sites across Texas.
• 24 x 7 worldwide rotation on call as last line system supports defense.

Confidential

Oracle DBA

Responsibilities:

• Created and maintained 20+ Oracle 10g/11g/12c databases. Some configurations use Oracle Data Guard for the DR/Standby solution and RAC in a SAN platform. Use RMAN for backup and recovery; use oracle tool AWR/ADDM and OSWatcher to diagnose database problems.
• Using MySQL workbench to monitor MySQL databases.
• Database changes and implementations follow strict Change management process.
• Install patch and maintain all Oracle software.
• Configure, Install and Troubleshoot RAC environment.
• Configure and manager PeopleSoft reporting application in production environment for vendors reporting.
• Write PL/SQL script to pull detail information on production performance issues using explain plans.
• Monitor and configure RAC services and check alerts logs on the primary and standby database for error.
• Tune Oracle instance components including SQL and PL/SQL.
• Design and implement backup and recovery systems.
• Implement Oracle failover technology Data Guard.
• Experience with OLTP, dimensional database design and code implementation.
• Work closely with the Developers in resolving performance issues and implementing process.
• Proactive personal with a proven track record of delivering responsibilities and task.
• Work closely with the Business Intelligent Team with home grown application RMS Application to resolve issues at the retail stores.
• User Golden Gate 11g for data replications and movement of large data from one platform to another platform with decision making.
• Managing up to 40 Oracle databases on different UNIX platforms in SAN environment: Sun Solaris, Linux Red Hat and AIX, HP and Dell. Administered in releases from 11g/10g/9i. Task includes install, migrate and upgrade Oracle, create database, database maintenance, database security, performance tuning, backup and recovery. Provide 24x7 production supports for mission critical databases.
• Use and configure Rman for database backup and recovery.
• Use Enterprise manager to monitor database health and check logs files for error.
• Major Player in UNIX Disaster Recovery Upgrade project. Implemented new DR strategies for 9i, 10g, 11g, and databases by using Oracle Standby database. Improved from the original 3-day DR recovery requirement to 3 hours.
• Major DBA player in UNIX and Windows Servers on Demand project. (80% of DBA work load.) This project includes the setup of 12 Red Hat, Sun, AIX Servers, 65 Oracle installations, 55 database migration and upgrades.
• Created and maintained 22 Retail Wireless’ mission critical oracle 10g, 11g databases. Implement the Data Guard technology for DR.
• Major Player in Oracle utility server conversion project, involved in work coordination, Server configuration, Oracle Installation, database creation and administration. Setup the databases with the HA failover ability.
• All phases of production support for Chase's mission critical Oracle databases.
• Oracle database administration in Windows & UNIX environments includes database design, database tuning, and managing of database security, resources and storage. Managed 20 databases for 5 different sites across the World.
• 24 x 7 worldwide rotation on call as last line system supports defense.

Confidential

Network Administrator

Responsibilities:

• Maintain Call Center and Site Building on Nortel PBX systems.
• Install and maintain customer desktop applications using push tool like batbliz, sccm, sms.
• Write scripts and batch files for various applications for Confidential