Darren McLaurin
Sugar Hill,GA
Summary
Highly accomplished, deeply-driven, professional Database Administrator with over 20 years of experience, with a profound knowledge in database security and user management, backup and recovery, database design, performance monitoring and tuning, migration, upgrades, cloning, and replication. Proficient in an assortment of technologies including Oracle 6, 7i, 8i, 9i, 10g, 11g, 12c, 19c, IRIS, CACHE, POSTGRES and MS SQL server. Exceeds ongoing and overlapping deadlines in fast-paced environments.
Overview
21
21
years of professional experience
Work History
Senior Database Administrator
University Of Maryland Medical System
02.2008 - Current
- Performed administrative support and maintenance on Oracle 10g, 11g, 12c and 19c installations, database creation, database security, database optimization and tuning.
- Experience with providing and maintaining high availability and disaster recovery using ORACLE DATA GUARD.
- Monitoring and troubleshooting database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD.
- Implemented Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
- Performed backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.
- Upgrading databases from 10g to 11g, 11g to 12c and 12c to 19c. Appling PSU and bug fix patch.
- Implementing, tuning and maintaining Oracle database using OEM.
- Developed Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
- Participating in 24/7 on-call DBA rotation schedule.
- Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges
- Oracle Database performance-tuning services with EXPLAIN PLAN, AWR reports, ADDM
- Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases
- Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.
- 24x7 remote support and on call rotation
- Experience with providing and maintaining high availability and disaster recovery using Intersystems Mirroring.
- Experience with providing and maintaining HL7 Interfaces and IRIS Productions
- Cloning IRIS and CACHE databases to development environments
Database Administrator
GEICO
07.2003 - 08.2005
- Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using Oracle SQL Developer to OFA Institution and finally to DB launch.
- System Development Life Cycle (SDLC) methodology for designing analysis, development and implementation.
- Designed and implemented ETL utilizing PL/SQL and Talend Administration Suite.
- Used range, hash and composite table partitioning which greatly decreased DB_time and SQL execution time.
- Managed database security by creating, assigning appropriate roles and privileges to users depending on user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
- Worked on user management mainly on grants, privileges, roles, and profiles.
- Performed hot and cold backup and recovery using RMAN
- Worked on application and database security (data access, passwords, network, etc.).
- Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
- Tuning test and production database by altering parameters.
- Export and Import of database objects to copy from one database to another database.
- Investigating suspicious database activity using Fine-Grain Auditing.
- Write database documentation, including data standards, procedures, and definitions.
- Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
- Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances.
Oracle Database Administrator
AAI Corporation
06.2003 - 06.2005
- Managed Oracle E-Business Suite 11.5.9
- System Development Life Cycle (SDLC) methodology for designing analysis, development and implementation.
- Designed and implemented ETL utilizing PL/SQL and Talend Administration Suite.
- Used range, hash and composite table partitioning which greatly decreased DB_time and SQL execution time.
- Managed database security by creating, assigning appropriate roles and privileges to users depending on user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
- Worked on user management mainly on grants, privileges, roles, and profiles.
- Performed hot and cold backup and recovery using RMAN
- Worked on application and database security (data access, passwords, network, etc.).
- Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
- Tuning test and production database by altering parameters.
- Export and Import of database objects to copy from one database to another database.
- Investigating suspicious database activity using Fine-Grain Auditing.
- Write database documentation, including data standards, procedures, and definitions.
- Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
- Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
- 24x7 remote support and on call rotation
Skills
- Backup and Recovery
- Data Pump and Export/Import
- Database Security
- Database Upgrade and Migration
- Oracle Performance Tuning
- Patch Set Management
- Oracle RAC
- Oracle Data Guard
- TOAD
- SQL Developer
- SQL Loader
- Oracle Enterprise Manager
- IRIS Mirroring and Production Management
Timeline
Senior Database Administrator
University Of Maryland Medical System
02.2008 - Current
Database Administrator
GEICO
07.2003 - 08.2005
Oracle Database Administrator
AAI Corporation
06.2003 - 06.2005