SUMMARY:

• Approx. 10+ years of experience in Database Administration, Architectures, Virtualization, Design, Development & Support of in Production and Development with a Primary Focus on MS SQL Server 2005/2008 R2/2012, Oracle 11g/10g and MongoDB 2.4,2.6,3.0, Cassandra 2.0 and up.
• Installed, configured MongoD, MongoS, Config Servers Linux 64 bit platform with best practices
• Implemented 11 nodes sharding cluster with 5/3/2 node Replica sets to best fit application performance and reliability.
• Experience in maintaining setting up poc, pre - prod clusters in Mongodb Environment.
• Experience in installing and maintaining On-Prem Mongo Ops Center, Mongo Backup Agent service Mongo databases for Point in time recovery strategies.
• Implemented, environment based Backup and Recovery procedures
• Created policies and developed models to support MongoDB Backups, Notifications and Security in non-MMS environments
• Installed Cassandra 2.0 in Production, Pre-prod environments as per best practices.
• Configured 12 node Cassandra clusters with 2 datacenters across different regions.
• Experience in Tuning Cassandra for Read/Write Workloads.
• Experience in building scalable and fault tolerant Cassandra production database system
• Experience analyzing Big data internal structure in to provide custom results in big data space.
• Experience in storage model in Cassandra and implemented various optimal configuration to meet storage requirements
• Experience in administrating Cassandra cluster using Opcenter 5.0
• Experience in installation, configuration and management of   Hadoop   Clusters 
• Experience in managing teh   Hadoop   infrastructure with Cloudera Manager. 
• Knowledge of in Scala language, framework spark.
• Experience in setting and configuration High availability solution like Oracle 11gR2 4 Node RAC on exadata, adding and deleting node to RAC cluster online.
• Experience in setting up disaster recovery solution like Data guard, Standby Databases, Replication, Always On, and Golden Gate.
• Excellent noledge in Backups, Recovery and Cloning of databases using RMAN & exposure to various technology using VERITAS Net Backup, snapshot technologies.
• Experience on setting up and configuring SQL Server SQL 2005, SQL 2008, SQL 2008 R2, 2012.
• Experience with HA/DR SAN Production environment - Always On, Mirrored Cluster, Log Shipping & Replication.

TECHNICAL SKILLS:

Relational Databases: Oracle 12c,11g, 10g, 9i, SQL Server 2005, 2008 R2,2012, MySQL 5.5,5.7

NoSql Databases: MongoDB 2.4.8,3.0 Cassandra db 1.2,2.0

Querying/Reporting: T-SQL, PL/SQL, SQL * Plus, SQL*Loader, TOAD.

ModellingTools: SQL Server Analysis Server 2005(SSAS),ER-win.

ETL/Reporing Tools : Microsoft Integration Services (SSIS), SSRS.

DataMiningTools: Microsoft Analysis Services(SSAS),Red Gate tools

Server Scripting: PERL, PHYTON, Json, Bson

High Availability: Real Application Clustering,Data Guard,Golden Gate, Log Shipping, sharding, apache clusters

Virtualization: VMware 3.1,4,VMware Fusion,Vmotion.

ProgrammingLanguages: C, C++,PL/SQL, .Net.

Operation Systems: Windows Server 2003/2008, UNIX, Solaris, Macintosh, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA 

Sr. Database Administrator

Responsibilities:

• Installed and Mongodb Ops Manager (On Perm) for monitoring and Backup services
• Performed Point in time recovery for MongoDB into different testing servers using On Perm Ops Manager.
• Implemented and tested multi node Sharded cluster with best practices scalability testing.
• Migrates 3 node sharded cluster form one node to another node with minimal downtime
• Configured 12 node Cassandra clusters with 4 datacenters across different regions.
• solved various production performance issues with Cassandra 2.0
• Installed, configuration and Managed   Hadoop   Clusters
• Worked on Security policies for Cassandra db.
• Knowledge of using Hive, Map-reduce, and loaded data into HDFS. 
• Scheduled Cassandra Backups with OpCenter 5.0.
• Developed Restoration Policies Mongo DB.
• Resolved various production/performance issues on daily bases.
• Administered Cassandra Cluster with OpCenter 5.0, Adding and removing Nodes, Node Repair, and Backups.
• Worked extensively in mongodb Scaling and implemented various best practices for scaling mongodb.
• Worked in performance tuning in mongodb from storage layer to Index tuning in Mongodb
• Benchmarked various mongodb performance measures.
• Worked on implementing Monitise platform, implementation, and production support Oracle 10g, 11g, 12c, MS SQL Server 2008 R2, 2012, troubleshooting production issues.

