Oracle/Cassandra/Sql Server/MY SQL

SANJEEV DOBHAL Milpitas, CA, USA. Mobile: 925-***-****

Email: ******.******@*****.***

Professional Summary

Around 17+ year experience in IT including 15+ years Oracle Database Administration and 2+ years of Cassandra/MYSQL/SQL Server Database Administration in UNIX (Sun Solaris, HP UNIX, IBM AIX, Linux and windows) including Production and Application development support. Having strong technical skill set, rich experience, and an impressive record of accomplishment in IT domain.

Extensive experience in the areas of System analysis and Database Administration including database creation, up-gradation, migration, performance tuning, backup and recovery management.

Expertise in applying quarterly security patches (PSU, CPU) and bug fixes.

Experience in using RMAN for Backup, Recovery management, duplication database and build standby databases etc.

Good experience in Installation, Configuring and Administration of Oracle server as well SQL Servers databases.

Experience in setup RAC for 9i/10g/11g databases on Linux environment with ASM functionality.

Implemented 3-hr/3-day/30-day disaster recovery planning, exercises.

Experience in configure and setup Data Guard physical standby for 9i/10g/11g databases.

Expertise in implementation of projects, gathering requirements, interacting with Client, working along with team members, capacity planning, designing including creation of logical and physical storage Structures and projecting future requirements for expansion.

Expertise in using data pump, Exp/Imp, SQL Loader, Toad and Transparent data encryption (TDE).

Experience in working with large Data ware housing (22 TB).

Good working knowledge in OEM Grid Control (11g and 12c), setup alerts for monitoring, Change Management Pack, plugins, RMAN, and AWR/ADDM etc.

Excellent communication skills, excellent team management problem solving skills and an attitude to learn the new cutting edge technologies

Good knowledge of shell scripting, scheduling jobs, debugging and enhancing existing code.

Implemented Heterogeneous Database connections - Oracle to SQL Server.

Expertise in query tuning, memory tuning, find the bottlenecks and pro-actively provide suggestions to application teams, Debugging major oracle issues and interacting with Oracle Support Services on need basis.

Expertise in implementation of projects, gathering requirements, interacting with Client, working along with team members, capacity planning, designing including creation of Logical Storage Structures and projecting future requirements for expansion.

Knowledge of C language and well versed with RDBMS like Oracle, with Front End GUI tool Visual Basic, ASP and ASP.NET.

Experience in Oracle WebLogic / Oracle application server administration.

Automation of regular operational tasks; implement and streamline processes to increase productivity as well as respond to business needs.

More than 10 years of experience as a Lead Oracle DBA in 24x7 Production Support environments.

Exposure on oracle Application DBA

Good working knowledge on Oracle Agile and Demantra Applications/Modules setup and support.

Good working knowledge on OBIEE and Informetica setup and support.

Exposure on MES Applications.

Exposure on Perl scripting.

Working Experience in SQL Server.

Working experience in Cassandra.

Installed and configured Cassandra DataStax Enterprise and OpsCenter monitoring.

Supports/works on Cassandra's database administration.

Supports full life cyle of system deployments.

Hands on experience in configuring snapshot and incremental backups on Cassandra databases.

Attended Cassandra trainings and webinars from Datastax

Migrated data from Oracle database to NOSQL using Sqoop.

Experience on MYSQL and SQL Server Databases.

Experience in automation tools Jenkins, SVN and GitHub.

Trainings/Certifications

Oracle 12C certified professional.

Oracle Weblogic Server 11g: Administration Essentials.

ITIL Foundation Certificate in IT Service Management.

M102: Mongo DB for DBAs.

Scaled Agile Practitioner.

No-SQLs databases (Cassandra, Hive, and Hbase etc).

Tableau (BI) Tool, ELK.

Cisco security Green belt.

MySQL databases.

Education:

Degree

University

Year of Passing

M.C.A.

Purvanchal University, Jaunpur

1998

Experience Summary:

Innovative Solution INC (Client– CISCO, San Jose, USA).

Sr .Database Administrator / Programmer

April, 15 – Till Date

JDS Uniphase Corporation

Senior Oracle Database Administrator

Nov, 12 – April, 15

Innovative Solution INC (Client– Wells Fargo Bank, West Des Moines USA).

Senior System Analyst (Sr. Oracle DBA)

