We provide IT Staff Augmentation Services!

Principal Dba/dba Manager Resume Profile

3.00/5 (Submit Your Rating)

TX

Summary:

  • 18 years of experience in the IT industry.
  • 16 years of Production Oracle DBA/Internet DBA experience, versions 7.x/8i /9i/10g/11g/12c on Sun Solaris , HP, Linux and Windows 2008
  • 8 years of Project tech lead experience and providing guidance to DBA team members
  • Install/configure Oracle 10gR2/11gR2 RAC in sun Solaris/Linux environment
  • 6 years of 10g R2/11gR2 RAC experience using ASM technology
  • Upgrade experience from Oracle 9i/10g to Oracle 11gR2 in Linux, Solaris and Windows
  • Strong RMAN experience using with/with out catalog database
  • Strong understanding oracle architecture and database engine
  • DB tuning using AWR and ADDM reports
  • 6 years of Oracle Financials 11i/R12 DBA on SUN , HP and Windows 2000 platforms
  • Implementing 11g Grid Control Solution across all Oracle databases 11g/10g/9i
  • skills in upgrade/patching and cloning activities of Oracle Applications
  • 10 years of experience in EMC Legato Networker module
  • Expertise skills on AD utilities , printer configuration and concurrent manager processing
  • Experience in Oracle portal/OBIEE and Fusion Middleware
  • 8 Years of Experience in managing SQL Server 7.0/2000/2005/2008 databases
  • Expert in supporting complete development and production cycles in OLTP and DSS environments.
  • Implementation and maintenance of Databases utilizing Replication and Standby techniques.
  • Presentation and implementation of DR and HA strategies for large corporate clients.
  • Implemented DR and HA solutions with VCS, VVR, BCV, SRDF and other products.
  • Installed/configured Disaster Recovery Solution using Oracle 10g Data Guard across Data centers
  • 24X7 On-call support for Oracle, Sql Server and mysql databases
  • Sun/HP Unix Administration activities with hands on experience
  • Experience in Data Warehousing Projects and familiarity with ETL tools
  • Strong skills in PL/SQL programming, procedures, functions, packages and triggers
  • Scripting skills in Korn shell, Csh shell and Perl
  • Database Design and Implementation with Oracle and 3rd party tools
  • Work closely with sysadmins, developers and Project mgmt teams
  • Executive briefing and management updates.
  • Status meetings with clients/end users on weekly basis
  • Good communication, and excellent presentation, leadership and mentoring skills
  • Excellent team player and can work independently
  • Monitoring Databases and Setting Standards
  • Incident management and Change Management policies

Skill Set

Database

Oracle

  • Versions 7..x , 8i and 9i /10g/11g RDBMS Server.
  • Installation, design and maintenance of OLTP and DSS environments.
  • Installation, configuration and Administration of Real Application Clusters RAC in Oracle10R2 10.2.0.3
  • Redundancy and High Availability including Data Guard and Advanced Replication - Multimaster and Snapshot Replication.
  • Tuning Oracle databases based on application requirements.
  • DR Planning and implementation using Advanced Replication, Standby, VVR, SRDF, HDS and other technologies.
  • Disaster Recovery using online backups, logical backups and RMAN.
  • Migration from Oracle 9i/10g to 10g/11gR2 , Oracle 11g R2, RAC
  • Data Guard
  • Dedicated Servers, MTS, Connection Manager, Sql loader, exp/imp, Oracle Partitioning and replication, ASM
  • 10g Oracle Enterprise Manager Grid Control
  • Database schema design and application development support and troubleshooting.
  • BMC knowledge module for Oracle
  • Oracle Portal , OBIEE and Fusion Middleware
Oracle Financials
  • Installed/configured Oracle Applications 11i
  • upgrade of Oracle E-business suite 11i to R12
  • Worked as Oracle Financials System Administrator on 11i/R12 .
  • upgrades, patching and cloning activities

