SUMMARY:

• Over 20 years experience of design, development, maintenance and administration of relational databases, applications, data warehousing and other computer systems; have successfully managed high availability of production systems and large - size databases (50 Terabytes) ; Frequently using Oracle Grid/Cloud Control, OEM/OMS to manage Oracle databases.
• Oracle Architect, MY Sql and SQL Server DBA.
• Strong Oracle skills but also significant System Administration skills in a UNIX environment. Proficient at writing shell scripts as well as knowledge in general systems administration tasks.
• Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.
• 4+ years of Oracle GoldenGate experience with Installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.

TECHNICAL SKILLS:

Platforms: Unix, Linux, Solaris, AIX 4.3.x, 5L, Windows 2000,2003,Oracle 6,7,8,8i,9i,10g, 11g, 12c,Oracle RAC, Streams,Goldengate Exadata, Exalogic, SQL*PLUS,SQL*NET,Net8, SQL*Loader, PL/SQL, export/import, Unix shell Scripting, MYSql, SQL Server 2000, 2005, RMAN, BMC SQL-Backtrack, Designer/2000, Developer/2000, MS Access, C/C++,PRO*C.

Tools: Data Guard, Streams, Grid Control/OEM, RMAN, BMC SQL-Backtrack, Oracle Data warehouse Builder/OWB, Embarcadero Performance Center/ DBArtisan, Quest Software, Toad, OEM, Designer/2000, Developer/2000, SQLPLUS, Report 2.5, SQL*REPORTWRITER, Platinum Desktop DBA, Remedy ARS, Goldengate

Performance Tuning: AWR, TKPROF, Explain Plan, Trace, Oradebug

Hardware: IBM RS/6000 SP, Pyramid RM1000, Sun, NCR, VAX II, IBM PC, LAN

Software: Oracle 11g,10g, ORACLE 9i,8i, 8 & 7, MySql, MS ACCESS 2.0, TCP/IP, PC/TCP

Operating Systems: UNIX, AIX, Linux, SCO Unix, Solaris, MacOS, NT, WINDOWS2000, VAX/VMS, MS DOS, MVS/XA

Languages: C/C++, PRO*C, JAVA 2, J2EE, Pascal, HTML4, Cobol, CICS, JCL, Fortran

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. Oracle Database Administrator (Consultant)

Responsibilities:

• Setup and Test Goldengate replication on RAC
• Installed and Configure Oracle 12C Cloud Control in two cluster nodes with High Availability option
• Support Oracle RAC and Active Data Guard
• Upgrade Oracle databases from 11g to 12c
• Backup/Restore Oracle databases by RMAN in DBBoost (EMC software)
• Troubleshooting complex problems for databases
• Using Oracle Golden Gate to replicate 5TB databases to other sites
• Using Oracle Golden Gate to migration databases without down time

Confidential, San Francisco, CA

Sr. Oracle Database Administrator (Consultant)

Responsibilities:

• Apply Oracle PSU for Grid Infrastructure and RDBMS
• Created automation scripts to audit Oracle users
• Responsible for supporting the design, development, and operations of databases for Web Portal, data warehouses and data flows.
• Assist of several systems to Exadata and Exalogic -- setup ASM, RAC.
• Migrate Single Instance to RAC, Setup PCP, Configure Active Data Guard - Goldengate replication to a reporting system.
• Created Oracle SR and worked with Oracle support.
• Monitored databases, performance tuning using Grid Control.
• Backup Oracle databases by RMAN.
• Design, development, and operations of Oracle,and MS SQL databases for mission-critical applications troubleshooting complex problems for databases
• Worked as a resource deploy SQL, PL/SQL scripts for QA and Development teams
• Installed and configure Mysql Master/Slave replication for member portal

Confidential, Pleasanton, CA

Sr. Database Administrator

Responsibilities:

• Responsible for supporting the design, development, and operations of Oracle 11g databases for Claims, DataMart.
• Monitored databases, performance tuning using Grid Control.
• Installed and configure Mysql Master/Slave replication for Big Data Projects.
• Responsible for databases code deploy and software release for QA, Stage and production.
• Using Oracle Goldengate to migrate Oracle 11g databases between HP-UX and Linux.

Confidential, San Francisco,,CA

Sr. Oracle Database Administrator

Responsibilities:

