SUMMARY:

• 19+ years of total IT experience spanning Hadoop Administrator, Big Data Architect, Oracle Database Architect and Sr. Database Administrator.
• Experience in all aspects of Big Data Architect and Hadoop Administrator (Hadoop ecosystem design, Design data stage and data lake for enterprise data, Data Extraction from RDBMS, Data streaming from IOT, Data Ingestion into Hadoop ecosystem, Data Feeds to other internal systems and Data Analysis and Management, Data distribution and Processing for reporting purpose.
• Experience and implemented End - to-End Big Data projects with Financial Services and Insurance companies.
• Experience in Hadoop Admin, HDFS, Hive, HBase, Sqoop, Oozie, Zookeeper, Flume, Kafka, Pig, Yarn, Map Reduce, Syncsort, Splunk, Cloudera Manager.
• As a Database Architect/Administration experience, I have managed a team of database administrators in both Production and Non-production environments.
• Strong technical and hands on experience in Oracle 12c, 11g, 10g, 9i, 8i, Oracle RAC, Golden Gate, Data Guard, Oracle Exadata, Oracle Cloud, OEM 12c, RMAN, Expdp, Impdp, SQL Loader, SQL Plus, Performance Tuning AWR, ADDM and other utilities.
• Extensive experience in Oracle Database Administration, Installation, Configuration, Migration, Backup, Recovery, Security / Bug patches, Upgrades, Consolidation and Disaster recovery.
• Executed and managed several million dollar projects and delivered them on time and budget. Exhibited excellent project management skills managing a team of more than 35+ members across various projects.
• Experienced in handling Onsite/Offshore teams across locations in North America, Europe, Asia
• Quickly adapts to new professional settings, Fast learner, acquires skills/knowledge easily.
• Good communication, Persuasive, Influential and interpersonal skills.

TECHNICAL SKILLS

Big Data Ecosystems: Hadoop, HDFS, Hive, HBase, Sqoop, Oozie, Zookeeper, Flume, Kafka, Pig, Yarn, Map Reduce, Syncsort, Splunk, Impala, Scala, Spark SQL, Cloudera Manager.

Hadoop distribution: Cloudera

Database Technologies and Utilities: Oracle 12c/11g/10g, Oracle RAC, ASM, Golden Gate, Oracle Data Guard, Oracle Bare Metal Cloud 12, Expdp, Impdp, Toad, SQL PLUS, SQL Developer, RMAN, MS-SQL Server 2012/2008, MS-SQL Enterprise Manager, Oracle Weblogic 12/11, Oracle Apex 5, Oracle Exadata X5/X6, Oracle Enterprise Manager 12 for Oracle Fusion Middleware, OEM for SOA suite 12c, Erwin.

Scripting Languages: UNIX Shell scripting.

Other RDBMS: Oracle 12c/11g,MS SQL Server 2012, DB2 UDB 9, Sybase 4, MySQL

Other Utilities: Service Now, Tableau, Clarity, SharePoint, Putty, DevOps, GitHub, Jenkins, MSTSC, MS Cluster Admin, VNC, Jira, Erwin, Toad, SQL Plus, Tkprof

Platforms: UNIX, Linux, MS Windows, Max OS.

PROFESSIONAL EXPERIENCE

Confidential

Big Data Architect/Hadoop Administrator

Responsibilities:

• Working as a Big Data Architect/Administrator for a Confidential and insurance company.
• Provide solution to ingest their sensitive and non-sensitive data into Hadoop ecosystem.
• Hadoop ecosystem design, installation, configuration and monitoring.
• Involved in creation of Hive database, writing queries, job scheduling in Oozie workflow.
• Configured and setup data streaming methods.
• Designed and created Sqoop scripts to transfer data from various RDBMS into Hadoop.
• Working closely with the business users and IT application SME to design databases, create solution blue prints.
• Provided Technical solutions, support and improve the performance of the systems.
• Involved in scope and requirements discussions with business and IT departments to ensure alignment with the overall objective of the project.
• Acted as a liaison between the business and IT teams.
• Working closely with IT Directors, Service Delivery Managers and Project executives.

Environment: Big data and Hadoop, Sqoop, Flume, Map-Reduce, Yarn, PIG, Hive, HBase, Zookeeper, Oozie, Kafka, Splunk, Scala, impala, Oracle Database 12c/11g/10g, Linux 6/5, OEM 12c, SOA Suite 11, Weblogic 12/11, Oracle Exadata, ZDLRA, OBM Cloud, Shell scripting, RMAN, Data Guard, Golden Gate, RAC, IMPDP, EXPDP, AWR, ADDM, tkprof, Windows server 2012,Window 8.

Confidential

Sr. DBA

Responsibilities:

• Worked as a Senior Database Administrator for a leading financial Corporation firm.
• Involved in Oracle Database Installation, Configuration, Upgrade and Migration.
• Involved in Application and database design and Architecture.
• Provided solutions and support and to improve the performance of the systems.
• Implement Oracle best practices and provided guidance, mentoring and support for Equity Edge Online team to create, migrate, and Upgrade databases and Database Roll Deployment.
• Provided end-to-end support (DB Provisioning, Backups, Monitoring, Capacity planning, Privileged User monitoring (PUM), Patching, Performance tuning).
• Provided 24X 7 production support (3 rd /2 nd /1 st level).
• Worked closely with IT Directors, Service Delivery Managers and Project executives.

Environment: Oracle Database 12c/11g/10g, Linux 6/5, UNIX, OEM 12c, Shell scripting, RMAN, Data Guard, RAC, Oracle Golden Gate, IMPDP, EXPDP, AWR, ADDM, tkprof, MS SQL Server 2008/2012,Windows server 2008/2012, Window 7.

Confidential

DB Architect/Sr. DBA

Responsibilities:

• Worked as a Database Architect for pharmaceutical and Health Care Group firm for the Data Center Migration program (Emerald) and Hardware refresh project (R&D HW). Datacenters were located in USA, UK, Sweden, France and Singapore.
• 950+ Databases, 1100+ Servers were migrated from old Datacenter to new Primary Datacenter.
• Designed Architecture and created Solution Blueprint documents for all the new build applications.
• Provided expert opinion for different types of Migration methods (PV2, V2V, Lift & Shift, Fresh build).
• Prepared Migration approach, Migration strategic document, Database Migration methods document, cut over plans, Base build, Core build, Qualification document and Implementation plan etc. to migrate database from Old Data center to new Data Center.
• Provided guidance, mentoring and support to ITIS teams to migrate, upgrade, and consolidate databases.
• Prepared scope, estimate and SOW documents for complex/non-complex application database migrations.
• Performed several Database upgrades from Oracle 10g/11g to 12c.
• Installed, configured and maintained Oracle Real Application Cluster (RAC).
• Worked on DB migration/consolidation projects and Database Integration projects.
• Provided end-to-end support and implemented enterprise wide Backups, Monitoring, Capacity planning, Privileged User monitoring (PUM), DB/User Provisioning
• Implemented automatic Oracle security patching (CPU/PSU) using Tivoli provisioning manager.
• Experienced in handling Onshore and Offshore teams across locations in US, UK and India.
• Successfully managed and completed Datacenter migration program (Emerald) and R&D hardware refresh projects.
• Worked closely with Service Delivery Managers and Program Mangers.

Environment: Oracle Database 11g/10g, Linux 6/5, OEM, Exadata, Oracle SPARC-T series, Weblogic 10/11g, MS SQL Server 2008/2012, MS Access, Window server 2008, Shell scripting, RMAN, Data Guard, IMPDP, EXPDP, AWR, ADDM, tkprof.

Confidential

Sr. DBA/SME

Responsibilities:

• Provided end-to-end support and standardized/implemented enterprise wide Backups, Monitoring, Capacity planning, Privileged User monitoring (PUM), DB/User Provisioning, Sarbanes-Oxley compliance.
• Implemented Enterprise-wide standards and best practices, Infrastructure upgrades, Migration of Backups to Tivoli Storage Manager (TSM) and Configuration /Change management process and procedures. Also fixed Security issues and Audit violations.
• Implemented automatic Oracle security patching (CPU/PSU) using Tivoli provisioning manager.
• Migrated 300+ databases on SQL 2000 Server Farm to SQL 2005 Enterprise Servers utilizing active/passive clustering.
• Created database coding standards and naming conventions for the DBA team.
• Created database for OLTP, Data warehouse and Decision support system. Worked closely with database team, developers, solution engineering team and project management office to setup new database and ensure the standards and best practices are met and are created efficiently.
• Installed Oracle 11g, 10g, 9i and 8i enterprise edition software and associated components
• Responsible for database restoration from production environment to test servers and attaching/detaching databases from prod to test.
• Provided 24X 7 production support (3 rd /2 nd /1 st level).Worked closely with Oracle, HP and IBM support for critical issues, bugs and errors.

Environment: HP-UX ia64, HP-UX RISK, AIX -5L, Linux 5, Sun OS 5.8, Oracle 10g, 9i / 8i, PL/SQL, Oracle RAC, SQL*Loader, Export, Import, STATSPACK, UNIX shell scripting, OEM, Oracle Diagnostics Pack, Oracle Performance Pack, RMAN, SQL Trace, tkprof, Windows server 2003, Windows server 2000, MS-SQL Server 2000/2005 SQL Server 7, DTS, SQL Query Analyzer, SQL Server Enterpriser Manager.