Environment: RHL-5,6, CentOS, Ops Manager, Bash scripts, Python,Cassandra 1.2, 2.0,Opcenter 5.0,Mongodb 2.4.8,2.6,3.0,Hadoop,AWS, Oracle 10g, 11g, 12c, RAC, Postgres.

Confidential, Thousand Oaks, CA

Sr. Oracle DBA

Responsibilities:

• Worked in a team that supported more TEMPthan 1500+ databases, actively worked on migration from various data center to los Vegas datacenter, implementing Oracle 11gR2 RAC, Dataguard, HP Database and Middleware Automation.
• Installation, configuration maintenance of Oracle 11g 4 NODE RAC, Standby Databases (Data Guard).
• Worked in Converting Non RAC Database to RAC via manual, rconfig utility.
• Performed extensive performance testing via Real application Testing.
• Upgrade teh databases from Oracle 10.2.0.4 to 11.2.0.2, 11.2.0, and 12c.
• Performed advanced Backup and Recovery using Oracle’s Netapp snapshot technology.
• Supporting Data Warehouse Database i.e. over 6 TB in size.
• Experience in setting up third part clustering technology like VERITAS Cluster, vMotion in VM.
• Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.
• Worked on Data center Migration using snap mirroring.
• Worked on setting up Golden Gate replication.
• Worked on Database tuning, SQL tuning, Application tuning & performance monitoring.
• Expert with OEM Grid Control in 11g, 12c, setting up teh monitoring.
• Worked on application and using MySQL database as backend.
• Setup backup via Data pump (Expdp / Impdp), Import / Export for shared application.

Environment: Oracle 10g, 11g, 12c, RAC,MySQL, Exadata OEM Grid Control, VMware, Linux.

Confidential, Los Angeles, CA 

Oracle Database Administrator

Responsibilities:

• Worked on Installation and Configuration of Oracle 11g, 10g on ASM.
• Implement teh automated Hot Backup scripts for teh Daily full backup using shell scripting.
• Ongoing proactive database-level performance tuning, segment management, Index management.
• Worked on logical and physical database design.
• Upgraded databases from Oracle 10.2.0.4 to Oracle 11.1.0.7.
• Maintained standby databases, in both local and remote locations.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Database monitoring and performance tuning using Statspack, AWR, Explain plan, TKPROF/AWR/ADDM.
• Worked on ETL tools and halp teh app team to design teh database for data warehouse.

Environment: Oracle 10g, 11g, Partitioning, Archiving, VMware, Linux, AIX, Media Application.

Confidential, Raritan, NJ 

Oracle DBA

Responsibilities:

• Worked as team lead to administer 2000+ Oracle databases.
• Performing day-to-day database administration tasks like monitoring tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Worked on converting Single Node Non-ASM Database to 2 Node RAC Database.
• Setup teh backup for SAP Database backup management using (Brtools).
• Worked on performance tuning for SAP databases and backup using (Brtools).
• Performed teh SAP refreshes using hot backup via incomplete recovery and cold backup.
• Worked Backup and Recovery using Oracle’s RMAN software; performed database refreshes for dev/test from production environment.

Environment: Oracle 10g/11g, Data Guard, Standby, SAP,Brtools, RMAN, Linux, Solaris.

Confidential

Oracle DBA

Responsibilities:

• Worked as trainee DBA for 9 months and then as joined full time Oracle DBA.
• Installation and implementation of teh Oracle8i, 9i on Windows NT, Linux environment.
• Performed recoveries using hot and cold backup, applied on-off patches, patch sets.
• Upgraded teh databases from 9.2.0.8 to 10.2.0.4.
• Used PL/SQL, SQL Loader as part of ETL process to populate teh operational data store.
• Worked database development writing PL/SQL code, analyzing business requirement.
• Evaluation on packages for higher performance using Explain Plan and tkprof.

Environment: Oracle 9i (9.2.0.8) /10g (10.2.0.4), PL/SQL, tkprof, RMAN, Linux, Solaris.