We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

0/5 (Submit Your Rating)

Burlington North, CarolinA

SUMMARY

  • Over 7+ years of IT experience including 2.5 years of experience with Hadoop Ecosystem in installation and configuration of different Hadoop components in the existing cluster.
  • Experienced on Hadoop 1.x and Hadoop 2.X installation, configuration and Hadoop Clients online as well as using package implementation.
  • Excellent experience in Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, NameNode, Data Node and MapReduce.
  • Cluster security protocol deployment - Kerberos and Ciphers.
  • Capacity Planning, hands on experience in various aspects of Database Systems as well as installing, configuring & maintaining Hadoop clusters.
  • Hands on data ingestion through Sqoop and Flume from different sources.
  • Adept in Hadoop cluster expansion and planning.
  • Experience in analyzing clients in existing Hadoop infrastructure and understanding the performance bottlenecks and providing performance tuning accordingly.
  • Installed, Configured and maintained HBASE.
  • Hands on experience in installing, configuring, and using Hadoop ecosystem components like MapReduce, Hive, Pig, Sqoop, HBase, Zookeeper and Oozie.
  • Package Management: RPM, YUM & TAR package administration.
  • Exposure to "Productionalizing" Hadoop applications (i.e. administration, configuration, management, monitoring, debugging, and performance tuning).
  • Expertise in High Availability Configurations for Mission Critical Applications.
  • Experience in System Architecture and Infrastructure Planning.
  • Install/Configure/Evaluate System Backup and Monitoring Software.
  • Cluster configuration and data transfer (distcp and hftp), inter and intra cluster data transfer.
  • Excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels and work in a team as well as independently.
  • Good understanding of network protocols, routing, switching equipment, Networking Operating Systems, Servers and overall different network architectures.
  • Experienced in Linux Administration tasks like IP Management (IP Addressing, Subnetting, Ethernet Bonding and Static IP).
  • Have experience in architecture, design and development of Big Data platform including large clusters, Hadoop ecosystem projects and custom map-reduce user management, cluster management, setup NOSQL databases, Security design and Implementation.
  • Hands on experience in Installing, Configuring and managing Hue and HCatalog.
  • Experience in importing and exporting data using Sqoop from HDFS to Relational Database systems/mainframe and vice-versa.
  • Experienced of Service Monitoring, Service and Log Management, Auditing and Alerts, Hadoop platform security, and Configuring Kerberos.
  • Optimizing performance of Hbase/Hive/Pig jobs.
  • Worked on setting up Name Node high availability for major production cluster and designed automatic failover control using zookeeper and quorum journal nodes.

TECHNICAL SKILLS

Operating System: Red Hat, CentOS, Ubuntu, Solaris, Windows 2008/’08R2

Hadoop: Cloudera and Apache Hadoop

Languages: Core Java and C

Hadoop Distribution: Cloudera and MapR

Ecosystem Hadoop: MapReduce, YARN, HDFS, Sqoop, Hive, Pig, Hbase, Sqoop, Flume, Oozie

Tools: JIRA, PuTTy, WinSCP, FileZilla

Protocols: TCP/IP, FTP, SSH, SFTP, SCP, SSL, ARP, DHCP, TFTP, RARP, PPP and POP3

Database: HBase, MongoDB, RDBMS Sybase, Oracle 7.x/8.0/9i, MySQL, SQL

PROFESSIONAL EXPERIENCE

Confidential - Chesterfield, Missouri

Hadoop Administrator

