We provide IT Staff Augmentation Services!

Sr, Oracle, Sql Server Dba Consultant Resume

South, FloridA

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)

Hire Now