Sr. Oracle Dba Resume
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