SUMMARY:

• Database Administration, Performance Tuning, Architecture and Security.
• Experienced Database Administrator and IT security professional with 8 years of experience.
• With a background in engineering, she possesses comprehensive knowledge of database design, database migration and upgrades, database backup & recovery, as well as more advanced administration tasks such as cloning, replication, and security protocol implementations.
• Confidential is proficient in several versions of Oracle - Oracle 10g, 11g and 12c.
• She demonstrates excellent oral + written skills, a strong work ethic and can-do positive attitude for outstanding team building and performance.

CORE COMPETENCIES:

• Database Security & Patching
• Backup, Restore & Disaster Recovery
• Performance Monitoring & Tuning
• Upgrades & Migration
• Project Management.
• Oracle ASM & Grid control
• Oracle Data Guard
• Installation, configuration, capacity planning
• Creative Thinking & Problem Solving
• Clear Communication

ORACLE TECHNICAL SKILLS & TOOLS:

• Conversant with various operating systems: MS Windows Servers, UNIX (Solaris 8/9/10), LINUX (Red Hat)
• Installation, configuration and update of Oracle 11g and 12c using OUI.
• SQL, PL/SQL, UNIX Shell Scripting.
• Database security. STIGs implementation and POAM development
• Database migration using Exp/Imp/Data Pump, and SQL Loader. Backup & Recovery using RMAN.
• Oracle ASM (clusters) and RAC configuration and administration.
• Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR)
• Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control.

EMPLOYMENT PROFILE:

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Deployed Database security policy and installation using passwords, privileges and user profiles. Implemented Oracle Transparent Data Encryption (TDE) to encrypt logical structures. STIGs implementation, developing POAMs.
• “Triple A” (AAA) security strategy, database auditing policies including data redaction/masking.
• Administered Oracle Physical Standby Database for single/multiple instances for high availability.
• Implemented backup strategy per company SLA; execution of backup schedule for physical/logical backups using RMAN and DATAPUMP utilities respectively. Block change tracking (BCT) to cut backups time from 8hrs to 45mins.
• Supported daily admin, monitoring, tuning & troubleshooting for single instance on UNIX/Linux, (Databases 100GB - 21TB)
• Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, System Event Logs for unusual events and took appropriate action per company policies of incident reports.
• Performed database Refreshes from production environments. PL/SQL errors fixes, modified applications using PL/SQL
• Installed and configured software for Oracle 10g, 11g, 12c on Windows & UNIX platforms using Oracle OFA.
• Implement table/index partitioning to minimize downtime, increase disk load balancing & query speed for faster parallel query.
• Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases
• Experience migrating database objects from development through test and into production environments.
• On-call production support team for 24/7 production support.

Confidential, Maryland

Lead Database Administrator

Responsibilities:

• 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.
• Used range, hash and composite table partitioning which greatly decreased the downtime and SQL Execution time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared pool size and db cache size with the use of AMM and ASMM.
• 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.
• Used range, hash composite table partitioning which greatly decreased the downtime SQL Execution time.
• Performed instance tuning by changing init.ora parameters and managed region parameters such as shared pool size and db cache size with the use of Automatic Memory Management (AMM) and Automatic Shared Memory Management (ASMM).
• Configured Oracle tools like SQL*Net to access the database across the network
• Configure and manage ASM instances on Oracle 11g and 12c.
• Worked in a cross functional team that oversaw the Oracle RAC installation and configuration for Linux environments.
• Expert in working with PL/SQL including Procedures, Functions, Cursors and Triggers.
• Applied Oracle's quarterly Critical Patch Update(CPU/PSU application) using Opatch utility to install, test, and deploy patches to database instances
• Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database
• Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture
• Configure and manage CloudWatch alarms to monitor resources in AWS for Disk, Memory, and CPU utilization.
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, table/spaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.
• Participated with team work on performance tuning of end-to-end ETL integration processes in Talend environment.
• Worked alongside consultant to assist with implementing Talend solutions including best practices.
• Develop solutions in an agile/scrum development environment.

Confidential, Baltimore, MD

Oracle Database Administrator

Responsibilities:

• Provide administrative support and maintenance on Oracle 10g, and 11g installations, database creation, database security, database optimization and tuning.
• Provide and maintain high availability and disaster recovery using ORACLE DATA GUARD.
• Monitoring and Troubleshooting database performance using OEM, AWR, ADDM, and TOAD.
• Manage 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 (TDE).
• Implement Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.
• Perform backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.
• Install and administered GOLDEN GATE in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability, in a heterogeneous environment, also worked with EXADATA Machines for high performance and availability.
• Apply Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances.
• Apply quarterly security patches to all the databases. Apply security changes to the databases as per the department of State security(DISA) guide line.
• Participates in the 24/7 on-call DBA rotation schedule