SQL Server

  • Versions 7.0/2000/2005/2008
  • Upgrade experience from 2000/2005 to 2005/2008
  • Creation, backup, restore and monitoring of SQL databases
  • Database schema design and application development support and troubleshooting
  • Applying service packs on routine basis
  • SSIS and Reporting services
MYSQL
  • Installation and configuration of MySQL on windows, Linux/solaris
  • Backup/restore and daily maintenance activities

Install/configure MySQL 5.0/5.1

Operating systems

  • Solaris 8/9/10, HP, AIX, Redhat Linux , os/390,Windows NT/2000/2008

High Availability

Products

  • Veritas Cluster Server, Veritas Volume Replicator, Veritas Quick I/O, HP ServiceGuard EMC BCV/SRDF, Clarion Storage Array, Legato Cluster Server, Shareplex

Others

  • PL/SQL, XML, Java 2, EJB, Shell and Perl scripting
  • Internet architecture, firewalls, web servers.
  • VB 6, Websphere, BEA Weblogic, Cold Fusion, Oracle Application Server
  • JDBC, ODBC, OCI drivers, Quest TOAD..
  • TCP/IP, HTTP, FTP, SSH, SSL
  • Project management including estimation of time and resource required for projects.
  • Train and mentor junior DBAs and make presentation on new strategies and implementations to peers
  • Interviewing, mentoring and training of new DBAs

Work Experience

Confidential

Title: Principal DBA/DBA Manager

  • Supporting Oracle10g/11g, SQL server 2005/2008 databases
  • Upgrade of Oracle instances to higher version from 10g to 11g
  • Install/configuration of Oracle 11g R2 RAC on Linux servers using ASM technology
  • Maintaining the database in 2-node RAC cluster
  • Install/Configure 11g R2 Grid control solution to make a central control of all 10g/9i databases
  • Managing several Database related projects
  • Creating/managing 10g RMAN catalog database and performing online backups using EMC Networker modules
  • Setting up Oracle 11gR2 Data Guard replication across data centers
  • Set up Golden Gate replication from one version of Oracle to another version of oracle
  • Lead role in Data Center consolidation project
  • Guiding/Supporting DBA team members
  • Expertise in core DBA skills like , installation/backups/RAC/DR
  • Strategic design in setting up HA and DR databases across data centers

Confidential

Business: Publishing Title: Lead DBA/Project Manager

  • Supporting Oracle8i/9i/10g, SQL server 2000/2005 and mysql databases
  • Upgrade of Oracle instances to higher version from 9i/10g to 10g/11g
  • Managing Oracle Applications 11i/R12
  • Install/configuration of Oracle 10g R2 RAC on Sun servers using ASM technology
  • Maintaining the database in 2-node RAC cluster
  • Install/Configure 10g R2 Grid control solution to make a central control of all 10g/9i databases
  • Logical backup scripts using new 10g utilities expdp/impdp old version is exp/imp
  • Creating/managing 10g RMAN catalog database and performing online backups using EMC Networker modules
  • Setting up Materialized view replication used fast refresh and full refresh
  • Upgrading 9i/10 databases to 10g/11g environment
  • Played major role in Data Center consolidation project
  • 24/7 Production DBA support
  • Guiding/Supporting Development DB team
  • Maintaining automated tasks through autosys, cron and Windows scheduler
  • Unix/Linux Administration skills

Confidential

Title: Lead DBA consultant

  • Supporting Oracle8i/9i, SQL server 2000 and Sybase 12.0/12.5 databases
  • Migration of Oracle Databases from version 8i/9i to 10g
  • Implemented the Oracle Standby Replication across Data Centers
  • Oracle 9i Installations on New Projects in Sun Solaris and Windows Environment
  • Configuring the RMAN backups using Legato Media Management Software

