Database Administrator Resume
SUMMARY
- IT professional with over 15 years of Oracle database experience including DBA, operational and architectural design support.
- Superb analytical skills assist with design process architectures based on Oracle 12c and 11g platforms supporting SAP, supply chain and engineering applications.
- Oracle database migration experience enables the creation of proven automated processes to load and manage application data.
- I am seeking database role supporting Data Warehouse and Cyber security support duties.
TECHNICAL SKILLS
Oracle Products: RDBMS v7.3.4/v8.0.4/v8i/v9.2, 10g, 11g, 12c ASM, RAC, OEMGrid Control
Data Warehouse Appliance: Netezza Twin Fin Data Warehouse Appliance
Business Intelligence Products: Microstrategy v9.0 Administration, IBM Data Stage Administration
Microsoft Products: MS SQL Server 2000/2005, Microsoft Clustering Services, 64 bit database architecture
Operating Systems: Red Hat Enterprise Linux, UNIX (Solaris, Sun/OS, HP - UX, AIX), MS Windows NT/ 2000/2003/2012 Servers
Specialty Training: Oracle Business Intelligence OBIEE/OBIA DAC (instructor led)
Specialty Skills: Data Warehouse Architecture and Design, Database Administration, Performance Tuning, Application Development Consulting, Capacity Planning Management, Database Server Consolidation, Clustering Technologies, Enterprise Cost Recovery Models
Life Cycle Expertise: ER Modeling using Erwin, Data Modeling, Logical Database Design, Physical Database Design, Database Administration, Application Development, Stress Testing, Database Tuning, Configuration Production System Deployment Support
Other Skills: Oracle PL/SQL, Oracle Goldengate, Oracle Streams, Oracle Financials Physical Database Administration (cloning), Maintenance of Data Modeling (ERWin), Data warehouse design using Star schema methodologies, Perl, Korn Shell Scripting, Awk, NoSQL knowledge.
PROFESSIONAL EXPERIENCE
Confidential
Database Administrator
Responsibilities:
- Performed Oracle database administration duties including critical database resumption of services for the Lennox corporate applications.
- Supported Oracle 12c & 11g environments running Red Hat Linux and HP-UX operating systems.
- Setup Data Guard environments in support of Business Continuity and Disaster recovery operations.
- Performed Root Cause Analysis, SQL tuning and database optimization activities in support of production, user acceptance testing and development database environments.
- Performed database migrations from HP-UX to RHEL Linux - Oracle 11g.
- Providing functional and capacity planning analysis for upgrade environment to Oracle 12c RAC Clustered systems.
- Performed Oracle DBA Team Lead duties developing standard processes & procedures using custom document and SharePoint.
Confidential
Database Administrator
Responsibilities:
- Performed Oracle database administration duties including critical database resumption of services for the Energy Services corporate applications.
- Supported Oracle 11g, 10g, 9i, 8i environments running Solaris operating systems.
- Performed Root Cause Analysis, SQL tuning and database optimization activities in support of production, user acceptance testing and development database environments.
- Performed database upgrades from Oracle 9i/10g to Oracle 11g.
- Performed Oracle database quarterly patching for latest version.
- Providing functional and capacity planning analysis for upgrade environment to Oracle 12c RAC Clusters and ExaData systems.
- Performed Oracle DBA Team Lead duties developing standard processes & procedures
Confidential
Database Administrator
Responsibilities:
- Performed Oracle database administration duties including critical database resumption of services for banking systems for the Global Services team.
- Supported Oracle 11g RAC Clusters and Data Guard database environments running Solaris, Linux and AIX operating systems.
- Performed Root Cause Analysis, SQL tuning and database optimization activities in support of production, user acceptance testing and development database environments.
- Performing database support for Oracle data distributed systems using Oracle Goldengate.
Confidential
Database Administrator
Responsibilities:
- Performed Oracle database administration duties by providing day-to-day support of application development team, backup and recovery activities and performance tuning tasks for Alcon Labs supply chain operations throughout the US and European operations.
- Supported Oracle 11g RAC Clusters and Data Guard database environments and Oracle 10g databases by patching and upgrading the existing databases.
- Provided guidance for performing standard process architectures by writing standard operating procedure documents. Created UNIX shell scripts and PL/SQL data capture procedures to enforce policy.
- Performed SQL tuning and database optimization activities in support of production, user acceptance testing and development database environments.