~ Oracle Database Administration ~

QUALIFICATIONS PROFILE

Forward-thinking, solutions-oriented, and technically inclined professional, offering comprehensive experience in Oracle database administration, encompassing database architecture, production support, backup and recovery migration, and performance tuning. Highly skilled in technology development and management as well as overall process improvement and project operations while optimizing systems efficiency and productivity. Adept at performing broad range of IT initiatives while participating in planning and implementing systems and solutions to achieve established goals and objectives.

AREAS OF EXPERTISE

Database Administration and Maintenance Space Management ETL Processing

Troubleshooting Installation and Configuration Database Design and Architecture

Database Security and User Management Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Navy Exchange Service Command Virginia Beach, VA

Oracle Database Administrator Dec 2015–Present

Administer STIGS and database security through the use of SSL, LDAP, as well as data and public key infrastructure (PKI) encryption.

Upgrade databases from 10g to 11g and 12c as well as update Oracle critical patch and patch set.

Experience in used of OBIEE to generate ad hoc queries, enterprise and financial report notifications and alerts.

Adeptly handle Oracle advanced replication jobs and transactions along with archives and operational advanced replication database.

Hold accountability in configuring RMAN for database backup and recovery and repository maintenance.

Guarantee proper operation and maintenance of all systems as well as dissemination of information internal security policies and practices.

Conduct thorough review of security logs and audit trails in alignment with set-forth schedules.

Perform database cloning by utilizing RMAN to ensure consistency and availability of new features.

Troubleshoot databases to secure adherence of systems to the requirements, consistency, and availability.

Analyze and propose options toward the improvement of database server environment.

Used of Data Warehouse for high performance and management of large date

Expertly allocate system storage and plan future storage requirements for the database system.

Develop database structure and Schema changes as deemed necessary based on the information provided by the application developers.

Take full charge of controlling and monitoring user access to the database as well as researching available technology solutions.

LOCKHEED MARTIN Silver Spring, MD

Oracle Database Administrator May 13–Dec 2015

Drove key efforts toward the successful installation and configuration of Oracle 10g, 11g, and 12c databases on both Linux and UNIX Red Hat 5.0 and windows platforms.

Displayed proficiently in using AWR and ADDM and employed critical thinking skills in defining plans for periodic performance tuning.

Made use of Tuning Pack, Diagnostics Pack, and STATSPACK, as well as Trace and TKPROF in monitoring systems.

Carried out database monitoring and maintenance as well as replication process and performance tuning through OEM Oracle Enterprise Manager.

Streamlined processes such as organizing files, managing alert log, and executing backups through development of UNIX scripts.

Initiated flashback technology of the Oracle 11g and 10g along with the recycle bin for a faster recovery of databases and objects.

Utilized RMAN in performing full and incremental backup; refreshing and cloning databases; and implementing recovery strategies.

Spearheaded the execution of data pump and conventional export / import utility of Oracle 11g and 10g to reorganize databases, schemas, and tables toward performance improvement.

Migrated and cloned small-sized databases and data pump by using import and export utilities to move data between 9i and 10g and 11g environments.

Led the installation of ASM environment and migration of databases from NON-ASM to ASM.

Executed database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and Oracle 11g (11.2.0.3) as well as from Oracle 11g (11.2.0.3) to Oracle 12c (12.2.0.1).

Enhanced the security and functionality of the databases through the application of RDBMS and security patches.

Obtained an optimized performance of the databases by reestablishing indexes and enforcing partitioning methodologies such as range, list, hash, and composite partitioning on tables and indexes.

Assumed full responsibility in installing, configuring, and administering RAC for disaster recovery; as well as optimizing startup, shutdown, backup, and cloning of the databases.

Maintained active involvement with the migration of cluster databases and single instance databases.

QWEST Communications Dublin, OH

Oracle Database Administrator Oct 2011–Mar 2013

Devised, tested, and instituted backup and recovery solutions, which included automated daily hot and cold backups based on the criticality of the database and migration.

Coordinated performance-tuning activities to improve Oracle database; tuned database by initializing parameter, SQL statement, and memory through routine checks of the SGA, CPU, as well as logical and physical I/OS and contention.

Oversaw security implementation through basic and advance security techniques while applying recent patches and upgrades, appropriate user grants, permissions, and profile management.

Tracked database growth, developed objects, managed users, and tuned expensive SQL statements using EXPLAIN PLAN and SQL TUNING ADISOR.

Offered a 24/7 availability and coverage of technical assistance through emails, cell phones, and PDA's for mission critical databases.

Strong knowledge installation and configuration of RAC and Data Guard in Oracle 10g and 11g UNIX/Linux environment.

Created and configured Oracle database with various sizes which included 200GB, 400GB, and 2TB in Dev, ITG, as well as model and production environments.

Modified performance and optimized SQL Query, SGA, and Disk I/O by utilizing Oracle Enterprise Manager and monitoring the Stats pack report generated from snapshots taken at the peak business hours.

Leveraged technical skills in troubleshooting performance issues through automated workload repository (AWR) and automatic database diagnostics monitor (ADDM).

Worked with Oracle through the use of My Oracle regarding major database issues / problems; as well as on Oracle public and private database link.

Systematically arranged job schedules in Crontab, which involved RMAN backup and other memory maintenance and security jobs.

SERCO-NA Fairborn, OH

Junior Oracle Database Administrator May 2009–Sep 2011

Rendered 24/7 production database and applications support.

Keenly assessed database products and third-party tools for the project.

Established database environments for the Dev and Quality Assurance teams.

Proactively participated with the migration of the database from Oracle 9i to Oracle 10g.

Generated database objects in alignment with the project requirement.

Conducted table space analysis, space allocations for tables, and rollback segment monitoring and as member of the Application Development Team.

Instigated complex business rules through database triggers and constraints.

Integrated and dropped users as well as formulated roles, profiles, and grants according to the role of the user.

Conceptualized and initiated database backup on development and preproduction databases.

Determined and created cost-effective solutions for poorly written queries.

Employed keen attention to detail in conducting diagnosis and preparing database and SQL statements as needed.

EDUCATION AND CREDENTIALS

Associate in General Studies: 2013 Prince George's Community College Largo, MD

Oracle Certified Associate 11gR2

Security + Certification: In Progress (Expected Date of Completion)

TECHNICAL ACUMEN

Operating Systems:

HP-UX 10.x / 11.x 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/2008 MS SQL Sever

Tools & Utilities:

RMAN OEM SQL*Loader EXP IMP data pump TOAD Oracle SQL Developer

Tuning Tools

RMAN TKPROF EXPLAIN PLAN STATSPACK AWR and ADDM

Languages:

SQL PL/SQL UNIX Shell Scripting PERL

Environment:

PeopleSoft HRMS/HCM 8.8 EXP IMP Data pump Oracle 9i/10g/11g/12c Sun Solaris 2.5

Others:

Remedy ConnectWise

Contact this candidate