SUMMARY

• Worked 9 Months on Informatica Powercentre(IICS) / UC4/ Teradata and Hadoop 5.6 Monitoring with Confidential .
• Have around 3 years of experience in Hadoop Administration and 10 Years of experience in Oracle Database Administrator.
• Monitoring/Tuning SLA jobs in MELD(Hadoop Tool) and UC4 and IICS(Informatica Cloud).
• Monitoring services for Hadoop Platform.
• Connection creation and maintenance, Scheduler creation and Jobs scheduling in UC4 and IICS.
• Installation, configuration, and managing Hadoop Clusters using Cloudera (CDH 5) and Hortonworks versions (HDP 2) from Test to Production Setup.
• Implemented HDFS, HDFS Federation, Hbase, Hive,Yarn,Scoop,Kafka,Impala,Sentry,Oozie.
• Backup configuration and Recovery from a NameNode failure.
• Decommissioning and commissioning, adding/removing Nodes on running hadoop cluster.
• Hands on experience in analyzing Log files for Hadoop and eco system services and finding root cause.
• Experience in importing and exporting the data using Sqoop from HDFS to Relational Database systems/mainframe and vice - versa.
• Scheduling jobs via different schedulers also allocate resources as required.
• Configured High Availability(HA) for HDFS,Hive, Hbase.
• Schedule and Maintain jobs via Cloudera and providing appropriate resources.
• Good experience in managing data with HIVE (partitioning and bucketing) and HBase .
• Experience in job workflow scheduling and monitoring tools like Oozie and Zookeeper .
• Worked on NoSQL databases including HBase.
• Hands on experience in Capacity planning, monitoring and Performance Tuning of Hadoop Clusters .
• Experience in working with cloud environment like Amazon Web Services ( AWS) EC2 .
• Worked in visualizing data using Tableau.
• Implemented High-end HDP security with KERBEROS, RANGER . .
• Implemented RBAC using Sentry .
• Brainstorming with developers/architects to find best solutions with new Hadoop features/services.
• Upgrade Ambari and HDP Versions.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 10g, 11g on Sun Solaris, Windows and UNIX/Linux Environment.
• Implementing database administration using tools like OUI, DBCA, EM, SQL*PLUS, upgrading using tools like DBUA.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g, Oracle 10g to Oracle 11g/12c.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Working Experience with ASM.
• Install database software and configuration accordingly.
• Worked on Database Profiling, Locks, Memory Usage, security.
• Excellent knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Oracle Database performance-tuning and Auditing services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, Gather Statistics appropriately,TRCSESS.

TECHNICAL SKILLS

Operating Systems: Linux, Solaris, Unix, Windows

Databases: Oracle 9i, 10g, 11g, SQL, HBASE, Teradata

Tools: & Utilities: Hadoop Cloudera(CDH 5.6) and Hortonworks Ambari (HDP2.6),HIVE,Hbase,sentry,zookeeper,oozie,impala, UC4, Informatica Powercentre, RMAN, OEM, SQL Loader, OEM Grid Control, SQL Plus, DBCA, Import/Export, Data Pump, Hsql,Toad for Oracle, Teradata SQL Assistant

Programming Languages: SQL, PL/SQL(Basic), Shell Scripting, Nosql(Hbase),Mongo DB,HIVE

Office Tools: Microsoft Office Suite (Word, Excel, PowerPoint, Outlook),Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia

Informatica /Hadoop Administrator

Responsibilities:

• Handling Production/SLA jobs on ETL Platform Informatica Powercentre and UC4 till Dashboard Refresh.
• Monitoring Hadoop services and job, finding RCA for failures and performance issues.
• Provide incident and problem management support for business groups and operations.
• Manage code synchronization across all development, QA and production environments.
• Monitor network performance, Space management on Linux servers.
• Create and maintain technical documentation including operations run books, user guides, and standard operating procedures
• Finding RCA’s of jobs and take actions appropriately.
• Finding Problematic query in Teradata/Oracle respective to jobs and suggest inputs to DBA’s.
• Checking HQL’s for jobs via HIVE.

Confidential, Houston, TX

Hadoop Administrator

Responsibilities:

• Installation, configuration, and managing Hadoop Clusters using Cloudera (CDH 5) and Hortonworks versions (HDP 2.6) from Test to Production Setup.
• Implemented HDFS, HDFS Federation, Hbase, Hive,Yarn,Scoop,Kafka,Impala,Sentry,Oozie.
• Adding/removing,decommissioning/commissioning nodes to an existing hadoop cluster.
• Configured High Availability(HA) for HDFS, Hive, Hbase.
• Good Hands-on experience on full life cycle implementation using CDH (Cloudera ) and HDP ( Hartonworks Data Platform ).
• Good experience in managing data with HIVE (partitioning and bucketing) and HBase .
• Experience with migrating data to and from RDBMS and unstructured sources into HDFS using Sqoop .
• Experience in job workflow scheduling and monitoring tools like Oozie and Zookeeper .
• Worked on NoSQL databases including HBase, Mongo DB.
• Hands on experience in Capacity planning, monitoring and Performance Tuning of Hadoop Clusters .
• Good experience in working with cloud environment like Amazon Web Services ( AWS) EC2 and S3 .
• Worked in visualizing data using Tableau.
• Implemented High-end HDP security with KERBEROS with RANGER and KNOX
• Upgrade Ambari and HDP Versions.
• Performed database tuning using Explain Plan, TKPROF, Statspack, AWR, ASH, ADDM and SQL Trace.
• Maintained and scheduled Cold Backups, Hot Backups, and Export Dumps.
• Upgrade Oracle 9i to 10g/11g.
• Applied Oracle Patches (CPU/PSUs and One-off patches)
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements.

Confidential

Hadoop /Senior Oracle Database Administrator

Responsibilities:

• Installation, configuration, and managing Hadoop Clusters using Cloudera (CDH 5) and Hortonworks versions (HDP 2.6) from Test to Production Setup.
• Implemented HDFS, HDFS Federation, Hbase, Hive,Yarn,Scoop.
• Adding/removing,decommissioning/commissioning nodes to an existing hadoop cluster.
• Configured High Availability(HA) for HDFS,Hive, Hbase.
• Implemented High-end HDP security with KERBEROS with RANGER and KNOX
• Upgrade Ambari and HDP Versions.
• Performed database tuning using Explain Plan, TKPROF, Statspack, AWR, ASH, ADDM and SQL Trace.
• Maintained and scheduled Cold Backups, Hot Backups, and Export Dumps.
• Upgrade Oracle 9i to 10g/11g.
• Applied Oracle Patches (CPU/PSUs and One-off patches)
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Maintain security while maintaining priviliges/role and profiles.
• Maintain Oracle Database performance-tuning using services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas,auditing, and analyzing security problems.
• Experience in MongoDb administration.
• Experience in creating Database,Documents,Datatypes,indexes.
• Install database software and configuration accordingly.
• Worked on Database Profiling, Locks, Memory Usage, security.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Performed database tuning using Explain Plan, TKPROF, Statspack, AWR, ASH, ADDM and SQL Trace.
• Maintained and scheduled Cold Backups, Hot Backups, and Export Dumps.
• Upgrade Oracle 9i to 10g/11g.
• Applied Oracle Patches (CPU/PSUs and One-off patches)
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Maintain security while maintaining priviliges/role and profiles.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.

Confidential

Oracle Database Administrator

Responsibilities:

• Worked as Onsite Oracle DBA for telecommunication Client of Thailand.
• Implemented Oracle Products on Client site, while taking care of Client requirements.
• Created and Maintained 50+ Databases and upgraded 100+ Databases .
• Scheduled and Maintained Various backups of Databases.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Managed PDBA and ADBA tasks.
• Enforced Security administration, system monitoring by adding and removing users, configuring quotas,auditing, and analyzing security problems.
• Handled Oracle Pfiles and Spfiles along with required parameters.
• Create and manage HOTFIX’s with customized scripts.
• Create, manage, export/import, applying patches on Environments for our clients .

Confidential

Oracle Database Administrator

Responsibilities:

• Worked on all Physical database activities.
• Worked on Confidential Billing and Ordering Products (ABP and OMS)
• Create, manage, export/import, applying patches on Environments for our clients .
• Worked on Tiger tool, to create, apply and upgrade patches for Environments.
• Worked for PDBA and ADBA tasks.
• Created and managed HOTFIX’s with customized scripts.
• Created, managed, export/import, applying patches on Environments for our clients .
• Creating users,tablespace,assigining quotas to users.
• Assigning DB roles and Privileges as required by applications and products.
• Manage resources using profiles.

Confidential

Oracle DB Consultant and Confidential Trainer

Responsibilities:

• Impart to more than 150 Confidential International Clients on Oracle 9i/10g.
• Provide consultancy to all our clients for 3 years in their ongoing projects.