Production Database Administrator Resume
SUMMARY
- Technology Professional with over six years of experience utilizing Oracle for database administration.
- Extensive experience with databases and their comprehensive development, maintenance, backup, and infrastructure.
- In - depth knowledge of multiple programming languages, operating systems, and tuning tools.
- Equipped to be a highly knowledgeable team-oriented administrator with intangible traits such as leadership and communication.
- Additionally, possesses an educational background in business and economics, which allows for a different perspective to be brought to the company and its work groups.
AREAS OF EXPERTISE
- Database Administration
- Knowledge of Oracle
- Knowledge of SQL Server
- Infrastructure Management
- Troubleshooting
- Resolving Database Issues
- Cold/Hot Backups
- Export Dumps
- Archive Logs
- Data Transfer
- User Configuration
- User Security
- Critical Patch Updates
- Database Upgrading
- 12c Multitenant Databases
- Real Application Clusters
- Production Support
- Rollback Segments
- Database Tuning
- Standby Databases
- Leadership
- Problem Solving
- Communication
TECHNICAL SKILLS
Databases: Oracle 12c, 11G, 10G
Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x, Linux Enterprise Server 9, 10, Windows 95/98/NT/2000
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM
Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL
Utilities: SQL Server Management Studio 2014, RMAN, OEM 13c, SQL*Loader, EXP, IMP, Data Pump, TOAD, Oracle SQL Developer, Spotlight.
PROFESSIONAL EXPERIENCE
Confidential
Production Database Administrator
Environment: Oracle 11.2.03, 11.2.04, 12c, Windows, Failsafe, RMAN, OEM, TOAD, SQL server Management Studio 2014, Availability Groups.
Responsibilities:
- Create, remove, maintain and monitor housekeeping tasks for Oracle database as required, using such tools as cron, RMAN, DBMS SCHEDULER, etc.
- Monitor and maintain optimal server health allowing maximum throughput and minimal resource contention.
- Monitor available disk space and plan for the future.
- Manage security.
- Review and organize latest data patches and database upgrades.
- Run scripts (supplied by development DBAs) in production environments.
- Install and patch Oracle Server in a production environment as required.
- Ensure Oracle database assets are correctly licensed
- Develop and test disaster recovery plan.
- Develop and test backup & recovery plan.
- Execute and verify database backup procedure.
- Ensure proper logging to adhere to existing and new audit and compliance requirements.
- The ability to use problem solving skills to resolve problems professionally and accurately.
Confidential
DATABASE ADMINISTRATOR
Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0
Responsibilities:
- Operated with an inventory of 200 databases, the largest of which are 5 TB
- Extensively managed databases through testing using RMNA Duplicates databases, Point in Time Recovery (PITR) AND Tablespace Point in Time Recovery (TSPITR) using RMAN utilities,
- Developed network security encryption with SSL
- Worked heavily with Oracle databases including: implementing Oracle TDE to allow for transparent encryption, upgrading from Oracle 9i to 10g to 11.2.0.3 RAC databases, configuration of Physical Standby using Oracle Data Guard, installation of Oracle Enterprise Manager 12c, and adding database tools within the software
- Maintained tables through partitioning with Oracle 11g and redefine with DBMS REDEFINITIONS
- Resolved database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), and Active Session History (ASH)
- Developed backup strategies utilizing RMAN to clone test databases, implemented back strategies with Cold, Hot, and MAN with Flash Recovery, additionally, scheduled RMAN backups, and conducted further maintenance with several software packages
- Achieved optimal performance tuning by explaining plan with STATSPACK, SQL TRACE, and TKPROF
Confidential
DATABASE ADMINISTRATOR
Environment: Oracle 11g / 10g / 9i, Linux, Solaris, SQL Developer, PL/SQL, Shell scripting (Bourne), OEM, Statspack, RMAN, AWR, ADDM, DataPump
Responsibilities:
- Implemented a full-circle database and development program involving: installation of Oracle 11g databases to meet project requirements, utilizing Import and RMAN backups to test database production, maintain security, ensure effective space for optimal performance in databases through structural edits, and backups of various types (full, partial, expert/import).
- Created a database link between two separate databases to access table data from one local database
- Specifically performed Oracle DBA performance tuning and maintenance to ensure optimization while configuring hardware and software for the Oracle database using the UNIX system
- Developed procedures for using PL/SQL and created database objects using written SQL scripts
- Monitoring the security of the database through alert logs and checking the space for normal and rollback segments as well as tablespaces
Confidential
JUNIOR ORACLE DATABASE ADMINISTRATOR
Environment: Oracle 11.2.0.3, 10.2.0.2, Sun Solaris 10.0
Responsibilities:
- Responsible for the comprehensive development and maintenance of database and associated objects such as tables, tablespaces, buffer pools, indexes and views
- Analyzed tables and indexes for performance tuning, along with analysis of databases
- Created PL/SQL functions and manipulated data in tables using respective procedures
- Developed appropriate login information to set up proper procedures to protect data
- Prepared business requirement documents (BRD) and functional requirement documents (FRD) by conducting interviews, focus groups, and surveys with clients in order to provide an evaluation
- Conducted comparative and gap analysis to meet HIPAA guidelines
- Planned budgets for each respective project in order to present cost estimate to stakeholders
- Presented ICD-9-CM diagnosis with CPT codes so that stakeholders can understand the need to incorporate changes into the recording systems