Sr. Lead Oracle Database & Mysql Resume
2.00/5 (Submit Your Rating)
Herndon, VA
SUMMARY:
- Managed and lead a group of DBA s.
- Over 20+years extensive experiences in Information Technology industry, especially in Oracle Database / UNIX - like system administration, software and database design and implementation area.
- Over 10+ years of Oracle RAC and Data Guard experience
- Over 7+ years of Oracle Golden Gate experience
- Over 10+ years of MySQL
- Over 5+ years of Sybase
- Solid hands-on experiences in installation, configuration, trouble-shooting, performance tuning in Oracle High Availability technologies, including 10g/11g/12c RAC, ASM, Physical/Active Data Guard on any environments.
- Proficient with Database Cloning, Migration from version 11g to 12c, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications.
- First hands-on experiences in software maintenance of Databases including upgrades and patching.
- Provide and implement performance tuning recommendations of all components in database machine.
- Over 15+ years experienced and solid hands-on experienced in Installation / Configuration / Performance Tuning / Troubleshooting Oracle Golden Gate data replicate middleware in Oracle to Oracle homogeneous environments and heterogeneous environments (including MySQL Server to Oracle).
- Proficient in Oracle database backup & recovery strategies plan and implementation such as user-managed backup, RMAN backup with/without catalog, cold and hot backup(Data Pump) Flash-Back recovery, full/incremental backup.
- Highly skilled in SQL Tuning by using Oracle statistics management, AWR, ADDM, ASSM, Grid Monitoring, Explain Plan, TKProf and necessary SQL code rewrite.
- Enthusiasm to learn new technologies.
PROFESSIONAL EXPERIENCE:
Confidential, Herndon, VA
Sr. Lead Oracle Database & MySQL
Responsibilities:
- Configured, implemented, designed and supported the Oracle and MySQL databases.
- Being lead database on a group compose of 4, I see to it that all standards are met when deploying until supporting of a database system.
- Give task to individual and assisting them.
- Create new ways to monitor databases to be more pro-active.
- Created some performance and tuning script for everyday health check.
- Defined and implemented backup and recovery procedures for data stored using scripts and RMAN.
- Set up, configured and maintained Oracle RAC, Oracle Data Guard, Golden Gate and multi-master replication servers.
- Migrated database from version 10 to 11g and 11g to 12c.
- Assisted with database configuration documentation working with engineering.
- Work closely with product development team to identify Oracle problem, troubleshoot, and either fixed or recommend solutions.
- Participate as part of a team providing 24x7 support of mission-critical Oracle databases and related technologies.
Confidential, Dulles, VA
Sr. Oracle & Sybase Database Administrator
Responsibilities:
- Configure, implement, and support the Oracle and Sybase databases that are part of the Confidential /Netscape Network Operations, including Oracle and Sybase RDBMS installation, logical and physical design, database creation, performance and tuning
- Defined and implemented backup and recovery procedures for data stored in Oracle and Sybase databases using scripts and RMAN. Set up and maintained Oracle RAC, Oracle Standby(Data Guard) and multi - master replication servers and Sybase replication servers, both bidirectional and warm standby.
- Assisted with database configuration documentation. Work closely with product development team to identify Oracle/Sybase problems, troubleshoot, and either fix or recommend solutions.
- Participated as part of a team providing 24x7 support of mission-critical Oracle databases and related technologies.
Confidential, Colorado
Lead Database Administrator
Responsibilities:
- Installed and configured Oracle V8.0.5 for SITE/SIM data warehouse using Solaris 2.6 Unix platform. Administered Oracle V7.3.4.3 and V8.0.5.2 using NCR and Solaris 2.6 Unix platform running applications such as HR Benefits & Retirements, HR Assets, Inventory and Price Management System.
- Administered Sybase SQL Server V11.0.3 and V11.0.3.3 using NCR machines as a datawarehouse.
- Administered Informix V7 using NCR machines for Corporate Data Reconciliation application.
- Responsible for setting up development and test servers.
- Designed structure of the databases and file systems. Responsible for capacity planning of the systems, performance monitoring and tuning, backup and recovery, and failover.
- Responsible for day - to-day operations including monitoring status and response time of systems and databases.
- Responsible for special projects including system upgrade, disaster recovery plan and implementation, Y2K testing plan and implementation.
- Responsible for making recommendations and vendor relations.
