We provide IT Staff Augmentation Services!

Informatica /hadoop Administrator Resume

PhiladelphiA

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.

Hire Now