We provide IT Staff Augmentation Services!

Lead Dba Resume

New, JerseY

SUMMARY

  • 12 years of IT experience in which 9 years of DBA experience includes (Oracle 12c, 11g, 10g 9i and SQL SERVER DBA 2012 and Postgres DBA) in SAP, Banking, Pharma, Insurance and FMCG domain.
  • 3 years experience in SAP platform for oracledatabase using Brtools for backup, brachive, rebuilding indexes and other support for databases on SAP.
  • Experience in Oracle Installation, Oracle Upgrade, Cross platform Migration, Database configuration and Administration, Backup and Recovery, Tuning, Stand by database/data guard setup, and troubleshooting of various Oracle Products/versions on different platforms covering Redhat Linux, HP - Server and Sun Solaris.
  • Experience in DBA Lead- Poject Lead for various Technical Projects on SAP Platform
  • Familiar wif ITIL Processes - Incident Management,Change Management etc
  • Security Compliance Experience
  • Experience in Performance Tuning using AWR and ADDM.
  • Oracle Enterprise Manager
  • Experience in performing database upgrades from 11g to 12c, 10g to 11g and applying latest patches & releases.
  • 11g features like Data pump, Flash-Back Recovery & Recycle Bin.
  • Oracle 11g, 10g Installation, Configuration and Creation of Oracle databases.
  • Experience in Oracle DR - Standby database creation
  • Experience in Oracle Data Guard (11g) configuration & management
  • Experience in RMAN backup design and implementation
  • Managing Database Structures, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges and Database Auditing.
  • Database design including creations, modification, and deletions of table spaces, data-files, rollback segments and schema's, Create Schema (Tables, Indexes, views, sequences, synonyms, roles, and users).
  • Administer Microsoft SQL 2005, 2008 and 2012 database environments
  • Experience on Always on database administration
  • Windows patching in cluster environment
  • Familiar in Oracle Data Warehouse environment.
  • Unix Shell Scripting for automating teh DBA tasks
  • Experience in implementation of OEM tools for database administration and monitoring.
  • Hands on experience in oracle 10gFLASHBACK to provide fast and easy recovery at database, table, row and transaction level.
  • Knowledge of asset, Incident and change management software BMC remedy.
  • Hands-on experiences in Oracle 11G enhance features such as Flashback Data Archive, RMAN Data Recovery Advisor, and 11g DATAPUMP.
  • Installation of SQL Server 2005,2008 & 2012 in cluster and non-cluster environment
  • Oracle Enterprise Manager (OEM) for configuration and monitoring multiple instances.
  • 10gFLASHBACK to provide fast and easy recovery at database, table, row and transaction level.
  • Oracle 9i Certified Professional OCP-DBA
  • Oracle Golden gate noledge

TECHNICAL SKILLS

Operating systems: Sun Solaris-8,9,10, HP - UX 10.x/11i, Redhat Linux, AIX, Windows

Databases: Oracle 12c/11g/10g/9i, MS Sql server 2000,2012

Case Tools: Sql * Loader, OEM, Toad, Golden Gate, PL SQL Developer

Hardware: HP-UX, Intel PC, Sun Ultra Sparc, IBM - AIX

Tools: & Utilities: SAP BRTOOLSExport/Import, Sql * loader, Server manager, OEM, Sql*net, quest toad, RMAN, RAC 11g, DGMGRL SRVCTL, CRSCTL, AWR, top, sar, tkprof, strace

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Lead DBA

Responsibilities:

  • Database upgrade from 11.2g to 12c
  • Database refresh from prod to UAT, ST and other environments
  • Database monitoring for space management, growth and archive logs
  • Deployments for applications break fix, new build/releases
  • Implementing DCRs
  • Resolving alerts
  • Managing application - creating users, granting privileges.
  • Consulting to Application team for issues, database design, implementing new features..

Confidential, Rochester, MI

Lead DBA

Responsibilities:

  • Maintaining existing 11.2.0.3 databases
  • Managing Security Compliance - at database, user, and data level by granting appropriate privileges to user, data dictionaries, creating roles, data masking and encryption.
  • Setting up password policies and managing teh user profiles.
  • Familiar wif database valut
  • Backup and restore as per requirement
  • Support to development team
  • Performance of SQL queries
  • Designing of new schemas in BI environment

Confidential, MN

Lead DBA

Responsibilities:

  • Design and architecting teh backup policies using BRBACKUP, BRARCHIVE
  • Integration of RMAN using Brtools
  • Testing all backup/restore scenario.
  • Training to teh team for RMAN usage on SAP
  • Writing RMAN scripts for automation of jobs.
  • Flashback Implementation.

Confidential

Oracle DBA - Lead

Responsibilities:

  • Define strategies
  • Planning
  • Execution
  • Documentation
  • Risk analysis
  • Post upgrade Issues Resolution
  • Coordination wif Oracle support and SAP support for any issues or help.

Confidential

Team Member

Responsibilities:

  • Creation of standby database using rman
  • Configuration of data guard - setup
  • Testing of standby database
  • Documention
  • Training

Confidential

Team member

Responsibilities:

  • Installation of Grid Infrastructure
  • Oracle Installation
  • PSU Patching on RAC systems
  • Database Creation
  • OEM Configuration

Confidential

Lead DBA

Responsibilties:

  • Managing Security & Compliance - at database, user, and data level by granting appropriate privileges to user, data dictionaries, creating roles, data masking and encryption.
  • Setting up password policies and managing teh user profiles.
  • Existing system study for performance issues
  • Monitoring Performance for specific reports using AWR and DBMS advisors
  • Debugging slow running jobs and suggesting performance improvement creating/rebuilding proper index
  • Regular server monitoring using top, sar,iostat
  • SQL query tuning using hints, advisors, execution plans and wait events.
  • Presentation on Performance to developers community

Hire Now