SUMMARY

• Over 12+ years of Information Technology experience which includes Hadoop Administration, Oracle Database Administration (12c/11g/10g/9i/8i) on different operating system environments like Sun Solaris, Linux, IBM AIX, HP UX /Windows 2000/2003/NT/2008, SQL Server 7/ 2000/ 2005/2008/2008 R2/2012 Administration, PostgreSQL and BigData applications.
• Experience in building and maintaining Hadoop Clusters.
• Worked on Pivotal HD 2.0 and Horton Works HDP2.3 Hadoop architectures.
• Experience in working wif Hadoop services like APACHE HIVE, HBASE, SPARK, TEZ, and PIG.
• Excellent skills in datanode/Cluster management using Hadoop/hdfs commands.
• Expertise in UNIX Shell scripting. Can set up Jobs to automate Map - reduce Jobs in APACHE Hadoop.
• Managed 100-node Hadoop cluster using HDP2.3 wif Automatic Failover of the namenodes.
• Expertise in PostgreSQL and GreenPlum database management systems which are used in our Hadoop Environment.
• Good Working Knowledge on GreenPlum Segment management and datanode/data segment expansions.
• Set up jobs to pull data from Multiple RDBMS into HDFS using SQOOP.
• Good Knowledge in monitoring Hadoop clusters using Nagios, Ganglia and Ambari tools.
• Worked on Upgrading Pivotal HD2.0 to HD3.0 using Rolling upgrade option.
• Worked on integrating APIs like Python, Java, and Scala to HDFS eco system.
• Expertise in adding, decommissioning nodes in a cluster wifout any service disruption.
• Expertise in Administering PostgreSQL 8.2 to 9.2 Databases for financial Analytics products.
• Comfortable in using Management tools like PgAdmin III, Talend to manage PostgreSQL databases dat are heavily used by Hadoop Ecosystems.
• Experience in Real Application Cluster (RAC) Setup and Administration. Involved in configuring and maintaining Oracle 3-node/2-node RAC for high scalability and availability.
• Expertise in configuring and maintaining Oracle Data guard for Disaster Recovery.
• Expertise in Installing Oracle Enterprise Editions until 12c on UNIX and Windows Servers. Good Working Knowledge on Grid Infrastructure, Weblogic Installations and maintenance.
• Experience in Creating Physical databases using Oracle ASM wif SAN at the back end
• Good practical exposure on Upgrading Oracle Software across multiple versions. Extensively worked on Conversions from one RDBMS to another (eg: SQLServer to oracle)
• Expertise in setting up of RMAN backup and Recovery strategies wif the halp of UNIX shell scripting.
• Clone/Refresh of Production databases for testing and Development environments using Recovery Manager (RMAN).
• Extensive noledge in using statspack, TKProf, Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for performance tuning.
• Expertise in working wif Oracle partitioning technology.
• Expertise in working wif loading tools like sqlldr, impdp, expdp, imp, exp utilities.
• Good Knowledge on VERITAS Netbackup, EMC and Netapps storage practices. Good understanding about Netapps Snap-manager for High availability solutions.
• Knowledge in setting up Oracle Enterprise manager (OEM) 12c/11g/10g. Installed OEM agents on UNIX/Windows platforms and configured the TARGETS in the repository for efficient monitoring of the mission critical Production databases.
• Extensive Knowledge in using Tools like TOAD, Putty, Confio, Attunity, FOGLight, embarcadero-DB Artisan, SQL Developer, OEM for SQL/Oracle performance tuning.
• Worked on Oracle Streams, Gloden Gate replication technologies and LOG Miner.
• Experience in handling Solaris, Red hat Linux, and Windows NT/ 2000/2003/2008/2008 R2 systems.
• Knowledge in downloading and applying Oracle Patches following CPU patch updates.
• Complete range of Oracle DBA activities including Day-to-day production database monitoring of alert logs, trace files Troubleshooting production issues and Performance Tuning issues.
• Installed & configured SQLServer database software (7/ 2000/20 ) associated database tools and performance monitoring software.
• Experience in Query Optimization and performance tuning. Strong in using SQL profiler to debug any issues.
• Good in T-SQL Programming skills.
• Expertise in setting up SQL Database Mirroring as Disaster recovery solution using various protection modes.
• Expert in creating and maintaining SQL Replication - Snapshot, Transactional and Merge. Worked on SQL to SQL and SQL to Oracle Replication.
• Expertise in migrating databases to amazon Cloud (Amazon workspace - AWS).
• Good working noledge in using SQLServer 2012 - Always On feature in Database Mirroring.
• Experience in setting up Log shipping on SQL 2000 and 2005 Servers.
• Performed several migrations from SQL 2000 to SQL2005, SQL R2.Currently involved in SQL 2008/2008R2 to SQL 2012 migrations.
• Extensive Knowledge on creating SSIS and DTS packages. Has trained developers to do the same.
• Experience in applying SQLServer Service Packs and latest Patches from Microsoft.
• Implemented MS SQL Mutli Node Cluster (Active/Active and Active/Passive)
• Setting up MSSQL Mail - DBMAIL and SMTP Configuration for sending mails from SQLServer.
• Extensive Knowledge on creating and maintaining SSRS reports and working wif SSAS Analysis services.
• Knowledge on using dbcc utilities to Reorg, Rebuild indexes and fine tune SQL queries.
• Expertise in using powershell scripting to control Backup, Restore and DBA maintenance activities.
• Good in using Database Engine tuning advisor, Dynamic Management Views (DMVs) and SQLServer dash boards while troubleshooting performance issues.

