Oracle Microsoft Office

Jaspreet Singh E-mail: ***********@*****.***

Mysql DBA www.linkedin.com/in/jasappsdba

Phone:510-***-****

Summary

Overall 14+Years’ Experience in IT Industry as Database Administrator with specializing in data architecture and development using Oracle, MySQL, NoSQL, Big data Technologies.

Technical Expertise in Database system architecture and design, modeling, development, data warehousing, decision support systems, web-based data solutions, Unix system administration, internet communications, user interface and ergonomics, multilingual application development, feasibility analysis (prototyping), application and query performance tuning.

A team player and leader with excellent written and verbal communication skills and outstanding interpersonal skills.

Over 5 years of MySQL DBA experience in replication, High availability, Clustering and performance tuning.

Over 2 years of NoSQL DBA experience in Mongodb/Cassandra with expertise in Partitioning, clustering, sharding, High availability and performance tuning

Implemented Multi Master Replication configuration using Percona cluster.

Set Up Multi-Master Replication Using Tungsten And MySQL-Proxy For MySQL High Availability.

Experience in setting up MySQL backup using XtraBackup,mysqldump. Mysqlbackup.

Good understanding of enterprise tools like MySQL workbench/MySQL monitor

Sound knowledge of MySQL Indexing, Query performance tuning and optimizations

Monitor and optimize MySQL database performance and capacity planning

Implemented large-scale data processing using Cassandra and Mongodb sizes over 100TB.

Experience in Monitoring and optimizing database performance and capacity planning

Experience in Tuning JVM using jconsole,jstat and Eclipse MAT

Experience in setting up and configuring Backup and recovery procedures for databases.

Knowledge of Hardware including RAID, Multiprocessor Architecture, Networking, Memory.

Expertise in upgrading OS from RHEL 5 to 6 for SQL/NoSQLdatabases.

Used Agile/Kanban system to manage the projects.

Experience with creating portal in for OpenstackVM management using provisioned cluster.

Performed Automation for VM configuration using Puppet/Chef

Experience with Unix Shell Scripting for automating the DBA tasks.

Good at intellectual knowledge base creation-documentation during the project implementation phase and maintenance phase

Hard working, well in analytical and logical problem solving and excellent communication skills. Worked efficiently as an individual as well as in team environment

Have given presentation and writtenwhite paper on Performance Tuning and Capacity planning in Oracle.

Skill Set

Technical

Operating System

RHEL,Centos,Ubuntu,AIX,HPUX,Sun,MS Windows 2012,2008

RDBMS

Microsoft SQL Server 2012, Oracle 11g12c,, MySQL5.x,Postgres

NoSQL Technologies

Mongo DB 2.x/3.x,Cassandra1.x,2.x,Vertica7.x

Scripting Language

Shell,PHP,Python,PowerShell

Performance Tools

MySQL workbench/MySQL monitor,Oracle OEM,DatastaxOpscenter,SolarWinds,Zenos,Ignite,Jstat,Jconsole,Nagios, Percona Tool kit, Htop, Netstat,NetHogs, iftop

Application Server

IIS7,Apache,Tomcat,Weblogic

Business Suite

Oracle ERP11i/R12

Office Suite

Microsoft Office, MS VISIO.MS Projects

PROFESSIONAL EXPERIENCE:

Jul’15 -till date Risk Management Systems

Sr DBA Newark, CA

Building database system for Catastrophe models and map the risk landscape, quantifying the impacts of natural and man-made catastrophes for the global insurance and reinsurance industry

Responsibilities:

Migration of Oracle Databases to MySQL

Configure MySQL Cluster with Multi master and master/slave configuration

Manage database using Percona toolkit and MySQL workbench/MySQL monitor

Setup Aurora engine for mysql databases.

Set Up Multi-Master Replication Using Tungsten And MySQL-Proxy For MySQL High Availability.

Define services to check for consistency for slaves with eventual consistency

Scheduling and monitoring backups using commvault.

Develop complex SQL queries using efficient function

Setup Master/Master and Master slave configuration.

Setting MySQL varied parameters like per thread buffer, Global buffers and Insert parameters

Implemented MySQL Indexing, Query performance tuning and optimizations

Monitor and optimize MySQL database performance and capacity planning.

Build NoSQL system heavy write intensive applications using Mongo/Cassandra

Configuring Nagios for OS and Database health monitoring.

Monitoring Database health using Solarwinds,Zenoss,Ignite

Setting up alert for MySQL (uptime, Users, Replication information, Alert based on different query).

Troubleshooting issues raised by the users and technical team during the entire upgrade project

