PROFESSIONAL SUMMARY:

• 9 years of experience as an Oracle, SQL Server and Mongo Database administrator. My experience has scaled in providing client support, analysis, designing, development, testing, installation, migration, maintenance and administration for Oracle, SQL Servers and Mongo DB’s which included understanding the requirements, upgrades, performance tuning, backup & recovery, cloning and space management using ORACLE 12c/11g/10g/9i, MS SQL Server 2008/12/14/16 and Mongo 3.2 and performing the role of Database Administrator according to the set standards and timelines.
• 9 Years of experience in Oracle Database (DB) administration supporting very large database (VLDB) environments and mission critical low latency OLTP systems for Trading, Brokerage, Investment, Insurance, Security, Holdings, Global Markets and Education.
• 3 Years of experience in building and supporting MS SQL Server 2008/2012/2014/2016 Databases in Finance, HR (PeopleSoft) domains.
• 2 Years of experience in building and supporting Mongo 3.2 NoSQL Database on Wireshark Storage with multi datacenter stretched cluster with and without data sharding for low latency Dashboard applications.
• Experience in installing, configuring and supporting Oracle Databases on Exadata V2/V3 quarter, half and full RAC’s along with configuring RMAN image backups to ZFS storage.
• Experience in Database/SQL performance tuning using diagnostic tools like AWR, ADDM and ASH and tuning Database performance parameters accordingly. Experience in using Explain plans, SQL Baselines, SQL Tuning Sets, SQL Profiles and SQL hints with or without OEM.
• Experience in Oracle Database Upgrades for Software Obsolescence (EOL) projects and automated patching (PSU/CPU) from OEM 12c/13c for Standalone and RAC DB’s as part IT Sec Baselines. Upgraded legacy applications Databases from 9i to 11g/12c Databases.
• Experience in Oracle Database Migrations including VLDB’s for Datacenter moves and Business acquisitions and converting DB to established standards. Migrated DB’s from Solaris/AIX to Linux and to Exadata during consolidation projects. Migrated critical and non - critical DB’s from Physical to virtual servers as part of Virtualization projects.
• Supported Oracle Database on Linux, Solaris, AIX and Windows environments.
• Installed, Configured and supported Oracle 12c/11g RAC Databases including Multitenant DBs with ASM, ASM Clustered Filesystem (ACFS) and 10g Clusterware with OCFS and VCS Clustered FS.
• Installed, configured and supported SQL Servers 2008/12/14/16 with SSMS, SSRS and SS Agents.
• Installed, configured and supported Oracle 12c/11g Databases on Active-Passive Clusters using VCS along with implementing stretched VCS clusters (Low Latency DR Solution) between multiple Datacenters with SRDF storage replication.
• Configured SQL Server backups using TSM Storage admin and SSMS Maintenance Plans.
• Worked on SQL Server 2008/12/14 SP3 and Critical patches as per IT Sec guidelines.
• Implemented DR for SQL Servers using SQL Mirroring with High Protection/Performance mode along with SRDF for physical and SRM for Virtual servers.
• Supported MS SQL DB’s on SQL Server clusters 2012/14 with mounted Filesystems and SRDF replications and VCS Stretched SQL Clusters using SRDF technology.
• Installed, configured and supported Mongo 3.2 DB on Wireshark with 3 node replica sets with each node in different Datacenters and few replicas with two node data nodes and 1 Arbiter.
• Installed, configured and supported MongoDB Ops Manager 3.4 for monitoring and support.
• Installed, configured and supported Disaster recovery (DR) solutions using Oracle DataGuard technology for Physical/Logical Standby Databases with or without Real-Time apply. Other supported DR solution are SRDF for physical servers and VMWare SRM for virtual servers.
• Configured and supported Database replication using real time replication technologies like Streams and GoldenGate and also supported Materialized view refreshes.
• Expert in backup/recovery/cloning strategies using RMAN disk and Direct to Tape (TSM) backups, along with implementing Data Domain (DD Boost) client side dedupe Backups, ZFS backups and LAN Free TSM backups. Configured and supported DB cloning for VLDB using Delphix engine.
• Installed and configured OEM 12c/13c with SNMPV1 Trap monitoring for DB’s.
• Experience in writing/debugging PL/SQL Stored Procedures, Triggers along with various scripting languages such as Perl, awk and Shell Scripting for Infrastructure automation.
• Experience in configuring, supporting Oracle Advanced Security features like TDE for Table and Tablespace (Data at rest encryption) and Network data Encryption (in-transit data encryption)
• Worked on 24x7 environments including but not limited to follow the sun support models and on-call rotational support models for overnight and weekend production database support.
• Extensively used Service now, BMC Remedy and HP Quality Center ticketing systems for supporting.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris SPARC 9/10/11, AIX 5/6, RHEL 5/6/7 and MS SQL Server 2008/09/11/12/14/16, Windows XP/7, Macintosh 10.x