PROFESSIONAL EXPERIENCE

Confidential, Woodbridge, NJ

Sr. SQL Server / Oracle DBA /HADOOP Admin

Responsibilities:

• Installing and configuring PostgreSQL 8.2/9.2 databases for Analytics products.
• Worked on Backup, recovery and Performance tuning of PostgreSQL/GreenPlum databases.
• Working on installing and maintaining Hadoop Clusters (up to 1000 nodes).
• Working in HawqDB on Hadoop which is a port of Greenplum databases.
• Deploying Apache Software and updates on Pivotal HD2.0 and Horton’s HDP2.3.
• Worked on Setting up monitoring mechanisms for Hadoop Clusters using Nagios, Ganglia and Ambari.
• Writing Scripts to Pull Data from Oracle/SQLserver to HDFS using SQOOP.
• Optimizing HDFS Data Loads using Spark and TEZ execution Engines.
• Namenode, Datanode and client node set up and management dat includes Addition/Decommission.
• Setting up standard practices for Hadoop Security at multiple levels.
• Involved in Migration of SQLServer and Oracle Databases into AWS (Amazon Workspaces) Cloud.
• Responsible for providing end-to-end Cloud solutions for migrating Retail Applications into Amazon Cloud.
• Implemented logshipping, SQL Database Mirroring and Oracle Data Guard to SYNC databases in Cloud.
• Maintained Oracle 11gR2 RAC and SQLserver 2012/2008R2/2005 Clustering on UNIX and Windows platforms.
• Upgraded databases from Oracle 10g/11g to 12c, SQLserver 2000/20 .
• Set up Always On feature for SQLserver2012 by configuring availability groups as part of providing high availability solution.
• Performed Upgradation of Oracle OEM from Oracle 10g to oracle 11gR2.
• Designing and maintaining reports using SQLServer Reporting Services (SSRS).
• Building packages for in house projects using SSIS. Helping Developers solve any SSIS related issues.
• Installed Oracle and SQLserver RDBMS software on physical and virtual machines including Clusters.
• Tuning Oracle performance issues using Tkprof, Statspack, AWR, ADDM and ASH.
• Tuning SQLServer performance issues using SQL profiler, Database tuning advisor and tools like Foglight.

Environment: Sun Solaris, IBM-AIX, Oracle Linux Server(OEL), Windows 2003/ 2008R2, Oracle 11gR1/11gR2/12c, PL/SQL, shell scripts, Powershell, Foglight, SQL Server 2000/ 2005/2008/2008 R2 /2012, DB Artisan, SQL Developer, OEM 11gR2, Confio, PostgreSQL, AWS, PostgreSQL 8.2/8.4/9.2. HDFS, HawqDB, GreenPlum, Sqoop, PIG, HIVE, Spark.

