Oracle Manager
Resume:
Jaspreet Brar
****************@*****.***
Professional Summary
Database Administrator with over 8 years of experience in the administration of relational databases (Oracle) and NoSQL databases which includes analysis, design, development, database administration and tuning.
Proficient in Oracle Database Administration activities like day-to-day support, database design, database administration and building large OLTP/OLAP databases on a variety of UNIX (Solaris, HP-UX, AIX) with Oracle (9i, 10g, 11g, 12c)
Design scalable solutions with various database and infrastructure technologies.
Design high availability/zero downtime solution using active/active approach with streams and golden gate.
Installed, configured and maintained Oracle, Mongo and MySQL databases with 24X7 production support.
Performance Tuning Expert: Diagnosed performance issues using AWR, SQL Tuning Advisor and fixed issues using SQL baselines and SQL profiles.
Extensive experience with Oracle Database Migration/Upgrade.
Design backup and recovery strategy to provide almost zero downtime solutions.
Hands on experience with database backup, restore and disaster recovery procedures using RMAN and Data pump (expdp/impdp).
Hands on experience on Oracle Data Guard.
Expertise in setting up SSL/TLS for Oracle, MySQL and Mongo Databases.
Managed Oracle database security by implementing SOX policies through cronjob from central server.
Worked on setting up MySQL DB, replica, performing upgrades and switchover of MySQL databases.
Worked on Mongo DB with Wired Tiger Engine. Experience with Ops Manager to setup and upgrade Mongo DB using automation.
Tools and Technologies
Databases: Oracle (12c, 11g, 10g), MySQL, Mongo
DB Tools: OEM Grid Control, RMAN, DATAGUARD, Golden Gate, Data Pump, Mongo Ops Manager
Languages: SQL*Plus
OS: Sun Solaris, AIX, Linux
Professional Experience
Employer: Tata Consultancy Services Ltd. (11/2011 – Till Date)
Client: Apple Inc
Role: Sr Oracle DBA Sunnyvale, CA
Responsibilities
Providing 24X7 support in managing critical database systems for Apple including production, UAT and development environments.
Creating new databases, patching databases from 10g, 11g, 12c using CPU, PSU and Database Bundle Patch
Handling performance issues using AWR/ASH reports including high CPU utilization, wait events, fixing SQL profiles, creating SQL baselines.
Using RMAN backup and restore to refresh non production databases from production backups. Recovering data from recycle bin and UNDO.
Using flashback to recover from manual mistakes and rollback patch upgrades in case of failures.
Experience with Oracle VM, creating VM and managing VM using GUI.
Setup data guard using RMAN for replication.
Worked on database refreshes using Delphix.
Installed and configured databases in 12c OEM including setting up alerts, notifications and redirecting alerts to appropriate teams.
Worked on database security and compliance by setting up SSL/TLS and TDE across Oracle Databases.
Raising Service Requests with Oracle Support for solving critical production issues and communicating to proper teams in case of maintenance.
Migrating data from Oracle to Mongo, Kafka using Golden Gate.
Setting up Golden Gate for active/active replication across data centers.
Perform HA failovers and switchover of databases.
Worked on setting up MySQL DB, upgrading, database backups and replica setup.
Setup Mongo DB manually and using Ops Manager. Worked on Mongo dump and restore and set up X509 for security.
Employer: IBM India Pvt Ltd. (07/2011 – 10/2011)
Client: National Grid, US
Role: Oracle DBA Gurgaon, India
Responsibilities
Provide complete life cycle support for Oracle databases.
Monitor and resolve issues logged by end users in incident reporting tool Remedy.
Upgrade Oracle Databases to 11g
Complete database refreshes using RMAN and partial DB refresh using datapump.
Implementation of Grid Control for monitoring, maintenance and troubleshooting the Oracle databases, setting up alerts and notifications.
Raising Service Requests with Oracle Support for solving critical production issues and communicating to proper teams in case of maintenance.
Worked with various database groups on capacity planning, propose and implement new database environments based on the customer requirements providing HA solutions.
Handle performance related issues including high CPU utilization, wait events, blocking and generating AWR/ASH reports for analysis.
Schedule database backups using RMAN and perform restore and recovery operations when required.
Manage users in the database, grant and revoke access to the database, setup roles and profiles for security as per SOX guidelines.
Employer: HCL Comnet Systems & Services Ltd. (03/2008 – 07/2011)
Client: E*Trade Financial
Role: Oracle DBA Gurgaon, India
Responsibilities
Responsible for monitoring and maintenance of financial production and non production databases.
Monitor and resolve issues logged by end users in incident reporting tool Remedy.
Installed Oracle and created databases to support financial applications.
User Management and tablespace management.
Worked on basic performance tuning including generating AWR reports and explain plans.
Schedule database backups using RMAN and perform restore and recovery operations when required.
Responsible for data integrity, user security, daily monitoring for production and non production databases.
Raise Service Requests with Oracle Support to solve any critical issues in production.
Migrate databases between different Unix Servers and data centers.
Employer: Wipro Ltd. (07/2007 – 02/2008)
Client: Dell Inc.
Role: Customer Support Executive Delhi, India
Responsibilities
Providing front-line state-of-the-art technical support to US based customers of Dell Desktops in both hardware and software.
Surpassing the productivity targets with excellent quality with onus on customer satisfaction.
Read technical manuals, confer with users or conduct computer diagnostics to investigate and resolve problems or to provide technical assistance and support.
Provide weekly and monthly status reports to management about average handling time, customer satisfaction and product dispatches.
Provide floor support and assist new joinees in getting a better understanding of the technical processes.
Education
B.Tech. (Computer Science & Engg.) April 2007
Contact this candidate