Feb, 11 – Nov, 12

Mahindra Satyam Computer Services Ltd (Client–Chevron, San Ramon, USA).

Senior System Analyst

April, 06 – Feb, 11

Softenger India Pvt. Ltd. (Client– Citibank data center, Chennai, India)

TEAM Lead (oracle) / System Analyst

Nov, 03 – March, 06

Atlas Offshore Pvt. Ltd.

Senior software engineer and Oracle database administrator

May, 03 – Nov, 03

InfoEd Technologies Pvt. Ltd.

Oracle database administrator

July, 02 – May, 03

WoodApple Interactive Pvt. Ltd.

Programmer

Jun, 2000 – Jul, 02

INSDOC

Junior Programmer

Aug, 98 – May, 2000

Technical Skills

Operating Systems

Sun Solaris, HP Unix, IBX AIX,Linux,Windows95/98/2000/NT,MS-DOS

Languages

C,VB, SQL, PL/SQL, Shell Scripting,VB Script and COM,DCOM etc.

Databases

Oracle 8i/9i/10g/11g,12c SQL Server 7,2000, 2005 and 2008

Hardware

Sun Solaris SPARC Enterprise, IBM RS6000 E-Server Pseries 44p Model 270,HP-UX PA RISC 9000, Linux X86-64,DELL4400 Server, DELL2500 Server, COMPAQ PROLANT 5500 Server, COMPAQ PROLANT 6400R Server,E25K.

Web Related

HTML, Java Script, ASP, ASP.Net, Oracle application Server, Oracle webLogic Servers

Domain Knowledge

Banking, Information Technology and Medical

Tools & Utilities

Oracle Enterprise Manager, PL/SQL Developer, SQL Enterprise Manager, Query Analyzer, DTS Package, Export/Import and Profiler, TOAD, SQL *Plus, Pro*C, SQL loader, RMAN, Data pump, NAMES, OID and LDAP, netiq, Autosys, Golden Gate, Oracle Streams, Putty, Secure CRT, Hummingbird, JIRA, Remedy,Sharepoint,Subverson.Sharepoint, Microsoft project 2010

Current Projects Summary:

Client / Projects

CISCO / SNTC, PSS, SCH,SC,DSS and IBNG

Organization/Role

Innovative Solutions INC. / Sr. Database Administrator / Programmer (Sr. Oracle DBA)

Location

Sanjose, CA, USA

Environment

Oracle 12c,11.x, 10.x, IBM AIX, RHL,OEL, Linux X86 64 and Windows 2008, Golden Gate, OEM 12C, RMAN,Putty, Win SCP, Secure CRT, VNC Viewer, Hummingbird, Sharepoint and Toad for Oracle, SQL, PL/SQL, UNIX Shell Scripting, AWR, ADDM.

Responsibilities:

Supporting, development and production databases of internal applications.

Extensive knowledge & working experience of Oracle OEM 12c Architecture, Framework, and Infrastructure.

Consolidated database creation in oracle 12c using multiple PDBs.

Migrated pluggable databases by cloning using DB links and manually moving files.

Used the CDB, PDB views for querying against container, pluggable 12c databases.

Migrated 11.2.0.3 databases to 12.1.0.1 and supporting 12c production databases.

Upgraded databases from 11.2.0.2 to 11.2.0.3 with full version upgrade.

Deploying the database changes thru CVS/SVN control version tool.

Worked on multiple projects as shared resource and responsible for infrastructure and capacity planning of databases, schemas etc.

Managed the security access for databases as part of CDP (Customer Data Protection) process & SOX compliance.

Worked on 11g golden gate unidirectional replication for DML & DDL changes.

Worked on 11gR2 databases. Implemented new features of Oracle 11g like 11g streams, Automatic Memory Management, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, SQL Performance Analyzer, and SQL Plan Management.

Worked in Agile methodology environment in all projects and having daily scrum calls.

Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM, ASH & tkprof.

Experience deploying the data models in the databases.

Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS_STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.

Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.

Worked on Oracle DB Virtual Machine 2.X on Linux servers.

Configuring RMAN backups and traditional backups.

Supported multiple projects end-end for life cycles DEV, QA, LT and Prod environments.

Worked closely with developer for tuning the SQL queries, DB parameters.

Used Materialized Views (snapshots) for replication of data.

Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)

Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.

