SUMMARY
- Over 17 years of experience in administrating Oracle databases.
- Oracle Certified Professional (OCP) since 2000.
- Over 7 years of experience in administering UNIX and Linux systems.
- Experience with Oracle advanced features such as RAC, ASM and DataGuard.
- Implement database backup procedures and restore databases from a various failure scenarios
- Develop and implement disaster recovery plans
- Configuration of SQL*Net for Client/Server connectivity
- Performance Tuning of design, application, memory, Input/Output, contention, operating system and query.
- A capacity for managing multiple tasks and competing demands while maintaining the large vision perspective; as evidenced by my consistent ability to meet project targets and deadlines.
- Effective at working both independently, and with a team in order to quickly assess problems and determine solutions in a timely and cost efficient manner.
- I have developed and instructed motivational and educational programs on personality profiling and motivational psychology for business owners, managers, and frontline staff. I have also initiated programs to provide ongoing support and mentorship to colleagues.
TECHNICAL SKILLS
Oracle RDBMS: 7, 8, 8i, 9i, 10g, 11g
Operating Systems: HP - UX 11.11, 11.31; Solaris 2.6, 8, 9, 10; AIX 6.1, 7.1; Linux Redhat 7.2, Enterprise 3; Oracle Linux 6.3.
Database Administrative Tools: SQL*Plus, SQL*Loader, SQL*Developer, Enterprise Manager - GRID, TOAD, Ignite, Server Manager, Server Control, Automatic Segment Control, Clusterware Control.
Programming Language: SQL, PL/SQL, shell scripting.
Unix/Linux: O/S install, O/S patching, Configure disk mirroring, Shell scripting, Maintaining and troubleshooting Operating Systems, Creation and maintenance of users and groups, Customization of user environments, Setting and changing file permissions, Process control, Cron job scheduling, File system administration, LP printing service, Disk Administration, Syslog auditing, V.I. file creation and editing
PROFESSIONAL EXPERIENCE
Confidential - Salt Lake City, Utah
Sr. Database Engineer/Administrator
Responsibilities:
- Point of contact for all Select Health Oracle database administration
- Primary DBA support of over 50 Oracle instances
- Oversee new development of all Oracle databases and objects
- SQL and PL/SQL query scripting, tuning and code deploys.
- Refreshes via data pump, tablespace transport
- RMAN duplicate from active and convention restores
- Extensive tracking, logging and documentation.
- Light SQL Server administrative duties
- Light MySQL administrative duties
Confidential - Phoenix, Arizona
Database Administrator
Responsibilities:
- Support of over 60 Oracle and 80 SQL Server instances.
- Delphix ‘virtual’ databases.
- Data batch loads
- Data retention standards execution
- After hours support
Confidential - Phoenix, Arizona
Database Administrator
Responsibilities:
- Support of over 130 Oracle database instances.
- Support of OLTP and Data Warehouse databases in production, development and QA.
- Delphix ‘virtual’ databases
- Real Application Clustered (RAC) databases
- Automatic Segment Management (ASM)
- Support of new Data Warehouse implementation
- Support of new billing system upgrade in production OLTP database
- Light MySQL administrative duties
Confidential .
Sr. Database/Systems Administrator
Responsibilities:
- 24/7 support for Manufacturing Execution System (MES) and its associated UNIX servers, Oracle Databases and applications.
- Complete rebuild from scratch of the entire production environment with zero down time to implement.
- Create and maintain data retention policy
- Creation of a complete test/development environment.
- Creation of an Oracle standby (DataGuard) database environment.
- Oracle production, test and development support.
- Oracle Database refreshes via exp/imp, hot backups.
- Oracle Database data purges and retention.
- Oracle Database objects creation.
- Oracle Database and query level tuning.
- Scripting of Oracle and Unix level maintenance activities.
- Creation and maintenance of FTP server environment for client access.
- Coordinate with programmer on object development and updates.
- Source and negotiate support contracts for databases and servers.
- Exposure to SQL Server databases.
Confidential
Database Administrator
Responsibilities:
- Support for Data Warehouse
- Data loading via SQL*Loader
- Enforcing data retention policy
- Database object development via Erwin
Confidential
Database Administrator
Responsibilities:
- Support of Merced Database systems for the Travel counsellor community
- Creation of clone reporting environment refreshed weekly with scripted transportable tablespace export and import.
- Install upgrades and patches.
- Migrate from Oracle 9i to Oracle 10g.
