SUMMARY

Confidential is an accomplished Oracle Database Administrator with over 6 years of extensive knowledge and experience in security implementations, database design, monitoring & tuning, migration, upgrades, patching, backup & recovery, database cloning, replication, high availability and disaster recovery solutions. Proficient in various platforms such as Linux, Unix, Windows, and various database systems such as Oracle 10g, 11g, 12c. Exceptional writing, verbal, analytical, and problem solving skills. An energetic achiever who can successfully prioritize and manage multiple projects, perform effectively well under pressure, and adapt to a fast - paced environment.

TECHNICAL SKILLS

• Oracle RDBMS 10.2.0.1, 11.2.0.1, 11.2.0.4, 12.1.0.2, 12.2.1.0, MySQL, and MS SQL Server
• Installation, configuration and update of Oracle 11g and 12c using OUI, DBCA, DBUA
• Plan, Statspack/AWR, ADRCI, ADDM, DRA, Dbms monitor, Alert Log, SQL Tuning Advisor, SQL
• Work with various operating systems like MS Windows Servers (2008, 2012, 2014), UNIX (Solaris 8/9/10), LINUX (Red Hat, Ubuntu, Centos)
• Database design X Installation & Data modeling
• Database migration using traditional Exp/Imp, Datapump, and SQL Loader, Transportable Tablespaces (TTS)
• Backup & Recovery using RMAN
• SQL, PL/SQL, UNIX Shell Scripting
• Oracle ASM (clusters) and RAC configuration and administration
• Oracle Golden Gate (Data Replication)
• Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR)
• Database security using TDE, Data masking, Patching, data redaction

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus .

Responsibilities:

• Support multiple databases running Oracle 11g and 12c on Linux platforms in all environments in multiple data centers.
• 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%.
• Executed SQL queries with pre-defined aggregated functions such as COUNT, MAX or MIN.
• Applied Oracle’s quarterly Critical Patch Update (CPU/PSU application) using Opatch utility to install, test, and deploy patches to all database instances.
• Performing Database Refresh from production to test and development environments using RMAN Duplicate.
• Proactively monitor the database systems to ensure secure services with minimum downtime.
• 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.
• Installed and administered Physical Standby databases to achieve high availability and disaster recovery solutions (DATA GUARD).
• Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 2012 (Database sizes range 100GB to 35TB).
• Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, 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.
• Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases.
• Generated shell scripts with developers to automate maintenance and backup jobs.
• 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.
• Part of the support team for 24/7 on-call production support.
• Generating Standard operating procedures (SOPs)

Confidential, New York, NY

Oracle and SQL Server DBA

Responsibilities:

• Excellent communication skills and great team player
• Created documentation on standard procedures and maintenance of existing DBs and routine tasks
• Configured alerts on database, system and application performance monitoring and notifications
• Participated in Change Management Control meetings and new project implementations reviews
• Participated in on call services during off hours and weekends
• Installed and configured various SQL Server and Oracle database software and maintenance tools
• Enforced DB security using passwords policy, Least Privileges Rule, profiles creation and Encryptions
• Participated in configuring Oracle DB backups using RMAN and Datapump
• Performed daily incremental and full backups oracle databases
• Created Oracle DB link, set up and configured ODBC (Data source)
• Participated in database Migration from Oracle 11gR2 to 12cR2 using DBUA and Datapump
• Performed Database cloning and refresh using RMAN and Datapump
• Participated in Oracle 11g Golden gate installation and unidirectional configuration.
• Performed daily management, administration, monitoring of oracle goldengate using ggserr.log and view command
• Used AWR, ADDM, ASH, Alert log, dynamic performance views, stats pack, DBMS STATS, Trace files, explain plan, System Event Logs to tune and analyze performance issues
• Participated in setting up Physical Standby Database from Active Database using RMAN Duplicate
• Performed Oracle Data guard quarterly switchover to DR site for validations and SLAs compliance
• Applied various security patches and updates on existing DBs and track update changes
• Used Sql server Management Studio (SSMS) to managed sql databases, objects creation, users’ logins, role access, backups, restore and other administration tasks
• Installed PostgreSQL software and create database.
• Schedule backup requested by vendor.
• Experienced in supporting Very Large databases, data redaction and data masking.