SUMMARY:

• 15+ years of IT experience in analysis and design and implementation of stand alone and distributed systems maintaining systems scalability and reliability
• 15+ years experience in Data Management and Systems administration
• Over 15 years of systems deployment and proactive monitoring of systems and devise improvement plans
• Experience in working with Network teams, infrastructure teams, developers teams, analysts teams, executives, technical and non technical as well as onshore and offshore models to get jobs and projects done efficiently to completion
• Over 15 years as an Oracle DBA using 7.x, 8i.x,9i.x, 10g.x and 11g.x and 12c.x
• Knowledge of Database Optimization Techniques such as Partitioned tables, sharding
• Experience in Hadoop technologies, Cloudera Hadoop, Hortonworks and Big insight
• Good understanding and knowledge of Hadoop architecture and various components such as HDFS, Name Node, Data Node, Resource Manager, Node Manager and Map Reduce
• Over 5 years of experience in Apache Hadoop, Big Data deployment, capacity planning, administration and Clusters upgrade
• Experience in Data lakes creation, data extraction, transformation and loading across multiple data sources and destinations
• Experience in installation and administration of elasticsearch clusters
• Experience in building enterprise Data lakes
• Experience in administering and installation of Kibana for elasticsearch data visualization
• Proficient with NoSQL database experience with HBASE,MongoDB, Oracle NoSQL
• Experience in installing, configuration, capacity planning and managing Cloudera Hadoop clusters and Hadoop file system (HDFS) and various big data echo systems
• Good understanding and knowledge of big data Hadoop architecture and various components such as HDFS, Name Node, Data Node, Resource Manager, Node Manager and Map Reduce
• Experience in System configuration and deployment tools such as Puppet
• Experience in DEvOps envorionments and tools such as Puppet, GIT version control
• Extensive experience writing scripts in SQL, PL/SQL packages, procedures, functions and triggers in multiple Oracle environments.
• Oracle Database installation, migration, upgrade, patching, administration and performance tuning proficiency in Linux, Solaris, HP, AIX and windows
• Good experience in PHP and Java programming languages
• Excellent written and verbal communications skills plus strong analytical, problem solving and troubleshooting skills
• Full life - cycle software development expertise in Big data, Databases, and Data warehouse environments with 24*7 support
• Solid experience managing Multiple Databases and projects, in multi-terabytes environments, overseeing and managing multiple personnel
• Extensive knowledge of Real Application Cluster configuration, installation, administration and performance tuning in multiple OS environment
• Exadata x2-2, x3-3,x4-2, x4-5 Database Machine installation, administration and performance tuning experience

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Big data Consultant

Responsibilities:

• Responsible for Infrastructure setup, capacity planning and, administration for Hadoop clusters and echo systems including multimode Cloudera Apache Hadoop.
• Initiated and oversee project to build enterprise Data lake for a large energy company with System reliability and scalability archicture design
• Handled resource planning, installation, configuration and administration of Hadoop
• Responsible for troubleshooting systems and resolving issues to minimize or eliminate impact on end users and business customers
• Created SOP for various applications and environment administrations and maintanance
• Installed and administered Hadoop ecosystem components (Hadoop, MapReduce, Yarn, Pig, Hive, Impala, Sqoop, Flume, Zookeeper ensemble and HBase Master and Region servers ) 
• Reponsible for installation, administration of elasticsearch clusters
• Configured Confidential Infosphere Data Replication using IIDR to move data across databases and Hadoop data lake
• Configured Flume and flume agent for data ingestion into Hadoop clusters
• Created a local YUM repository for installing and updating packages
• Created and maintained technical documentation for systems design, architecture and run
• Involved and implemented data collection mechanism aggregating large amounts of log data using Apache Flume and staging data in HDFS for further analysis
• Involved in loading data from LINUX file system to HDFS
• Created ELT jobs and managed data movement, export and import between HDFS and RDBMS using sqoop
• Configured AWS POC including Amazon Kinessis data stream and loading data to S3 buckets and Redshift Database
• Responsible in managing the Hadoop infrastructure with monitoring tools such as Cloudera Manager and Oracle Cloud control. 
• Responsible for Hadoop cluster upgrade and migration from Hadoop CDH4 to CDH5
• Good experience with Configuration Management tools such as Puppet
• Knowledge of ETL and Reporting tools such as Tableau and Pentaho and responsible for installation and configuration of such with data sources
• Managed and reviewed Hadoop log files and other components for troubleshooting issues as well as looking for ways to improve performance
• Discussions with other technical teams on regular basis regarding upgrades, Process changes, any special processing and feedback.
• Attend meetings and briefings to update stake holders, customers, executives and other teams on project pros and cons, projects implementation status and progress as well as ways for improvement

