We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Houston, TX

SUMMARY:

  • Oracle Certified Professional O.C.P (11G/10g/9i/8i/8.0/7.3 DBA track)
  • 16 year experience in IT industry.
  • Over 10 years experience of ORACLE database administration.
  • ORACLE 7.3/8/8i/9i - 11iAppps/11g/12c on UNIX (HP-UX 11i, AIX 4.3, Solaris 5 .7) & SQLSERVER 2K.
  • ORACLE RAC, DATAGUARD, ASM, ORACLE GRID CONTROL, EXADATA& Enterprise Manager.
  • Multiple years experience on UNIX (AIX 4.3/Solaris 5.6/HP-UX-11i) platform.
  • Expert of tools Enterprise Manager, Backup/RMAN/Security Manager, Flashback, ADDM,AWR.
  • Experience in Performance Tuning of large databases, modeling/mapping, Physical/Logical Designing.
  • Expert in PL/SQL, SQL+, C, Confidential scripting, applying ORACLE patches.
  • Create database objects & database links and multiple database instances within an application.
  • Experience of Migrations / upgrades of ORACLE Databases from 9i to 10g & 10g to 11g & 12c.
  • Automating and scheduling regular Backups and performing critical complete & incomplete media Recoveries, deploying 10g/11g DATAGUARD and maintaining standby databases as large as several Tb.
  • Experience of deploying ICP database on top of ORACLE8I for E-COMMERCE and B2B exchanges.
  • Developing Entity Relationship Models for the development system life cycle.
  • Experience of Erwin, Discoverer, Designer Brbackup, Brrestore, SAPDBA, SQLDEVELOPER, TOAD.
  • Knowledge of SAP upgrade to 4.6c, SAP client export/Import, transports, kernel upgrades.
  • Installation/Upgradation of MATRIX 10.5 / WEBLOGIC 7.0.
  • Knowledge of E-business suite / Oracle Financials & its components CRM, SCM, HR, ERP, OTM, Order Management, Oracle Warehouse Management system.
  • Concepts of Oracle Fusion Middleware & it’s components (Oracle Weblogic Server, Oracle SOA, Oracle Http server, Oracle Web Cache, Oracle Fusion Governance, Risk, and Compliance(GRC),HCM,SCM.
  • Implement Database Objects and Files needed by Database Applications
  • SAP INSTALLATIONS (BW/EP/WAS/XI) on HP-UX 11i, SAP BASIS experience.
  • Planning and Performing Disaster Recoveries.
  • Supported 8 nodes RAC.
  • Flashback / Performed recoveries using FLASH RECOVERY AREA.
  • Monitoring tools DBMON/DBSPI.

TECHNICAL SKILLS:

4GL and Database Programming: ORACLE Database Administration (Enterprise Manager, Backup/Recovery Manager, Security Manager, Instance Manager, SQL*Plus, PL/SQL), ORACLE Developer 2000.

Operating Systems/Networking: UNIX, Windows 95, Novell NetWare, Windows NT

Languages: C, SQL, PL/SQL, FORTRAN.

PROFESSIONAL EXPERIENCE:

Senior Database Administrator

Confidential, HOUSTON, TX

Environment: Oracle 9i /10g/11G (Windows, AIX, Solaris), SQL, PL/SQL, SQLSERVER, RAC, OEM, RMAN, ASM, EXADATA, Dataguard / Standby databases, SAP BASIS, GRID CONTROL, FLASH RECOVERY AREA, (Thin Image Hitachi), ADDM,AWR, SUPPORT PACK,PLUGINS,TRASPORTS

Responsibilities:

  • Performed Disaster Recovery drills / Dataguard / Physical Standby databases.
  • Built & supported 8 nodes RAC (Voting Disk, OCR, Interconnect, Cache Fusion, SCAN Listener) & ASM.
  • Supported/Installed EXADATA databases / Partitioning, Streams, OEM 24 X 7 database support.
  • Performed critical recoveries using RMAN/FLASHBACK/THIN IMAGE, trained juniors.
  • Upgraded databases from 10g & 11g to 12c, upgraded ASM from 10x to 11x / tested 12c new parameters.
  • Kept databases SOX Audit compliance & applied CPU & PSU patches.
  • ITIL best practices / incident management & change management / documenting database strategies.
  • Tool evaluation, integration and support. Database growth / SQL tuning / AWR / ASH reports.
  • Developed and maintained database support documentation, resolved issues with Oracle support (SR’s).
  • Participate in logical and physical database design / performance and query tuning / Database refreshes.
  • Apply SAP (Support patch bundles), SAP support packs, plug ins, transports, brtools, brconnect.

Senior Database Administrator

Confidential, FORT WORTH, TX

Environment: Oracle 8i/9i/10g/11G (Windows, Linux, Solaris), SQL, PL/SQL, SQLSERVER, RAC, OEM, RMAN, ASM, LEGATO, Dataguard / Standby databases, SAP BASIS, GRID CONTROL, FLASH RECOVERY AREA, ADDM, AWR

Responsibilities:

  • Created & maintained Dataguard / Standby Environment & performed Disaster Recovery drills
  • Worked on migration of LIMS application, coordinated with the Application team, including architects.
  • Trained less experienced team members, performed critical recoveries.
  • Reviewed AWR reports, TKPROF & execution plans for PERFORMANCE & TUNING.
  • Upgraded databases from 9i to 10g & 11g to 12c.
  • Provided backup & recovery solutions using RMAN & FLASHBACK/BCV/SRDF/THIN IMAGE.
  • Maintained databases SOX Audit compliance & reviewed quarterly Audit reports.
  • Followed Change management process / Incident management process & ITIL best practices.
  • Database reorganization & SQL tuning.
  • Database monitoring solutions and assisted others in monitoring and proactively identifying issues.
  • Took ownership of complex database incidents & problems and provided resolutions in a timely manner.
  • SAP support packs / plugins / (SPB), BRTOOLS, BRCONNECT/ UMR export & import.

Senior Database Administrator

Confidential, Houston, TX

Environment: Oracle 8i/9i/10g/11G (Windows NT, UNIX SOLARIS 2.7, HP-UX-11i, 9ias), SQL, PL/SQL, SQLSERVER, RAC, OEM, RMAN, ASM, LEGATO, SRDF/VERITAS Dataguard / Standby databases, Flash Recovery Area, SAP R3 support.

Responsibilities:

  • Installed ORACLE 11g & upgraded from 10g to 11g.
  • Worked collaboratively with the Application team, including architects, developers and testers.
  • Contributed significant, new and innovative ideas to the team knowledge base.
  • Designed database environments and databases, supported ASM architecture.
  • Executed database and data recovery in RAC environment.
  • Managed database performance, capacity and availability in RAC environment.
  • Applied CPU & PSU patches, performed database reorganizations & rebuilding of indexes.
  • Reviewed statspack reports & execution plans for SQL tuning.
  • Performed critical recoveries using RMAN & FLASH RECOVERY AREA, BCV backups.
  • Participated in project technical reviews.
  • Developed and maintained database support documentation, opened cases with Oracle support.
  • Took ownership of complex database incidents and problems and provided resolutions in a timely manner.
  • Supported High Availability clustered environment.
  • Applied SAP support packs / Plugins, UMR export / import, BRTOOLS / BRCONNECT.

Database Specialist

Confidential

Environment: Oracle 8i/9i (Windows NT, UNIX SOLARIS 2.7, HP-UX-11i, 9ias), SQL, PL/SQL, SQLSERVER, LEGATO, RMAN, Netbackup, SAPR/3 4.X, SRDF/VERITAS, MATRIX/WEBLOGIC, SAP (BW/EP/WAS/XI/CRM).

Responsibilities:

  • Installation/Upgradation (to Oracle 8.1.7.4/ 9.2.0.5 64 bit) on SOLARIS/HP BOXES as required.
  • Upgradation of MATRIX from 9.0 to 10.5 along with cluster configuration of WEB LOGIC 7.0
  • SAP TRANSPORTS.
  • Responsible for applying Support Packages (SPAM) & PLUG IN’s (SAINT).
  • SAP INSTALLATIONS (BW/EP/WAS/XI).
  • Physical sizing&reorganization of the production databases ranging from (GB to Tb) using SAPDBA.
  • Cold/hotbackupscripting in ksh/csh and scheduling backups using RMAN/LEGATO/OMNIBACK.
  • Refreshing development databases from Production cutoffs.
  • Daily refresh of SAP reporting environment from Production.
  • Installation of Planview Application.
  • 24x7 support to critical databases, altering tablespaces, rollback segments, distributed database quires.
  • Supporting On call rotations, Participation in Disaster Recovery Rehearsals, refreshing procedures, fail over testing, cluster testing.

Senior Database Administrator

Confidential, Houston TX

Environment: Oracle 8i/9i (Windows NT, UNIX SOLARIS 2.7, HP-UX-11i, 9ias), SQL, PL/SQL, SQLSERVER, LEGATO, RMAN, Mystro, Bolt-on, SAPR/3 4.X, SRDF/VERITAS 9i Dataguard - Standby databases, Live-Reorganization (by Quest), CASE Tools.

Responsibilities:

  • Installation/Up gradation (to Oracle 8.1.7.4/ 9.2.0.7/10 g/11g 64bit) on SOLARIS/HP BOXES as required.
  • Upgradation of Oracle 9i databases to Oracle 10g.
  • Hyperion database upgrades from 10g to 11g.
  • Physical sizing&reorganization of the production databases ranging from (GB to Tb) using SAPDBA.
  • Cold/hot backup scripting in ksh/csh and scheduling backups using RMAN/LEGATO/OMNIBACK.
  • Refreshing development databases from Production cutoffs using EXPORT/IMPORT.
  • Reorganization/Reducing Fragmentation while keeping db online using Live Reorg tool by Quest.
  • Maintaining standby databases using Dataguard.
  • Using Business copy and SRDF technologies.
  • Responsible for critical database recoveries and performance & Tunning using Cost Based Optimization.
  • Creating and maintaining databases and schemas.
  • Creation of Snapshots and Materialized Views.
  • 24x7 support to critical databases, altering tablespaces, rollback segments, distributed database quires.
  • Installation of 9ias and its components (DISCOVERY MANAGER, WEBCACHE).
  • Supporting On call rotations, Participation in Disaster Recovery Rehearsals, refreshing procedures, fail over testing, cluster testing, ASM file systems, RAC, Oracle streams.
  • SAP client copies, UMR exports/imports, support packs, and plug INS.
  • Work close with SAP team to resolve Database/SAP related issues and early watch reports.

Database Administrator

Confidential

Environment: Oracle 8i (Windows NT, UNIX SOLARIS 2.7, OAS, JAVA SQL, PL/SQL, Developer 2000 (Forms 4.5, Reports 2.5), Dataware housing.

Responsibilities:

  • Installation and Configuration of ORACLE 8.1.6 (8i) instances on multiple SOLARIS BOXES (including pre- installation and post- installation steps, Configured LISTENER & TNS NAMES Net80)
  • Proper sizing of the production databases and schema designing using Erwin tool, designing ERD models, forward engineering, reverse engineering.
  • Writing both cold/hot backup scripts in ksh/csh and scheduling (full/incremental) backups using cron utility. (Upgraded databases from ORACLE 8.1.0 TO ORACLE 8.1.6).
  • Responsible for taking cutoffs for new releases from development database, maintaining version control consistency using PVCS tool, refreshing databases when required. Administering databases through out the system development cycle of the project i.e. from development to production.
  • Responsible for BATCH LOADS, DATA MIGRATIONS using SQL*LOADER.
  • Installation of ICP database on top of ORACLE8I to setup e-commerce environment for commerce1.
  • 24x7 support to critical recovery issues, altering tablespaces, rollback segments, distributed database quires.
  • Worked with the PARTITIONING, RMAN new features.

Hire Now