Worked on the Change Management process for releasing database code.

Designed new meaningful shared documentation directory .Documented various repeatable ERRORS during on call, this helped lookup and troubleshooting time.

Implemented backup and recovery through RMAN tool.

Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Automatic Segment Management.

Deciding and implementing the naming conventions of data file, redo log files, tablespaces, and segments.

Working performance of the views and SQL queries.

Responsible for the database backup and recovery operations and strategies of the databases.

Expertise and support in creating data guard and logical standby setup.

Expertise in maintaining and applying patches (PSU/CPU) and bug fixe patches.

Expertise in creating and suggesting the best approach to duplicate and refresh the databases.

Responsible to provide support as per SLA.

Worked on Cassandra administration and related technologies.

Installed and configured Cassandra DataStax Enterprise and OpsCenter monitoring.

Supports/works on Cassandra's database administration.

Supports full life cyle of system deployments.

Hands on experience in configuring snapshot and incremental backups on Cassandra databases.

Attended Cassandra trainings and webinars from Datastax

Migrated data from Oracle database to NOSQL using Sqoop.

Experience in automation tools Jenkins and GitHub.

Previous Project Summary:

Organization/Role

JDS Uniphase Corporation / Sr. Oracle DBA

Location

Milpitas, CA, USA

Environment

Oracle 11.x, 10.x, IBM AIX, RHL,OEL, Linux X86 64 and Windows 2008, Golden Gate, OEM 12C, RMAN,Putty, Win SCP, Secure CRT, VNC Viewer, Hummingbird, SharePoint and Toad for Oracle.

Company Description:

JDSU (NASDAQ: JDSU; and TSX: JDU) A leading provider of optical products and test and measurement solutions for the communications industry, the JDSU technology portfolio is a key enabler for optical solutions in industries such as broadband communications, brand enhancement and authentication, manufacturing and energy.

JDSU innovation is the catalyst for a multitude of innovative solutions and services that touch people’s lives every day. In the car and at home, at work, at the movies and the mall, even in the bank or the doctor’s office, JDSU technology is part of the next-generation products that make the unimaginable possible.

Responsibilities:

Supporting Production/Stage/Test/Dev databases running for different applications like Oracle 11i E-Business Suit, Agile, Demantra, BI, SOA, ESSBASE and OBIEE.

Providing 24x7 supports for the production and development databases size from 150 GB to 2+ TB.

Experience in using RMAN for Backup, Recovery management, duplication database.

Installing, configuring, administering and tuning Oracle database for 11g, 10g databases on Linux, AIX and windows environment.

Installing and Expertise in OEM 12c and OEM Grid Control, Change Management Pack, plugins, monitoring and setup alert/SMS bases on groups.

Oracle software deployments, and software maintenance including planning and applying Oracle PSU/CPU, bug fix patches.

Installed and configured Oracle agile application (Agile PLM 9.3.3) also upgraded from agile version 9.3.1.

Installed and configured Oracle Demantra application (7.3.1.0).

Installed Oracle OBIEE (11.1.1.7) and performed the related configuration.

Installed Informatica 9.5.1 hotfix 2 and performed the related configuration.

Installed Informatica PWC client, DAC and OBIEE client.

Providing 24x7 supports for the production and development databases size from 150 GB to 2+ TB running on 2 and 3 node RAC cluster with ASM.

Data Guard physical and logical standby setup and maintenance.

Analysis of AWR/ADDM reports and finds the bottlenecks and provides the better solutions; Resolving performance issues caused by problematic queries and tune them for better performance.

Monitor and resolve application design issues and guide application team; CPU, Memory and IO Utilization monitoring at Server level; Space administration including capacity planning.

Perform data model changes for various implementations of projects without affecting the daily database loads and usage by business users.

Involve in discussion with development people for suggestions on project to improve the performance when the system goes live.

Disaster Recovery Configuration, Testing and Coordination.

Manage and mentor technical teams for good service delivery on all operational tasks and projects. Manage the communication and interaction with business customers and technology peers for all Database related tasks and services.

Writing and Maintaining shell scripts, SQL and PL/SQL code.

Expertise in implementation of projects, gathering requirements, interacting with client, working along with teams, capacity planning, designing including creation of Logical Storage Structures and projecting future requirements for expansion.

Expertise in replication tools Oracle streams, golden gate and shareplex setup and maintenance.