OS Tool: pidstat, mpstat, iostat, vmstat, top, topas, strace, ps, netstat, OSWatcher

RDBMS: Oracle 12c/11g/10g/9i, SQL Server 2008/10/11/12/14/16

NoSQL: Mongo 3.2

Tools: and Utilities: RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard

Languages: HTML, CSS, PHP, Java, SQL, PL/SQL, Shell Scripting, AWK scripting, Perl

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL Tuning sets, SQL Baselines, SQL Profiles, SQL Real Time Monitoring

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Oracle/SQL/Mongo DBA

Responsibilities:

• Provide Day-to-Day Production and non-Production support for more than 1000 Databases including Oracle, SQL Server and Mongo Databases with 24x7 on-call rotation model.
• Provide performance tuning support for OLTP and VLDBs scaled between 6 to 40 TB with or without STAR schema, partition pruning by using diagnostics tools like AWR, ASH, ADDM and Performance packs like SQL Tuning advisor, SQL Baselines, SQL Tuning sets, SQL profiles, SQL Hints and Explain plans on 11g/12c RAC DB’s, VCS Clusters and Standalone Databases.
• Provide support on DB service outage calls due to Infrastructure slowness or failures which includes and not limited to IO slowness, Network slowness, Server resource bottleneck and perform end to end diagnostics and provide immediate fix following by RCA.
• Proficient in using OS tools for Server performance stats like pidstat, mpstat, iostat, vmstat, top, topas, strace, ps, netstat, OSWatcher, osbb, traceroute, tcpdump
• Installed, configured, scripted and documented Data Domain (DD) Boost for client side dedupe RMAN backups for VLDB scaling between 5 TB to 40 TB.
• Installed and supported Oracle 4, 2 node RAC 12c with DR setup using real-time apply Dataguard (Availability/Performance) and SRDF technologies. Implemented VCS Stretched cluster between Datacenters for Low Latency DR configuration.
• Migrated and Upgraded legacy Databases based on 9i/10g to 12c from non-ASM to ASM and vice versa with or without 12c RAC multitenant (CDB/PDB) Database architecture and cross-platform with endian conversion.
• Installed, Configured and Managed Oracle Enterprise Manager Cloud Control 12c/13c
• Migrated traditional monitoring system to OEM Incident Management and automated ticketing system by delivering SNMPv1 traps to CA Spectrum and Geneos Monitoring Systems.
• Migrated Databases from traditional Auditing to 12c Unified Auditing using custom policies.
• Developed and documented platform independent and DB version independent Perl based utility oracle manage (OM) to integrate Oracle services (Database/Listeners/Agents) auto shutdown and startup when Server recycles and send notifications.
• Implemented and documented Oracle Database Patch automation using EM12c/13c to perform PSU/CPU patching.
• Installed, configured and supported SQL Servers 2008/10/11/12/14/16 with SSMS, SSRS and SS Agents.
• Configured SQL Server backups using TSM Storage admin and SSMS Maintenance Plans.
• Worked on SQL Server 2008/12/14 SP3 and Critical patches as per IT Sec guidelines.
• Implemented DR for SQL Servers using SQL Mirroring with High Protection/Performance mode along with SRDF for physical and SRM for Virtual servers.
• Supported MS SQL DB’s on SQL Server clusters 2012/14 with mounted Filesystems and SRDF replications and VCS Stretched SQL Clusters using SRDF technology.
• Installed, configured and supported Mongo 3.2 DB on Wireshark with 3 node replica sets with each node in different Datacenters and few replicas with two node data nodes and 1 Arbiter.
• Installed, configured and supported MongoDB Ops Manager 3.4 for monitoring and support.
• Supported Annual DR Test drive using Dataguard, SRDF, SRM and SQL Mirroring DR Solutions.

