Professional Database Administrator Resume
OBJECTIVE:
Seeking a position as a Database Administrator where I can contribute my solid organizational abilities and operational DBA technical skills and expertise (MySQL, Oracle, Sybase, Datacom)
SUMMARY:
- Utilize significant MySQL and Oracle database experience working with a team of geographically diverse personnel supporting over 200 terabyte database environments
- Serve as technical escalation point for Oracle database issues used by the Confidential & Confidential billing and IVR applications (in development and production environments - Linux). DBA support and duties encompass the following: Tier 3 Support, 24 x 7 on-call rotation, installation and configuration of MySQL and Oracle RAC RDBMS, GoldenGate replication, cloning of environments, instance performance tuning, Unix shell scripting, database patch application, backup and recovery, and problem resolution.
- Create and coordinate development of highly technical and detailed documentation of procedures, methodologies and quick reference guides for team members. Creation and maintenance of web pages and Unix shell scripts that provide statistics of databases, file systems, backup history, database parameter auditing and ASM disk group usage across several applications.
- Provide training as needed to DBA team members on DBA tasks, responsibilities and best practices. Coordinate key project activities across multiple technical teams, track progress and provide updates to upper management.
TECHNICAL SKILLS:
Databases: MySQL (5.5 and 5.6), Oracle Releases 12c, 11g, 10g, MySQL, Sybase, MS-SQL, Datacom
Database Products: MySQL Workbench, Oracle RAC, Golden Gate, Oracle Data Guard, RMAN (Recovery Manager), ASM (Automatic Storage Management), ACFS, SQL, PL/SQL, OEM (Oracle Enterprise Manager), Toad, DB Artisan, Cognos
Operating Systems: Red Hat Linux, HP-UX, Sun Solaris, IBM AIX, OS/390, OS/MVS-XA, DOS, OS/2, Windows
Languages and other Utilities: UNIX shell scripting (Korn shell, C shell), SQL, PL/SQL, Confidential -SQL, Python, Visual Basic, C, JCL, TSO/ISPF/CICS
PROFESSIONAL EXPERIENCE:
Confidential
Professional Database Administrator
Responsibilities:
- Primary applications currently supported: IVR and VIVR (GoldenGate and DataGuard), Enabler (RAC and GoldenGate) on over 200 terabyte databases
- Installation of Golden Gate and creation/management of extracts, pumps & replicats
- MySQL and Oracle: Research and resolution of database performance issues, implementation of RAC installations, upgrades and patches, RMAN backups, restoration and recovery of databases, review of storage documentation, mounting of ASM and ACFS file systems
- Create Unix shell scripts and web pages that provide near real-time statistics of MySQL and Oracle databases, file systems, backup history, database parameter auditing and ASM disk group usage to track across the application.
- Refresh databases by using shadow image scripts to copy existing production databases to development.
- Implement and test switchovers and failovers of a disaster recovery environment consisting of a primary database and two physical stand by databases
- Monitor, track and review production database/Unix changes. Validate changes were implemented successfully and communicate issues and areas for improvement to management.
- Create technical documentation for DBA team policies, procedures, overnight maintenance and best practices.
- Coordinate key project activities across multiple technical teams, track progress and provide updates to management.
- Manage current and future project tasks, database upgrade/patch planning, ensuring database coverage/support
- Work with a team of 9 geographically diverse personnel (6 onshore / 3 offshore) Oracle DBA’s to coordinate the continuing migration and upgrade of Oracle databases from 11g / RHEL 6 to Oracle 12c / RHEL 7
Confidential
Professional DBA
Responsibilities:
- Provided Sybase DBA support for Confidential & Confidential Fraud systems environments (production, development, and QA) running on the IBM AIX and HP UX platforms
- Performed database upgrades, sizing, performance tuning, backups and patching
- Migrated developers code to development, unit test and production environments.
- Coordinated with app teams on alerting, performance tuning, database enhancements, and error resolution
Confidential
Sybase Database Administrator
Responsibilities:
- Provided Datacom and Sybase DBA support for Confidential customer facing system environments (production and development, and QA) running on the IBM mainframe (OS/390), IBM AIX, and HP UX platforms
- Performed database upgrades, sizing, performance tuning, backups and patching
- Coordinated with app teams on alerting, tuning, application database enhancements, and error resolution
- TSO/ISPF, CICS
