Candidates About

 

Satvir Singh Deol

Professional Summary:

·         Over 7 of experience in IT Industry working as a Database Administrator in Development.

·         Had done various projects using RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, cloning, patching, Performance Tuning.

·         Promising experience in installing and configuring of databases on Operating Systems UNIX and Windows platforms.

·         Planned and scheduled the Physical backups as well as Logical backups.

·         Experience in management of tools like Oracle Enterprise Manager, TOAD and SQL Developer.

·         Proficiency in Disk management and problem resolving techniques with a good understanding of capacity planning and efficient usage of disk space.

·         Experienced in configuring and setting up of RMAN environment on various platforms for TAPE backup and scheduling backup jobs using Oracle Enterprise manager Grid Control.

·         Experience in Database migration from SQL server to Oracle Database using DTS (Data transformation services) and SQL*loader.

·         Extensive performance tuning activities like Operating system Tuning, SQL Tuning, and Database/Instance Tuning.

·         Worked as a primary support for database related issues with clients.

·         Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and ensure Disaster Recovery using various data protection modes.

·         Knowledge of Real Application Cluster (RAC).

·         Provided 24x7 Remote / on-call production supports.

·         Had an experience in Agile Methodology for 1 year and made a project named “Kenya Farms” for the same.

 

TECHNICAL SKILLS

·         Operating System: Window NT 4.0, Solaris, Red Hat Linux 5.0, 5.4

·         RDBMS: Oracle 8i, 9iR2, 10gR1 & R2, 11gR1 & R2

·         Tuning Tool: TKPROF, EXPLAIN PLAN, AWR, ADDM

·         Backup Tool: Cold, Hot backup, RMAN, Import/Export

·         Tools: SQL Plus, Oracle Enterprise Manager (OEM), SQL * Loader, MS

·         Access, MS Visio, CAD/CAM software - PRO/ENGINEER

·         Script: UNIX/Linux shell script

·         Language: SQL, PL/SQL, Java, VB 6.0, C, C++

·         Web Technology: HTML, XML

·         Virtual Machine: VM Ware server 2.0 to 2.2, Oracle VM Virtual box 4.0

·         BPM: PEGA 5.5v

·         Concepts: Industrial Automation and Robotics, Computer Aided Design, Machine Design, Total Quality Management, Total Productive Maintenance, Kaizen Safety Processes, Business Intelligence, Management of Operations, Project Management, Agile Methodology, Business Analytics, Database Management Systems, Business Intelligence in Healthcare, Business Process Management, SQL

 

·         Education: Bachelor in Engineering

 

WORK EXPERIENCE

 

Company: United Health Care, Las Vegas, Nevada                                                             July 2015- Present

Role: Oracle DBA

 

Responsibilities:

·         Installed, configured and maintained Oracle 9i/10g/11g/12C Databases on Linux, UNIX and Windows Platforms.

·         Involved in the complete SDLC, Database design, System analysis, design and development.

·         Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

·         Installation and Configuration of 11g Grid Control/Cloud Control 12C agents.

·         Implemented Oracle Database 11g, 2 node Real Application Cluster (RAC) using Oracle Cluster ware for achieving high Availability on ASM.

·         Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.

·         Worked on Oracle 9i to 10g/11g migration projects with low maintenance window and applied patches to various databases.

·         Worked on OEM Grid Control 11g, scheduling and troubleshooting OEM jobs and deploying OEM agents. Scheduling Backup Jobs and troubleshooting failed jobs through OEM GC.

·         Disaster recovery implementation using physical standby databases for high availability.

·         Worked for Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement).

·         Monitored the Performance of the migrated databases using grid Control and features AWR, ADDM, ASH and generated the reports for metric collection and health check of the databases.

·         Created, Upgraded, and Cloned Oracle databases for Development and testing databases.

·         Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

·         Configured RMAN tape backups (TSM) for the newly created databases and scheduled Daily, Weekly and Monthly Jobs using the OEM Grid Control.

·         Installed and patched SQL server 2005 and SQL server 2008 R2 servers.

·         Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.

·         Performed application Query tuning using Utilities Stats Pack, explain Plan, Magic Quadrant for data integration, TK Prof, and SQL Tuning Advisor and suggested the best access path for the SQL queries.

·         24X7 production support and on call rotation

·         Applied latest patches as per evaluation requirement.

Environment: Oracle 9i/10g/11g/12C, MS SQL Server 2005/2008/2008 R2, RMAN, RAC, ASM, TSO, Windows, Sun Solaris, Magic, TOAD, Oracle OBIEE, Shell Scripting, TWS, PL/SQL.

 

Safe lite Auto Glass, Columbus, OH                                                                               May 2014 – June 2015

Position:  Oracle Database Administrator

 

Responsibilities:

·         Evaluating, Supervise, plan, Installing Database servers, Database software, upgrading to new versions, coordinating with hardware changes and applying database patches.

·         Planned backup and Recovery Strategies and Performed Backup and Recovery activities (Archive log Mode and No Archive log Mode) using RMAN, DATAPUMP, EXP/IMP Utilities.

·         Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.

·         Re-organizing the database architecture to work efficiently and for better response time.

·         Define Database level authentication and OS level authentication using password file and User Profile.

·         Intensively used latest 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.

·         Intensively used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.