Implemented Sybase HA solution using VCS in Sun Solaris environment

  • Using EMC SRDF for Disaster Recovery in DR site
  • Supporting WebLogic Applications in Production Environment
  • Using 3rd party tools DBArtisan centralized tool for Oracle/Sql/Sybase databases
  • Using Autosys Job Scheduler for nightly cycles
  • 24/7 support for the production databases pager rotation among the team members

Confidential

Title: Service Management Specialist

  • Member of a team of six senior DBAs working as the ultimate escalation point for all database issues.
  • Responsible for installation and maintenance of approximately 120 large to very large Oracle databases 10GB to 1TB plus on Solaris, HP-UX and Windows NT/2000 platforms and 3 DB2 UDB instances on Solaris platform.
  • Working closely with customers and assisting in day-to-day Oracle/DB2 database administration.
  • Migration of Oracle Databases from version 8i to 9i.
  • Team member in Managing Oracle Applications 11i in Sun Solaris environment
  • Studying customer's requirements and making recommendations for application and database design, capacity planning, HA and DR strategies.
  • Evaluation of new Oracle/DB2 related products, developed internally as well as off the shelf on different platforms.
  • Engineer packages for rapid deployment of database servers and work with the engineering team in specifying requirements and evaluating products.
  • Installation, patching and upgrade of Oracle RDBMS and DB2 UDB instances.
  • Creation of databases and integration with backup and monitoring systems.
  • Implementation and integration of RMAN and Legato backups and monitoring using shell scripts.
  • Recovery of database using RMAN and Legato when required.
  • Analyze customer's business needs, database tuning using utlbstat , utlestat and statspack utilities, explain plan and recommend database/application modifications and upgrades to customers.
  • Installation and maintenance of Oracle Context Server, Oracle Forms, Oracle Reports, Web DB.
  • Analysis and implementation of a sound high availability strategy for mission critical customers.
  • Develop shell and perl scripts and PL/SQL procedures as required for day to day database administration and support.
  • Tech Lead DBA for many of highly visible accounts.

Confidential

Title: Sr Database Administrator

  • Oracle RDBMS installation, Net8 and connection manager configuration.
  • Planning and executing migration from Oracle 7 to Oracle 8.
  • Data modeling and logical and physical designing of databases.
  • ORACLE Database Administration, including tuning, backup, recovery of more than 20 databases on
  • Oracle 7.3.4, 8.0.4, 8.0.5 on Solaris 2.5/2.7 and Windows NT in a production environment
  • Installation and configuration of OraPerl.

Confidential

Business: Banking

  • Installation and Administration of Oracle Applications 10.6 and 10.7 on HP 10.20.
  • Upgrade experience from 10.6 to 10.7 SC.
  • Maintaining the Oracle Application modules, creating users, responsibilities, work shifts, assigning user profiles and responsibilities, monitoring, registering printers, printer styles, managing the concurrent managers, creating Oracle user IDs and maintaining Oracle database objects.
  • Supporting and mentoring developers and troubleshooting development issues
  • Worked with Oracle Application tools, such as adaimgr, adrelink, adpatch.
  • Evaluation of newer version of Oracle application and presenting the migration path and capacity planning.

Confidential

Title: Sr Software Engineer

  • Designing a GUI based product with the functionalities of SQL DBA and a precursor of the modern OEM.
  • Creation, administration, tuning and maintenance of Oracle RDBMS database.
  • Designing and implementation of a financial package for banks that included investor registration, dividend calculation and share allotment
  • Designing and implementation of a material management and inventory system
  • Designing of reporting tools using SQL Report 3.0

Confidential

Title: Software Engineer

  • Designing and implementation of a stores accounting system involving inventory accounting, stock reports, status reports and replenishments requisitions.
  • Development and testing of a hospital information system that had the capabilities to maintain patient records for quick retrieval of patient's medical history, medical research and early warning system for infections and epidemics.
  • Designing and implementation of a financial accounting system for small businesses.

We'd love your feedback!