• Responsible for supporting the design, development, and operations of databases for Web Portal, data warehouses and data flows.
• Assist of several systems to Exadata and Exalogic -- setup ASM, RAC.
• Migrate Single Instance to RAC, Configure Active Data Guard - Goldengate replication to a reporting system.
• Provided 24X7 Production supported.
• Created Oracle SR and worked with Oracle support.
• Monitored databases, performance tuning using Grid Control.
• Backup Oracle databases by RMAN.
• Design, development, and operations of Oracle,and MS SQL databases for mission-critical applications troubleshooting complex problems for databases
• Supported BI and Informatica Applications
• Worked as a resource deploy SQL, PL/SQL scripts for QA and Development teams.

Confidential, San Ramon, CA

Sr. Oracle Database Administrator

Responsibilities:

• Collaborate and consult with application support teams to fully understand database requirements, issues, and concerns and to maintain database operations according to service level agreements.
• Provide consulting services to application support teams, DBA team mates, and management for purposes of explaining and defining optimal database strategies and operations. Align strategies with operational service level agreements.
• Created Oracle SR and worked with Oracle support Provide expert, hands - on production support of mission-critical and other assigned Oracle databases. Monitor assigned Oracle databases for performance, maintenance, and tune these databases as appropriate to maintain predefined service level agreements. Install, upgrade, patch, backup, and recover assigned Oracle databases as specified by business and compliance requirements. Enforce company change control, patch management and information security standards and procedures. Maintain all change and patch management documentation as required by company policy. Collaborate and consult with DBA team mates to help perform all of the above on Oracle databases assigned to others.
• Provide off-hour and weekend production support as necessary and to act as backup DBA as required for maintaining SLA support
• Demonstrate a consistent, independent ability to manage assigned Oracle databases and the workload required to maintain those databases. Manage work according to criteria of costs, scheduling, and functional and technical performance. Maintain open and honest communications with clients, team mates and management for purposes of providing ongoing, timely status reporting. Communicate status, issues and concerns in both written and oral formats
• Demonstrate ability to maintain and advance Oracle and
• UNIX knowledge, skills and abilities through self-study, instructor-led training, and assignments designed to stretch and teach. Share knowledge with team mates via collaboration and mentoring. Produce white paper overviews and conduct team presentations as appropriate to help advance overall team knowledge, skills and abilities.

Confidential, SFO, CA

Sr. Database Administrator

Responsibilities:

• Upgrade Mysql databases.
• Using xtrabackup to create many replicat.
• Monitor Databases performance, check slow sql log and tune many SQLs.
• Created new tables and indexes for new projects.
• Using Mysqldump backup Mysql tables.

Confidential, Brisbane, CA

Sr. Oracle Database Administrator

Responsibilities:

• Migrated Oracle single instance to 11g RAC on Sun Solaris 10 with ASM and Sun IPMP failover solution.
• Set up Physical and Logical Standby database by Data Guard.
• Monitored databases, performance tuning using Grid Control.
• Set up and Test Golden Gate replication between Oracle databases
• Supporte and Monitor MySql databases.
• Migrate MySql database to Oracle.

Confidential, San Francisco, CA

Sr. Oracle Database Administrator

Responsibilities:

• Upgraded 10g databases to 11g
• Set up Oracle streams/downstream/stage in 11g and 10g for Siebel Application.
• Installed and set up Oracle 10g RAC databases on Sun Solaris 10 with ASM and Sun IPMP failover solution.
• Added more nodes for current production RAC.
• Supported MySql databases.
• Migrated MySql databases to Oracle.
• Set up Physical and Logical Standby database by Data Guard.
• Set up Oracle streams/downstream.
• Upgraded 9i databases to 10g in Linux environments.
• Upgraded Oracle Warehouse Builder and Workflow.
• Supported production databases for ecommerce and data Warehouse.
• Installed and setup SQL servers 2005 for Internal Applications.
• Installed and setup Oracle Grid Control
• Monitored databases, performance tuning using Grid Control.
• Used RMAN backup and recovery databases.

Confidential, North Pacheco, CA

Sr. Oracle Database Administrator

Responsibilities:

• Applied Oracle Security patch for 8i, 9i and 10g.
• Set up Physical and Logical Standby database by Data Guard.
• Created and supported internet banking system using Oracle 10g database.
• Worked with Oracle database failover in veritar/SAN environments.
• Used RMAN backup and recovery databases.
• Working on Filenet application project which uses Oracle databases
• Created more than 5 Oracle instances for peoplesoft upgrade project.
• Supported Peoplesoft production development and tested environments.
• Worked as a DBA for Siebel CRM desirable.
• Responsible for database audit using Dsauditor from Embarcadero.
• Upgraded 9i Oracle database to 10g for data warehouse.
• Migrated Oracle databases to different hosts.
• Set up Oracle 9i OEM/OMS and 10g database control/Grid control

