SUMMARY:

• Senior Oracle DBA with over 10 years’ of IT experience with last 9 years’ of Oracle and SQL DBA experience along with Strong Hands - on Experience in PL/SQL Development and MSBI (SSIS, SSRS, SSAS). In a typical day, I manage multiple projects at different stages of Development, with different resource levels.
• Maintain legacy applications, design and implement solutions, help with projects or application installs and assist with compliance & s. Establish internal auditing of processes and monitor internal s to allow talented individuals move up the ladder. I have always focused on understanding the main business and a solid team effort in providing a technology edge and exploring any viable niche in the industry; this has allowed me to implement cross-industry solutions. I have been on both sides of outsourcing business and developed a good understanding where to avoid too much outsourcing and how to save cost without compromise on quality.
• Install/manage RAC with up to 12 nodes on Linux Red hat and Exadata platforms*.
• PeopleSoft and Oracle upgrades, patches, recoveries workarounds and troubleshooting.
• Heavy use of partitioning and sub-partitioning with periodic archival to optimize*.
• Hot/Warm/Cold backup strategies using RMAN with Veritas or Data Protector Solutions.
• Using Flat-file, data pump/SQL Loader with ftp to interface legacy systems with oracle,
• Database conversions to exchange formats such as CSV, XML, HTML, even XLS etc.
• Standby/GGS replication and materialized view
• Builds and manages entire virtualization environment, spanning several countries, and over 200 hypervisors in VMware
• Strong experience working in large scale enterprise environment containing OLTP and OLAP systems encompassing many terabytes of data.
• Exadata X4/X5-2 Full Rack server, ½ Rack and ¼ Rack with ASM as storage management. Worked on multiple clients for consulting firm and Involved in managing multiple databases up to 50TB OLTP and 100TB OLAP databases
• Performance Tuning using oracle or third party tools and scripts, adding lots of value*.
• Performance monitoring and alerts using AWR, OEM, Grid control, OEM 12c etc.
• Installed & Configured Oracle Weblogic 12c, Golden gate Monitor 12.1.3.0 and Golden gate Veridata 12.1.3.0 and Configure Repository Database with Server/Agent configuration.
• Extensively involved in Data Encryption, Data Masking and Developing Governance processes for protecting critical data.
• Configured Database Vault, Audit Vault and did Web Content List partitioning of UCM Secure Files Data with encrypt option.
• Work with Application teams like Siebel, GIS and flex pay for performance related issues
• Client installation in application server and tns-entry update in OID, OUD, tnsnames.ora file and troubleshooting connectivity from application server to database.
• Setup and configuration of ASM on multiple RAC instances. Setup TDE for data encryption. Setup of OVD to support single sign-on. Migration of EDW database from 11g running on AIX to Exadata Full Rack X5.
• Proficient with Native Backups, Ola Scripts, Avamar, Symantec, and Doubletake.
• Implemented Database Security Compliance Standards using Database STIGs
• SQL server 2000/2005/2008 install, configure, backup and recovery.
• Created scripts to assign values to variables at runtime.
• Worked with Integration Services Event Handlers, Log Providers.
• Reviewing/Validating Data across all the Source and Target databases as the ETL Packages Execute.
• 24x7 Mail and On Call support to clients in DEV, QA and PROD Environments.
• Logging the DTSX\SSIS packages to maintain consistency between source and target.
• Good knowhow of Oracle Storage Internals & dealing with dumps and crashes.
• Tuning at various levels starting at Hardware, then System, Database and SQL.
• In-depth knowledge of SQL server 2008/2012 and above with SSIS/SSRS.
• Experience with migration of SQL2000/2005 to newer versions.
• Experience in Configuring and Scheduling Backups, Recovery and Restoration using SQL Server Agent and LiteSpeed for SQL Server.
• Experience in SQL Server Upgradation, Migration and applying Cumulative updates and Service Packs.
• Experience in Analyzing the performance using SQL Server Profiler and Monitoring using Activity Monitor, System Monitor.
• Ability to execute performance monitoring and necessary adjustments.
• Proactively monitor databases and identify potential problems.
• Enforced all database architecture and relevant procedures according to established policies.
• Hands on Exp in Creating, troubleshooting and deploying SSIS/SSRS solutions for data exports/imports and reporting needs.
• Familiarity with Microsoft clustering SQL databases and disaster recovery solutions.
• Position will report to the Senior Database Administrator.

TECHNICAL SKILLS:

Technology and Tools: Oracle 12c/11g/10g Core DBA Exadata Golden Gate RAC RMAN PL\SQL Data Guard Data Pump SQL Server ASM Backup\Recovery Data Security GRID Data warehouse(ETL) Clusters Shell\Perl UNIX\Linux Data Migration Tuning SIEBEL Remedy OBIEE Double take Database vault ESB AWS(CLOUD) Oracle Web Logics Audit vault OEM MSBI (SSIS, SSAS, SSRS) VMWARE AWS(Amazon web services)