Environment: HBase, Oracle, R, impala, Linux, Oracle big data appliance, Flume, Cloudera manager, Hbase Apache spark/Scala, Hadoop, Exadata,HDFS

Confidential, Atlanta, GA

Lead Engineered system administrator/ Big Data Space

Responsibilities:

• Deployed and managed Oracle big data appliance in a test environment, using Cloudera enterprise Hadoop distribution,
• Installed and configured Horton works and Big insight platforms for various customers
• Configured flume agents and sinks to facilitate data movement from myriad of data sources and servers into Hadoop file system
• Configured flume to log file movement from servers to elastic search and analyze the data using Kibana
• Configued elasticsearch cluster for large amount of data indexing
• Utilized Cloudera manager for system administration, configuration and monitoring
• Installed and managed Cloudera Hadoop clusters and Hadoop file system (HDFS)
• Worked on Big Data Hadoop echo systems including Map Reduce, Map reduce2,YARN, flume, Sqoop, Hive, Apache Scala and Spark
• Installed and Configured Big data echo systems components such as Impala Hive, hive service and Hive Metastore to allow data analysis and expolaration
• Involed in idealation, implementation and deployment of NOSQL Hbase clusters with Master and Regional servers utilizing zookeeper ensemble for coordination to ensure data robustness, scalability and availability
• Responsible for Hadoop cluster Capacity planning and cluster expansion by adding Data Nodes
• Responsible for systems patching, package upgrades and installation
• Worked on MongoDB database Proof of concept project and involed in implementing envorinment for development teams
• Manageed and performed ELT processes importing data to and from Hadoop clusters and other database sources utilizing sqoop and other Data Integration tools
• Worked on other NoSQL databases such as Cassandra and Oracle NoSQL, Hbase
• Installed and configured elastic search and managed the system for data ingestion
• Installed and configured reporting and Business intelligence tools such as Tableau and Pentaho family of suites and configured them with right packages for various data analysis and Integration.
• Managed Business Intelligene servers including user management and report bursting configurations

Environment: Oracle Linux, Oracle RAC, 11gr2, 12c, x2-2,x3-2,x4-2 and x5-2 Exadata database Machine, Oracle Big data appliance, Cloudera hadoop, Oracle golden gate (11g.x,12c.x), Oracle VM for SPARC, MongoDB, Cloudera, Hadoop, HBase, Tableau

Confidential, Atlanta, GA

Lead oracle DBA/ RAC Architect

Responsibilities:

• Responsible for overall oversee deployment, management and maintenance of High Availability and Mission Critical Exadata Database with size of over 50TB
• Recommend appropriate technologies, enhancements upgrades and modifications to systems and Databases to improve efficiency and services for customers
• Created oracle 12C clusters and migrated oracle database to 12c using both RMAN and data pump
• Advise and provide guidance to deploy and use High performance and fast systems using Exadata smart scan and Flash Cache technologies
• Utilize Exadata Hybrid Columnar compression for Huge table storage and space saving for Decision support systems
• Installed, configured and managed Oracle Agents, grid control, and 12C Cloud control for Exadata and other monitored components
• Configure systems for Storage allocation, asm disk groups on Exadata machines and file systems using and EMC SAN storage.
• Work closely with the system administrators about system resource usage and allocation, system backups, and system upgrades.
• Perform data analysis and performance troubleshooting using oracle tools such as AWR reports and SQL analyzer
• Responsible for installing and Configuring Automatic Service Request(ASR) for phne home and monitoring exadata components
• Work with application developers in enhancing application performance, data management and projects support
• Develop awareness and familiarity with issues concerning report generation and database as well as other areas of technology to less technical staff members
• Work with other application team, engineers and developers in resolving issues test, development, qa and production systems and support them in data extraction, transformation and upload both ETL and ELT
• Perform Grid infrastructure and database server patching to maintain current security requirements and database versions
• Installed and managed Confidential big insight platform as poc and administered system patching, and eco system intergration
• Act as initial point of contact for matters pertaining Oracle database, the system’s performance and high availability during regular and off hours support

