Highly accomplished, deeply-driven, professional Oracle Database Administrator with over 8 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 10g, 11g, 12c, MySQL and MS SQL server. Exceeds ongoing and overlapping deadlines in fast-paced environments.
Database Expertise
Backup and Recovery
Data Pump and Export/Import
Transparent Database Encryption
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
Oracle VM Virtual Box
Work History
Senior Oracle Database Administrator, 08/2018 to Current Ntirety, Inc. – Tampa, FL,
Providing administrative support and maintenance on Oracle 10g, 11g and 12c 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.
Performing other Security related tasks including Transparent Data Encryption (TDE).
Implementing Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
Cloning schemas, objects and databases on new server using exports from 10g database and imported in 11g using data pump.
Performing backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.
Upgrading databases from 10g to 11g and 11g to 12c. Appling PSU and bug fix patch.
Implementing, tuning and maintaining Oracle database using OEM.
Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
Participating in the 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.
Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the 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 the ETL utilizing PL/SQL and Talend Administration Suite.
Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL execution time.
Managed database security by creating, assigning appropriate roles and privileges to users depending on the 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 the 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.
Reconciled functional and technical problems through research and training workshops, achieving a 65% increase in satisfaction rate of database end users and supervised the coaching of junior DBAs.
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
Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the 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 the ETL utilizing PL/SQL and Talend Administration Suite.
Used range, hash and composite table partitioning which greatly decreased the DB_time and SQL execution time.
Managed database security by creating, assigning appropriate roles and privileges to users depending on the 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 the 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.
Reconciled functional and technical problems through research and training workshops, achieving a 65% increase in satisfaction rate of database end users and supervised the coaching of junior DBAs.
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
Education
: Computer Science, Expected in 05/2022 University of Maryland - Global , GPA:
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
