SUMMARY:

• 9 plus years of experience as Data Architect/Oracle Dba and BigData and BigData analytics
• Having 3 plus of experience in (Big Data) Hadoop technologies such as (Hbase, Hive, Confidential, Flume, SQOOP).
• experience on creating databases, tables and views in Hbase, Hive, Mongodb, couchdb
• written and executed queries in Confidential
• experience in loading data in PIG using LATIN
• Having hands on experience in writing Map Reduce jobs in Hive, Confidential, Pig.
• SPARK on Data Brics.
• Worked with Confidential .
• Migrated applications and databases to Cloud Platform.
• Used REST api to pull json data and load Nosql databases .
• Having experience on HDFS file system..
• Having experience on export and import data from different systems to Hadoop file System by using Sqoop.
• Having experience on using OOZIE to define and schedule the jobs.
• Having experience on Storage and Processing in Hue covering all Hadoop ecosystem components
• Experience in database design and development.
• Database Design with Developer 2000/10g and Erwin
• Creating Logical and Physical Database design and Entity Relationship Models
• Experience in using Oracle Developer and Erwin to create ERT models
• Create and store Logical and physical data base models for new application design
• Develop PL/SQL Packages, Procedures, Triggers
• Experience in UNIX shell programming and PL/SQL
• SME for Data Centre Migration Project involving data bases ranging from 6 GB to 30TB.
• Used RMAN Restore, SRDF, Data Guard Methodologies for Migration
• Migrated both RAC and NON - RAC databases
• Set up Multi Master (Advanced Replication)
• Setup Data guard on 10g R2 and 11g R2
• Worked with ASM extensively and OEM Grid Infrastructure
• Fine tune the new databases for Maximum performance.
• Administered databases on Linux, IBM-AIX, Solaris, Windows
• Involved with installation and maintenance of RAC on 10g and 11g R2
• Configure, trouble shoot, switchover, failover Data Guard on 10g and 11gr2
• Experience in Oracle Enterprise Manager (OEM) & Oracle Management Server (OMS).
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables
• Applied patches and involved in patch set up gradation
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.
• Experience in Design, Creating and maintaining the Oracle Database.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Experience in doing backups and recovery using RMAN and Scripts.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,5.3 Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11g,10g/9i/8i, Oracle 10g Real Application Cluster (RAC)

Languages: SQL, PL/SQL, C, C++, XML, UNIX Shell Scripting.

DB Management: TOAD, OEM 9.2

Tools/Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Query builder, Net Backup, VB, Crystal Report, MS Access, Oracle Streams.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Database Modeling: Oracle Designer

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA/ Detroit, MI

Data Architecht/Hadoop Engineer

Responsibilities:

• Having hands on experience in using Hadoop Technologies such as HDFS, HIVE, SQOOP, Confidential , Flume, Solr.
• Having hands on experience in Map Reduce jobs in Hive, Pig.
• Having experience on importing and exporting data from different systems to Hadoop file system using SQOOP.
• Using Hadoop ecosystem components for storage and processing data, exported data into Tableau using Live connection.
• Having experience on creating databases, tables and views in HIVEQL, Confidential and PIG LATIN.
• Strong knowledge of Hadoop and Hive’s analytical functions.
• Implemented Proof of Concepts on Hadoop stack and different bigdata analytic tools, migration from different databases ( i.e. Oracle, MySQL) to Hadoop.
• Having experience on using OOZIE to define and schedule the jobs.
• Having experience on Storage and Processing in Hue covering all Hadoop ecosystem components.
• Load and transform large sets of structured, semi-structured and unstructured data using Hadoop ecosystem components.
• Efficient in building hive, pig and map-reduce scripts.
• Having knowledge on Zookeeper.
• Experience in working with different data sources like Flat files, XML files and Databases.
• Having experience on Managing HDFS file system.
• Having knowledge on Couch dB, MongoDB, Cassandra.
• Having good experience on all flavors of Hadoop(Cloudera, Hortonworks, MapR).
• Develop and maintain logical and physical database designs for clients and internal applications.
• Define business and design elegant database solutions that meet their needs
• Create, maintain, and document all tables, views, snapshots and other database objects created for development
• Write triggers and check constraints to ensure data Integrity
• Design and maintain database standards and data standards.
• Define domains and maintain naming standards for new and existing data structures
• Maintain database integrity and naming standards
• Analyze and process complex data from heterogeneous sources
• Coordinate and perform detailed, complex data cleansing
• Design, implement, and document exception handling for non-standard and redundant data
• Design, implement, and document shell scripts and PL/SQL procedures to execute loads into databases
• Manage, maintain, and document client, schema, and program codes common between clients and internal databases
• Document new and existing changes enterprise data processes and procedures