Confidential, Roseland, NJ

Sr. ORACLE/SQL Server DBA

Responsibilities:

• Worked as Senior Database Consultant for Oracle and SQL Server.
• Involved in Migration of Sybase databases to Oracle and SQL Server environments for Wealth Management group.
• Established SQL Database Mirroring for SQLServer2008 R2 environment in maximum Performance Mode.
• Involved in Setting up Oracle DataGuard 11g as part of our Disaster Recovery Solutions.
• Upgrading Oracle database from 10g to 11gR2 and from 11gR2 to 12cR1.
• Installing SQLServer 2008, 2008R2 and 2012 on Windows Servers.
• Implementing Maintenance tasks using UNIX shells and Windows powershell 2.0/3.0.
• Setting up Oracle ASM. Worked on migrating oracle Physical files from UNIX file system to ASM.
• Maintaining Oracle 11g RAC on a 2-node cluster wif Oracle DataGuard set up.
• Setup and maintenance of SQLServer Clustering on Windows 2005 and 2008 Servers.
• Setting up Replication between SQLServer to SQLServer and SQLserver to Oracle environments.
• Extensive noledge on Setting up and maintaining Oracle Gloden gate Replication technology.
• Setting up and maintaining Log shipping in some of the SQLServer environments as a Business continuity solution.
• Upgrading SQLServer R2 and 2008R2 to SQLServer 2012 versions.
• Installing and configuring Latest Oracle Softwares on UNIX and Windows Servers.
• Installing and setting up of Oracle Grid Infrastructure, WebLogic and OEM 12c.
• Creating and maintaining Oracle table Partitions to enhance Oracle performance.
• Actively involved in Annual Disaster Recovery Testing for Oracle and SQLServer Databases.
• Well versed wif most of the financial jargon and actively involved in Coordinating wif Vendors for any product enhancements or Application issues.
• Tuning Oracle performance issues using Statspack, AWR, ADDM and ASH.
• Tuning SQLServer performance issues using SQLServer profiler, Dynamic Management Views (DMVs), Database tuning advisor and dashboards.
• Providing assistance to immediate manager on Cost and storage estimations for the next IT Budgeting.
• Performing DBA daily maintenance tasks and monitoring Jobs scheduled using AutoSYS.Good working noledge on AutoSYS
• Supported Vendor related applications such as Eagle Pace, SUMMIT, Eagle Wings, and ATOM.
• Worked on PostgreSQL 8.2/8.4 database Management for Financial applications.
• Installed and created PostgreSQL databases. Performed PostgreSQL database maintenance using PgAdmin tool.
• Upgraded PostgreSQL 8.1 to 8.4, 8.4 to 9.1 versions on Production systems.

Environment: Sun Solaris, IBM-AIX, Oracle Linux Server(OEL), Windows XP/2003/2008 and 2008R2, Oracle 10g/11gR1/11gR2/12c, PL/SQL, shell scripts, Powershell 2.0/3.0, Toad, SQL Server 2005/2008/2008 R2 /2012, embarcadero, SQL Developer, OEM 11gR2, Confio, WebLogic 10.2, PostgreSQL 8.1/8.2/8.4/9.1

Confidential, Springfield, MA

Sr. ORACLE / SQL Server DBA

Responsibilities:

• Worked as Senior Database Consultant for Oracle and SQL Server.
• Managing all DBA related tasks pertaining to Oracle and SQL Databases.
• Includes DBA daily tasks such as monitoring Database health, checking logs, solving Production issues.
• Capacity Planning, Trouble shooting and Pro-active maintenance.
• Setting up Oracle 10g DataGurad as a Business Continuity Solution.
• Designed Backup and Recovery strategies using Oracle Recovery Manager (RMAN).
• Managing Oracle RAC 10g 3-node cluster environment wif Load Balancing on LINUX server.
• Involved in Upgrading Oracle 9i/10g databases to 10g/11g Enterprise Database softwares.
• Tuning Oracle performance issues using Tkprof, Statspack, AWR, ADDM and ASH.
• Configuring Oracle Streams replication on Oracle 9i databases.
• Setting up SQLServer Replication - Transactional, Snapshot as a High availability solution.
• Setting up and maintaining Log shipping technology in SQLServer 2005 and 2008 Servers.
• Involved in Upgrading/Migrating SQLServer 2000 to SQLServer 2005 and SQLServer 2005 to SQLServer2008.
• Working wif Developers involving Integration Services(SSIS) and Reporting Services (SSRS)
• Working wif Data warehouse team by setting up SQLServer Analysis Service (SSAS) on 2005 Servers.
• Tuning SQLServer performance issues using SQLServer profiler and dbcc commands
• Maintained SQLServer 2005 Active-Passive cluster configuration in SQLServer 2005 environment.
• Had always been on Disaster Recovery team and involved in smooth completion of annual DR testing.
• Manage complex Production environments which include around 100 Production Database environments.
• Mentored Junior DBAs and documented all DBA duties to be performed.
• Installed and configured most of the Oracle and SQLServer Database software tools and utilities.
• Part of a highly talented Infrastructure Team. Responsible for supporting the entire IT infrastructure of the Company.
• Strict adherence to Change Control Procedures. Worked wif Audit Controllers of the clients, once every year.
• Worked on Several In-house Projects in Conjunction wif Systems teams and Business Partners. Actively participated in Project planning and execution phases.
• Supported major Vendor related applications such as Murex for accounting, Gloden Source for Securites, CDO etc.
• Regular Coordination wif DBA teams at OffShore Supporting Nightly activities.

Environment: Sun Solaris, LINUX, Windows XP/2003/2008, Oracle 9i/10g/11g, PL/SQL, shell scripts, Powershell, Toad, SQL Server 2000/2005/2008, embarcadero, SQL Developer, OEM 10g, Attunity, FogLight.

Confidential, Naperville, IL

Sr. Oracle DBA

Responsibilities:

• Preparing the DBA project plan, DBA project estimation and the execution plan
• Involved in setting up the Disaster Recovery plan for Business continuation.
• Involved in logical migration/transferring of around 50 databases spread across the world to the DataCenter
• Maintained around 60 production and 70 test instances.
• Supporting both production and development activities.
• Creating databases for Testing, Development and Production.
• Installing various versions of Oracle software in UNIX and Windows Servers.
• Involved in manual as well as Oracle RMAN backup and recovery
• Helping the Business users in creating the new database links.
• Restoring the data from the backup tapes.
• Database recovery / crashes using hot /cold backups and dump/loads.
• Configured and implemented Physical Standby DB using Oracle DataGuard.
• Reorganized existing database to de fragment database objects like tables and indexes.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Recovering the databases using point-in-time recoveries.
• Migration of the central databases from oracle 8i,9i to 10.2.0.2 version
• Developing UNIX shell scripts to automate the Database maintenance processes.
• Extensively used import/export utility to handle change requests.
• Coordinating wif Application teams while trouble shooting any Database related issues.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, statspack.
• Involved in 24x7 production support

Environment: Sun Solaris, IBM-AIX, Windows NT/2003/Xp, Oracle 8.1.7/9.2.0.4/10.2.0.1, PL/SQL, shell scripts, Toad, SQL Server 7.0/2000

Confidential 

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 8.0.5 /8.1.x on Solaris 2.6, Windows NT
• Creation of databases for Testing, Development and Production
• Every day lights on activities (Monitoring database and Operating system)
• Space management issues involving resizing table spaces, data files and rollback segments
• Migration of oracle 7.3.4 databases to Oracle version 8.1.5
• Created Database triggers and stored procedures
• Automate backup jobs (hot, cold and export) and performed regular test recovery to validate the backups
• Performance Tuning at Database Level.
• Provided 24x7support (on call) to all end users of the applications related to Databases.

Environment: Windows Servers, Sun Solaris, Oracle 7.x, 8i