Environment: Oracle Exadata,X2, X3, X4 and X5, Oracle Databases, UNIX OS, Virtualization

Confidential, Columbia, SC

Lead Senior Oracle Database Administrator/ RAC Architect

Responsibilities:

• Responsible for PoC projects on Big data, Apache Hadoop and NOSQL technologies
• Installed Apache Hadoop cluster including big data echo system, Map reduce 1, hive, mongoDB, sqoop, Confidential big insight
• Responsible for overall installation, deployment, management and maintenance of High Availability and Mission Critical RAC Database with size of over 1TB
• Created Standard Operating Procedures for Oracle environments, RAC installation, daily administration and maintenance, Switch over and fail over instructions
• Recommend appropriate technologies, enhancements upgrades and modifications to systems and procedures to improve the services provided by the Information Technology department
• Lead a team of Oracle DBAs in upgrading mission critical environment from single instance to high availability RAC and Exadata environments on Linux operating system
• Advise and provide guidance and develop High Availability and Disaster Recovery Strategies for Oracle RAC Database
• Implemented and managed a high availability and Disaster Recovery Standby system using Data Guard
• Installed, configured and managed Oracle Agents, grid control, and 12C Cloud control
• Configure systems for Storage allocation, asm disk groups, and file systems using and EMC SAN storage.
• Work closely with the system administrators about system resource usage and allocation, system backups, and system upgrades.
• Perform data analysis and loading data into oracle database using appropriate tools such as SQL loader
• Responsible for generating sql script, shell scripts and stored procedures for data manipulation, data loading and server/database administration
• Work with application developers in enhancing application performance, data management and projects support
• Perform complex analysis of Database server, SQL and PL/SQL queries for optimum database and query performance
• Develop awareness and familiarity with issues concerning report generation and database as well as other areas of technology to less technical staff members
• Work with other application team, engineers and developers in resolving issues test, development, qa and production systems and support them in dataextraction, transformation and upload.
• Perform Grid infrastructure and database server patching to maintain current security requirements and database versions
• Act as initial point of contact for matters pertaining Oracle database, the system’s performance and high availability during regular and off hours support
• Environment: Oracle 10g, Oracle 11g,Oracle Cloud Control, Oracle Linux, Windows Server, Sun Solaris, VM, RAC Database creation and Server Migration

Confidential, Dubuque, IOWA

Oracle Database Administrator

Responsibilities:

• Responsible for all aspects of Oracle DBA support including install, configure and maintain highly available Oracle 11gR2 on single instance and RAC multi-node environment.
• Work as a senior DBA responsible for the OS and Oracle environment, database backup & restore, database performance diagnostics and tuning for client databases.
• Work closely with the system administrators about system resource usage and allocation, system backups, and system upgrades.
• Perform database patching and migration to ASM of existing non ASM databases
• Implemented Database replication for reporting services using Golden Gate
• Perform production database backup, restoreConfigure RMAN for database hot backup, cold backup and archive log backups
• Create, analyze and implement Disaster Recovery Best practices for customers utilizing backup and recovery strategies as well as Standby databases
• Support replication environments using Oracle dataguard and golden gate technologies
• Build Golden gate replication systems for Clients’ Disaster Recovery and Reporting systems
• Give presentation to managers and clients about project status and Database Systems’ health
• Perform Monitoring of database health and availability, monitoring database space usage and growth, adding and resizing data files as needed, creating table spaces and redo logs
• Responsible for maintaining, supporting and troubleshooting Oracle 8i, 9i, 10gand 11g instances running on UNIX and windows platforms
• Explore and use database Data pump utility for database export and import
• Maintain STANDBY Database.
• Clone and duplicated oracle Databases for reporting, testing and development purposes using various tools, RMAN, OS copy as well as oracle data pump
• Write shell scripts for performing database activities such as backup of DB, automatic shutdown and startup of DBs, finding out dumping of core and display of generation of alert logs and to display the contents of Alert log file.
• Environment: Oracle 8i, 9i, 10g and 11g on Sun Solaris, Linux, AIX and windows servers

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Successfully upgraded, installed and managed proprietary clinical applications.
• Successfully installed and implemented multiple oracle 11gr2 RAC databases on customer client sites.
• Provided troubleshooting expertise for both clinical application tier and database tier and resolved several SQL, OS and application tier issues
• Used Oracle enterprise manager (OEM) to monitor, diagnose and resolve database performance issues
• Managed Oracle active data guard & standby database and provided critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Cloned development databases from PROD using RMAN plus configured and scheduled RMAN Backups as per business requirements
• Designed implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle goldengate product suite
• Identified and resolved causes of slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components
• Monitored and resolved different process problems, such as extract and replicate process issues
• Utilized Oracle goldengate troubleshooting tools such as knowledge documents, documentation, SHOWSYNTAX parameter, and the Logdump utility
• Participated in logical and physical database design reviews to ensure application design integrity
• Environment: Linux, Windows XP, 10g, Dbconsole, Grid control, Dataguard,