Confidential, DEARBORN, MI

Sr. Oracle DBA

Responsibilities:

• Part of the team that performed 8i/91 database migration to oracle 11G both stand alone and Data Guard set up
• Migration done through export/import Utilities and database refresh.
• Used export/import utility as well as data pump utility to do database refresh.
• Wrote shell scripts to automate processes
• Refreshed over 100 databases at the current client.
• Oracle Grid Control 11g Installation and Configuration.
• Supported oracle version 8i/9i on Windows NT and W2k
• Migrations from oracle version 8i/9i on Windows to oracle 11gR2
• Modified shell scripts to changed business requirements
• Build databases, both single instance, data guard
• Automated database creation and data guard builds through shell scripts
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Drafted best Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Design and trouble shoot, Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM

Environment: ORACLE 8i/9i/10g/11g, RMAN, GRID, OEM, DATAGUARD, Data pump, AWR, on windows 2000/2003, UNIX, SLES10, Solaris 9, AIX.

Confidential, Waltham, MA

Sr.Oracle DBA

Responsibilities:

• Managing production instances in 24/7 environment.
• Administering Oracle Databases 10gR2, 11g R1, 11g R2 with over 5 TB in size.
• Trouble shooting for performance issues.
• Approach to issues by collecting stats pack, AWR and OEM.
• Collected stats, rebuild indexes, provided hints to improve performance.
• Collected statistics on object and schema level
• Created partitions
• Created global and local partition indexes
• Cloned/Refreshed Oracle Databases for development and testing.
• Knowledge of the Oracle Golden Gate installation, configuration.
• Deployed Disaster Recovery (DR) solution for Oracle 10g using Data guard.
• Implemented Oracle 11g Data guard for High Availability and maintained stand by database
• Implemented strategy for partitioning and management of historical data tables in RAC.
• Performance tuning, troubleshooting & monitoring using ADDM and Automatic Workload Repository Advisor in Oracle for very large OLTP databases (VLDB’S).
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN
• Monitored table space size, resize table space, relocating data files for better disk I/O.
• Responsible for setting and managing user accounts, Granting required privileges to users
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Shell scripting for Linux servers to perform database maintenance operations.
• Performed DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.

Environment: ORACLE 9i/10g/11g, RMAN, RAC, ASM, GRID, OEM, DATAGUARD, Data pump, AWR, ADDM, ASSM, Humming bird, X-manager, Golden Gate, SQL Developer, SQL, UNIX, HP, Sun Solaris 9, 10, Linux AS4.0, IBM AIX, Jira Ticketing tool.

Confidential, Nashville, TN

Oracle Database Architect

Responsibilities:

• Deciding and executing the strategy for Migration
• Created UNIX shell scripts for Restore and Recovery
• Ran scripts in background with “nohup” option
• Restore from Backup tapes and apply differential backups using RMAN recovery
• Supplied logs for recovery while using recover database until cancel
• Built New RAC servers
• ASM disk group creation, drop, add disks
• Created backup strategy by creating a trace controlfile and editing the trace
• Used the edited version of trace file to recover databases
• Gather incoming and outgoing connections to database using listener. log and dblinks
• Firewall testing on new server using telnet and tnsping
• Enable, disable, and edit the crontab on the new server
• Schedule cron jobs
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Database Creation for UNIX Server; Parameter Assignment in init file or session level assignment; database startup and shutdown process. Database configuration on parameter file and operating system file
• Database User Creation with limited rights as per specific module under specific client. Creating roles and profiles as per system study and assign to users.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Configured backup strategy for all production databases.