Environment: Oracle 12c/11g/10g/9i, SQL Server 2008/10/11/12/14/16, Mongo 3.2, Sun Solaris, Red Hat Linux, AIX, SQL Developer, RMAN, Dataguard, Golden Gate, OEM, Grid Control, STATSPACK, AWR, Explain Plan, SRDF, SRM, VCS Cluster, DD Boost, TSM

Confidential, NJ

Oracle/SQL DBA

Responsibilities:

• Installed, configured and maintained Oracle Databases 9i/10g/11g/12c on Real Application Cluster (RAC) with ASM and without ASM.
• Installation and maintenance of Oracle 9i, 10g, 11g, 12c Data Guard.
• Supported 11g Grid and Databases on Exadata V2/V3 Database Machines.
• Involved in consolidation of multiple Databases on to Exadata Database using Datapump.
• Configured and Managed Oracle Enterprise Manager 11g to monitor more than 1400 Targets
• Standby database setup via Dataguard for Database Disaster Recovery.
• Backup and recovery using RMAN, Datapump and Export/Import.
• Provided backup/recovery, problem diagnosis, performance tuning, and database upgrade support.
• Providing technical support to Application Support team for performance and database related issues.
• UNIX shell scripting as and when required based on the requirement.
• Dataguard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Creating and maintaining the Oracle databases.
• Created and managing the database objects such as tables, indexes and views.
• Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
• Applying patch set and interim patches whenever required to make the database software up to date.
• Installed, configured and supported SQL Servers 2008/10/11/12/14/16 with SSMS, SSRS and SS Agents.
• Worked on SQL Server 2008/10/12 SP1/2 and Critical patches as per IT Sec guidelines.
• Implemented DR for SQL Servers using SQL Mirroring with High Protection/Performance mode
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Manage users, privileges, profiles, and schemas using Grid Control of Oracle Enterprise Manager.
• Installed11g/12c agents for new OEM 11g and EM12c.
• Worked on special project for Database Risk Analysis. Worked independently to design/develop and deploy the project using APEX, Crystal reports and PL/SQL development on SQL Developer/TOAD.
• Developed automated scripts using Perl and Shell scripts to perform Database backups, Auto shutdown/startup and Monitoring.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Performed Database and SQL tuning by using various Tools like AWR, TKPROF, EXPLAIN PLAN, and optimizer hints.

Environment: Oracle 12c/11g/10g/9i, Exadata, Sun Solaris, Windows NT / 2000, Red Hat Linux, PeopleSoft, Data Mover, Application Designer, TOAD, RMAN, SQL server, Data Guard, Golden Gate, OEM, Grid Control, STATSPACK, AWR, Explain Plan, APEX, Crystal Reports.

Confidential

Jr. DBA and Web Developer

Responsibilities:

• Administrating SIU Oracle Production OLTP Databases, which are supporting several applications on Linux platforms.
• Involved in installation, configuration and maintenance of Oracle Databases 10g/11g and MySQL 5.1.
• Performed Oracle databases upgrades from 10g to 11g and MySQL.
• Daily backups and recoveries and schema refresh using Database dump extracts as required.
• Manage Users, Privileges, Profiles, and Schemas using Oracle Enterprise Manager along with command line interface.
• Responsible to maintain Oracle/MySQL databases for web applications and Content Management Systems running on WordPress and Joomla.
• Develop and coordinate with Student Employees to build University WordPress and Joomla templates and webpages along with supporting IT CMS/HTML websites.
• Develop, document, and implement security configuration for Oracle software and database instances to comply with existing standards.
• Involved in gathering requirements from end users and design an optimal schema design.
• Develop/maintain University Network Engineering website using PHP, HTML, CSS, SQL and PL/SQL.
• Develop/maintain an online ticketing system for RezNet Move-In Project web interface to handle customer requests using PHP, HTML, CSS and MySQL
• Installing/Maintain Linux Operating Systems RHEL 4, CentOS 5/6 with required services, security and secured web communication using SSL.

Environment: Oracle 9i/10g/11g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, Quest Performance Analysis, Quest Space Management tool, DB Artisan, Toad, PL/SQL Developer, OEM, Windows NT/XP

Confidential

Oracle Developer/ Jr. DBA

Responsibilities:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 10g, 9i on Sun Solaris and Windows 2003, Redhat4.
• Installation, setup and configuration of Dataguard.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Performed Data Migration as a part of enterprise data warehouse project.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Implemented schema level, table level and bidirectional oracle streams.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.

Environment: Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, STATSPACK