Sr. Database Administrator/export/architect Resume
Austin, TexaS
SUMMARY:
- Oracle Certified (7,8, 8i &10g) DBA (OCP)
- Certified Oracle DBA from Chauncey Group International
- In - depth knowledge of Oracle enterprise database production administration, performance tuning, security administration, migration/replication with knowledge of agile methodology and strong problem solving skills
TECHNICAL SKILLS:
Languages/Tools: Mongodb, Enteprisedb/Postgres, Java, JDBC, C, Perl, Php, ASP, IIS, Apache, LDAP, C/C++, SQL, Yasql, XML, Mysql, PL/SQL, Perl, Shell Scripts, ERwin, Pro*Fortran, Pro*C, Transact - SQL, Modula-2, Fortran, Assembler, Visual Basic, PeopleTools, PeopleCode, SQR, ESQR, Oracle WebDB/Portal, Oracle 8i/9i/10g/11g/12c, Oracle Standby Database/Active Data Guard, Oracle Grid Control, Data Guard, Oracle Replication, Oracle Streams, Oracle Goldengate, OPS (Oracle Parallel Server), Oracle RAC (Real Application Clusters), OCS (Oracle Collaboration Suite), Oracle iFS, Oracle Text (formerly Intermedia), Oracle Developer 2000, OEM (Oracle Enterprise Manager), EcoTOOLS, SQL-BackTrack, ProactiveNet, SQL Server 7/2000, SQL Server Cluster, QuestSoftware, Toad, Apache, Tomcat:
Hardware/OS: HP-UX, DEC-Digital Unix, Sun Solaris, Red Hat/SUSE Linux, Apple/Macintosh, PC s, Windows (3.x, 95, 98, NT, 2000, XP, 10), OS2, EMC Symmetrix/Clarion Storage, Dell Storage/SAN, Hitachi Storage, AIX/HACMP/GPFS
PROFESSIONAL EXPERIENCE:
Confidential, Austin, Texas
Sr. Database Administrator/Export/Architect
Responsibilities:
- Install, configure and manage Oracle 10g/11g/12c Real Application Clusters (RAC) on Linux/ASM/OCFS/RAW, Sun Solaris/Veritas, and AIX/HACMP/GPFS
- Successfully Migrated 30-Terabyte Oracle database from Oracle Solaris to SUSE Linux with Oracle Replication (Streams)
- Designed and implemented Oracle RAC with reporting database on Active Data Guard
- Designed and Implemented RMAN backup strategy of Oracle RAC on Oracle Standby Database.
- Designed and implemented Oracle security/password complexity to be in compliance with corporate security requirements.
- Designed and implemented RMAN backup and recovery strategy to create and refresh UAT database from 45-Terabyte Oracle production database monthly
- Design and implemented database archive strategy for large tables
- Database/SQL/ tuning/partitioning
Confidential, Austin, Texas
Sr. Database Administrator/Architect
Responsibilities:
- Install, configure and manage Oracle 9i/10g Real Application Clusters (RAC) on Red Hat Linux/OCFS/RAW, Sun Solaris/Veritas, and AIX/HACMP/GPFS
- Install, configure and manage MS SQL Server 2000 Cluster
- Provide database (Oracle 8i/9i/10g, SQL 7/2000) architectural consultations for high availability, high performance, high transaction rate N-tier (Java/Web) application
- Design, implement and manage highly scalable 24/7 e-Commerce database systems (Oracle 8i/9i/10g) through Oracle RAC/partitions
- Design, implement and manage high available database systems (Oracle 8i/9i/10g, SQL 7/2000)
- Perform all backup/recovery, standby/failover server/log shipping, monitoring/performance tuning, capacity planning
- Install, configure, upgrade, tune and manage Oracle Text (formerly Intermedia) databases (Oracle 8i/9i/10g)
- Database support of 40 developers of heterogeneous platforms
- Database/SQL/Application tuning/optimization
Confidential, Columbus, Ohio
Sr. Database Administrator
Responsibilities:
- Installation, configuration, administration and upgrade of Oracle 8.x (including Oracle 8i) database on HP-UX 11.x
- Installation, configuration, administration and upgrade of Oracle (7.x, 8.x, including Oracle 8i) database on NT 4.0/Windows 2000
- Oracle (8.x) database/SQL/PeopleSoft application/process tuning
- Advanced Replication and Partitioning of Oracle instances
- Design and implementation of enterprise (24 X 7) database Backup/Restore/Reorg strategy including ‘Standby Database’
- Installation, configuration, upgrade and performance tuning of PeopleSoft (7.x) Financials, Distributions, Manufacturing and PeopleSoft application (BEAS/TUXEDO) server
- Installation, configuration and administration of PeopleSoft Web Application
- PeopleCode customizations using PeopleTools
- Maintaining SQR programs for PeopleSoft applications
Confidential, Columbus, Ohio
Sr. Database Administrator
Responsibilities:
- Installation, configuration, and upgrade of Oracle (7.x) database on DEC Alpha 4100
- Creation, administration, reorganization, capacity planing and troubleshooting of multiple Oracle databases/instances
- Installation, configuration, upgrade and performance tuning of PeopleSoft (6.x, 7.x) HRMS and PeopleSoft application (BEAS/TUXEDO) server
- Oracle (6.x, 7.x) database/SQL (query)/application/process tuning
- Design, implementation and maintenance of a fortunate 500 enterprise Oracle/SAP database Backup/Restore/Re-org strategy
Confidential, Worthington, Ohio
Database Consultant/System Analyst
Responsibilities:
- Implementation of PC utilities for UNISYS to update 60-gigabyte image files using C
- Provided consultation on Oracle (7.x) database design and configuration for a government agency
- Data migration of legacy data from an IBM mainframe to Oracle database using SQL*Loader
- Implemented and Maintained Oracle PL/SQL, stored procedures for online procurement system on UNIX for an international manufacturing company
- Created many reports using data outside and inside Oracle databases using Pro*C under UNIX environment for a telecommunication company
- Oracle Database Administration consisting of backup/recovery, performance tuning, data and space management, and loading flat file into Oracle databases
- Designed, data modeled and implemented HMMS (Highway Maintenance Management System) for a foreign government agency using Oracle (6.x, 7.x) database and Oracle developer’s tools
- Implementation of the Gas/Oil pipeline extract approximation comparison strategies with Cubic-Splines using C and MS FoxPro