SUMMARY:

An accomplished, Senior ORACLE Database Administrator speak, write both French and English .IT security expert with over 10 years of experience with extensive knowledge and proficiency in Back & Recovery, monitoring & tuning, Migration, Upgrades, database design, Cloning, Replication, and Security Implementations. Proficient in an assortment of technologies including Oracle 10g, 11g and 12c, MySQL and MS SQL Server. He possesses exceptional written, verbal, analytical and organizational abilities. Proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions. An energetic achiever who can successfully manage multiple priorities and perform tremendously under pressure.

SKILLS:

Database management proficiency

TECHNICAL COMPETENCE:

• Backup and recovery using RMAN
• Data pump and export/import
• Transparent Database Encryption.
• Database upgrade and Migration
• Oracle performance tuning.
• Patch Set Management
• RAC
• Data Guard
• TDE, RMAN, DATAPUMP, EXCEL, T - SQL, MySQL, ETL(SSMS), Oracle RAC, Oracle Data Guard, TOAD, SQL Developer, Oracle Enterprise Manager, Oracle VM Virtual Box .
• MS WINDOWS
• UNIX
• LINUX

PROFESSIONAL EXPERIENCE:

Senior Database Administrator

Confidential, Washington, DC

Responsibilities:

• Providing administrative support and maintenance on Oracle 10g, 11g, 12c installations, database creation, database security, database optimization and tuning.
• Constructed database security policy using passwords, privileges, user profiles, Transparent Data Encryption to encrypt tables and Tablespaces; implemented auditing policies as well as data redaction and data masking.
• Designed backup strategies following company SLA; execution of backup schedule for both physical and logical backups using Rman and Datapump utilities respectively. Used block change tracking (BCT), reducing backup time from 5hrs down to 45mins. Resolved space issues with backup optimization, reducing storage costs by 20%.
• Championed database migration from 10g to 11g and upgrade using the Oracle Datapump . Cloned databases for testing using RMAN and DATAPUMP utilities for all database sizes.
• Installed and administered Physical Standby databases for a single instances to achieve high availability and disaster recovery solution (DATA GUARD).
• Supported daily administration, monitoring, tuning, and troubleshooting on single instance on Linux,(Database sizes range 100GB to 49TB).
• Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, Trace Files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports.
• Implemented table and index partitioning and materialized views to minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
• Configure and manage ASM instances on Oracle 11g
• Cloning schemas, objects and databases on new server using exports from 10g database and imported in 11g using DATA PUMP.
• Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
• Implementing, tuning and maintaining Oracle database using OEM Grid Control.
• Researched, tested, and made recommendations of data validation tools. .
• Created, tracked, and closed service tickets using REMEDY ticketing system and developed a defect prevention process including but not limited to root cause analysis and corrective action.
• Controlled all databases with high alertness to ensure peak performance, stability and reliability and availability.
• Monitor and tune Oracle database environments for improved system performance, ensure integrity and recoverability of Oracle database structures
• Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases.
• Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report. Participates in the 24/7 on-call DBA rotation schedule

Oracle Database Administrator

Confidential, Lynn, Florida

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, ASH, Explain Plan, 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 O patch 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 guide line.
• Participates in the 24/7 on-call DBA rotation schedule

Oracle Database Administrator

Confidential, Newyork

Responsibilities:

• Installed oracle 12c in Linux operating system and migrate databases from 11gr2 to 12c.
• Installation and configuration of oracle 11g standalone and RAC databases in Linux, Windows. Migrate and upgrade oracle 10g RAC databases to 11g. RAC databases are 2 - 8 nodes on RHEL.
• Followed System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
• Installed and configure the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replications.
• Tuned database for higher performance, analyze, explained and trace sessions for bottleneck queries, and configured instance optimal parameter setting.
• Supported daily Database call for maintenance and administration such as performance, connections, locks, refresh data and security issues.Worked with MONGO DB for temporal projects.
• Participates in the 24/7 on-call DBA rotation schedule