Sr.sql Dba Resume
SUMMARY
- Twenty - two (22+) years of Oracle DBA experience in analysis, design, monitoring, performance tuning, upgrade, & backup / recovery with Oracle ODA, RMAN, OS LVM, PL/SQL, Oracle OEM grid/db Cntrl, TOAD, IBM DB2, Tivoli, & Oracle 13c, 12c, 11g/10g, 9i/8i, on Win7, Win10, RHEL-LINUX, Solaris, AIX, & HP-UX Unix platforms,servers.
- Eight years in setup, install, & maint. of clustered environments. 12cR2, 11gR2/10gR2, LINUX/UNIX (RAC) instances/platforms.
- 10+ yrs. experience supporting Oracle 11g as a DBA with 4 yrs. on 12c & 14 + years’ experience on Oracle 10g RDBMS.
- Over 22 + years’ experience as an Oracle Core Production/QA/Application DBA.
- Proficient in large RDBMS Administration, Installation, Performance Tuning, & Security Data Management.
- Primary Support for 46 RAC instances on 2-Node ODA(Oracle Database Appliance) HA cluster environment.
- Strong Backup & Recovery, Replication w/DataGuard / Standby database support using RMAN.
- Proficient in UNIX korn/bash shell scripts & updating cron jobs for job scheduler & automated tasks.
- Performed Data Migration & Data Integration of Oracle 11g, 10g/ 9i, Migrations, Upgrades, and Conversions.
- Eight+ years’ experience in SQL Server 2016, 2012,2008r2, 2005, SSMA,SSIS, & SS Management Studio, Support DBA.
- Excellent knowledge & understanding of DataGuard, Oracle 11gR2 RAC, 10gRAC (VERITAS & Oracle Clusterware), Golden Gate advanced replication.
- Proficient in SQL, PL/SQL, Oracle OEM utilities, ODA Database Appliance, DBA tools, etc.
- Efficient in deployments of database features available in specific Oracle versions 8i, 9i, 10gR2 & 11gR2.
- Experienced working with Data Warehouse & OLTP Multi-Terabyte db’s in QA /Prod UNIX environments.
- Created 11gR2 OLTP databases on Linux /UNIX servers, supported all dev, test & prod environments.
- Mentored 5 junior DBA’s to help mentor their development /progress to becoming Mid-Level or Sr. DBA(s).
SUMMARY OF COMPUTER SKILLS/Tools:
LANGUAGES: PL/SQL, PERL, JAVA, C++, C#, SQL
Databases: Oracle, SQL Server 2005/2008, Sybase, DB/2, MySQL 5.0
Operating Systems: UNIX (HP, Solaris, AIX), RH Linux, SAP, Win NT, 2K, XP/2K3, Win7
Database Tools: Oracle OEM Grid Control, RMAN, SQLDEV, TOAD, VERITAS, DB Artisan, SQLPLUS, Quest-TOAD, FogLight. SharePlex, Oracle Streams, Golden Gate
Data Design Tools: CA /ERWIN, TOAD, DB Artisan, SQL Navigator, SQL Developer
Front End Tools: Informatica, WebLogic, Websphere and SQLDev
HARDWARE: HP-9000, IBM 3650, Sun Sparc Sun-Fire 15k, COMPAQ Prolinia, Compaq, ES40, DELL R710, SUN Enterprise ULTRA 5S/10S.
Other: UltraEdit, Remedy, IBM-Tivoli, DynaTrace, VMWare /CHP, SAP ECC 6.0
PROFESSIONAL EXPERIENCE
Confidential
Sr.SQL DBA
Responsibilities:
- Used DBCC-CheckTable,,DBCC Table Repair--Transact SQL Replication commands for SQL 2014,2016
- Experience using MSSQL SSIS, SSRS packages for cross platform migrations lie Oracle to MS Sql Server2012.
- Created new ODA Oracle 12cR2, 12cR1, 11gR2 databases from older 11gR1 & 10gR2 databases.
- Performed expdp/impdp from OS putty /Xshell command line for many lower env. Db’s from Prod export dump file.
- Created new databases on ODA Database Appliance with oakcli command(s). oakcli create database -db TRCRGODB -oh OraDb12102 home1 -params TRNCRGODB. (iCARGO)
- Startup/shutdown physical/virtual database for OS patching CM’s on Prod, Perf, UAT, QA, Test/Stage environments.
- Perform root-cause analysis using AWR/ASH Reports to identify indexes needing dropped recreated and updates to table to improve sql queries for MSSQL Oracle single instances.
- Experience on Amazon Web Service (AWS DMS) DB migration Service to create virtual Linux (6.7) db instances to replace older physical db instances.
- Experience with DBCA (DB Config Assist) for upgrades - reduce downtime of Linux/Solaris Oracle db instances.
- Created new 12cR2 databases for Oracle Database Appliance (ODA) 2 node cluster environment using oakcli command line, create db commands. (/opt/oracle/oak/bin/oakcli)
- Providing db instance support using srvctl cli commands to monitor status, startup/stop instances for maintenance.
Confidential
Sr.SQL DBA
Responsibilities:
- Updated Prod. to lower environment servers Dev, QA, UAT, Perf & refreshing db’s from pre-production servers also for testing.
- Maintain Oracle /PostgreSQL db’s at Confidential E-commerce websites confidential . (QA/UAT/Prod).
- Created new Oracle 11gR2 /PostgreSQL 9.5 databases for older 11gR1 /9.2 ez2 databases.
- Application Development support & performance tuning of slow performing sql statements.
- Experience using Amazon Web Service (AWS) to create virtual Linux (7.1) server instances to replace older physical servers as leases expire.
- Export/Import Oracle & PostgreSQL export dump files to new 11g Linux databases from Solaris 11gR2 databases.
- Monitor performance tuning of RDBMS, Oracle 12c, & PostgreSQL 9.2.13 db’s on Linux/AIX OS platforms.
- Creating new 11gR2/12c databases on new VM servers (AWS) using dbca/runInstaller utilities.
- Startup/shutdown physical/virtual databases for OS patching CM’s on Prod, Perf, UAT, QA environments.
Confidential
DevOps /DBA
Responsibilities:
- Creating new database installations for testing new applications and new features of TRIAD software releases.
- Troubleshot Root Cause (RCA) for TRIAD multiple Vendor auto provisioning Issues on cross connects & Juniper router hand off from Interfaces.
- Updating to Production from conversion servers Test01 to Test 06 & updating from pre-production servers.
- Migrating from single instance TRIAD server to 40 Prod and 35 Dev & Pre-Prod server cluster environments.
- Support clustered databases, zero delay app. failover (TAF) & advanced replication for the SIMPL/TRIAD application.
- Monitor performance tuning of RDBMS, Oracle, MSSQL, IBM DB2, & PostgreSQL db’s on Linux platforms.
- Support AWR/ASH Reports for troubleshooting poor SQL & performance bottlenecks for application DEV. support.
- Supported smart phones mobile devices, account access with Oracle Application Development Framework (ADF) on Android mobile devices.
- Application support for Relativity & e-discovery software packages for proactive compliance monitoring to support Legal Team
- Migrated from Oracle 10gR2 to 11gR1, SQL Server 2012 with SSMA & SQL Server Management Studio GUI.
- Experience on Amazon Web Service (AWS) to create virtual Linux (6.7) server instances to replace older servers.
- Provide auto provisioning for Alcatel, DAC, GenBand, Tellabs interfaces thru TRIAD/ETI SIMPL API.
- Managed Daily Open Remedy Spreadsheet Frontier & ETI Vendors based on BMC Patrol reported issues.
Confidential
Oracle/PostgreSQL/MSSQL DBA
Responsibilities:
- Export/Import Oracle & PostgreSQL export dump files to new 11g Linux databases from Solaris 11gR2 databases.
- Creating new 11gR2 database with different character set to support EMEA or APAC languages, also English.
- Experience with DBCA (DB Config Assist) for upgrades - reduce downtime of Linux/Solaris Oracle db instances.
- Troubleshooting WFM (WorkForceManagement) application database issues/errors for ver 4.6 to ver 6.4.
- Application support for Relativity and FYI e-discovery software packages for proactive compliance monitoring.
- Supported Relativity as a comprehensive, complete platform for organizing data, discover y for follow up legal solution/actions.
- Creating new database installations for testing new applications and new features of WFM software releases.
- Used Oracle Web Center Content to help organize, consolidate unstructured content from across diverse systems to be centrally managed and then exposes it from within desktop productivity tools, business applications. (IEX Workflow)
- Support clustered database instances for zero delay failover (TAF) & advanced replication for the IEX application.
- Migrated from Oracle 11gR1 to SQL Server 2012 with SSMA & SQL Server Management Studio GUI.
- Monitor performance tuning of RDBMS, Oracle, MSSQL & postgresql db’s on Linux platforms.
- Adding pg maint - pv to crontab /job scheduler for file system maintenance on postgresql databases.
- Development support for workforce management application to confirm program resolution fixes
- Running vacuum full and vacuum analyze verbose r queuestats (tablename) to free file sys space.
- Migrated databases from Solaris to Linux platforms using MSSQL SSIS, DB2, Oracle SQL Dev. & OEM/DBCA.
- Provide a postgresql dump/restore using pg dump and pg restore commands on Linux platform.