Create and maintain EC2 Instance on AWS (small, medium, large and xlarge).

Feb ‘10 – Jun’15 Yahoo

Sr DBA/Cloud Openstack SE Sunnyvale, CA

As the Lead member of the oracle apps cloud team charged with defining next-generation product line

leveraging multi-tenant cloud architecture model. Oversaw the evaluation and selection of

business intelligence and database technologies.

Responsibilities:

Installation and configuration of MySQL database servers.

Writing SQL queries, stored procedures and code review of SQL Code by developer

Created documentations for MySQL 5.6 databases i.e. Backup & Recovery procedures,

Created Maintenance procedures, Performance Tuning procedures.

Monitor and optimize MySQL database performance and capacity planning.

Installed LAMP stack, and build PHP portal over apache.

Monitor Replication for master/master and master /slaves configurations.

Worked with different MySQL tools like Workbench and Toad for MySQL etc...

Migration of Mysql database from physical machines to openstackcloud .

Build PHP portal to manage mysql database on openstack cloud.

Automated mysql server build during the vm spin and joining it to the MySQL cluster.

Writing of UNIX shell scripts to manage the health of database proactively.

Feb ‘08 – Feb’10 Cisco

Oracle Apps DBA/Architect/Performance Tuner San Jose, CA

As the Solution Architect/APPS DBAfor The ICE (Incentive Compensation Excellence) Programto create a world class, agile and trusted compensation business and system architecture, with seamlessly embedded business controls, to effectively drive Cisco sales and partners behaviour.

Responsibilities:

Responsible for installation of Oracle Applications R12/11i in single node &Multinode

Perform Complex RAC setup with shared appl-tier application system

Load testing the oracle application before the go live using Mercury Load runner

Load Balancing Mid-Tier web servers with BigIP Load balancer with 4 nodes

Load Balancing Concurrent Processing tier – PCP with 2 nodes

Applying one-off fixes to Database Oracle Homes (both RAC and non-RAC) using Opatch utility

Cloning Oracle Applications instances both R12 and 11i instances with RAC to RAC,Multi node

Applying Rollup Patches R12.0.1, R12.0.2, R12.0.3.

Developing Strategies for Oracle Application Upgrades from a lower version to higher version

Frequent Upgrades of techstack components and applying one-off fixes to 10.1.2 and 10.1.3 Oracle

Setting up resource manager with DBMS_Scheduler

Upgrading 11.5.10 environment to 11.5.10 CU2

Setting up and monitoring the Data Guard for 10g Production servers.

Applying patches using distributed AD

Relinking applications executables

Oct ‘05 – Jan-‘08 Oracle Corporation

Oracle Apps DBA/Architect/Performance Tuner Pleasanton, CA

As The Solution Architect / Enterprise Architect responsible for working with client’s senior level technical and business resources to understand their business needs and help shape the desired solution. Focusing on R12 Upgrade/Implementation with 10g/11g databases.

Responsibilities:

Oracle Applications R12 MultipleNode installation in Sun Boxes.

Tuning of Jservand Apache web server, forms server and architectural differences between technologies stacks of apps 11i. Actively participated in several mercury cloud tests for Network Efficiency.

Load testing the oracle application before the go live using Mercury Load runner

UpgradePatching of the R12 Instances

TroubleshooterApache, Forms and CM service availability on daily basis

Installed and configured the Load balancer for apps mid tiers

Capacity planning of the Hardware sizing for CPU/RAM for Database tier and Mid tiers

Setup monitoring through EM 10g Grid Control and Oracle Alerts

Cloned and automated cloning/refresh process of test and development databases

Applied RDBMS patches using Opatch

Oracle Application Maintenance. The Maintenance includes patching, cloning

Created the plans for the Application Stress testing

Performance Tuning of Applications and database using awr reports.

Apr ‘05 – Oct ‘05 Cisco

Oracle Apps DBA Research Triangle Park, NC

Cisco, upgraded their Oracle Applications from 10.7 to 11i. The application includes Manufacturing, SCM, and Financials. The project was about providing the upgrade support and the capacity planning of the new version.

Responsibilities:

Upgrade of the Oracle Application 10.7 to 11.5.9 for Manufacturing, Financials and Order Supply

Upgrading Oracle Databases from 8i to 9i.

Configuring the Apps on RAC with 2-node database.

Installed and configured the Load balancer for apps mid tiers

Cloning of Database and Applications using adclone, autoconfig and manual cloning.

Used the Maintenance tools like adadmin, adpatch, adaimgr, admrgpch, adctrl

