OBJECTIVE:

To join a prestigious organization as a Sr. Database / Application Administrator, and participate in the success and development of the company through the use of Information Technology and cutting - edge methodologies and practices.

CAREER PROFILE:

10+ years experience as an Oracle Database Administrator, 5+ Years Oracle application DBA, Also SQL Server (5 years).

PERSONAL SKILLS:

• Creative programming skills and problem analysis
• Fast learning
• High productivity
• Hard working
• Self management

TECHNICAL EXPERTISE:

• Oracle 12c, 11g,10g, 9i, 8i (10+ Years).
• Oracle 11gr2 upgrade, implement scan technology.
• 12c, 11g, 10G Grid control and Oracle RAC in Linux Redhat AS v.4
• Oracle streams, Oracle weblogic server 12c
• Oracle Resource Manager
• RMAN scripting
• Oracle RAC 10g and ASM, ASMFS
• SQL Server 7, 2000, 2005, 2008 (5 Years)
• Java, ASP and Dot Net frame work
• Tivoli TSM (4 year) & Backup exec (2 years).
• Unix AIX 5L (3 year),
• Sun Solaris 8, 9 and 10 (2 year).
• HP UX 11 (5 year)
• Sun fire 6800 and Sun SPARC HW.
• Oracle Fusion and Oracle data integrator.
• Install and configure RAC with four nodes.
• SQL Plus, PL SQL (4 Year).
• Oracle Enterprise Manager, Schema Manager, Security Manager (2.5 Year).
• Supporting DB2 and UDB (6 month)
• ITIL knowledge from the government contract, ITIL processes including Problem and Change Management, and Configuration and Release Management
• Windows SharePoint, Lotus Domino, IIS.
• PeopleSoft (2 year)
• Working Experience with SQL server versions 6.5,7.0,2000.
• MySQL Installation and Administration version 5.x
• Set-up cluster servers to provide high availability for customers, AA (Active-Active model), AP (Active passive model).

WORK EXPERIENCE:

Confidential, South Florida

Sr, Oracle, SQL Server DBA Consultant

Responsibilities:

• Work with the PS Admin team to upgrade the PS environment from people tools 8.5 to People tools 9.2. This involves move to a new powerful HW, reduce the clustering nodes from 3 to 2 “one node evicted”
• Upgrade Oracle Grid control from 11g to 12C
• Install Data Masking plug-in to satisfy audit requirements for non prod copies of production
• Build shell scripts to refresh 10 non prod databases nightly from prod backup
• Install and upgrade to Oracle 11gr2 upgrade, patch set 3.
• Work on a POC project for evaluating an enterprise backup strategy, some of the products involved on the POC (DDBoost, CommVault, Avamar etc…)
• Migrate ASM disk to bigger LUNs to reduce disk numbers on a disk group.
• Install quarterly PSU patches on all eligible systems
• Work with the ETL developers to fix performance issues in DWH system
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Worked with Star Schema, Cubes and Analytical services.

Confidential

Sr, Oracle, SQL Server DBA Consultant

Responsibilities:

• Install and upgrade to Oracle 11gr2 upgrade, patch set 3.
• Build 3 node RAC and implement SCAN technology, and DNS registration
• Most of our systems use ASM storage
• Install quarterly Oracle PSU patch
• Install and implement the production server on Linux platform
• Work with Development team to write SP, functions, packages that holds business rules
• Upgrade Grid Control 10.2 to Cloud control 12cR1.
• Install and configure Oracle physical stand by for 11gr2 for every production system
• Install and configure logical standby databases to allow for business reporting
• Build and configured ASMFS on RAC 11gr2 for non database files
• Implement Database custom monitoring scripts and block defection mechanism
• Work closely with ETL developers to enhance their ETL load by integrating stats and histogram statistics for better execution plan
• Implement database cashing for lookup tables
• Implement flash back on most databases for PeopleSoft bundle install
• Setup Grid control monitoring Template for different environments based on different thresholds. And setup alert mechanism for various each severities
• Implement a demo ODI work flow as an alternative to ETL work flow for bench marking
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Implementing stand by servers and Log shipping.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.

Confidential

Sr, Oracle, SQL Server DBA Consultant

Responsibilities:

• Upgrade Grid Control 10.2 to Cloud control 11cR2.
• Monitor Oracle and web logic servers using Oracle Cloud and setup rules to send alerts for 24/7 support.
• Experience in Data warehousing concepts such as dimensional modeling, Star Schema and snowflake schema, galaxy schema, Data marts, Dimensions and facts identification.
• Experience in writing the Technical Design Document
• Install and configure Oracle fusion and Oracle data integrator
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Develop data extracts from the data warehouse environment using ODI
• Creating schedulers in OBIEE using ibots.
• Performance tuning in OBIEE repository level and reporting level.
• Install and support Oracle web logic server 12c and 11g.
• Migrate 4 NUC databases across platforms from Solaris to AIX using RMAN
• Build and configured ASMFS on RAC 11gr2 for non database files
• Implement Database custom monitoring scripts and block defection mechanism
• Experience in development of Data Warehousing and Business intelligence solutions.
• Experience on Oracle Warehouse Builder 11g R2
• Experience in Oracle Discoverer (Administration, Desktop)
• Having good knowledge on data modeling tool (Erwin).
• Excellent problem solving skills with strong technical knowledge, good communication, and interpersonal skills.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Worked with developers to tune the SQL queries using SQL Profiler.
• Worked with Star Schema, Cubes and Analytical services.
• Provided 7 x 24 Production support for the database and application issues.
• Knowledge of Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations

Confidential

Sr, Oracle SQL Server DBA Consultant

Responsibilities:

• Oracle 11gr2 upgrade, implement scan technology in 3 node RAC.
• Implement IPMP Oracle 11gr2 patches.
• Debug node eject from the cluster and implement Oracle patch to fix the eject problem on SunOS version 10. ASM does not have this issue.
• Install and implement Oracle GRID, Oracle physical stand by for 11gr2
• Install and implement Oracle Net-backup module for Oracle to backup ASM FRA backups to tape
• Write shell scripts to check backup log files and send severity 1,2 and 3 alerts.
• Install and configure Oracle SCM/ERP
• Tune and configure large SGA configuration ‘18GIG SGA size’
• Build 2 RAC clusters two node each with data guard configuration for DR
• Installed and configured 2 node ASM RAC.
• Build and configured ASMFS on RAC 11gr2 for non database files
• Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 20005.
• Good experience with SQL Server 2005 online Indexing and Recoveries features.
• Experience in migrating packages from DTS to SSIS
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Effectively configured MySQL Replication as part of HA solution
• Write shell scripts to check backup log files and send severity 1,2 and 3 alerts.
• Write stored procedures, packages, functions for some business reports and dash board.
• Wrote web based application using Java and ASP with SQL server engine. The app is for medical research.
• Implement OS authentication for ETL tools.
• Develop data extracts from the data warehouse environment using ODI
• Experience in Data warehousing concepts such as dimensional modeling, Star Schema and snowflake schema, galaxy schema, Data marts, Dimensions and facts identification.
• Experience in writing the Technical Design Document
• Tune and configure large SGA configuration ‘18GIG SGA size’
• Build and configured GRID Control server and monitoring template
• Build and configured data guard and perform switch over test
• Implement RMAN backup scripts to DISK and tape
• Setup SQL Server mirroring and cluster service for SQL Server 2005
• Migrate databases from SQL server 2000 and 2005 to 2008
• We used ER-Win to create data Model for our WH database, different process follows as well as gather reporting requirements

Confidential

Sr, Oracle, SQL Server DBA

Responsibilities:

• Oracle 11gr2 upgrade, implement scan technology.
• Design and implement RAC ASM database, physical and logical dataguard system for OLTP database.
• Implement and design failover and switch over systems
• Implement and design flashback system on a physical dataguard database to accommodate business reporting needs
• Implement and tune large OLTP application with a reporting component to it using RAC and streams.
• Upgrade Oracle 10g RAC to 11g release 1 RAC
• Install and implement resource manager in SAP, PS and Clarify database
• Install and implement table cashing mechanism ‘keep pool’ on Clarify
• Adjust Kernel parameters to accommodate large SGA (18GIG).
• Tune and configure large SGA configuration ‘18GIG SGA size’
• Configure RMAN repository for Clarify and SAP system.
• Install and upgrade 10g to 11g database
• Write and impalement PL/SQL procedure to create and split partitions on the fly before batch processing in DWH system
• We used ER-Win to create data Model for our WH database, different process follows as well as gather reporting requirements
• Migrate PeopleSoft database from UDB to Oracle
• We used ER-Win to create data Model for our WH database, different process follows as well as gather reporting requirements
• Involved in installation and configuration of SQL server 2000.
• Applied patches and service packs to keep the database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
• Designed and implement database logical and physical Schemas using Erwin 3.5.2./4.0
• Created DTS packages to maintain central repository. Extensively used different SQL2000 DTS tasks.

Confidential

Sr, Oracle DBA Consultant