Confidential, Philadelphia, PA

Sr. Oracle database Administration

Responsibilities:

• Created, upgraded and migrated 10 large Oracle databases for both transaction and analytical production databases from 8i to 9i including applying patches.
• Used RMAN (TSM) backup and recovery databases.
• Worked with external procedural calls to Oracle databases.
• Responsible for data modeling, created primary keys, foreign keys and indexes.
• Installation and configuration of Oracle 9i and 10g RAC with Data Guard and database replication
• Database monitoring and performance tuning with Embarcadero Performance Center and Oracle STATSPACK for Web (Transaction Type) and Data Warehouse applications (analytical Type).
• Supported EPIC Healthcare applications.
• Installed MS SQL and Administration of MS SQL database under cluster Server for In-Patient application (SCM).
• Responsible for system architecture, optimization and disaster recovery strategies.
• Mentored other Jr. DBAs and developers as an advisor.
• Involved many Servers Consolidations and Migrations projects including large scale storage technologies SAN.

Confidential, Newark, DE

Sr. Oracle DBA/Sr. Information System Specialist

Responsibilities:

• Set up Oracle Jserver including EJB, JDBC.
• Designed, Built, and Managed Oracle Data Warehouse Project using Oracle 8i.
• Upgraded Oracle 8i (8.1.6) to Oracle 8i (8.1.7) in the Test and Production Boxes.
• Oracle 8i Tuning for the OLAP and the DSS including Oracle parameters and SQL tuning.
• Involved Enterprise Backup and Recovery project using SQL*Backtrack (BMC software)
• Upgraded Oracle Designer6i from Designer 2000
• Installed and Configured the OEM (8.1.7), including SNMP and Intelligent Agent.
• Infrastructure research, such as Oracle 9i and XML.
• Supported the SQL server for Micro Strategy projects.
• Support of Peoplesoft production development and test environments.

Confidential, Horsham, PA

Sr. Oracle DBA

Responsibilities:

• Oracle Database Disaster/Emergency recovery.
• Responsible for upgrading, maintenance Oracle7, Oralce8 and Oracle8i.
• Performance Turning Oracle7 & Oracle8, where the databases are storing BAAN & PeopleSoft Data. Analyzing and reorganizing database objects. To avoid fragmentation and to improve performance. Space management and regular monitoring of databases.
• Installed Oracle8 & 8i for E-business projects.
• Installed Perl, including DBI & DBD modules.
• Installed Apache server.
• Tested CGI by using Perl.

Confidential, Wilmington, DE

Sr. Oracle DBA - Data Warehouse

Responsibilities:

• Management of a large scale data warehouse projects (three Terabytes Oracle Database) under MPP and oracle parallel server environment, where there are 64 nodes.
• Responsible for the creation, maintenance, and usage of Oracle environments.
• Created multiple Oracle database instances, monitor, adjust database storage, and ensure database performance.
• Supported and maintained another 18 small Oracle Databases under UNIX and NT.
• Anticipated, prevented, detected and resolved problem.
• Planned, Created and maintained a Standby Database for the Enterprise management system.

Confidential, Stratford, CT

Sr. Systems Analyst/Oracle DBA & Developer

Responsibilities:

• Installed and upgraded the Oracle 8 & 7.3.X Servers and Sun Solaris 2.X.
• Installed and setup Oracle Web Servers
• Installed and upgraded the Oracle application tools, such as Designer/2000, Developer/2000 on the Winders95 and Sun Solaris 2.X.
• Backing up and recovering the databases.
• Created primary database storage structure, Such as system, temporary tablespaces and rollback segments.
• Redesigned the Mainframe application and reversed engineering by Designer/2000 and Developer/2000.
• Installed and upgraded Remedy, a help desk software, on Sun and Windows95.
• Installed and set up Oracle Web Server.
• Installed and used Platinum Desktop DBA to Maintain the Oracle databases.
• Used html format to document.
• Migrated a Microsoft Access 2.0 database to Oracle7 including convert all the GUI by using VB5 and Developer/2000