Patch application to the production and non-production environment like Dev, SIT, UAT, and QA.

24X7 Production support when on Call.

Database backup and recovery Using RAID /BCV (Time Finder) integrated with Third party tools.

Trouble shoot day-to-day database and application problems.

Analyzed the statspack report for the performance Tuning.

Tuning for I/O Contention, Memory contention, Row Migration, Block Contentions, etc.

Jul ‘03 – Mar ‘05 Fidelity Investments

Oracle Apps DBA Merrimack, NH

This Project is about handling of Financials and HRMS of a large user base of multi clients like Fidelity, Boeing, Agilent Inc., Genuity Inc. major responsibilities have been implementation and 24x7 on call support for the Oracle Applications and databases.

Responsibilities:

Implementations of Oracle Financials Applications 11i (11.5.10/11.5.9 /11.5.8) for (GL, AP, AR, FA.)

Installation & Configuration of HRMS modules: Payroll, HR, Health and other Benefits

Upgrading Oracle Applications from 11.0.3 to 11i (11.5.4/11.5.9/11.5.10)

Upgrading Oracle Databases from 9i to 10g.

Installation and Configuration of Oracle Web Server, Forms Server, Concurrent Managers.

Cloning of Database and Applications using adclone, autoconfig and manual cloning.

Export in using Maintenance tools like adadmin, adpatch, adaimgr, admrgpch, adctrl

Patch application to the production and non-production environment like Dev, SIT, UAT, and QA.

24X7 Production support for 160 HRMS databases when on Call.

Configuring and running the patches fromKintana including the vertex and hrglobal driver setup

Feb ‘02 - Jul ‘03 PolarisSoftware Labs

Oracle Apps DBA Gurgaon, India

Worked with Polaris clientGE Capital International Services is a Financial Institution, which manages financial accounting information. As an Oracle Applications DBA. GE Capital has implemented a multi-server architecture of a Production instance and Test instance.

Responsibilities:

Installation & Configuration of Oracle Apps 11.5.4: GL, AP, AR, FA, HR, Payroll

Installing Oracle Database 8i/9i.

Oracle Apps upgrade from 11.0.3 to 11.5.4

Installing and configuring Real Application Cluster (RAC) on two nodes for the load balancing.

Refresh Test instance from Production instance on a regular interval.

Install patches using Adpatch utility.

Installation of Discoverer Administration Edition 4i and Creation of the Discoverer 4i End User Layer (EUL)

Coordination with Oracle for TAR using Metalink.

Responsible for Severity 1 & 2 Tars and providing 24X7 support.

Administer the data that users enter, update, and delete while using Oracle Applications.

Manage Tablespaces, Rollback Segments, Redo Logs and other database objects.

Communicate regularly with internal technical, applications and operational staff, particularly as a liaison between the DBA's and the application systems development team as appropriate, in order to ensure integrity, security and availability of the database. Provide support for post-live issues.

Environment:HPUX-11, Sun 5.8, Oracle Applications11i (11.5.8 / 11.5.9), Financials, Oracle8i / 9i.

Jan 00 - Jan ‘02 TATA Consultancy Services

Oracle DBA Gurgaon, India

Worked as Oracle DBA in a team size of 15 with maximum database size Up to 50 GB of different types like Q&A, development and test on VERITAS Cluster Server.Worked with several clients of TCS like Dresdner RCM, P&O, ISBS

Worked as a Database Administrator in a team size of 10 with maximum database size Up to 500 GB of different types like production, Q&A, Development and test.

Included Oracle Installation, tuning of database by parameter file, creation of database, export / import

Create Schema (Tables, Indexes, views, sequences, synonyms, roles, and users), grant roles to users.

Handling Database recovery / crashes using hot /cold backups and dump/loads.

Reorganization of existing database to standardize the placement of various databases related files.

Writing of UNIX shell scripts to manage the health of database

Performing space estimation for database objects. Taking hot backup of all production databases

maintaining, tuning and upgrading database.

Estimating disk space requirement and de-fragmenting, analyzing objects, rebuilding indexes,

Environment: IBM-AIX 4.1, Sun Solaris 5.5., HP UX-10.20/11.0, Oracle 8i/7.3.4

Education and Training:

Graduated from IETE, New Delhi, India in Electronics and Telecommunication

Post Graduation in Business Administration from Symbiosis, Pune

Diploma in Computer Eng from Ambedkar Polytechnic, New Delhi, India.

Oracle Certified Professional

Oracle APPS DBA course from Oracle Corporation

Oracle DBA 11g from Oracle Corporation

Contact this candidate