SUMMARY:

• IT professional with 15+ years of progressive Oracle DBA experience.
• Collaborating on database design (conception through completion) with user and development community managers / directors for risk assessment application for high - value customers of Confidential .
• Managing Oracle DBA group Confidential as interim manager for more than a year.
• Took over after former manager’s promotion, successfully leading group and continuing pace and morale.
• Upgrading e-business suites (EBS) Confidential, navigating all application changes and software module updates as well as data migration.
• Completed project in single weekend to ensure no downtime across district.

EXPERTISE IN:

Database Performance Tuning | SQL Tuning | Database Replication & Design & Structures | Disaster Recovery Capacity Planning | Data Modeling | UNIX Scripting | Memory Management | Backup & Recovery

TECHNICAL SKILLS:

Software: Oracle 8i/9i/10g/11g, Oracle EBS 11.5.10.2, Oracle OEM 12c, Grid Control, Oracle Discoverer 4i/10g, 10gAS, APEX, RMAN, PL/SQL Developer, Toad, Embarcadero, DBArtisan, ERwin

UNIX: Korn Shell/AWK/SED

Microsoft: MS/SQL Server, Office Suite

Mainframe: ANSI COBOL, OLQ, IDD, DMLO, OLM, DB2, DFSORT/ IBM Utilities, VSAM, CICS/CL, CEDF / CEMT, TSO/ISPF, DB/COBOL, ADSG, ADSO, EASYTRIEVE, ALC, ISPF, CLIST, ACF/2, Smart Scheduler, OS/JCL, MVS/ESA/XA, PANVALET, FORTE, Dialog Manager, ADSALIVE, COBOL II, FOCUS

Hardware/OS: Win95/98/2000/XP/7.0, AIX P5, P750, RS 6000 6L, UNIX/Linux, SUN 6000/ Confidential, WANG V6, IBM/PC, DOS/VS, OS/MVS/XA/ESA, MS/DOS, AMDAHL

RECENT EXPERIENCE:

Oracle Database Administrator

Confidential, Dallas

Responsibilities:

• Collaborated with developers to create database schemas based on new application specifications and data models. Created procedures to fix unexpected anomalies.
• Executed disaster recovery solution utilizing RMAN backups for Oracle EBS database, replacing old and inefficient file system recovery solution.
• Investigated and tuned performance of critical business reports and queries. Improved efficiency of response time.
• Documented Oracle upgrade steps for 10g 32-bit to 11gR2 64-bit project, mentoring associate DBAs in test run of upgrade.

Oracle Database Administrator (DBA)

Confidential

Responsibilities:

• Collaborated with vendors and application owners to facilitate ETL of Confidential data to new databases from DB database platform.
• Addressed application issues, successfully configuring them to new database.
• Conducted diagnoses of data and Oracle environments, resolving issues and tuning performances.
• Identified and solved poorly written SQL commands.
• Teamed with systems group to migrate database file systems from NetApp filer storage to DS8070 Raid 10 SAN storage system.
• Implemented Oracle DataGuard for disaster recovery solution.

Oracle Database Administrator

Confidential, Dallas

Responsibilities:

• Provided level III reactionary support for Confidential 's global collection of Oracle and MSSQL databases on UNIX and Linux servers, resolving issues with backups, capacity, performance, GoldGate issues, SOX DB, and user requests.
• Executed Oracle upgrades (11.2.0.4), patching, cloning, and migration. Installed new databases, client binaries, and opening SRs with Oracle. Worked with client community to resolve any issue related to database.

Oracle Database Administrator

Confidential, Dallas

Responsibilities:

• Implemented auditing features and role-based security across bank's global network of 1000+ Oracle 10g-11gR2 databases (many in RAC configuration on UNIX and Linux servers) to ensure standard compliancy.
• Coordinated install with primary DBAs, application managers, and user community to ensure proper backups and preparation for system impact.
• Resolved tickets issued to data center due to above global implementations.

Support Database Administrator

Confidential, Dallas

Responsibilities:

• Performed global assistance for any problems associated with asset management application.
• Installed upgrades and patches to asset management application on SQL server platform.
• Migrated internet security certificates and general maintenance of application.
• Provided client level II support, resolving client issues with applications: investigated reporting problems, connectivity issues, installation of new versions, modifications, and resolutions of failed processes.
• Ensured Oracle 11g database interfaces to application were complete and efficiently tuned.
• Documented procedures for SQL server restoration procedures. Resulted in management presenting information to technical team.

Database Administrator

Confidential

Responsibilities:

• Installed and maintained Oracle EBS and databases supporting product, development, and test instances including multi-tiered environments.
• Oversaw configuration changes in Apache databases.
• Upgraded database from 9i / 10g / 11g, EBS to 11.5, and Oracle BI to 10.0.
• Installed patches, drove code promotions, resized / added data files, and scripted code.
• Managed platforms on AIX and Red Hat Linux.
• Performed system administration for business suites: program promotion, requesting sets, attaching programs to request groups, and implementing reporting database.
• Managed 5 DBAs as interim manager for 1.5+ years.
• Cloned Oracle database tier and application tier into test and development environment. Implemented changes.
• Tracked alert logs, archives, and trace files and proactively worked on said alerts for file system and CPU issues utilizing GGSCI to monitor GoldenGate.
• Implemented database backup and recovery procedures with RMAN, system file backups, and UNIX scripts.
• Converted database files to ASM and provided daily support. Automated storage management in Oracle. Resulted in increased efficiency.
• Troubleshot problems with web server, web listener, forms server concurrent managers, workflow, and database.

Database Administrator

Confidential, Dallas

Responsibilities:

• Collaborated with application DBA cross-culture team supporting conversion of Confidential & Confidential billing and customer order management to Confidential 's Oracle 9.2.0.6 database on Confidential UNIX platforms.
• Created instances to stage, merge, and test different aspects of numerous systems.
• Managed data ETL in-house with Korn shell scripts, PL/SQL, and third-party software for data mapping; some secondary databases were on DB2.
• Configured database environments, physical structures, schema changes, management, and refresh of data for all conversion subsystems divided into regional markets and functional areas.

Database Administrator

Confidential, Dallas

Responsibilities:

• Created logical and physical database models, primary database storage structures, and primary database objects as well as document database environments and configuration information. Supported database environments for production, testing, and development.
• Reviewed current and future environments for database growth and optimal database performance of Oracle and Sybase DBMS on Sun Solaris and Red Hat Linux platforms.
• Ensured available memory was utilized to full capacity.
• Created 9i Oracle database for web application supporting high-value users through connection pool of 100 concurrent people. Utilized material views and partitioned tables for quick access to larger tables.
• Designed offsite standby database in managed recovery mode for disaster recovery. Implemented reporting / DR database utilizing standby database to replicate production.
• Developed database recovery processes and procedures to perform loads and validations.
• Coded and tested stored procedures, views, and triggers to support applications, user needs, and admin duties.