PROFESSIONAL EXPERIENCE:

Confidential, Sterling, VA

Sr. DBA

Responsibilities:

• Configure, Maintaining and troubleshooting Exadata Cell disk/Grid Disks
• Patching Storage server using PATCHMGR utility (OFFLINE/ONLINE).
• Migrating databases from NON-EXADATA to EXADATA.
• Configuration Standalone and Cluster databases on exadata.
• Troubleshooting Exadata smartscan/offloading issues
• Monitoring the InfiniBand Switches/ports, DB/CELL nodes and IB topology
• Troubleshooting Infiniband/RDS performance issues
• Enabling Hybrid Columnar compression. HCC
• Hands on Dcli and CellCli utilities
• Patching Database using OPATCH AUTO
• Backing-up database machine Using LVM sanpshot
• Configuring IORM/DBRM and Implementing Oracle Exadata best Practices
• Setting and Monitoring Exadata using OEM12c
• Bare metal restores of Exadata DB node and CELL node
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues
• Monitoring Exadata hardware using ILOM
• Installing and configuring Oracle 11g, 12c Grid infrastructure.
• Configuring SCAN, VIP, Private and Public IPs
• Experience on Cluster utilities OCRCONFIG, CRSCTL, SRVCTL and CRS
• Finding root Cause for Cluster issues like node eviction, Storage and network.
• Adding Service for Load balancing.
• Setting up local and remote listeners.
• Backup of CRS binaries.
• Cloud Computing Oracle Java cloud, Microsoft Azure, Amazon Web Service (AWS
• Experience in Cloud Computing (Oracle Java cloud, Microsoft Azure Knowledge in AWS (Amazon Web Service)
• Evaluate running Oracle Database on AWS (Amazon Relational Database Service (Amazon RDS), and Amazon Elastic Compute Cloud (Amazon EC2)
• Install/configure Oracle Enterprise Manager 12c cloud control.
• Configuring and Managing OCR and Vote disk
• Datagurd setup for Cluster environment.
• Goldengate setup for RAC environment.
• Adding/Deleting/Relocating Instances, DB, listener, Services
• Installing and configuration of Oracle databases 9i, 10g, 11g, 12c.
• Upgrading, cloning, refreshing and migrating oracle database.
• Migrating database using RMAN, DATAPUMP, DATAGUARD and GOLDENGATE.
• Migrating databases from non-pluggable to pluggable databases.
• Configuring multiple container databases under single oracle home and configuration listener.
• Migrating NON-ASM, NON-RAC database to ASM and RAC databases.
• Configuring databases on SUSE Linux cluster
• Data encryption and Database security using database Vault and wallets.
• Working knowledge on Active directories, Oracle single sign on.
• Experience data modeling using Erwin tool. Physical and logical designs, reverse and forward engineering
• Replicated databases using Oracle Streams and Data Guard for reporting purposes in OLTP environment with minimum lag.
• Design data security and/or backup/recovery programming specifications that meet security requirements.
• Configuring database backups using RMAN, DATAPUMP, HOT and COLD backups.
• Performance tuning and identifying Bottle Necks at Query, database and OS level.
• Analyzing Stats pack, TKPROF AWRR, ASHR and ADDM identifying Bottle necks
• Migrating database using Transportable table space.
• Strong experience working in large scale enterprise environment containing OLTP and OLAP systems encompassing many terabytes of data.
• Exadata X4/X5-2 Full Rack server, ½ Rack and ¼ Rack with ASM as storage management. Worked on multiple clients for consulting firm and Involved in managing multiple databases up to 35TB OLTP and 50TB OLAP databases
• Design databases for HIGH availability using data guard setup logical and physical.
• Configuration of data guard Broker.
• Applying Rolling and Roll off Patches databases using OPATCH, OPATCH AUTO and OPLAN on Standalone and Cluster environment.
• Builds and manages entire virtualization environment, spanning several countries, and over 200 hypervisors in VMware
• Had fixed several performance tuning issues which relates to RAC & standalone databases by recommending better solutions that could save cost, virtualization, and resources.
• Installing and configuration OEM 12c, Pushing agents and different Operating systems
• Registering databases with 12c OEM and creating Monitoring templets and setting notification and incident rules.
• Siebel Admin responsibilities (user creation, DB extract, repository compilation)
• Replicating data using materialized views and golden gate.
• Install, configure and support GoldenGate uni-directional and bi-directional Oracle-to-Oracle replicated
• Experience in cross platform Database Migration and Upgradation.
• 24x7 Mail and On Call support to clients in DEV, QA and PROD Environments.
• Extensively involved in Data Encryption, Data Masking and Developing Governance processes for protecting critical data.
• Configured Database Vault, Audit Vault and did Web Content List partitioning of UCM Secure Files Data with encrypt option.
• Implemented Database Security Compliance Standards using Database STIGs
• Monitoring GoldenGate activities using 12c OEM and Veridata.
• 10g/11g replication to remote sites (active/passive and active/active) for disaster recovery, change data capture, platform migrations & load balancing.
• Implemented GoldenGate for Active-Active Replication between the Datacenter for High Availability.
• Experience in implementing Oracle internet Directory.

Confidential, Baltimore, MD

Sr. Analyst

Responsibilities:

• Design: Conceptual Data Modeling, Enterprise Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, Operational Data store Design, Data mart Design, Metadata Management
• Implementation: 12c Grid and database on Linux 6.
• Oracle database administrator: Database administration, Performance tuning, database creation RAC & NON-RAC (using Oracle utilities and Manual)
• Backups: RMAN, Data pump, Export/import and user managed
• Migration: Cross-platform, different servers, NON-ASM and NON-RAC to RAC.
• Upgrade: Database Upgrades, Database Upgrade from 10g to 11g Using RMAN.
• DR Configuration bet ween Data Centers (Automatic Failover, Snapshot database).
• GoldenGate Bi-directional Configuration
• Patching: CPU/PSU Patches on RAC and NON-RAC
• Oracle Security worked on data encryption wallets
• Capacity planning: Designing database
• Reports: AWRPT, ASHRPT, ADDM, Statspack.
• Oracle Applications Backup & Recovery Best Practices
• Oracle Applications Performance Best Practices
• Oracle Applications Security Best Practices
• Oracle Applications Concurrent Managers Best Practices
• Oracle Applications Purging Strategy Best Practices
• Integrate Oracle Applications with Custom Application
• Oracle Applications Workflow Notification Mailer Configuration
• Design and Develop data sync methods, write ESB based ETL jobs using Talend, PLSQL packages, Shell scripts, SQL Loader, External tables to accommodate average daily feed size of 0.5 - 3 billion.
• Articulate Data Modeling duties, evaluate, engage data from external / internal ERP, CRM systems to Data ware house and Data marts systems.
• Create ERDs, CDMs, LDMs, PDMs, database objects, perform data mapping and data cleansing routines for quality.
• Observe and Comply for GLB compliance for hosting consumer data in various Oracle and SQL Server
• Create and Follow up Service Requests with Oracle Support for Technical Support
• Working with the Development Team to fix the problems in Applications
• Monitoring Health Check of servers by background process and by using OEM
• Maintaining Application Security and Database Security
• Experience data modeling using Erwin tool. Physical and logical designs, reverse and forward engineering.
• Worked extensively with configuring database backups in RMAN environments using TSM, Net App backup utilities.
• Performing Backups, Cloning and Refresh with Delphix for Oracle Databases.
• Experience on VMware Workstation to install different Operating systems, Software’s and Disk partitioning.
• Installed and configured Active/Passive clusters on SQL Server 2008/2012 versions.
• Design data security and/or backup/recovery programming specifications that meet security requirements.
• Extensively involved in Data Encryption, Data Masking and Developing Governance processes for protecting critical data.
• Experience in cross platform Database Migration and Upgradation.
• 24x7 Mail and On Call support to clients in DEV, QA and PROD Environments.
• Configured Database Vault, Audit Vault and did Web Content List partitioning of UCM Secure Files Data with encrypt option.
• Implemented Database Security Compliance Standards using Database STIGs
• Managing Users, Responsibilities and Profile options
• Siebel Admin responsibilities (user creation, DB extract, repository compilation)
• Installed Microsoft SQL Enterprise Server 2008/2 bit version on windows 2008 R2 Servers.
• Installation of Oracle 11g Real Application Cluster(RAC) release 2 and Oracle 12c Databases Linux RHEL5, also created Oracle 11g DB on AWS cloud servers using templates.
• Performed and applied Microsoft SQL service pack and windows service pack to upgrade.
• Implementation of SQL logins, Roles and Authentication modes as a part of security policies for various categories of user.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Performing Backup and Restore operation from Production Server to UAT and DEV.
• Involved in implementation of log shipping for disaster recovery.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Performance testing on stored procedures, indexing and Triggers.
• Involved in trouble shooting and fine tuning of database for its performance and concurrency.
• Monitoring SQL server Error logs, Disk Space growth, Clustering Environment.
• Monitoring and making recommendations for performance improvement in hosted databases which involves index creation, index rebuilding, defragmentation, file group modifications and adding scheduled jobs to re-index and update statistics in databases
• Installation and configuration of Linux for new build environment.
• Virtual Machine administration on VCENTER.
• Linux SuSe Cluster Administration.
• Creating Logic Volume Partitions and File System Administration.
• NFS configuration & administration.
• Monitoring & troubleshooting with performance related issues.
• Installation of patches and packages.
• Configuring and managing network interfaces.

Environment: SQL Server 2008 R2, Oracle 10g/11g, T SQL, SSRS, MS Visual Studio 2008, SQL Server BIDS, Remote Desktop Connection (RDC), SharePoint, Secure Access SSL VPN, TFS, Windows Server 2008 R2, and Windows 7 Enterprise, MSBI (SSIS, SSAS, SSRS).

Confidential

Sr.DBA

Responsibilities:

• 24x7 support for Production databases and applications.
• Installation, configuration and administration of Oracle 10g/9i databases.
• Implemented Oracle 10g RAC and Standby Databases for High Availability and Disaster Recovery.
• Applied patches to Oracle databases.
• Work with Application teams like Siebel, GIS and flex pay for performance related issues
• Client installation in application server and tns-entry update in OID, OUD, tnsnames.ora file and troubleshooting connectivity from application server to database.
• Setup and configuration of ASM on multiple RAC instances. Setup TDE for data encryption. Setup of OVD to support single sign-on. Migration of EDW database from 11g running on AIX to Exadata Full Rack X5.
• Upgraded databases from 9i to 10g, 10g to 11g, and 9i to 11g.
• Siebel Admin responsibilities (user creation, DB extract, repository compilation)
• Performing upgrades of the databases and software to new releases.
• Monitoring growth of the database objects.
• Experience in cross platform Database Migration and Upgradation.
• Regular Monitoring Alert Files on Day to Day Basis OVD
• Migrating schemas from development to test and test to production databases.
• Created index or rebuild index in order to improve query performance in Oracle.
• Managed System Users, security and system monitoring for development / production environment.
• Backup and Recovery of the databases using RMAN and Conventional Hot and Cold backups.
• Performed installation, configuration, deployment, migration and up gradation of oracle database servers.
• Implemented materialized views.
• Load data using SQL*Loader
• PL/SQL Programming.
• Cloning of databases from production to development and test.
• Performance monitoring and tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).
• SQL, PL/SQL Programming. Developed PL/SQL functions, procedures, packages and triggers.
• Performed Database security and Auditing.

Environment: Oracle 10g RAC/9i/8i, Citrix Xenapp4.5, Oracle Application server, Oracle web logic, Red Hat Linux, HP-UX, OEM (Grid Control), SQL, PL/SQL, TOAD, RMAN, ASMTKPROF, STATSPACK, AWR, ADDM, SQL* Loader, EMC, SAN, NETAPP

Confidential

Sr.DBA

Responsibilities:

• Configured, implemented 10g RAC with ASM disk on Linux servers·
• Performed several RDBMS upgrades from 8i to 9i, 8i to 10G, 9i to 10G and 7.x to 8i on AIX 32 bit and 64 bit platforms·
• Expert in 10G Oracle RDBMS installation on Linux platforms (32 and 64 bit), upgrade, configuration, backup, recovery, archiving & purging activities
• Used stats pack report to tune materialized views by creating materialized view logs to enable fast refreshes on master tables.
• Created physical standby database from hot backup of primary database
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Setup physical standby on a 9i database to protect mission critical from any failures, errors or corruptions·
• Cross platform Database Migration and Upgradation.
• 24x7 Mail and On Call support to clients in DEV, QA and PROD Environments.
• Configured a cold-failover for 9i and 10G database using Sun clusters. 3.1·10G RAC switchover and failover configuration, implementation, and testing·
• Installed Oracle 10G RAC on Linux platform using ASM for a storage manager·
• Provided performance tuning on a 10G RAC database on a Linux platform·
• Installed Oracle 9i RAC in a Unix environment for multiple nodes·
• Configured a 10G database in a non RAC environment using Sun clusters· Tuned 10G RAC.

Environment: Oracle 10g RAC/9i/8i, Citrix Xenapp4.5, Oracle Application server, Oracle web logic, Red Hat Linux, HP-UX, OEM (Grid Control), SQL, PL/SQL, TOAD, RMAN, ASM, TKPROF, STATSPACK, AWR, ADDM, SQL* Loader, EMC, SAN, NETAPP

Confidential

PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Installation scripts for all the deliverables.
• Siebel Admin responsibilities (user creation, DB extract, repository compilation)
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Experience in using various oracle Pl/Sql collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2 Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Involved in migrating database from Oracle 9i to 10g database.
• Involved in developing screens and generating reports.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, Data Pump, Erwin, Informatica, SQL Developer, SQL Navigator, TOAD, UNIX/LINUX, Windows.