Environment: ORACLE 9i/10g/11g, RMAN, RAC, ASM, GRID, OEM, DATAGUARD, EMC SAN Storage, SRDF, Data pump, AWR, ADDM, ASSM, Humming bird, X-manager, SQL Developer, TOAD, SQL, UNIX, HP, Sun Solaris 9, 10, Linux AS4.0Confidential, Cincinnati, OH

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, and maintenance of Oracle 10g and 11 g R2 on UNIX environment (SOLARIS). Upgraded from Oracle 10g to 11g
• Ran Pre migration scripts
• Checked for invalid objects
• Checked the consistency of Diagnostic dest folder
• Created pfile from spfile and copied it to 11g target Home
• Configured Oracle Net, RMAN and Data guard in 11g after Up gradation
• Ran Post Migration Scripts
• Applied Time Zone Patch
• Install and upgraded RAC on 11g R2
• Responsible for setup and implementation of 2 node RAC on Linux in 10g and 11g R2
• Implemented and Managed Oracle Data Guard on Oracle 10g and 11gR2
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Daily Health Check Up of the Database using statspack, AWR, ADDM.
• Provide at least double redundancy for all development databases.
• Database backup & Recovery with export and import for non archive and archive database with RMAN commands.
• Implemented Data Guard on production database.
• Develop and enforce both database and OS-level security policies for data protection. Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Undo table space management for rollback segment; Rollback segment creation and assignment for transaction as per departmental requirement for process.
• Hands on experience working on High Availability Environments
• Month end job monitoring and checklist preparation and co-ordination.
• Post installation process, kernel upgrade, applying support packs and add-ons.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Automated Database refresh from the Host system to Oracle using PERL-scripts, SQL and PL*SQL procedures.
• Creation of database objects like Tables, Indexes, Views, Users, etc
• Monitoring Batch jobs and SQL files.
• Created database links for Center’s tables to update Corporate database for billing modules
• Migration of database from one server to another server.
• Scheduling the databases backup using cron tab.
• Managing databases on multiple servers.
• Disk Space Monitoring
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules
• Managing & providing 24 X 7 supports for various versions of databases.

Environment: Oracle 10.1.0.4/10.2.0.4/11 g, IBM AIX 5L/6.1, Windows 2003, Oracle Enterprise Manager Grid Control, RDBMS, SMO 3.0, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, CSSCAN and CSALTER utility, TOAD

Confidential, Columbus, OH

Sr. Oracle DBA

Responsibilities:

• Implemented Real Application Cluster (RAC) Setup & Administration.
• Supported different Databases like Production, Development, Testing, UAT and Training.
• Recovered critical databases from failures with minimum downtime.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Designed Logical and Physical Modeling using C.A Erwin.
• Logical to Physical Transformation using Erwin
• Forward engineering using Erwin
• Reverse engineering using Erwin
• Model to model comparison using Erwin
• Conducted daily routine checks on alert logs and trace files.
• Creating the Database, table space, Control files, log files and user profiles
• Performed Backup and Recovery with export and import for non archive and archive database using RMAN, scheduled backup on Solaris& NT environments using the incremental complete and full backup strategies based on the database purposes.
• Automated back-up procedures using crontab.
• Performed activities such as Query Optimization, Database Consistency Monitoring. Configured and managed replication server.
• Expertise in Installation, Configuration, Application Support, Performance Tuning/ Optimization, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance and configure database stand by database using Data Guard.
• Automated database backup using shell scripting.
• Involved in the database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain the security according to application.
• Worked on performance and tuning on SQL queries wherever it is required.
• Install OCI header files on Client Machines.
• Migration of database from one server to another server.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Rename the database and database SID.
• Create Directory in the database.
• Moving data files from one location to other.
• Scheduling Oracle Jobs in the database.
• Analyze the schema and tables.
• Finding average row length for all the tables in each schema.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Develop table structures, PL*SQL stored procedures and database triggers to implement
• Responsible to provide 24 x 7 database administrative activities over different database servers

Environment: Oracle 10.2.0.3/11.1.0.6/.7, Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard, CICS business rules.