Application, Database Performance Tuning and Monitoring.

Contacting Oracle support and raise SR on critical database issues. Resolving ad-hoc database issues requested by Client.

Oracle alert log and trace files monitoring, tkprof trace file generation and analysis, DB hang analysis, resolving table locking and dead lock issues.

Client Name/ Project Name

Wells Fargo Bank / Core Application Oracle DBA Support.

Organization/Role

Innovative Solutions INC. / Senior System Analyst (Sr. Oracle DBA)

Environment

Oracle 10.x, 11.x Sun Solaris 2.9, 2.10 Sun Enterprise Sun, Linux and AIX.

SPARC Enterprise M5000 ; HP-UX U 9000/800; Linux X86 64 and Windows 2008, Golden Gate, Oracle Streams, Secure CRT, Hummingbird, JIRA, Remedy,Sharepoint,Subverson.

Project Description: Core Application Oracle DBA Support Team.

Wells Fargo & Company is a diversified financial services company providing banking, insurance, investments, mortgage and commercial operations around the world. Wells Fargo is the fourth largest bank in the US by assets and the second largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit card. CORE Project is one of the biggest projects of Wells Fargo Home Mortgage. The platform was required to uplift the current sales platform for home mortgage to a new componentized platform, which would simply with development of UI, and reuse the common UI components, which are present across different pages. These components would be integrated to web services to fetch the data for decision on home mortgage.Wells Fargo is in progress to develop Home Mortgage application by 2012, for which our team is supporting from the database point of view. We have different – different environments (Development, UAT, IST, Prod-fix and Production) where we test the application from database as well performance point. It is a very big project where more than 300 technology people are working as one team. My role involves in database administration, database performance, maintaining database servers in RAC/standalone, Database migration/Upgrade, database refreshes, implementation of, database performance strategies, monitoring alert logs, trace files, resolving critical issues, performance tuning of databases, Tuning SQL queries, Writing shell scripts, job scheduling and maintaining standby databases, Oracle Streams, database backups/recoveries using RMAN and expdp/impdp, DDL deployments and ensure all the patches works fine into the production, partitioning, rebuild tables and indexes, TDE implementation.

Responsibilities:-

Configured, implemented 10g/11g RAC with ASM disk on Linux/AIX Servers.

Good working knowledge in database backup/recoveries using RMAN.

Implemented/Set-Up OEM grid control and registered all the databases for monitoring.

Implemented transparent data encryption (TDE).

Implemented Heterogeneous Database connections - Oracle to SQL Server.

Migrated & upgraded oracle databases (Standalone/RAC environments) from Oracle 10gR2 to oracle 11gR2.

Expert in 10g Oracle RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging activities.

Performed database cloning/set-up on VM Servers.

Monitoring and optimizing the Performance of the database, capacity planning and SQL tuning.

Configuring the Streams replication (Capture, Propagation and Apply processes) to replicate the data from the production systems to the operation data stores databases.

Involved in design and implementation of oracle 10g Data-guard both physical/logical standby databases.

Perform DR Test by every quarter.

Implemented Load balancing in RAC environment.

Schema & Tables refresh from Production to Development and Test Environments.

Loading data using SQL Loader and Data Pump utilities.

Writing monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues

Management of schemas, objects & Partitioning of tables & indexes.

Installation and configuration of Oracle Grid Control and deploying the monitoring the agents on all the database servers hosts.

Involved in the applying the patches for the oracle enterprise database servers, the grid control servers and the oracle management agents.

Worked on Automatic Storage Management (ASM) for managing data in SAN.

Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.

SQL tuning and Database tuning has been done based on reports generated by AWR,ADDM, Statspack, Explain Plans and monitor the database performance on daily basis.

Writing Perl and Shell scripts to automate manual DBA tasks.

Applying incremental DDL and DML patches into Production, Development, UAT, Prod-Fix & IST Environments.

Support & Maintenance of Production/Development Databases on various servers with on-call support for Production applications.

Involved in Creating & refreshing Materialized Views as per requirements.

Coordinate with Unix Administrators for space management and other issues.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export / Import utilities).

Refreshed databases and tables using data-pump, Exp/Imp, SQL Loader utilities and created customized shell scripts according to requirements. Worked in database, applications, memory and disk tuning.

