SUMMARY:

• Innovative - driven Database Administrator and Manager with over 16 years of IT experience specialized in problem-solving and mission-critical OLTP, OLAP and high availability landscapes.
• Responsible for database architecture, development, replication, upgrades, migrations, patching, backup and recovery. Proven successful managing dba teams. Delivered essential production support. Served in key roles assisting application development for database access, tuning, staging and testing. Demonstrated expertise serving in reporting and analytical systems roles. Strategic thinker with outstanding problem-solving skills. Outstanding verbal and written communication skills. Effective Team leader, manager, mentor and motivator proven capable of supporting technical needs of companies and the community.

EXPERTISE AREA:

• Database Administration
• Backup and recovery
• Database replication and Cloning
• Database Security and Trouble Shooting
• Analytical Thinking and Problem Solving
• Resource Allocation
• Staff Motivation, Leadership, Mentoring
• Management and Team Leadership Skills
• Creating Essential Procedures and Processes
• Linux/Unix Shell Scripting
• Database Architecture and Design
• Database Standby and Disaster Recovery
• Data Warehouse and ETL
• Database upgrades and Migrations

TECHNICAL SKILLS:

• Oracle Enterprise Server 12c through 8i
• SQL
• PL/SQL
• RAC
• DBMS
• Data Guard
• Partitioning
• Golden Gate replication
• Oracle Grid Control
• Oracle Wallet
• Oracle RCU
• Oracle RMAN
• Advanced Queuing
• Data Warehouse
• ETL
• Oracle text
• Solaris
• IBM AIX
• HP/UX
• Linux
• Unix shells
• Perl
• Apache
• Windows
• SQL Server
• MySQL
• Raven
• Cassandra
• Mongol
• Jira Confluence
• Clarity
• Clear Case
• Web Logic
• Legato
• VERITAS Netbackup
• Qwest
• Tableau Reporting
• EMC snapshots physical and logical design architecture data modeling data warehousing disaster recovery data replication and security.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• Established a working bridge with product owners to better understand their products and know how best to configure the database to meet and exceed expectation.
• Designed a process to upgrade, migrate and cleanup an old legacy oracle database to oracle 12c high availability database that has significantly improved performance by 30% and removed redundant data reducing the database size by 40%.
• Designed and created a process that is consolidating multiple oracle 11gr2 RAC One databases into a few oracle 12c RAC databases that has reduced the database footprint and in turn reduced license cost by 20%.
• Created a procedure for installing and configuring Oracle 12c Data Guard for Disaster recovery.
• Written procedural documentation for database installation, migration, upgrading, patching etc
• Streamlined the database cloning process from production environment into dev and test environments.
• Designed and Implemented a complex password policies enforced by the databases to increase database security against intrusion.
• Configure oracle 12c OEM cloud to alert on database issues
• Currently installed and configuring Oracle 13c OEM could
• Prepared and deployed multiple routine maintenance scripts shared by all database servers for backing up, schema exports, schema cloning, migration, diagnosing, data guard health check, etc.
• Supports Developers and Testers with database SQL developments.
• Assist with MYSQL administration in backing up, cloning, and general database administration.
• Work with oracle support on Oracle bugs encountered.
• Evaluating oracle golden gate if suitable as a part of the ETL process in populating oracle OLAP database.

Confidential

Lead Senior Database Administrator

Responsibilities:

• Made database and replication recommendations on industry best practices based on my findings.
• Designed a Migration plan that was used to move Oracle rdbms 10gr2 to 11gr2 with database clutter cleanup. This plan reduced the database down time, removed database cluster where performance improvement was achieved a 15% gain.
• In communicating with application administrators and owners I was able to establish performance metrics to meet the Contractual SLAs.
• Assisted application administrators to configure applications for high Availability access to the databases this enabled the applications to be more resilient.
• Evaluating the database setup came across a lot of inconsistency so I created a standardized Oracle database infrastructure that improved troubleshooting, database monitoring and performance monitoring.
• Designed a process for oracle database cross platform migration AIX/Solaris to Linux with upgrade that reduced application downtime, data integrity was maintained and performance improvement was gained.
• Established oracle RDBMS and Grid infrastructure Software clone repository to facilitate the setup of new Oracle RAC or expansion of existing Oracle RAC.
• Reconfigured rman backup and recovery strategy
• Making Golden gate highly available in oracle RAC
• Tuned Golden gate replication that improved throughput by 25%
• Reconfigured oracle 11Gr2 Data Guard to multiple location that increase recoverability should it ever happen.
• Formulate an approach to apply needed PSU patches to all oracle databases
• Designing a performance environment to mimic production environment
• Adding diagnostic tools to help pinpoint issues in the shortest possible time.
• Reconfigure RAC database for AQ
• Tune oracle database for oracle SOA application
• Evaluating oracle 12c and make recommendations if an Upgrade is needed
• Managed and assigned responsibilities to database administrators

Confidential

Lead Senior Database Administrator

Responsibilities:

• Created a quick install package for Installing Oracle 11gr2 RAC in a RHEL virtual environment on VMware for dev and testing. This process made it easy and quick to spin up a oracle RAC test environment in a couple of minutes rather than hours
• Created a standard process for Setting up and installing Oracle Data Guard and this allowed data guard systems to use a set of common tools and thus improved support effort tremendously.
• Redesigned a couple of oracle databases to support Bi-directional replication that was able to meet and exceed design expectation of making the application stable.
• Designed a model in conjunction with Unix/Linux system administrators for Dev and Staging lab VM environments with oracle 11gr1/gr2 that enabled multiple labs to be setup in the shortest possible time for developers and testers.
• Installed and configured Oracle Fusion Middleware Repository Creation Utility (RCU).
• Help establish Middleware oracle reports to Oracle RAC database via 11gr2 SCAN
• Configured Oracle Wallet with Verisign certificates in oracle RAC environment
• Providing Level 3 support to Production DBAs for On Call problems
• Researching database errors, and providing root cause analysis and executing problem resolutions
• Researching data replication errors, providing and executing problem resolution
• Working with multiple vendors (IBM, Open Text, Oracle etc.) on multiple concurrent projects.
• Backup/Restore, Cloning Oracle 11g RAC environment; Backup/Recovery, RMAN, Export/Import, flashback.
• Restart OID service and update records with service update
• Research into new database related technologies and provide tangible feed back
• Research, installed and configured NO SQL databases (e.g. Raven)
• Configured NO SQL database Raven with Bi-Directional Cross replication
• Designed, Installed and Configured OEM Grid control 12c that helped pinpoint problems
• Managed and Mentored Junior/Intermediate Database Administrators

Confidential

Engineer Level 4 (Sr. Database Administrator)

Responsibilities:

• Supported and maintained a scalable cluster of stand-alone oracle database currently (over 60 database)
• Supported and maintained a multitude of two - three node RAC database (about 10 RAC databases)
• Data guarded stand-alone and RAC databases.
• Golden Gate for replication is implemented on about 70% of the Oracle databases. Very complex and interesting configuration in support of availability requirements.
• There is creation, upgrading, migrating of numerous remote Oracle Data-Guards, some configured with Fast-Start fail-over in both 10g/11g as well as stand-alone and RAC databases.
• Automatic storage management on SAN storage is used for Database storage management.
• Installation of Oracle RDBMS software, software patches, security patches, evaluation of new Oracle database functionality, hardware and sending feedback to developers on system performance to help improve design, SQL and PL/SQL coding.
• MySQL databases are installed and configured with replication. (about 70)
• Support development, test, load, integration efforts. Installed and configured Grid Control 10g and upgraded to 11g in production, including developing monitoring and alert strategies. Standardize company-wide Oracle platforms on commonly accepted best practices.
• Grid Control and custom shell scripts are used for analytic and trend reporting to identify potential issues.
• Part of a team that was on a weekly 24X7 On Call rotational schedule to support Production issues
• Performed other duties as assigned.

Confidential

Senior Database Administrator

Responsibilities:

• In support of availability requirements, creation of numerous remote and local Oracle Data-Guards, some configured with Fast-Start fail-over in 10g /11g as well as single instance and RAC databases. Database storage management using both named files and Automatic Storage Management on SAN/NAS array for RAC and NFS mounts for a few single instances.
• Installation of Oracle RDBMS software, software patches, evaluation of new Oracle database functionality, third party tools and hardware, and educating developers on improving SQL and PL/SQL to reflect best practices. Use of Qwest Spotlight and Grid analytic and trend reporting to identify potential issues, perform migration of 9i RAC to 10g and 11g RAC. Provide mentoring and cross-training in critical systems.
• Installed and administered MicroStratey as one of the ETL tool for Dataware house reporting.
• Supported development, test, load, integration and partner-test supporting database instances. Conduct quarterly tests of RMAN backups to ensure SLA compliance for disaster recovery.
• Install and configure Grid Control 10g and upgrade to 11g in production, including developing monitoring and alert strategies. Standardize company-wide Oracle platforms on commonly accepted practices.
• Most recently configured Oracle and MS SQL Server in Amazon Cloud to support a new product that was beta testing. Began automation of a labor-intensive weekly job to load music content.
• Being a multinational organization with offices in the US, Spain, UK, Turkey, Germany, Austria, South Korea, India, China and Australia, I was part of the global team that supported all Oracle databases in these locations via VPN and consequently worked outside normal working hours.
• Part of a team that was on a weekly 24X7 On Call rotational schedule to support Production issues
• Installed and Configured OEM Grid Control 10g
• Performed other duties as assigned.
• Mentored Junior DBAs

Confidential

Senior Oracle DBA

Responsibilities:

• Responsible for database availability, gathering trend analysis, database performance statistics on weekly and monthly intervals and providing feedback to the relevant test and development teams. This trend analysis was used to identify issues and tune the database. Maintained the ETL source process populating the data warehouse with transaction data on a continuous basis.
• Worked with the test team to prepare functional and performance test strategies and indicators; worked with developers in writing efficient database SQL and PLSQL code to make use of Oracle's best practices without compromising accuracy. Oracle Designer was used to maintain database code.
• Maintained database access security, networking all the database servers into respective departments using Oracle Name Server. Applied necessary Oracle upgrades and patches as needed. Established backup and recovery strategies guidelines. Installed and maintained Legato suite for backups to the Oracle database and UNIX file system.
• Evaluated new Unix hardware, documented findings and recommendations, including evaluation of Oracle 10g. Installed Oracle, Apache and Weblogic on Sun Unix, Linux and Windows 2000 servers and Oracle clients on developers’ desktops.
• Mentored and trained 6 Junior DBAs
• Managed the DBA team for last 13 months prior to leaving

Confidential

Oracle Database Administrator

Responsibilities:

• Data warehouse tasks included identifying all the subject areas fields of interest and their respective dimensions for analytic reporting defined by the business. Created transitional schema for reporting database with links to a transactional databases schema; populated by a batch ETL process. Additionally set up materialized views, evaluated ad-hoc reporting tools, set up parallel processing with Micro Strategy 7 for report generation.
• On the team responsible for creating logical entity relationship diagrams using Erwin and Designer for the organization’s business data warehouse and its supporting data sources of transactional databases.
• Installed Oracle server and clients on various platforms including Sun, UNIX, Red hat LINUX and NT.
• Responsible for access security and networking all database servers into a distributed architecture to support the business model.

Confidential

Database Administration

Responsibilities:

• Provided application support, coding, testing and administration; projects included developing front-end and back-end application for a two-tier client server system and systems architecture design; performed installations, upgrades and migrations; redesigned file-based data storage into relational database on Oracle 7.3.4; later migrated to Oracle 8.0.4.
• Project tasks included requirement gathering, plan growth and changes (capacity planning), schema creation, performance analysis, troubleshooting, database performance tuning, and exports/imports; stabilized
• Production databases and performed hot backups on production databases running continuously; created presentations for end-user community.