PROFESSIONAL SUMMARY:

• Experience in installation, configuration and maintenance of Oracle 12c, 11g/10g RAC with ASM and single instance database.
• Perform Oracle database administration in a variety of environments including Oracle Linux, HP - UX, IBM-AIX, Sun Solaris, and RHEL.
• Experience in system monitoring and database performance tuning using Explain Plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Experience with Data Modeling
• Experience in RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• Experience in 12c Multitenant databases
• Experience in 12c container and pluggable databases
• Experience in Database Security including Oracle Vault, wallet and TDE.
• Managed Oracle server in high availability environments using failover, clustering, mirroring, Data Guard and cloning technologies.
• Build multimode RAC from scratch
• Migrated database from 10g to 11g by using scripts
• Experience in applied CPU and PSU patches
• Experience in database full backup (hot and cold), Incomplete Backup, Data Pump Export / Import, SQL backtrack and restore procedures.
• Experience in space management and capacity planning
• Experience in database creation with RMAN jobs and security implementations in Oracle.
• Experienced in setting up service load balancing in RAC
• Installed 12c Grid agent on servers and configured 12c OEM Cloud Control.
• Perform data loading using SQL*Loader and DBVERIFY for corruption checking.
• Build ASM Diskgroups and migrated from non-ASM to ASM.
• Upgrade databases from 10g to 11g R2 to 12c
• Worked with networking team to get IPs and configure SCAN listener for RAC.
• Performed tasks to gather database statistics
• Worked as SQL Server Database Administrator.
• Experience with new features including Flash Recovery, ASSM, AMM, ASMM
• Good experience in database creation, partitions, set up parameters, table spaces, indexes, user setup, roles, security, storage and hands on experience in network management.
• Experience of auditing, Oracle security, OEM, SQL Navigator and TOAD.
• Experience in Very Large Multi-Terabyte Database (VLDB)
• Worked with Performance Tuning tasks
• Worked on GoldenGate project.
• Experience in Building shell scripts to automate jobs.
• Worked with of offshore DBAs.
• Documented all Oracle database installations and database operations.
• Perform 24x7 production database supports to ensure availability, efficiency and recoverability.

TECHNICAL SKILLS:

Relational Databases: Oracle 12c, 11g, 10g, 9i, SQL Server / 2012

Operating Systems: Linux on Exadata, CentOS, Solaris, Windows, AIX, HPUX

Languages: SQL, PLSQLTools and Utilities:12c Cloud Control, RMAN, SQL*Loader, SQL*NET, TOAD, SQL Developer, exp, imp, impdp, expdp, srvctl, crsctl

Performance Tools: ASH, AWR, ADDM, Statspack, SPA, tkprof, OEM, explain plan

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Oracle DBA

Responsibilities:

• Build RAC Databases on Exadata
• Build Standby Databases using Oracle Data Guard.
• Installation of Oracle Database and Oracle products using silent install.
• Implementing Backup/Recovery Strategies on Exadata.
• Build 12c cloud control.
• Managed Databases on Exadata x3.
• Managed Materialized Views.
• Implementation of high availability of solutions with Oracle11g RAC and Data Guard.
• Setup unidirectional Oracle GoldenGate replication.
• Worked with Oracle on active issues using Oracle Support.
• Experience in replication using GoldenGate and Materialized Views
• Replication and Extracting data and applying on production database’s using Golden Gate
• Using Enterprise Backup utilities for backup.
• Written shell scripts (bash, korn) for backup and recovery.
• Database creation, Installation, patching and database upgrades.
• System tuning for better performance.
• Install SQL Server 2012
• Worked on SQL Server log shipping and backup/restore/recoveries.
• Applied CPU, PSU and one off patches using opatch.
• Used 12C OEM to run AWR reports, 12C MA agents registration
• Installed 12C MA Agents on Linux, AIX, and Solaris Platform.
• Creating packages and database triggers.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL procedures, tuning queries and
• Writing UNIX shell scripts for backup and recovery.
• Database/Schema Refresh as per client requirement.
• Managed databases on Linux and Windows
• Consolidate / migrated databases into one data center.
• Worked on Capacity planning.
• Provided 24/7 on-call support.
• Used TOAD and SQL Developer.

Environment: Windows 2012, Oracle 10g/11g/12c databases, 12c OEM, Shell Scripting.

Confidential - Richardson, TX

Oracle DBA

Responsibilities:

• Involved in 24x7 Production Database Administration and support.
• Data Refresh from Production to SIT/UAT/LT and Development environments using RMAN Duplicate Database.
• Setup, Configured and supported Physical Standby (Data Guard) databases for high availability and disaster recovery.
• Took Hot and Cold backups, Performed Full and Point in Time Recoveries using RMAN, investigated causes for failures and resolved them.
• Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases
• Created users, roles and granted privileges according to the business requirements.
• Migration of code from development to production instances, database space and file system space monitoring, purging of unwanted data and files.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Applied CPU and PSU patches.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Creating and refreshing materialized views, views, synonyms, and indexes.
• Developed UNIX Shell scripts for daily database logical backups, data retention, purging and other scheduled database procedures.
• Installed fog light and OS Watcher on various database servers.
• Evaluate and adjust Oracle database initialized parameters in init.ora file. Monitor and optimize database performance.
• Worked with Oracle support to resolve database critical issues
• Installed and configured Oracle 10g and 11g Real Application Cluster (RAC) Instances with stand by database (data-guard) using CRS and ASM.
• Added nodes to the RAC cluster for the increased load and removed it when not necessary.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Backup and Recovery using RMAN.
• Setting up and testing the Backup and Recovery strategies.
• Experience with SQL, PL/SQL, Shell Scripting.
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Successfully connected to OID using SSL.
• Subsequent implementation used Oracle Internet Directory (in order to extend the prototype for LDAP user authentication).
• Provided on-call support on 24/7