Responsibilities:

  • Debugged and solved major issues with Cloudera manager by interacting withHadoopteam.
  • Performed a cluster Upgrade from CDH 5.3 to CDH 5.4.
  • Managing the configuration of the cluster to meet the needs of analysis whether I/O bound or CPU bound.
  • Performed benchmark test onHadoopclusters and tweak the solution, based on test results.
  • Performed Data scrubbing and processing with Oozie.
  • Supported data analyst in running Pig and Hive queries.
  • Worked with full suite infrastructure services DCHP, PXE, DNS, KICKSTART and NFS.
  • Involved in runningHadoopstreaming jobs to process terabytes of text data.
  • Monitored system health logs and responded accordingly to any warning or failure conditions.
  • Setup Kerberos on the runningHadoopcluster.
  • Installed and configured multiple CDHHadoopclusters.
  • Installed and configured MapReduce, HIVE and the HDFS, Assisted with performance tuning and monitoring.
  • Worked on setting up High availability for major production cluster and designed automatic fail over control using zookeeper and quorum journal nodes.
  • Implemented rack aware topology on theHadoopcluster.
  • Created Hbase tables to load large sets of structured, semi-structured and unstructured data coming from UNIX, NoSQL and a variety of portfolios.
  • Added and DecommissionedHadoopcluster nodes including Balancing HDFS block data.
  • Involved in Performance Tuning, Troubleshooting ofHadoopcluster.
  • Worked on streaming web log data into HDFS from web servers using Flume.
  • Live deployment of Application build on Hadoop platform and support for the first-run in production environment and long term solution for incidents and contributing towards building stable and reliable systems.
  • Composing development plan and effort estimations for new project/change requests and distributing work among team members, managing assigned deliveries and providing end-to-end consultancy on project life cycle.
  • Undertaking design & development, testing, debugging and troubleshooting of the application.

Confidential - Atlanta, Georgia

Hadoop Administrator

Responsibilities:

  • Hands on experience in installation, configuration, maintenance, monitoring, performance and tuning, and troubleshooting
  • Hadoopclusters in different environments such as Development Cluster, Test Cluster and Production.
  • Hands on experience on Cloudera Upgrade from CDH 4.x to CDH 5.x.
  • Good experience on cluster audit findings and tuning configuration parameters.
  • Implemented Kerberos security in all environments.
  • Defined file system layout and data set permissions.
  • Implemented Capacity Scheduler to share the resources of the cluster for the map reduce jobs given by the users.
  • Good experience withHadoopEcosystem components such as Hive, HBase, Sqoop, Oozie.
  • Demonstrate and understanding of concepts, best practises and functions to implement a Big Data solution in a corporate environment.
  • Help design of scalable Big Data clusters and solutions.
  • Commissioning and Decommissioning Nodes from time to time.
  • Monitoring and controlling local file system disk space usage, log files, cleaning log files with automated scripts.
  • As aHadoopadmin, monitoring cluster health status on daily basis, tuning system performance related configuration parameters, backing up configuration xml files.
  • Work withHadoopdevelopers, designers in troubleshooting map reduce job failures and issues and helping to developers.
  • Worked with network and Linux system engineers/admin to define optimum network configurations, server hardware and operating system.
  • Evaluate and propose new tools and technologies to meet the needs of the organization.
  • Production support responsibilities include cluster maintenance.

Confidential - Burlington, North Carolina

Sr. Oracle DBA

Responsibilities:

  • Installed, configured, and maintained Oracle 10g and 11g on Linux and also Upgraded from Oracle 10g to 11g.
  • Performed the migration from Tandem to Oracle 11g.
  • Expertise in designing the table structure using Visio by creating ER diagram and normalized all the tables from the scratch according to the specifications provided.
  • Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
  • Performed Database Refresh from Production to Development databases.
  • Used PL/SQL (stored Procedures, triggers, packages), SQL* PLUS, SQL* LOADER of oracle database.
  • Supported different Databases like Testing, Staging and Training.
  • Upgraded the Oracle 10g database to 11gR2 version and also applied patch set and interim patches whenever required to make the database software up to date.
  • Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
  • Worked closely with developers during release and used oracle advanced features to achieve minimum downtime.
  • Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.
  • Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
  • Taking the RMAN incremental and cumulative backups.
  • Scheduling the databases backup using Cron tab and VERITAS net backup.
  • Perform Logical backup using full/partial export/import and data pump.
  • Creating Logical and Physical database structure, Creating and altering Tablespaces, Managing Users and Resources, Granting and revoking privileges through Roles.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
  • Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
  • Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
  • Creation of Users and granting them the required Roles and Privileges accordingly.
  • Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
  • Configuration of Listener and Net Service names using NETCA and NETMGR.
  • Cloned schemas, objects and data on new server using Data pump.
  • Managing databases on multiple servers.
  • Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 11g/10g, UNIX RHEL 5.x, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Business Objects, Toad, Awr, Addm, Sql*Loader, VERITAS Net Backup, Visio