Client Name/ Project Name

Chevron Information Technology Company / Base Business Support for Data Management Solutions

Organization/Role

Mahindra Satyam Computer Services Ltd/ Senior System Analyst

Environment

Oracle 8.x, 9.x, 10.x, 11.x Sun Solaris 2.8, 2.9, 2.10 Sun Enterprise Sun SPARC Enterprise M5000 ; HP-UX U 9000/800; Linux X86 64 and Windows 2000

Chevron is one of the global Oil and Gas Company. Chevron ITC is Information Technology division of Chevron and DMS is a group which manages databases of Chevron ITC. There are more than 600 databases supported by DMS DBA Team. These databases consists critical information, which are monitored and maintained in 24/7 support. My role involves in database administration, migration, maintaining database servers in RAC, implementation of backup and recovery strategies, monitoring alert logs, trace files, resolving critical issues, performance tuning of databases. Writing shell scripts, job scheduling and maintaining standby databases. Worked in Audit and SOX controls .Involved in process documentation. Manage Offshore and Onsite DBA Services. SOX controls

Client Name/ Project Name

Citibank Data Center / Oracle Database Support for Citibank Applications.

Organization/Role

Softener India Pvt. Ltd / Team Lead (Oracle DBA, SQL Server)

Environment

Oracle 7.x,8.x, 9.x Sun Solaris, HP Tru64 and Windows 2000

Citibank Data Center is one of the big well-known worldwide banking sector, which are running more than 350+ application supported by 900 databases. These databases consists critical banking information, which are monitored, maintained 24/7 support.

Client Name/ Project Name

J.D Power and other companies / Oracle Database Support for Applications.

Organization/Role

Atlas Offshore Pvt. Ltd / Senior software engineer and Oracle database administrator

Environment

Oracle 8i /SQL Server 7, SQL,PL/SQL,ASP and ASP.Net

Atlas Offshore Pvt. Ltd is one of software development company which has developed client applications (Sales and Information based system) and provided the support for their databasess. My role involves administration, monitoring of databases, and implementation of backup recovery strategies, writing shell/windows scripts, data migration and maintaining. Logical and physical designing of Oracle Databases as per the business requirements. Coding, Testing and implementation of the developmental and production databases. Daily monitoring and maintenance of database to ensure its availability and reliability. Creation of database objects eg. users, groups, roles and table spaces etc.

Client Name/ Project Name

InfoEd Technologies Pvt Ltd / Application and database Team.

Organization/Role

InfoEd Technologies Pvt Ltd / Oracle database administrator

Environment

Oracle 7i,8i,VB,SQL,PL/SQL,Windows

InfoEd Technologies Pvt. Ltd is one of software development company which has developed client and In-House applications and provided the support for their databasess. My role involves: oracle installation, Database creation, monitoring spaces, creation of all databases related objects, database security, account permissions, administration, monitoring of databases back-up/recovery,schema design, creation, data uploading and handling user’s problem related to connections.

Client Name/ Project Name

WoodApple Interactive Pvt. Ltd./ Development and Support Team.

Organization/Role

WoodApple Interactive Pvt. Ltd./ Programmer and SQL & Oracle database Administrator

Environment

Oracle 7i,8i,SQL Server,SQL,PL/SQL,VB,ASP,Oracle,Windows

WoodApple Interactive Pvt. Ltd is one of software development company which has developed client applications and provided the support for their databasess.My role involves Application level Analysis, design,coding,testing and implementation and database level database design, oracle/sql server installation, Database creation, monitoring spaces, creation of all databases related objects, database security, account permissions, back-up/recovery,schema creation, handling user’s problem related to connections.

Client Name/ Project Name

INSDOC (Indian National Documentation Center)/ EDP Division (Development and Support Team).

Organization/Role

INSDOC / Junior Programmer

Environment

Oracle 7i,8i, SQL Server,SQL,PL/SQL,VB,Oracle,Windows

INSDOC is one of the major IT Lab of CSIR, which is responsible to develop and support their applications and databases.Most of the application are information based applications.My role involves Responsible for application as well databases: In the Application level Analysis, design,coding,testing and implementation and database level database design, oracle/sql server installation, Database creation, monitoring spaces, creation of all databases related objects, database security, account permissions, back-up/recovery, schema creation, handling user’s problem related to connections.

Contact this candidate