QUALIFICATION SUMMARY:

• 12+ years of Oracle Database Production Infrastructure support. My previous role supporting 2,000 + Oracle/Linux servers with thousands of databases in Production/UAT/Development environment.
• My current certifications across different RDBMS databases/data warehouse (Oracle & MS SQL Server Databases) on Physical & Cloud services plus my teaching experience assures my employer, that my technical ability would utilize Oracle & Microsoft cutting edge technology collaboration in backend infrastructures with emphasis on security and best practice.
• My experience as an Oracle DBA Lead & MS SQL Server Senior Production Operate L3 DBA has bridged the gap between teaching and applied theory and methodology to benefit my employer. I have been also a SME & Principal owner for 100+ core Databases across the firm like Remedy Change Control.
• I also can work independently and across a global team. I am a quick learner, analytical and self - driven.
• I’m open for relocation with right opportunity

SKILL:

Databases: Oracle 10G/11G RAC, 12c, ODI, OWB, Golden Gate Streams, rman backup/restore and DR recovery, expdp/impdp, OEM support/configuration. Geneos support and configuration &. As well as SQL-Server 2008/2005/2000/7/6.5 , T-SQL, OLAP, OLTP, DTS/SSIS, DLL, DML, Active Script, (SQL Server Mail Agent), SQL Reporting Server.

Data Warehousing: Oracle ODI, Oracle Golden Gate, Oracle Stream, Oracle Materialized Views, Oracle BI Cloud Service, Oracle BI Tools, Oracle BICS, Oracle Database Exadata Cloud Service, Big Data Preparation Cloud Service, MS SQL Data Warehouse, SSIS & Attunity, Analysis Services, Cubes, Pivot tables, Business Objects, Business Objects ETL

O/S: Linux 5.5, 6.1, Windows 2007/2003/2000/ NT File Server, Windows 2007/2003/2000 Advanced Server, Data Center Server, Windows 2007/2003/2000 Professional, Windows XP, NT Workstation

Networking: Linux 5.5, 5.6, 6.0 & Windows Network Design, Installation and Configuration, Active Directory, DNS, TCP/IP, WINS Server, DHCP Configuration, ADSI, LDAP, IP Routing, switching and sub-netting, Network Performance Monitor, Network Optimization, VPN, RADIUS, PPTP, L2TP, IPSec, Windows Instrument, Vbscript

Data Modeling: Database Design, Visio 2000, MS Framework (MSF), Erwin, MS Visual Modeler, UML, OO, MS Visual SourceSafe

Middle Tier: pl-sql, MS Transaction Server (MTS), MS Messaging Queue (MMQ)

EMPLOYMENT:

Oracle Cloud Administrator

Confidential

Tools: Oracle 12c, GoldenGate, Materialized View, PL/SQL, Oracle OEM, rman backups & Disaster recovery, Replication (Transactional, Merge), Log shipping, Mirroring)

OS: Linux 5.5, 5.6, 6.0, Windows 2008 server and advanced server

Responsibilities:

• Leading modern technology testing and discovery with Oracle 12c for Oracle certification on multi-tenant databases, Flex Clusters, and advanced recovery options.
• Currently testing Oracle 12c on two 2-Node Grid Infrastructure Clusters with multi-database Data Guard replication.
• Create and standardize documentation for our engineering teams to assist in the installation of Grid Infrastructure, RAC DB, Data Guard Replication, and GoldenGate Replication.
• PeopleSoft installation/Configuration & Patching
• Responsible for all tasks related to Data Import, Data Export, customizations and extensions
• Schedule and troubleshoot all standard and audit reports. Perform all Data and Role Security Administration.
• Monitor and respond to all Oracle Cloud Service Notifications. Liaison between Oracle Cloud services and internal customers. Manage and maintain all tasks around monthly patching, regression testing and version upgrades.

Sr. Oracle Production/Infrastructure DBA

Confidential

Tools: Oracle 10g & 11g RAC, 12c, ODI, Materialized View, PL/SQL, Oracle OEM, Geneos, rman, Streams, SQL Server 2000, 2005, 2008, Profiler, DTS, SSIS (ETL), T-SQL, VB Script, WMI Script. Disaster recovery Replication (Transactional, Merge, Snapshot), Log Shipping, Mirroring, Cloning

OS: Linux 5.5, 5.6, 6.0, Windows 2003, 2008 server and advanced server

Responsibilities:

• Played role as ODI/GoldenGate Administrator:
• Architect, developed & implemented & supported a high-performance data movement and transformation on various data source platforms using Oracle Data Integrator (ODI 11g)'s Extract, Load, transform (E-LT), leveraging Oracle RDBMS engine to process and transform the data. I was the production ODI administrator and played the role of Oracle Database Administrator. I Was responsible for performance tuning of the staging and production database and all SQL queries for the application.
• Changed the original database design with foreign key constraints and set of unique keys to enforce referential integrity and data quality for the later load into the DataMart.
• Have designed staging database area to clean problematic data before loading into the Data Warehouse. Designed OLAP cubes for the individual Product engineer to view and manipulate data relevant to their own product.
• Automated all load jobs of the DataMart and OLAP cubes builds with stored procedures, PL/SQL packages and scheduled Oracle Jobs.
• Played role as Oracle/SQL Server Administrator:
• RAC Installations/configuration (10g,11g & 11gR2) on AIX/Solaris/Linux, Rolling Patching, non RAC to RAC, ASM migrations
• Production Working in a fast-paced large environment, responsible for Oracle & SQL Level 3 support database applications to achieve optimum utilization, best practice, integrity and security
• Extensive experience analyzing AWR, ASH & ADDM Reports to troubleshoot databases and application performance issues.
• Work effectively across multiple LOB owners and attend to their concerns and provide best communication to resolve chronicle problems & get their applications working fast and without glitches and gain their trust
• Anticipate problems as they occur and prepare for it by troubleshooting scenarios and analyze different options to mitigate or prevent escalating the problem to the global audience
• Documented system builds and complying with release management, change management, configuration management, and quality assurance standards
• Experience in Oracle RAC on AIX and Linux environments
• Robust performance tuning skills with Oracle 10g, 11g & 11g RAC & 12c environments
• Experience in setting up and supporting HADR - Active and Physical Dataguard
• Experience in problem analysis, determination and root cause analysis
• Proficiency in setting up backup and recovery strategies
• Utilize system monitoring tools & in-house monitoring scripts to perform database performance, analysis and tuning
• Experience with Unix scripting
• Sr. DBA in a 24x7 on-call global support environment & weekend support
• Solid grasp of advanced SQL query techniques in addition to experience with automating scripts
• Expertise with configuring, implementing and supporting high availability Oracle 11g RAC & 12c
• Expert in query, index and Database IO performance tuning
• Expert understanding of Database design principals
• DataGuard Broker configuration and Active DataGuard implementation & Configuration
• Ability to proactively identify, troubleshoot and resolve live database systems issues
• Ability to manage all database maintenance plan activities including backups, indexing, integrity and consistency checks
• Experience running and supporting large databases under high transaction rates
• Experience in managing Oracle DW on ASM environments in Oracle 10g and 11g
• Strong experience in SQL performance tuning in 10G & 11G environment for large databases (10 TB +)
• Extensive experience working with Star Schema and Materialized Views
• Design, deployed, implemented and migration SQL 2000 Reporting, Analysis, DTS/SSIS to SQL 2005/2008
• Installed the correct drivers to utilize SSIS and 2005 Report Servers
• Customize the newly converted OS (Windows bit Enterprise) to better integration with SQL 2005
• ODI/SSIS experience in Configured and tested the new Hardware’s to achieve best performance
• Performed Performance tuning utilizing SQLIOStress, SQL Server Profiler, index Tuning, Query plan, SAN configuration, Filegroups utilization, Clustering, Replication, Maintenance Strategist and disaster recovery
• Participated in interviewing new hire of JR DBA, and provide technical envision, guidance to DBA
• Developed Disaster Recover for production databases using Replication, Logshipping and Database mirroring
• Reestablished high availability database server, by fixing the broken Windows Cluster
• Monitored production databases performance/lock/warnings/errors and took corrective action
• Worked with minimal supervision and follow my manager and the Firm guide line of business conducts, and support the tactical and strategic goals of the Oracle/SQL team for the benefit of the Firm
• OEM Grid Control installation, configuration & Geneos Oracle support rman backup/restore/clone and recovery, DR recovery

Production DBA

Confidential

Responsibilities:

• Audited the company database applications for evaluation of optimum utilization, best practice, integrity and security.
• Repartition of the production IBM SAN from 2 drives to 8 drives for distributed db and tables to achieve optimum disk IO. I have also created Transaction Replication between segregated databases for Disaster Recovery
• Created Log-shipping and database mirroring, which spanned states
• RAC Installations and configuration (10g,11g & 11gR2) on AIX/Solaris/Linux, Rolling Patching, non RAC non ASM to RAC, ASM migrations Working in a fast-paced large environment, responsible for Oracle & SQL Level 3 support database applications to achieve optimum utilization, best practice, integrity and security
• Extensive Experience analyzing AWR, ASH & ADDM Reports to troubleshoot databases and application performance issues.
• I have been a member of the Hardware/Network committee that evaluate the purchase of Mass Storage machines (SAN) like (EMC, IBM, HP, Dell and other vendors) and server’s hardware, I’ve also evaluated the hardware through stress test.
• Configure SQL 2005 and converted SQL 2000. Installed the correct drivers to utilize SSIS and 2005 Report Servers.
• Customize the newly converted OS (Windows bit Enterprise) to better integration with SQL 2005
• Redesigned Oracle databases, hardware reconfiguration and code review for more than production 250 databases across 50 states and counties
• Develop and maintain standards of all data warehouse and ETL
• Transitioned the production legacy system (AS 400) to SQL 2005 and converted most data load from manual process to fully automated SSIS packages
• Configured and tested the new Hardware’s to achieve best performance utilizing SQLIOStress, SQL Server Profiler, index Tuning, Query plan, SAN configuration, Filegroups utilization, Clustering, Replication, Maintenance Strategist and disaster recovery
• Participated in interviewing new hire of JR DBA, and provide technical envision, guidance to DBA
• Developed Disaster Recover for production databases using Replication and Database mirroring
• Reestablished high availability database server, by fixing the broken Windows Cluster
• Monitored production databases performance/lock/warnings/errors and took corrective action.

Senior Production Database Administrator

Confidential

Responsibilities:

• Work closely with Network team to convert the database applications from SQL .
• Ensure compliance to all specifications and documents all data warehouse administration activities
• Reconfigured and optimized all SQL 2005 running on 32 bits running on 64 bit Windows 2003 Enterprise masking 32bits servers and SQL server 2000, to eliminate disk fill up. Stabilized production databases and increased durability and consistency
• Converted SQL 2000 DTS packages to SQL 2005 SSIS packages
• Built a production Transactional Replication with achieved latency of less than 3 Seconds in worse-case scenario
• Monitor Production databases and its replications for immediate recovery and kept uptime of almost 100%
• Redesigned/Automated the backup process into SQL 2005. Utilized Differential backup and Transaction logs to create almost up to the minute disaster recovery. Tested the nightly backups, by restoring it to Staging and Development database servers This process minimized the duration of the restore process and minimized disk space, and lowered the tape backup duration
• Created SQL server health Reports using Reporting Services and trouble shoot connection problems and rewrote some reports Utilizing Cube and aggregation; this saved paper space and produced more official looking reports.

Senior Oracle Production Database Administrator

Confidential

Responsibilities:

• Work closely with developers and sales team to Develop/test/deploy a newly developed SQL server Mobile replication for Confidential ’s 2000 in-the-filed sales executive. They can sync their PDA or tablet pc then to the Production server.
• Reconfigured and optimized all SQL 2005 running on 64bits and 32bits servers and SQL server 2000, to eliminate disk fill up.
• Stabilized production databases and increased durability and consistency
• Designed an upload data process with Informatica and SSIS, between SQL 2005 and Oracle 10. Eliminated locking while doing ETL by using shorter Transaction one long Transaction
• Enhanced the build process of Cube for the data warehousing to eliminate disk fill up and increase performance.
• Managed and Monitored more than 20 hydrogenise Production databases SQL Server 2005/2000/CE and Oracle for performance, job completion and security
• Collaborated and integrated heterogeneousness databases from different vendors and different version like, SQL 2000, SQL 2005, SQL CE, Oracle 8 and Oracle 10
• Redesigned/Automated the backup process. Utilized Differential backup and Transaction logs to create almost up to the minute disaster recovery. Tested the nightly backups, by restoring it to Staging and Development database servers. This process minimized the duration of the restore process and minimized disk space, and lowered the tape backup duration
• Provided SQL server 2005/2000/CE technical guidance/Support to Oracle database administrators.

Senior Production Administrator

Confidential

Responsibilities:

• Work closely with developers to tested/deployed newly released database’s service pack
• Reconfigured and optimized the SQL 2000 Server, to eliminate SQL server weekly crash.
• Stabilized production database and increased durability and consistency and enforced security
• Upload data from MS Access database to SQL Server 2000 and watch for inconsistency, duplication or Primary key violations
• Redesigned/Automated the backup process. Utilized Differential backup and Transaction logs
• Prepared test scenarios and generated test scripts for disaster recovery plans. In case of disaster, Production would flip to the backup system in less than 5 minutes
• Distributed Production in 2 databases into a frequently used data and archived data like Historical Withdraw, utilizing triggers to achieve distribution. This process saved more disk space and minimized the restore process and Disaster Recovery.

Oracle Production Database DBA/Performance Tuning Specialist

Confidential

Responsibilities:

• Redesigned modern design to all Production and Development databases for optimized performance, hardware reconfiguration and code review. Production database was proprietary third party database (Melon Financial/ Eagle Hedge Funds software).
• I have been head of the purchase committee for new hardware & software; this committee oversees and recommends the purchase of new SAN, 64-bit SQL Servers hardware
• Managed and supervised all BISYS Hedge Funds Corp. ’s SQL production databases, which spread over 4 continents, Europe (Ireland, Russia), North America (Columbus, Boston, New York, Florida), South America (Caribbean --Bermuda) and Asia (India)
• Managed the 24/7 monitoring of all Databases locking/Memory Performance/ Drive space/Schedule Jobs failure/ warnings/errors/ backup and restore operation and took corrective action to keep smooth running and high availability. Utilizing Blackberry, cell phone alert messages from SQL Server and remote access Laptop. Most databases were required for 100% uptime
• Expert in database design/architect/performance tuning, SQL Server Profiler, index Tuning, Query plan, SAN configuration, Filegroups utilization, Clustering, Replication, Maintenance Strategist
• Established track of every Stored Procedure execution within the databases, established base line test of Stored Procedures and maintained history of every Stored Procedure’s execution on the Production site, using native SQL Profiler trace files. Maintain history of tables growth daily
• Performed code review, stress test and approved modification of existing and new Stored Procedures code (T-SQL) of all Production and Developer databases. Established guideline and coded maintenance.

Oracle Production Database /Performance Tuning DBA

Confidential

Responsibilities:

• Member of the Hardware/Network committee that evaluated the purchase of 2 the new Dual Itanium chip servers, and SAN. The new Dual-Core Intel® Itanium® 2 processors would deliver more needed power than ever to our most demanding applications that runs the Emergency room admission, Medications and Lab and doctor offices. It has also accommodated the aggressive plan of migrations and acquisition to other hospitals with cost-effective Intel® technology-based servers.
• Worked closely with Microsoft & Oracle Consulting to configure and install the correct drivers to utilize many heterogeneous databases and applications the Itanium hardware
• RAC Installations and configuration (10g,11g & 11gR2) on AIX/Solaris/Linux, Rolling Patching, non RAC non ASM to RAC, ASM migrations Working in a fast paced large environment, responsible for Oracle & SQL Level 3 support database applications to achieve optimum utilization, best practice, integrity and security.
• Extensive Experience analyzing AWR, ASH & ADDM Reports to troubleshoot databases and application performance issues.
• Managed/Designed the conversion SQL 2000 sever to SQL 2005 and convert the databases to best utilize the new database technology. Customize new OS (Windows 2003 Enterprise) integration with SQL 2005
• Redesigned databases, hardware reconfiguration and code review, for 24/7, critical doctors/patient environment (doctor’s office, hospitals and emergency rooms) (admission, medical history, lab result, discharge of patients) with minimum downtime. Maintained 100% 24/7 uptime, by creating new process “Online Alternate Process”, which allow tables to be Rindexed while fully online without single timeout. This process truly combined Persistency and efficiency.
• Work with the new Hardware to achieve best performance utilizing SQL Server Profiler, index Tuning, Query plan, SAN configuration, Filegroups utilization, Clustering, Replication, Maintenance Strategist and disaster recovery. Expert in performance tuning, SQL Server Profiler, index Tuning, Query plan, SAN configuration, Filegroups utilization, Clustering, Replication, Maintenance Strategist
• Established new Web Trend, for every Stored Procedure execution within the databases, established base line test of Stored Procedures and maintained history of every Stored Procedure’s execution on the Production site, using Profiler trace files. Maintained Table growth chart to reflect the busiest duration or volume of acclimations. Performed code review, stress test and approved modification of existing and new SP code (T-SQL) of 8 DBA and Developers.