SUMMARY:

• More than 16+ years of experience in database administration (DBA) work for various kinds of applications in Oracle on both UNIX and Windows environments.
• A self - motivated, responsible, and reliable team player with a very strong set of technical skills in a wide range of database work.

TECHNICAL SKILLS:

Specialties: Oracle Exadata, Oracle Exadata Compress/Patching, PL/SQL, Oracle 10g - 12c, Oracle Real Application Clusters (RAC), Data Guard, GoldenGate, and Oracle Streams

Languages: Siebel, C, C#, .NET, Crystal Reports, Transform and Load (ETL), Oracle Reports, PL/SQL, T-SQL, HTML, shell scripts, SQRW, XML, Perl, Oracle Wallet, Oracle Security and Unified Modeling Language (UML)

Databases: DB2, Oracle 9i(9.0-9.2), 10g, 11g, 12c, MySQL, and MS SQL Server

Tools: DataMirror, Embarcadero ERStudio, ERwin, Oracle Enterprise Manager Grid Control, Informatica, SQL Navigator, TOAD, SQL*Plus, Quest Tools, Oracle Virtual Private Database(VPD), Oracle Virtual Machine (VM), Audit Vault and Database Vault and Visio

Operating Systems: Oracle Exadata Storage Server, HP/UX, MS NT/Window, Solaris, Linux, AIX and VMS

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Sr. Oracle DBA

• MGM Lead Oracle DBA for the Exadata Project
• Upgrading Oracle Real Application Clusters (RAC/ASM) d atabase on AIX from 11.2.0.3 to Exadata 11.2.0.4 with Confidential
• Help in upgrading Oracle OPERA Application System (Hospitality for Hotels)
• Install Audit Vault and Database Vault on Exadata
• Using rman and Transporting Tablespace for Exadata upgrade.
• Advising, mentoring, and technical leadership for the upgrade to Exadata
• Writing Korn Shell scripts for task automation
• Maintained, supported, and configuration Data Guard
• Maintained, supported, and configuration Replication (Oracle GoldenGate)
• Writing and Maintained Stored Programs (PL/SQL)
• Duties included: DBA Support, Database Backup/Restore (RMAN), Database installation, administration, Oracle patching, SR’s, Database performance tuning and query optimization
• Database size: Large +TB

Confidential

Oracle DBA / Developer

• Responsible for Database Support for Apartment Guide website
• Wrote Korn Shell scripts for task automation
• Maintained Database Architecture
• Maintained the DBA Support for Oracle (11g and 12c), MySQL and SQL Server
• Database performance tuning and query optimization
• Maintained Stored Programs ( Functions, Procedures Triggers, and Packages) for the projects
• Duties included: DBA Support, Database Backup/Restore (RMAN), Database installation, administration, patching, SR’s, Database performance tuning and query optimization
• Database size: TB

Confidential

Remote Oracle DBA

• Responsible for Database Support for Sabre ATSE Applications.
• Upgraded 15 Oracle Real Application Clusters (RAC/ASM) d atabase from 11.2.0.3 to 11.2.0.4
• Upgraded Oracle Real Application Clusters (RAC/ASM) databases from 11.2.0.3 to 12c
• Patched 27 RAC databases every quarterly
• Wrote Korn Shell scripts for task automation
• Wrote PL/SQL scripts for task automation
• Maintained, supported, and configuration Replication (Oracle GoldenGate in Peer-To-Peer environment on 7 RAC. Each RAC consisted of 3 instance).
• Duties included: DBA Support, Database Backup/Restore (RMAN), Database installation, administration, Oracle patching, SR’s, Database performance tuning and query optimization
• Database size: Large +TB

Confidential

Consultant (Sr. Oracle DBA)

• Developed and enhanced Entity Relationship Diagrams for new and existing custom applications using ERwin modeling tool.
• Maintained the DBA Support for Oracle, MySQL and SQL Server
• Perform batch job and online query performance/optimization
• Upgraded database from 10g to 12c in an Oracle Real Application Clusters (RAC/ASM)
• Upgraded database from 9i to 12c in an Oracle Real Application Clusters (RAC/ASM)
• Wrote Korn Shell scripts for task automation
• Maintained and supported Oracle Virtual Private Database(VPD)
• Working on Oracle Virtual Machine
• Database size: +TB

