SUMMARY:

• 12 years of experience in design, administration and development of RDBMS and NoSQL database systems of large enterprises and government agencies.
• Over 2 years of experience in installation and development of Big Data projects using Hadoop Ecosystem and NoSQL data stores.
• Subject Matter Expert in all aspects of Oracle database administration. Proficient in administration of MongoDB, PostgreSQL and SQL Server.
• Installed and managed Hadoop clusters and Hadoop ecosystem components. Developed Pig, Hive code. Experienced in Apache Solr and Neo4j databases. Trained on Apache Spark.
• Experienced as technical lead in 24*7 database support team, large data center provisioning/migration and data warehouse development projects. Administrated VLDB databases.
• Proven experience in requirement analysis, data modeling and ETL development. Experienced in development and administration of Informatica.
• Extensive experience in installation, backup/recovery, migrations and upgrade of various RDBMS and NoSQL databases. Configured database security features.
• Implemented High Availability and Disaster Recovery solutions using Oracle RAC, Active Data Guard, Streams, Veritas Clustering, SQL Server replication, MongoDB Replica sets and sharding, PostgreSQL replication, Storage level replication.
• Experienced in capacity planning, performance tuning, and database reorganization.
• Seasoned professional with excellent interpersonal skills and problem solving abilities.
• Oracle Certified Professional (9i/10g/11g DBA). MongoDB certified DBA.
• Cloudera Certified Administrator for Apache Hadoop (CCAH).

TECHNICAL SKILLS:

DBA: Oracle RAC, MongoDB, PostgreSQL, SQL Server, Neo4j.

OS: Linux ( Redhat, SuSe, CentOS, Debian, Ubuntu ), Solaris, HP - UX, Windows

BigData/Hadoop: HDFS, MapReduce, Pig, Hive, Sqoop, Flume, Oozie, Spark, Zookeeper, Nagios

Languages: SQL, PL/SQL, Python, Shell Script, Java Script, CQL, Cipher

DW/ETL/BI: ER/Studio, ERwin, Informatica, Business Objects, Qlikview, Tableau

Familiar with: SAP HANA, Openstack, Cassandra, Elasticsearch, Solr, HBase

PROFESSIONAL EXPERIENCE:

BigData/NoSQL Consultant

Confidential

Technologies: Oracle RAC, MongoDB, PostgreSQL, SQL Server, Linux, Hadoop, Pig, Hive, Sqoop, Flume, Informatica, Python, Esri(Oracle/Postgres Spatial), Qlikview, Tableau and Nagios.

Responsibilities:

• Provided technical leadership and hands-on support in database and BigData projects.
• Installed and administered Hadoop clusters. Performed cluster administration that includes adding and removing nodes, capacity planning, performance tuning, monitoring and troubleshooting.
• Installed and maintained MongoDB with replica sets. Modeled MongoDB collections, developed aggregation pipelines, migrated oracle schemas to MongoDB.
• Integrated Hadoop with Enterprise Data warehouse. Developed ETL based on pig, Sqoop and Flume. Used Hive for data aggregations. Deployed multi-hop flume environment.
• Configured Fair Scheduler to provide service-level agreements for multiple users of the cluster.
• Implemented monitoring using Nagios and Ganglia for production environments.
• Integrated Apache Solr with MongoDB and MySQL databases. Installed Neo4j.
• Setup backup, HA and disaster recovery for Oracle and MongoDB databases. Implemented Transparent Data Encryption for oracle tables containing PII and PHI.
• Implemented performance enhancing structures such as materialized views, OLAP cubes and replication solutions (MongoDB replication, PostgreSQL replication).
• Developed ETL mappings and workflows using Informatica. Administered Informatica environment, Upgraded Informatica from 8.6 to 9.1. Converted many PL/SQL ETLs to Informatica.
• Designed and maintained physical and logical models of the data warehouse, data mart, and staging area. Developed source-to-target mappings.

Sr. Data warehouse DBA/Developer

Confidential

Technologies: Oracle 10g/11g RAC, ASM, Data guard, Streams, OEM, Linux, PostgreSQL, SQL Server 2008, PL/SQL, Oracle Spatial, Informatica, Business Objects.

