Consultant DBA/Database Engineer Resume Fremont, CA - Hire IT People

SUMMARY

Highly accomplished and resourceful DBA with more than 9 years of experience managing database systems and infrastructure.
Proven expertise in production support, SDLC, database design, ERD and physical design.
Credited with providing technical support, quality improvements and technical analysis within high - profile institutions.
S killed in collaborating with all members of the organization to achieve technology objectives.
Instrumental in streamlining and improving processes, enhancing productivity and implementing solutions.

TECHNICAL SKILLS

Oracle 9.x - 11.2, RAC 10.2-11.2, Grid Control, Oracle Enterprise Manager, DataGuard, RMAN, SharePlex, GoldenGate, Toad, MSSQL Server2008, Autosys, LDAP, Samba, Unix, Solaris, RHEL, Windows, SQL, PL/SQL, Korn, C, Perl, Cobol, ErWin, SQL*Net, SQL*Loader,Export/Import, Datapump, Reportwriter, Peoplesoft 9.1, ODBC, Toad and SQLDeveloper, SUN Enterprise 3000, Sun Sparc T2000, Fibre (EMC) and iSCSI (Dell) SANs.

PROFESSIONAL EXPERIENCE

Confidential, Fremont, CA

Consultant DBA/Database Engineer

Responsibilities:

Oracle RAC (3-node) administration on Oracle 11.2.0.3 on RHEL 6.6
Oracle DataGuard administration, including testing Switchover to Standby.
Implemented incremental backups via Change tracker
Alert scripts in Python to check for ORA errors for 24/7 support
Troubleshooting performance issues using AWR and ADDM
Shell Scripts to monitor performance and refresh statistics
Migrate BasicFileLOBs to SecureFile which resulted in major space reduction and improved performance
Implemented Table compression to save space.
Table Partition management
Change management / Issue tracking via JIRA
Supported the application programmers with troubleshooting and problem solving.
Improved backups by implementing RMAN backups, restores and recovery.
Implemented Nagios.
Wrote and automated scripts to transmit data and utilized DataPump for exports automation.
Oversee planning, tracking and analysis of performance and incident resolution.

Confidential, Oakland, CA

Oracle DBA

Responsibilities:

Managed all of PHI’s critical databases and servers.
Ensured 24x7 Oracle 10.2 and 11.2 databases on Redhat Linux and SolarislO .
RMAN backup, testing, launches, recovery processes and training.
Improved IT infrastructure by designing and deploying the DR.
Led database administration and systems administration initiatives of Unix and Linux servers.
Implemented PeopleSoft 9.2 and MSSQLserver 2008 for staff training on Windows 2008 R2 Sp2.
Built a failover solution with Sunfire T2000 and SAN combination (simulated the 1-node RAC solution for POC)

Confidential, San Leandro, CA

Sr. Consultant DBA

Responsibilities:

Spearheaded installations, testing and maintenance of IT infrastructure including Dataguard switchovers, backups and replications.
Administration of Oracle RAC 10.2 and 11.2 on ASM
Shareplex administration for WellsFargo’s GTS (Global Treasury System) DBA On-call team.
Improved performance by collaborating in the development of the Automated Server Maintenance system in Perl.
Streamlined problem tracking with W2000 ticketing system including follow through to resolution.
Supported Baan ERP and other Oracle databases to host applications like Clarify, Plateau and AlarmPoint.
Managed 65 Oracle instances on IBM, HP, Sun platforms.
Provided production support (24x7) using the Clarify system.
Managed 65 Terabytes of Oracle databases on various Unix and Linux servers.
Wrote scripts using SQL and shell for automating DBA activities.
Increased transparency in performance by monitoring and tuning using Perfstat.
Configured and administration using OEM 9.2 and DB Control 10.2
Installed and tested Grid Control on Oracle 11g.
Evaluated products like Delphix (database virtualization) and Toad.
Developed backup and initiatives for recovery using RMAN.
Performed troubleshooting and problem solving for in-house and customer environments.

Confidential, New York, NY

Sr. Analyst/Oracle DBA

Responsibilities:

Oversaw Oracle database administration on Oracle10g on RAC and Oracle 10g Grid control.
Streamlined installations, maintenance, upgrades and performance testing with RAC, Beta/Dev, AWR, Nagios, Datapump, Netbackup and an Oracle database migration.
Provided Pl/sql procedures and package design and code for quarterly reports.
Datawarehouse load with Informatica Powercenter .
Periodic objects promoted to Production (from Dev/QA)