SUMMARY:

• A certified oracle DBA with experience in all facets of information technology, database architecture, physical and logical design and implementation is seeking to increased accuracy, performance, and efficiency in a long time opportunity. I am Skilled in collaborating with all members of the organization to achieve company objectives. Instrumental in diagnostics, production support, and incident management, and enhancing productivity with innovative technology solutions.
• Oracle Certified Professional (OCP: 9i, 10 & 11g) Database Administrator.
• 12 years of IT experience as Database Production Support, Data Analyst, and system Analyst.
• Comprehensive knowledge in Database Architecture, Design & Implementation - Physical and logical.
• Good understanding and Implementation experience in Data Guard, GG, RAC and Oracle Grid environment.
• Large high volume site support (OLTP & DSS) experience on transactional 24 x7 systems (Production & Appl. Support)
• Efficient in Database Performance monitoring, Diagnostic and tuning, Backup and Recovery, Upgrade, Patching and Managing users and security.
• Production support capable of managing incidents - reactive and proactive in terms of preventive maintenance and knowledgeable in terms of risk management.

TECHNICAL SKILLS:

Database Admin: ORACLE 9i/10g/11g/12c and MSSQL Sever 2012

Database: Oracle RDBMS (OLTP & Data Warehouse), CACHE, Microsoft SQLSEVER 2012, Access

OS/Server: Unix-AIX, Solaris, HP, Linux (Red Hat), VMWare, Window, Apacha web server, LDAP

High Availability: Real Application Cluster (RAC), Data Guard, Oracle Golden Gate

Tools: /Utility Oracle OEM- Grid and Cloud Control, ASM, ACFS2, RMAN, AWR/ADDM. Statspack, Liquibase XMLCitrix, Quest (Toad, Spotlight), SQL Server Mgmt. Tools (SSMS, SSIS, BIDS), Visual Basic.

Application: TIBCO, RAC, ATG, Lawson, Microstrategy, Artiva, HEAT, Remedy, SAP, MS Office, ILIEN, OC, ERP

Languages: SQL, PL/SQL, SHELL Script, Perl

General: Analytical, strong verbal and written communication skills and a team-player.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Oracle Production Support DBA

• Provide new installations, configuration, patch fixes, and upgrades of oracle database software: - I have achieved success in planning and upgrading the older oracle releases from 10g to 12c on very large production databases.
• Promoted changes to production and test environments to fix data issues and deployed application functionalities
• Enhanced data access performance through partitioning, replicating objects and building indexes.
• Investigated, and resolved potential problems and issues raised from monitoring events and user’s in a 24/7 hours on-call rotation..

Confidential, Houston, TX

Oracle Database/Application Support DBA

• Provide database and application support necessary to build, deploy changes and to maintain applications,
• Resolved application issues and keep the database available and running on high performance in production, staging (QA) and development.
• Created and refresh databases, replicate and archive data with security features (encryption and masking).
• Deployed application codes (Liquibase XML); support EOM billing activities and Disaster Recovery drills.
• Performed daily DBA administrative tasks such as creating and managing users, monitor & enhance performance, mange storage, backup and recovery, troubleshooting connectivity, and resolving database issues.
• Configured and troubleshoot oracle golden gates issues

Confidential, Dallas, TX

National Data Warehouse Support/Database Administrator

• Continually ensured upkeep of NDW application server hosting, Application (Micro Strategy and Informatica) and Database (Oracle and SQL Server) for production and FIT environments.
• Produced innovative remedial solutions to correct security risk findings and troubleshot performance on applications for MicroStrategy and Oracle database.
• Configured LDAP proxy servers, updated SSL certificates, monitored NGD Dashboard for application and infrastructure performance issues, and deployed codes and applications in Oracle and MS SQL databases.

Confidential, Atlanta, GA

Application Engineer

• Instrumental in implementation project in support of Tibco application and successful Cyber Vision data center migration, transporting large data (AIX to Linux) and integrating replication to improve performance and access.
• Provided technical support on issues involving database, O/S, and Oracle-supported applications, including Tibco Administration on Apache Tomcat, Hawk, EMS, portal builder, and business connect.
• Patched Oracle software, cloning and renaming databases after converting from legacy system.
• Utilized SQL Performance Advisory packages to improve database performance, proactively tuning prod, QA, and development database. Developed and approved technical SOP documentation on supported systems.

Confidential, Irving, TX

Data Analyst

• Consulted on multiple projects, including full life cycle implementations and providing data access needed for critical analysis and decision making.
• Reviewed, implemented and improved database integrity and security across high sensitive data through effective access control, fined grained access based on best practices
• Ran Oracle SQL reports to collect data for analysis and modeling for the customer's management reports
• Supported databases users and application developers to integrate functionalities based on business requirements