Objective

• To pursue a career in an esteemed organization holding a responsible position which would enhance skills at work in competitive & creative environment and crave for winning edge for the organization.

SUMMARY

• Over 10+ years of IT experience including 3+ years of experience with Hadoop Ecosystem in installation and configuration of different Hadoop eco - system components in the existing cluster.
• Experience in Hadoop Administration (HDFS, MAP REDUCE,YARN, HIVE, PIG, SQOOP, FLUME AND OOZIE, HBASE) NoSQL Administration
• Experience in deploying Hadoop cluster on Public and Private Cloud Environment like Amazon AWS, RackSpace and OpenStack.
• Setting up automated 24x7 monitoring and escalation infrastructure for Hadoop cluster using Nagios and Ganglia.
• Experience in installing Hadoop cluster using different distributions of Apache Hadoop, Cloudera and Hortonworks.
• Good Experience in understanding the client’s Big Data business requirements and transform it into Hadoop centric technologies.
• Analyzing the clients existing Hadoop infrastructure and understand the performance bottlenecks and provide the performance tuning accordingly.
• Installed, Configured and maintained HBASE
• Worked with Sqoop in Importing and exporting data from different databases like MySql, Oracle into HDFS and Hive.
• Defining job flows in Hadoop environment using tools like Oozie for data scrubbing and processing.
• Experience in configuring Zookeeper to provide Cluster coordination services.
• Loading logs from multiple sources directly into HDFS using tools like Flume.
• Good experience in performing minor and major upgrades.
• Experience in benchmarking, performing backup and recovery of Namenode metadata and data residing in the cluster.
• Familiar in commissioning and decommissioning of nodes on Hadoop Cluster.
• Adept at configuring NameNode High Availability.
• Worked on Disaster Management with Hadoop Cluster.
• Worked with Puppet for application deployment.
• Well experienced in building servers like DHCP, PXE with kick-start, DNS and NFS and used them in building infrastructure in a Linux Environment.
• Experienced in Linux Administration tasks like IP Management (IP Addressing, Subnetting, Ethernet Bonding and Static IP).
• Strong knowledge on Hadoop HDFS architecture and Map-Reduce framework.
• Experience in deploying and managing the Multi-Node Development, Testing and Production
• Experience in understanding the security requirements for Hadoop and integrating with Kerberos authentication infrastructure- KDC server setup, creating realm /domain, managing
• Principles, generating key tab file for each and every service and managing key tab using key tab tools.
• Worked on setting up Name Node high availability for major production cluster and designed Automatic failover control using zookeeper and quorum journal nodes.

PROFESSIONAL EXPERIENCE

Confidential - Jacksonville, FL

Hadoop Administrator

Responsibilities:

• Responsible for architecting Hadoop clusters Translation of functional and technical requirements into detailed architecture and design.
• Installed and configured multi-nodes fully distributed Hadoop cluster of large number of nodes.
• Provided Hadoop, OS, Hardware optimizations.
• Setting up the machines with Network Control, Static IP, Disabled Firewalls, Swap memory.
• Installed and configured Cloudera Manager for easy management of existing Hadoop cluster
• Administered and supported distribution of Hortonworks.
• Worked on setting up high availability for major production cluster
• Implemented Fair scheduler on the job tracker to allocate fair amount of resources to small jobs.
• Performed operating system installation, Hadoop version updates using Automation tools.
• Configured Oozie for workflow automation and coordination.
• Implemented rack aware topology on the Hadoop cluster.
• Importing and exporting structured data from different relational databases into HDFS and Hive using Sqoop
• Configured ZooKeeper to implement node coordination, in clustering support.
• Configured Flume for efficiently collecting, aggregating and moving large amounts of log data from many different sources to HDFS.
• Involved in collecting and aggregating large amounts of streaming data into HDFS using Flume and defined channel selectors to multiplex data into different sinks.
• Worked on developing scripts for performing benchmarking with Terasort/Teragen.
• Implemented Kerberos Security Authentication protocol for existing cluster.
• Good experience in Troubleshoot production level issues in the Cluster and its functionality.
• Backed up data on regular basis to a remote cluster using distcp.
• Regular Commissioning and Decommissioning of nodes depending upon the amount of data.
• Monitored and Configured a Test Cluster on Amazon web services for further testing process and gradual migration
• Installed and maintain Puppet-Based Configuration Management System
• Deployed Puppet, Puppet Dashboard and PuppetDB for configuration management to existing infrastructure.
• Using Puppet configuration management to Manage Cluster.
• Experience working on API
• Generated reports using the Tableau report designer.