Confidential, San Ana, California

Oracle Database Administrator

Responsibilities:

• Successfully upgraded oracle 10g RAC databases to latest patch sets
• Developed and deployed SQL, PL/SQL stored procedures, functions and triggers for several in-house projects
• Created and maintained physical, logical and snapshot standby databases for disaster recovery, near real-time reporting, load-testing and production database backup
• Utilized Oracle automatic storage management (ASM), Oracle managed files (OMF) and recovery manager (RMAN) to improve I/O performance, reduce administration overhead and provide a comprehensive backup and recovery strategy.
• Utilized cluster health monitor utility to manage and clusterware and OS resources and resolved known issues
• Successfully implemented and utilized Oracle real applications testing (RAT) for workload management and analyzing and optimizing SQL performance
• Installed and deployed oracle golden gate on Linux server for data replication
• Experience with installing and managing golden gate with DDL support
• Proven Knowledge of golden gate architecture and database replication using golden gate technology
• Experience with replicating big source environments with multiple initial load methods and managing big transactional volumes
• Diagnosed and resolved extract, replicate and network issues during goldengate replication
• Developed monitoring scripts to monitor goldengate and report issues proactively
• Employed Logdump utility to troubleshoot and fix goldengate replication issues
• Unix shell scripting, SED, AWK scripting for automating several DBA tasks
• Utilized performance tools like V$SQLSTATS, ASH and SQL monitoring views to resolve.
• Environment: Oracle 10g, on Windows and UNIX.

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Managed Oracle databases and database servers as well as oracle clients
• Installed Oracle databases on Unix servers and managed space growth and allocation
• Created database Disaster Recovery plans and their implementation according to Oracle best practices and organizations requirements
• Utilized Oracle and OS tools to minitor and troubleshoot database availability and performance issue
• Experience with replicating big source environments with multiple initial load methods and managing big transactional volumes
• Diagnosed and resolved extract, replicate and network issues during goldengate replication
• Developed monitoring scripts to monitor goldengate and report issues proactively
• Employed Logdump utility to troubleshoot and fix goldengate replication issues
• Automate DBA and server house keeping task using shell scripts
• Performed weekly full backups and daily incremental backups using RMAN
• Foresaw and managed Database objects refresh using export and import utilities
• Managed Test and Development databases and performed schedules refreshes from production data
• Performed database installation and upgrades to latest versions

Confidential, Johns Creek, GA

Oracle Database Administrator

Responsibilities:

• Responsible for oracle database environment supporting both Production QA and Development environments.
• Installed, configured, patched and upgraded Oracle databases as vendor released new security and product patches and versions
• Collaborated with Other IT teams including networking, and developers to make sure optimum invironment is configured and remains steady for desired system performance
• Attended Meetings and advised on Database issues and how to improve applications performance by implementing database best practices for different application needs
• Implemented database partition and data mean time to live and purged partitions after life time expires
• Performed database patching and cloning of database instances for different projects
• Monitored database logs, alert logs for potential issues and resolve issues as they arise
• Monitored database capacity and space utilization allocating space as databases size grew
• Acted as point of contact for database related issues, and acted promptly to resolve issues
• Implemented backup scheme and schedule for Production databases
• Managed database objects, users, privileges and roles so as to maintain access and database security