Database Administrator Resume
Dallas, TX
SUMMARY:
- Technically skilled, quality - focused, and results-proven Database Administrator with experience in providing high availability Oracle database solutions using Oracle RAC, ASM, Data Guard and experience in administering Netezza Appliances.
- Proven communication skills when working with senior management as well as with technical staff on database project statuses and issues.
- Install, configure and monitor Oracle database high availability solutions using Oracle RAC, Automatic Storage Management (ASM) on Linux 64-bit servers in Oracle 11g and 12c.
- Build Oracle database disaster recovery solutions using Oracle Active Data Guard on Linux 64-bit servers.
- Perform backup and recovery of Oracle 11g and 12c databases using Oracle RMAN methodology and RMAN Catalog.
- Perform Oracle database upgrades from versions 10g, 11g R1 to 11g R2, 12c R1, and 12c R2.
- Maintain development environment by performing refreshes using RMAN Duplicate method.
- Administer and maintain Netezza appliances on NPS versions 7.0x - 7.2x.
- Perform backup and recovery of Netezza databases using nzbackup and nzrestore.
- Work with Oracle and IBM support in identifying solutions to known issues and engaging support engineers on SRs and PMRs for a quick turnaround of solutions for Oracle and Netezza database issues.
- Maintain appropriate system release/patch levels. Perform Install, configuration, integration, tuning and patching of systems.
- Plan, implement and forecast system architecture requirements to support the business needs (in collaboration with IT Architecture).
- Perform Informix backup and recovery tasks using Ontape.
- Automate frequent Oracle DBA tasks using Linux shell scripting.
- Perform cloning and refreshing of Oracle, Netezza and Informix Development, QA and UAT environments from Production databases using various options and techniques, RMAN Duplicate, Data Pump, nzrestore.
TECHNICAL SKILLS:
Operating Systems: Linux (RHEL & SuSE) - MS Windows Server ( ) - UNIX (AIX, HP-UX & Solaris) Informix 11.x & 12.x Netezza NPS 7.0x 7.2x Oracle 9i, 10g, 11g & 12c
Applications, Tools and Utilities: ADDM & AWR Aginity Workbench ASM AWK & SED Cygwin Data Pump, Export & Import EMC Avamar & Data Domain Golden Gate HP Data Protector MS Office Suite (Excel, Word, PowerPoint) MS SCCM Netezza Performance Portal NZ SQL OEM 12c, 13c Cloud Control/11g Grid Control Putty Remedy RMAN Service Now (ServiceNow) SQL Developer SQL* Plus SQL Loader TOAD VMWare ESX, vCloud Director & vSphere WinSCP
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
Database Administrator
Responsibilities:
- Played lead technical role in maintaining and modifying Oracle 11gR2, 12cR1, and 12cR2 database(s) in production.
- Tracked system availability, uptime, and performance using Oracle Enterprise Manager, OEM 12c and 13c.
- Conferred with less experienced DBAs and guided their efforts in maintaining Oracle databases.
- Conferred with application development staff and project management staff regarding project planning, resource allocation, task definitions and schedules for substantial projects involving Oracle database(s).
- Planned and designed Oracle database changes necessary for data conversion, tool configuration, data refresh or migration or other initiatives related to large application development projects.
- Troubleshot or conferred with others troubleshooting errors or production problems involving databases to determine causes and proposed solutions.
- Set and documented standards for use of Oracle databases with objectives of data integrity, data security, efficient operation, audit requirements, and the like.
- Communicated to others in development or database administration roles.
- Conferred with managers in networking, systems operations, applications, and client/user community to maintain stable and efficient operating environment for database(s).
- Provided technical lead, project leadership or staff supervision in large development, migration, testing, acceptance or product rollout project.
- Performed Oracle database patches using OPatch.
- Performed Oracle database upgrades from 11gR2 to 12cR1 and from 12cR1 to 12cR2 using Data Guard, DBUA and manual methods.
- Responded to Oracle database requests using Service Now (ServiceNow).
Confidential, Carrollton, TX
Senior Systems Engineer (Sr. Oracle-Netezza DBA)
Responsibilities:
- Install, configure and monitor Oracle single-instance and RAC databases using Automatic Storage Management (ASM).
- Build disaster recovery solutions using Oracle Data Guard physical standby databases using Data Guard Broker.
- Implement and maintain Oracle Active Data Guard to meet reporting requirements.
- Establish and maintain backup and recovery processes using RMAN.
- Establish database security procedures.
- Perform performance tuning using ADDM, AWR and tkprof.
- Perform SQL tuning using various tools including explain plans, appropriate indexing and partitioning.
- Perform database upgrades from 11gR2 to 12cR1.
- Maintain appropriate database patch levels using OPatch.
- Automate tasks using shell scripts scheduled in CRONTAB.
- Perform data migration using Data Pump .
- Maintain lower environments in vCloud (DEV, QA & UAT) by performing refreshes using RMAN Duplicate.
- Create and maintain database templates in VMWare .
- Administer and maintain OEM 12c Cloud Control for monitoring database availability and performance.
- Integrate OEM 12c Cloud Control with MS SCSM for enterprise alerts.
- Identify and tune poor performing SQL & PL/SQL.
- Administer and maintain Netezza appliances on NPS versions 7.0x - 7.2x.
- Perform backup and recovery of Netezza databases using nzbackup and nzrestore.
- Maintain appropriate NPS release level by performing NPS upgrades.
- Perform refreshes of Netezza development appliance using nzrestore.
- Engage vendor support to identify solutions to issues.
Confidential, Dallas, TX
IT System DBA Administrator
Responsibilities:
- Worked with IT System Administrative group on plans for installation of hardware, SAN disks, hardware upgrades, network components (hardware and software) and bandwidth management to help ensure proper capacity is maintained.
- Planned and managed the installing/removing of RDBMS, OLAP and software as required.
- Ensured the Oracle and Informix RDMBS were correctly integrated in current software map, middleware framework and global infrastructure the information system relied on.
- Maintained appropriate system release/patch levels. Perform Install, configuration, integration, tuning and patching of systems.
- Planned, implemented and forecasted system architecture requirements to support the business needs (in collaboration with IT Architecture).
- Performed Oracle backup and recovery tasks using RMAN, Data pump and Export/Import.
- Performed Informix backup and recovery tasks using Ontape.
- Automated frequent tasks using shell scripts and crontab. Worked with Automation Team to set up jobs in CA AutoSys/Unicenter.
- Performed required tuning, and adjusting of parameters in order to provide optimal performance.
- Worked with Developers to tune SQL and PL/SQL.
- Performed cloning and refreshing of Oracle and Informix Development, QA and UAT instances from Production.
- Identified, developed and implemented a comprehensive software solution necessary to support the monitoring of the various database environments.
- Complied with the IT QA standards and references, in regards to quality, performance and reusability of the implemented solutions.
- Complied with the IT Pre-Production team standards in regards to operability of the developed solutions.
- Complied with the IT Technical Architecture team standards in regards to the global technical framework of the company.
- Worked with developers in creating and maintaining database objects including database partitioning.
- Ensured appropriate system documentations were kept up to date.
- Ensured proper operational integration (technical and functional), both individually as well as through working with any third-party companies contracted to provide support.
- Implement and audit database security policies in coordination with Operations and Systems Engineering.
- Evaluated, recommended and installed database security solutions.
- Performed capacity planning in terms of memory and disk usage, establishing benchmarks for performance.
- Provided on-call duty for Oracle and Informix system database-related issues.