Responsibilities:

• Administrated all aspect of Oracle RAC databases for Production, QA and Development environments. Also, maintained SQL Server and PostgreSQL databases.
• Migrated several databases from Oracle 10g 32-bit Windows to Oracle 11g 64-bit Linux.
• Implemented large scale database re-organization (partitioning, compression, resource manager).
• Configured database auditing. Setup Oracle streams, Data guard, SQL Server replication.
• Improved performance of several slow running ETL and BI reports. Implemented database and ETL monitoring via OEM and custom scripts. Conducted backup/restore and DR drills.
• Performed requirement analysis, created dimensional models for new data warehousing projects and worked closely with Data Architect and Business Intelligence team.
• Developed custom ETL modules using PL/SQL. Developed and maintained Informatica and PL/SQL based ETL loads from several DC agencies and groups.
• Providing technical supervision to other DBA resources in the team.
• Maintained database documentation, data dictionaries and data models.

DBA Team Lead

Confidential

Technologies: Oracle 10g/11g, RAC, ASM, OCFS, Veritas, SQL Server, Sybase, Solaris, Linux, Windows, VMware, EMC.

Responsibilities:

• Provisioning DBA Lead for US and UK regions.
• Install and configure Oracle 10g & 11g RAC/Non-RAC Databases for Production, QA and Development environments for all business units across US and UK regions.
• Handled database issues escalated by L3 support team. Built more than 200 Oracle RAC Clusters.
• Configured Grid Control, RMAN backup, Setup Veritas HA.
• Design, Develop and test Disaster recovery EMC SRDF, BCV, Data guard .
• Installed SQL Server 2005/2008 and Sybase 12/15 on clustered platforms.
• Ensured system and databases conforms to corporate security standards.
• Re-engineered the whole database provisioning process. Developed scripts for rapid deployment of database systems on Solaris and various Linux platforms.
• Member of organization wide enterprise server and database architecture team. Setup documentation on new database hosting platform.

Sr. Database Administrator

Confidential

Technologies: used were Oracle8i/9i/10g, RAC, PostgreSQL 7.x/8.x, HP-UX 11i, Linux, HP Serviceguard, Veritas Clustering, SQL Server 2000/2005 with MS Clustering, Perl/Shell Scripting..

Responsibilities:

• Lead DBA for Oracle and PostgreSQL databases of HP Imaging and Printing Group (IPG).
• Performed database installations, migrations and upgrade. Performed Character set migrations.
• Migrated 150+ databases from user managed backup to RMAN with HP OmniBack.
• Setup High Availability environments using HP Serviceguard clusters and Veritas Clustering.
• Technical lead for datacenter Disaster Recovery Drill.
• Reviewed the change tickets and represented the team in the Change Approval Board meeting.
• Conducted extensive research on the legacy In-house database/server monitoring setup, resolved the false alerts issues and reduced it to zero. Received for this effort.

Senior Database Support Engineer

Confidential

Technologies: Oracle 8i, 9i, Oracle Applications 11i on HP 9000 super-domes clusters with HP-UX 11i, Oracle data guard.

Responsibilities:

• Database Re-organization & Performance Tuning. VSNL, Mumbai: Implemented partitioning for 300 tables/indexes. Migrated of database files to a new and faster storage box.
• Capacity Planning & Database designing. New India Assurance, Mumbai: Performed database capacity planning. Designed the file system layout.
• Performance Tuning. Income Tax Department, Mumbai: Conducted database performance analysis, identified the problematic areas and suggested solutions that helped to achieve improved performance.

Database Engineer

Confidential

Responsibilities:

• Database Development & Support Hindustan Machine Tools, Bangalore: Administration of oracle8/8i databases. Backup management; Performance tuning. Worked on in-house ERP development project. Developed Ad-hoc reports using PL/SQL and Oracle Reports.
• DataScribe Development: Development of DataScribe, application for automating medical transcription. Tools used were Visual Basic 6.0, SQL Server and Crystal Reports. and