Confidential

Oracle DBA

Responsibilities:

  • 24x7 production database and applications support.
  • Installation, configuration and maintenance of Oracle 10g and 11g databases.
  • Implementation multi node RAC on Oracle 10g and Oracle 11g.
  • Involved in construction of DR sites for all the Production databases.
  • Performed Database Refresh from Production to QA, UAT and Development databases.
  • Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
  • Also added nodes to RAC for minimizing the downtime and maximizing the availability and also achieving load balancing.
  • Monitoring Day-Day Backups, Log's.
  • Extensive experience in restore and recovery.
  • Managing backup strategy for all production databases.
  • Cloning of Databases from Production to Development and Test.
  • Implemented DataGuard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
  • Configured Data Guard to provide high availability by implementing Physical stand by database.
  • Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
  • Cluster Installation and Configuration, Administering databases in RAC for high availability.
  • Installation, Configure, setup of 11g RAC on Linux.
  • Installed and implemented 10g RAC with 4 nodes with ASM.
  • Upgraded Databases from 10g to 11g and applied patches as per requirement.
  • Designed, configured and maintained backup and recovery policies including RMAN backups.
  • Performed Cross platform migration using transportable tablespaces and RMAN.
  • Performed Import and Export using Oracle Data pump utilities.
  • Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
  • Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations.
  • Designed and implemented database backup/restore methodologies, responsible for troubleshooting performance and networking issues. Basic OS system administration.
  • Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 9i R2/10g R2, 11g R1/R2 database, PL/SQL, TOAD, PLSQL Admin, Solaris, Oracle FMW 11g VERITAS Cluster, RMAN, Physical Standby, RAC -2 nodes, OEM GRID Control.

Confidential

Oracle DBA

Responsibilities:

  • Providing Configuration and Admin support for the Development and Test environment on Linux and Win2003 Servers.
  • Installation, configuration, maintenance/monitoring and environment support to the testing/development team including the databases (Oracle 8i, 9i, 10g).
  • Providing frontline application support for Testing Team as well as the backend support/maintenance of the entire environment which includes troubleshooting and debugging issues.
  • Web servers with Oracle 8i/9i/10g Databases on Linux and Windows 2000 OS.
  • Database Migration to 9i and 10.
  • Migrated databases from Oracle 8i to 9i.
  • Configured DR environment (Physical Standby) with DATAGUARD.
  • Managed backup and recovery strategy with RMAN.
  • Providing Day to day support for Siebel Servers, Web servers and Databases in Development, Test and Training Environments with on call 24x7 support.
  • Installation and Testing of Database Software, Monitoring performance and Maintenance (Back up/Recovery using Imp/Exp and RMAN) of Databases, Upgrade to higher versions 8i to 9i, applying patches, troubleshooting and tuning.
  • Debugging SQL/PLSQL (Procedures/Stored Procedures) and fine-tuning for improving performance.

Environment: Oracle 9i R2/10g R2, 11g R1/R2database, PL/SQL, TOAD, Solaris, Windows, RedHat, Oracle FMW 11g VERITAS Cluster, RMAN, Physical Standby, RAC -2 nodes, OEM GRID Control

We'd love your feedback!