·         Implemented Oracle range/hash partitions to improve database performances.

·         Implemented Materialized views to replicate data from OLTP database into data warehouse.

·         Monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs.

·         Creation of users, schemas, table spaces and other database objects. Managing resources via OEM, GRID.

·         Monitored Database Sizing, Table Space Management, Transaction Management and Security Administration.

·         Monitored and tuned SQL Server databases to meet the performance and availability requirements of on-line systems and multiple applications.

·         Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code

·         Configured SQL Server engine for hosting the web applications.

·         Performed Refresh of the SQL Server database as per the customer request to support the testing.

·         24/7 support for production, development, and test database. 

 

Environment: Oracle 8i/9i/10g, SQL Server 2000/2005, SQL Navigator, Oracle Enterprise Manager (OEM), RMAN, IBM AIX, RAC, Data Guard, Shell Scripting, PL/SQL, SQL*Plus.

 

Assurant Specialty Property, Santa Ana, CA                                                                        Sep 2013 – Apr 2014

Sr. Oracle DBA

 

Supported as an oracle database admin for Assurant Specialty Property which is into market insurance Industry.

 

Responsibilities

 

·         Ensuring availability and performance of the databases that support SAP R/3 Enterprise        and BW 3.5.

·         Liaison with other teams to ensure that the associated hardware resources allocated to the databases and to ensure high availability as well as optimum performance.

·         Regularly monitor the database systems to ensure secure services with minimum downtime.

·         Provide regular trend analysis to the service management team to enable them to make informed decisions regarding resource management.

·         Problem escalation to Oracle Development team and third parties as appropriate.

·         Ensuring improvement and maintenance of the databases to include rollout and upgrades.

·         Implementation and release of database changes as submitted by the development team.

·         Handling

Support Activities Includes:  

·         Migration, Upgrade and patching of databases from 9i to 10g and 11g.

·         Database cloning, Refreshing of UAT/DEV databases using Hot backup/Cold bkp/Export.

·         Software installation and databases creation for physical servers and HA cluster.

·         Create / Update documentation for daily, weekly and monthly database activities

·         Provide support for the Systems & Storage Team during SMVI backup testing

·         Temporarily Extend Table space on PSAPTEMP to allow BW Team to compress cubes

·         Reorganize Database to recover unused disk storage

·         Enhance existing documentation on database structure and configuration and make recommendations for improvement.

·         Troubleshooting various database issues.

Environments: (11g, 10g. OS: Sun Solaris, Linux, HP, AIX, Windows)

 

Company: YKK INDIA PVT. LTD. India                                                                              Jan 2011 – Jun 2013

Role: Oracle Database Administrator

 

Responsibilities:

·         Responsible for installing, upgrading and configuring the Oracle environment(8i,9i,10G) by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

·         Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetric.

·         Scheduled Oracle Jobs in the database server.

·         Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.

·         Performed a proof-of-concept of Oracle10g and Oracle11g databases on single RAC Cluster 11g.

·         Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running

·         Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager

·         Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.

·         24x7 Production database administration, support and monitoring to ensure a proactive problem. Recognition and resolution of database issues.

·         Devised & Implemented backup strategies using hot, cold and exports based on the business requirements. Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.

·         Proactively managed the databases by setting up alarms for managing any exceptions in day to day management of the databases and prevented issues, disasters from happening. Involved in session management and monitored the critical wait events, blocking sessions in the database. Worked closely with Business Intelligence group in tuning ad-hoc reports using Cognos.

·         Recovery of Database (Recovering from Media Failure, Recovering tables dropped  accidentally, Recovering data files, Recovering from Block Corruption).

·         Raised service request for production issues and worked with Oracle support resolving bugs & issues.

·         Resolved Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.

·         Used ORACLE Wait Interface, to identify the top most wait events and their causes.

·         Used the import wizard to import existing user accounts, groups, categories, universes, connections and universe restrictions to BOXI environment.

·         Performed patching on Oracle Database Server 10g and 11g using Opatch utility.

 

Environment: Oracle 10g/9i RAC, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, RMAN, OEM, STATSPACK, and Business objects, PL/SQL developer.

 

Company: Curement life Science, India                                                                       June 2010 - December 2011

Role: Database Administrator  

 

Responsibilities

 

·         Responsible for installing, upgrading and configuring the Oracle environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

·         Create & Managing Database Structure, Storage Allocation.

·         Used RMAN for backup and recovery jobs.

·         Trace the SQL.

·         Trace the frequently called procedures/packages and pinning them to improve the performance.

·         Worked extensively on Performance Tuning, RAW Devices.

·         Cloned databases using scripts.

·         Setup and configuration of Data guard.

·         Responsible for Load and Performance testing of the database servers and application servers.

Environment: Oracle 9i/10g, Windows 2007 server, SQL server

 

Company: IDS InfoTech. India                                                           Jan 2009- May 2010
Role: DBA Support

 

Responsibilities

 

·         Involved in installation and configuration of database 9i on Windows NT.

·         Involved in creating and managing users and objects.

·         Involved in assigning roles and privileges to different users.

·         Inspected log file, monitored table spaces and partitions.

·         Involved in creating tables, indexes and views. Hot and cold backup.

Environment: Oracle 9i, UNIX Windows 2007, SQL, PL/SQL