Confidential

Consultant (Oracle DBA)

• Supported the Java Developers Team for Prepaid Phone Application
• Responsible for Query Performance tuning
• Wrote Linux Korn Shell scripts
• Reviewed the Code, for purpose of designing, architecting, and developing
• Performed health check for the database environments, provided findings and recommended solutions to management.
• Monitored the replication (in SharePlex)
• Database size: Large +TB

Confidential

Consultant (Oracle DBA)

• Maintained Database Architecture
• Database performance tuning and query optimization
• Implemented Oracle Data Guard
• Database Troubleshooting automation including alarm log for down database, performance issues, killing user sessions which were blocking other connections, addition of space in response to proactive alarms, database recoveries and various other problem situations
• Database size: Large +TB

Confidential

Sr. Oracle DBA

• Upgraded Oracle Database 10g to Oracle Exadata 11g (in (RAC)
• Tasked with writing Exadata compression for historical partition table in the warehouse database
• Upgraded Oracle Database 10g to 11g (in RAC)
• Maintained Data modeling (with ERwin)
• Installation, configuration, and cloning of multi-node and replication (Oracle Steams)
• Duties included Database support, Database Backup/Restore (RMAN), ETL process for EBS Applications, Siebel, PeopleSoft, Database performance tuning and query optimization and other Cox databases.
• Working on Oracle Virtual Machine
• Database size: Large +TB

Confidential

Consultant (Oracle Developer)

• Responsible for building new backend process to handle small freight allocation project for UPS and FedEx customers
• Task with writing all Stored Programs ( Functions, Procedures Triggers, and Packages)
• Duties included Database Modeling, performance tuning, and pulling database from the legacy systems.
• Database size: +TB

Confidential

Consultant (Oracle DBA / Developer)

• Lead PL/SQL Developer for all projects
• Lead Database Architect
• Supported Java developers in the design and writing of SQL statements
• I dentified, assessed, and prioritized immediate problem areas and developed action plans as appropriate
• Also, performed DBA support of the databases ( alarm log for down databases, archive log directory filling up, database performance issues, database recoveries (RMAN) and various other problem situations)
• Maintained and supported Oracle Virtual Private Database(VPD)
• Database size: +TB

Confidential

Consultant (Oracle Developer)

• Wrote all Stored Programs ( Functions, Procedures Triggers, and Packages) for the project
• Wrote customer program in Korn Shell to implement as concurrent requests
• Database size: Large +TB

Confidential

Consultant (Siebel DBA)

• Installed and maintained ETL (DataMirror)
• Loaded Data in Siebel environment
• Wrote Shell Script programs
• Supported the Java/Tibco developers in query development to pull data for the SAMSONs (AMDOC) systemsapplication.
• Database Troubleshooting automation including alarm log for down database, performance issues, killing user sessions which were blocking other connections, addition of space in response to proactive alarms, database recoveries and various other problem situations
• Database size: Large +TB

Confidential

Consultant (Database Architect / Developer)

• Wrote PL/SQL programming (stored procedures, functions, and triggers)
• Database changes (create tables, columns, indexes, and analyzer SQL statements),
• Wrote Shell Scripts for the Billing Systems
• Wrote Perl scripts for ETL.
• Duties included Database support, and support of the Java developers in the design and development of the application.
• Database size: Large +TB

Confidential

Consultant (Database Architect / Developer)

• Wrote PL/SQL programming (stored procedures, functions, and triggers)
• Loaded Data from the legacy system
• Created and maintained Data modeling (with Erwin)
• Wrote shell scripts for a Siebel enhancement environment system.
• Database size: +TB

Confidential

Consultant (Oracle Developer / DBA)

• Lead Database Architect
• Lead PL/SQL Developer
• PL/SQL programming (stored procedures, functions, and triggers)
• Upgraded Oracle Database from 8i to 9i
• Assisted in rewrite the application code from JAVA to .Net and C#
• Database size: +TB

Confidential

Consultant

• Wrote PL/SQL programming (stored procedures, functions, and triggers)
• Data modeling (with Erwin)
• Design an warehouse database
• Converted the Individual Income Tax System from DB2 to Oracle
• Designed/Created a Warehousing Database for the Tax system.
• Supported JAVA developers in the design and development of the application
• Database size: Large +TB