Responsibilities:

• Install and Configure Oracle RAC in two to four node RAC system using ASM and CRS.
• Install and Implement RMAN backup scripts to backup recovery area FRA to tape and set conditions to run right after backups.
• Install the configure Oracle streams to move data across systems for business reporting
• Install and configure RMAN to backup the RAC system and refresh the reporting system every night
• Install and configure Grid Control to monitor RAC systems and setup and alerts and thresholds.
• Configure grid Control to send alerts to BMC Patrol and open remedy tickets to be assigned to the appropriate group.
• Create and Configure Oracle DataGuard for the SAP RAC system.
• Design and implement Migration strategy scripts to move data from Plano TX to Toronto.
• Install and Configure BMC patrol to monitor databases and send alerts based on pre-set thresholds.
• Adjust Kernel parameters to accommodate large SGA (12GIG).
• General maintenance tasks (i.e. rebalance ASM disk after loads, resize tablespaces, etc….)
• Configure Load Balance advisory goals based on transaction types

Confidential

Sr, Oracle DBA

Responsibilities:

• Install and upgrade Oracle on main client management system “Clarify” from Oracle version 8.0.6 to 10.2.0.2.
• Build and design UNIX server’s layout in accordance to OFA.
• Migrate backup systems from SQLBACK tracks to RMAN central repository.
• Build a home grown UNIX tool “RMF” (RMAN management facility) to backup any oracle database (8, 8i, 9i,10g) based on a parameter file that has all the client requirements
• Backup destination (disk or NetBackup)
• Number of generations
• Archive destination check frequency
• Archive log threshold
• Rman resync frequency
• Catalog location(s).
• Design and test DRP strategy for major systems using EMC SRDF technology.
• Design and implement Oracle security measures to insure secure DB links.
• Design and implement central Oracle stats-pack gather tool for all major systems.
• Design and implement resource management scripts to limit the DB resources for some reporting tools and adhoc users.
• Develop / implement Archive backup and recover methodology, maintain archived data on tape / backup devices.
• Backup and restore the database, develop, test & perform disaster recovery plans.
• Design and develop RMAN NetBackup scripts.
• Setup and design a standby database using 8i “managed recovery” and Logical standby database via Data Guard.
• Adjust Kernel parameters to accommodate large SGA (12GIG).
• Install and Configure Oracle 9i RAC in Linux Red-Hat for a financial document repository application. Also, install and configure RMAN to backup this RAC environment.
• Install and Configure Oracle streams for business reporting.
• Implement table cashing jobs to improve database and application performance (Keep pool), and adjust necessary latches.
• Implement Oracle Resource Manager to prioritize database resources across multiple interfaces.

Confidential

Sr, Oracle / SQL Server DBA

Responsibilities:

• Install and upgrade Oracle financial from Oracle 7.3.3 to 8.1.7 to 9.2.0 application level 11i
• Financial Data Repository, Payment Inquiry Application, as well as Oracle forms and Reports
• Database physical and logical design for a DWH .system.
• Build and design Central RMAN database for the TD systems.
• Install the configuring OEM for 24 *7 monitoring for all databases.
• Configure SMTP and paging services for OEM.
• Develop / implement Archive backup and recover methodology, maintain archived data on tape / backup devices.
• Develop RMAN repository database to backing up 16 different instances with three types of catalogs (8.0.6, 8.1.7 and 9.2.0) catalogs.
• Design and develop RMAN Tivoli backup scripts.
• Install and configure TSM client.
• Setup and design a standby database using 8i “managed recovery” and Logical standby database via Data Guard.
• Adjust some Kernel parameters to accommodate large SGA size (ex: SHMMAX, vxio:vol maxio, maxphys)
• Install STATSPACK and analyze output reports for performance enhancement.
• Deal with Oracle data block corruption and monitor block corruption with STATSPACK.
• Negotiate Oracle license with Oracle Corporation sales rep. for different Bank platforms (Production, user acceptance test, development and disaster recovery).
• Install and configure RAC, AIX HACMP/ES for capstone HA servers
• Install and configure Database redo logs in raw devices for high performance.
• Database average size 200GIG to 1.5 Tera-bytes.
• Install and configure 10g in Linux machine for a POC.
• Install and configure SQL Server 7 and 2000 Server.
• Manage SQL Server security profiles.
• Implement and configure SQL Server log shipping.
• Implement and configure SQL Server transactional replication.
• Performance tuning SQL statement for SQL server DB(s)
• Implement and maintained log shipping for SQL Server DR solutions.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on Linux (5.0, 5.1)