Confidential - Omaha, NE

Hadoop Administrator

Responsibilities:

• Installed Namenode, Secondary name node, Yarn(Resource Manager, Node manager, Application master), Datanode.
• Installed and Configured HDP2.2
• Responsible for implementation and ongoing administration of Hadoop infrastructure.
• Monitored already configured cluster of 40 nodes.
• Installed and configured Hadoop Components Hdfs, Hive, HBase.
• Communicating with the Development Teams and Attending Daily Meetings.
• Addressing and Troubleshooting issues on a daily basis.
• Launched R-statistical tool for statistical computing and Graphics.
• Working with data delivery teams to setup new Hadoop users.
• This job includes setting up Linux users, setting up Kerberos principals and testing HDFS, Hive.
• Cluster maintenance as well as creation and removal of nodes.
• Monitor Hadoop cluster connectivity and security
• Manage and review Hadoop log files.
• File system management and monitoring.
• HDFS support and maintenance.
• Diligently teaming with the Infrastructure, Network, Database, Application and Business Intelligence teams to guarantee High Data Quality and availability.

Confidential - Pittsburgh, PA

Hadoop Administrator

Responsibilities:

• Installed and configured Hadoop MapReduce, HDFS, Supported multiple MapReduce-YARN jobs in Java for Data Cleaning and Preprocessing.
• Importing and exporting data into HDFS and Hive using Sqoop.
• Experienced in defining Job Flows.
• Experienced in managing and reviewing Hadoop log files.
• Experienced in running Hadoop streaming jobs to process terabytes of XML format data.
• Load and Transform large sets of Structured, Semi structured and Unstructured data.
• Expertise in Hadoop Cluster Task like Commissioning Nodes, Decommissioning Nodes without any Effect to running Jobs and Data.
• Responsible to manage data coming from different sources.
• Supported Map Reduce Programs those are running on the Cluster.
• Implemented Fair Schedulers on the Job Tracker to share the resources of the Cluster for the Map reduce jobs given by the users.
• Cluster coordination services through Zoo Keeper.
• Involved in loading data from UNIX file system to HDFS.
• Involved in creating Hive Tables, Loading with Data and Writing Hive queries that will run internally in MapReduce way.
• Automated all the jobs, for pulling data from FTP server to load data into Hive Tables, using Oozie workflows.
• Production support responsibilities include Cluster Maintenance, Backup and Recovery.
• Gained very good business knowledge on Health Insurance, Claim Processing, Fraud suspect identification, appeals process etc.

Confidential, Atlanta, GA

Sr Oracle DBA

Responsibilities:

• Designed and implemented high availability solutions such as Data Guard and Real Application Clusters (RAC with 3 Nodes) on Linux Platforms.
• Configured Five Node RAC Environments on Linux Servers
• Applied PSU Patches on RAC Environments in Rolling Fashion
• Configuration parameters for Extract, Pump, and Replicate processes, Up/Down of Extract, Pump, Replicat processes, Resolution of GoldenGate data errors, Monitoring of up/down/lag for GoldenGate processes
• Formulated and monitor policies, Procedures and Standards relating to Database Management and implement Enhancements in Order to improve the performance and reliability of the system.
• Administeringof databases including Development of Database Policies and Procedures, Security Administration, Documentation and Maintenance
• Designing of databasesincluding Physical Disk Layout and Sizing,Database layout and Growth Management, and Backup and Recovery Planning
• Implementation of databasesincluding Installation and Configuration, Initialization and Data Loading, Backup configuration and Scheduling, and Disaster Recovery Testing
• Daily Operations including Tuning, Error Monitoring, Space usage and Monitoring, Performance Monitoring,Patching and Upgrading, identification and resolution of hardware, software and database problems/outages.
• OEM Grid Control Diagnostic and Tuning packs to tune the resources based on the ongoing performance.
• Research and identify performance bottlenecks and implement changes (CRs) proactively and avert troublesome trends, as they develop in order to ensure a stable performance for the production environments
• 24x7 coverage and response to systems alerts during after-hour periods. Specific database performance issues, error messages or service problems.
• Installation of Oracle 9i, 10g and 11g binaries on different platforms (include windows, Solaris, REDHAT Linux), for both single and multi-node environments.
• Creation of Databases and Configuring Linux clustering, preparing/reviewing Build Sheets, worked closely with Infra structure/network teams to submit IAFs(Infra Structure Assessment) for new projects
• Database development activities such as designing and implementing ETL processes using PL/SQL stored procedures, SQL scripting,
• Performance Tuning and Troubleshooting. Creating SQL Profiles/ SQL Plan Baselines to address performance issues. Importing SQL profiles from one database to another.
• Strong experience in working with various project, application and infrastructure teams, in large enterprise projects. Confirming to client compliances and SLAs.
• Managing Optimizer Statistics, SQL Access Advisor, Instance tuning using performance views
• Setting up Oracle streams- dropping, recreating, configuring /streams health check
• Installing OEM11g agents and applying 11g agent PSU5.Upgrading and repointing an OEM10g agent to OMS11g
• Oracle standby database, promoting standby DB to primary, re-establish standby database
• Refreshing databases using oracle flashback feature. scripts for Refreshing development databases databases/Monitoring the health check of databases /Cloning the reporting databases
• Oracle enterprise manager(OEM) monitoring/configuration/templates/groups
• Oracle APEX installation and configuration. Installing XDB/UTL MAIL on oracle 11g
• RMAN-configuration of backups to be stored offsite, setting up RMAN backup and recovery scripts. setting up RMAN duplicate database
• Good knowledge on Creating Oracle Service Requests SRs, Capturing trace information and providing additional information requested information and following up with Oracle CSS.
• Troubleshooting NetBackup issues
• Implemented DR recovery procedures for oracle databases
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analysing security problems.
• Managing and Monitoring tickets from the ticketing tool (HPSM & Clarify)
• Creating Change Management tickets and representing them in CAB meetings for approvals.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• DPARs-Database Privileged Access Requests
• Writing shell scripts for daily routine tasks

Confidential, Atlanta, GA

Database Consultant

Responsibilities:

• Support of 24x7 Production Databases. DBA on call rotation.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.Backup & Recovery of Database using RMAN
• Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose.
• Installation, Configuration & Administration of 10G OEM.
• Upgrade and install Sun Cluster on multi-node RAC - Upgrade 9i RAC and 10g RAC to 11g RAC.Install Dataguard for Reporting and failover for DR.
• Continuous Performance monitoring and tuning of the databases and application using OEMTuning Pack, Diagnostics Pack, STATSPACK.
• Responsibilities included data modeling, backup and recovery, performance tuning, maintaining data security, applying upgrades and patches to the database servers, storage monitoring.
• Design, development, implementation and automation via scripting and scheduling.
• Proficient in Using the 10g OEM Change Management Pack Installation
• Implementation & Administration of RAC with ASM.
• Excellent experience in handling daily database change activities.
• Making structural changes to the databases when database design changes are to be implemented.
• Migration of the database from sun Solaris to Linux. Installed and maintained Oracle 10g software On Linux systems.
• Monitoring of hot backups, exports on Linux and Windows.
• Performed Refresh of databases on Linux servers.
• Improving the Overall Response time of the SQL statements by using hints.
• Written SQL scripts to monitor Table spaces and extent growth.
• Routine Database Administration tasks such as Space Management, Upgrades, Migration, Patches, Cloning, Backup & Recovery.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Storage and space management including table spaces and data files.
• Developed scripts for daily maintenance activity for analysing tables/indexes, and monitoring their growth rate.
• Automation of startup shutdown on all production and development databases using shell scripts
• Performance Tuning of database supporting Web based applications.
• Analysing and validating objects for block corruption.
• Troubleshooting Database errors. Helping the development teams in writing the optimized SQL statements
• Implementing and rescheduling backup jobs
• Creating best practices and publishing to team

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Worked on 24*7 production environment.
• Maintenance and Administration of 2000+ databases on 300+ servers in three different Data Centres.
• Segregate work requests from turnover queue and admin queue based on priority and criticality.
• Installing and configurations of Real Application Cluster
• Preparing Standard Operating Procedures for the repetitive tasks like cloning, database refresh and maintaining standard logs for patching and shift handovers.
• Check status and performance management of all databases.
• Worked on reporting database clones. Activating R-databases for Cloning
• Creating change managements (CM’s) to perform tasks like database migrations, upgrades, retirements
• Architecture and Space management for future requirements.
• Capacity management for database on needs basis.
• Used Oracle utilities like, Imports, Exports, Expdp, Impdp, TKPROF, etc.
• Tested and implemented different physical, logical Backups and Recovery methods like point in time recovery, Media recovery, full and partial recovery using export, import.
• Created shell scripts for monitoring of reporting database clones and alerts.
• Developed shell scripts for monitoring objects, tablespaces, moving archives, check file system.
• Addressing hung analyse jobs. Application troubleshooting, ORA errors, Resolving export issues.
• Build verification for production databases.
• Worked on numerous Move to production cases.
• Database activities include allocation and maintenance of Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Worked on Cloning, refreshing, Creating new databases, hot & cold backups.
• Configuring RMAN on Sun Solaris.
• Applying patches for databases.
• Resolved oracle performance issues involving disk I/O, CPU usage, SQL tuning
• Resolved issues such as locking problems, rollback segs, connection problems, runaway processes
• Created databases and refreshing the data, configuring Data Guard
• Hot and Cold backup Cloning of instances.
• RMAN Auxiliary database cloning. SAN cloning.
• Reorganization of Database for performance gains.
• User account maintenance and administration of Database. Enabling User Auditing.
• Cloning, Patching, Upgrades, Monitoring and tuning for the different instances.
• Upgradation of 8.1.6 to 8.1.7.4 & 8.1.5 to 8.1.7.4 & 8.1.7.4 to 9.2.0.6 &9i to 10.1.x
• Implementing and rescheduling backup jobs
• Restoring dump files, hot backup files and archives from netbackup server.
• Migration of Sql server databases
• Creation, restoration and deletion of SQL server databases.
• Sql server Reporting database restores, build verifications
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Changing SQL server configuration options.
• Creating new user account, assigning roles and responsibility using system administration.
• Automated backup of Oracle database using RMAN and performing regular system backup.
• Documenting all the upgrade and standard process issues.
• Create Schema (Tables, Indexes, views, sequences, synonyms, roles, and packages), grant roles to users.
• Monitor databases using OEM, re-organization of database tables and indexes.
• Preparing and sending status report, backup report daily by 6:00AM(EST) and 9:00AM(EST)

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Worked as Oracle DBA (10g) on HP-UX 11i v3.
• Installed and configured Oracle Database Software 10g.
• Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database (from 9.2.0.5 to 10.2.0.1).
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Worked in advanced recovery methods like PITR. Logical backup using full/ partial export/import and Data Pump.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and UNIX shell Scripting.
• Implemented stand-alone database using Oracle Data Guard feature for High availability configuration.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Worked with Oracle partition tables and applied patches as per the requirements of the module.
• Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMS software.
• Used SQL* loader to move data from legacy systems.
• Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER, Explain Plan, and SQL tuning of Oracle database.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) . Tuned database for optimum performance.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.

Confidential

Oracle DBA

Responsibilities:

• Cloning, Patching, Upgrades, Monitoring and tuning for the different instances.
• Provided solutions and execution plans for issues. Migrations, DB Sizing, Load Balancing and Performance Improvements methods.
• Configured Recovery Manager (RMAN) to implement backup methodology.
• Performed defragmentation of database objects using export and import. Reorg of databases
• Automated backup of Oracle database using Recovery Manager. Perform regular system backup.
• Monitoring and optimize the performance of the databases.
• Work as part of a team and provided 24X7 support.
• Created shell scripts for monitoring and alerts.
• Protected environment from data loss through hot & cold backup strategy
• Managed tablespaces for storage, validated objects in system tablespace for block corruption.
• SQL Tuning using Explain Plan, SQL Trace, Tkprof, Statspack reports
• Refreshing the Stage and Development Databases using RMAN.
• Working with RMAN to take the backups and restore the databases. Backup and Recovery, RMAN, knowledge of various restore and recovery scenarios
• Performance Tuning of database supporting Web based applications.
• Resolved connectivity issues for users as appropriate.
• Fulfilled on the fly new database requirements for new customers.
• Provided technical support to developers in tuning applications and connectivity issues.
• Scheduling and gathering the statistics at database level
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments; proactively monitoring production environment for any exceptions/ issues.
• Have written shell scripts for automation of various database-monitoring activities.