Pushpinder Singh

Result oriented constructive team player with proven abilities in taking up and delivering time critical assignments successfully with a strong emphasis on maintaining quality and adhering to the software engineering processes. Highly effective communicator having good people skills and risk assessment abilities.

Extensive experience working as Senior Oracle DBA.

Oracle 11g/12c Certified Professional / DBA from Oracle Corp

Oracle Solution Architect Associate certified

Oracle 11g performance management and tuning certified

Extensive exposure of working with globally distributed teams.

Preparing for Azure Cloud Migration testing

Well conversant in technology and possessing the ability to troubleshoot issues quickly and effectively.

Proactive in taking up challenging assignments voluntarily.

Ability to coordinate work within the team members and motivate co-workers.

Technical/Experience Summary

Over 18 years as Oracle Database Administrator (Proficient in Oracle Database Administration Activities) like developing customized business applications, database design, database administration and building large public domain databases on a variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle (9i, 10g, 11g, 12c, 18c), Developer 2000/6i, SQL net, SQL*Plus, Pro*C etc. Worked on many large databases with size reaching 1.5 to 15 TB with ten of thousand of tables.

Performance engineering - Support performance testing, identify tuning and design changes to gain performance with AWR/Statspack. Engineering Large Scale Database Design and Tuning. Involved in optimizing SQL queries. Monitoring and optimizing the Performance of the database, tuning Management, Change Management, capacity planning, and SQL tuning.

Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN (18c/12c), 18c/12c Data pump (expdp, impdp) Export/Import and Transportable Tablespaces.

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

Strong experience with Database Modeling, Data Analysis and Conceptual, Logical and Physical modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.

Expertise in Oracle Veritas HA Cluster.

Expertise in Entity/Relation Data Modeling using ER-Win and Designer. Used and supported Informatica for ETL Transformations, Discoverer for adhoc query, Crystal Reports for reporting.

Working experience with Very-Large databases (VLDB) up to 20 terabytes, data migration, against Oracle & other databases such as MS Access, SQL Server.

Worked on EMC Symetrix DMX, EMC CLARiiON NAS devices, Hitachi, IBM, DMX SAN storage devices.

Expertise in Implementation of Fine Grain Access Control (FGAC).

Monitor and manage Oracle database Security by implementing SOX Policies through OEM Grid Control.

Extensive experience in Data warehouse environments with Star Schema and SnowFlake Architecture.

Extensive experience with Oracle Database Migration/Upgrade.

Expertise in VPD & TDE for Hardening database access and controls. Expertise in OID, Oracle Audit Vault.

Expertise in Installation & configuration of 9iAS/10gAS for Single sign on (SSO).

Databases:

Oracle 18c RAC, 12c RAC, Oracle 11g RAC, Oracle 9i, Oracle 8i, Microsoft SQL Server, DB2, MS ACCESS, Sybase, MySQL, Teradata

Database Tools:

9i/10g/11g RAC, Data Guard, Veritas Clusters, Replication Manager, Oracle Enterprise Manager, BMC Patrol, SQL Backtrack, DBARTISAN Smart DB, RMAN, SQL Trace, Golden Gate, TKPROF, Kintana, Netbackup, Legato, EMC DM/TimeFinder & SRDF for BCV, Shareplex, Space Manager, Discoverer 4i, 10g, EDW

Operating System:

RedHat Linux 4.x/5.x/6.x, Solaris 8/9/10, HP-UX 10.x/11.x/11iv3, IBM-AIX 5.1/5.2/5.3/6.1,Windows 2000/NT Server

Hardware:

EMC, Sun Sparc M5000, 5440, 5220, E5000, HP9000, RS6000, Compaq, Intel Servers.

Application/web Servers

Oracle Application Server, Apache, Weblogic, JBoss

Software:

DBA Studio, Oracle Performance pack, VERITAS, Clustering Software, Visual Basic, Microsoft Office

Report Writer

Oracle Reports, Crystal Reports 9, SSRS, Brio reports.

Soft Skills:

Time Management, Personal Effective Planning.

Professional Experience/Projects

Data Intensity LLC Senior Oracle DBA

Bedford, MA Since February 2012

Clients: Blackstone, Life Care Center of America, Integra Lifesciences and Aramark

Project:

Project: Installation, Setup, Maintenance and Upgrade of Oracle Databases 9i, 10g, 11g, 12c, 18c Oracle Real Application Clusters RAC 10g, 11g, 12c Oracle Security Administration, SQL Server 2005/2008 Active-Passive and active-Active Clusters, ERP application, SharePoint, Team Foundation Services, Cognos etc.

Oracle (10g/11g/12c/18c), Oracle 12c RAC, MS SQL Server 2000/2005/2008, Postgres, EBS Unix Shell Scripting, Oracle Golden Gate, Perl, SQL Scripting, Unix CRON jobs, Guardian Silhouette Scrambling Tool

Hardware:

Exadata, SPARC-Enterprise-T5220, M5000, Sun SPARC and Linux based servers, SAN

OS:

Sun Sparc 5.10, AIX, Red Hat Linux, Oracle Enterprise Linux, Windows NT/2000/2003/2008

Environment:

Sun Solaris 2.9, 2.10, Red Hat Linux AS ver 4, Microsoft Windows

Software:

Oracle (9i/10g/11g, 12c), Oracle 10gRAC, MS SQL Server 2000/2005/2008, EBS Unix Shell Scripting, Perl, SQL Scripting, Unix CRON jobs, Guardian Silhouette Scrambling Tool

Responsibilities:

Supported multiple clients including clients in Financial, Manufacturing and Healthcare domains.

Installed and Configured 3 Node RAC and added 1 Node to make it a 4 Node RAC.

upgraded the cluster from 11g to 12c grid home.

Upgraded the CRS from 12g to 19c.

Upgraded the database from 11g to 12c and 12c to 18c, 19c

Migrated the EBS 12.1.3 from on-prem to OCI.

Installed and Setup Oracle Golden Gate on 4 node RAC for failover.

Installed & Configured Oracle 12c Grid Control for monitoring over 2000 Prod / Non Prod Hosts

Maintaining Production and Development Instances of Oracle and SQL Server

Installing, Upgrading/migrating, Security Administration of Oracle Server/databases 10g, 11g, 12c, 18c

Cloning of different versions of Oracle and SQL Server instances on a regular basis

Migrated Legacy Databases from cross platforms to Exadata using Datapump

Migrated Legacy Databases from cross platforms to ODA using datapump

Automated the security patching to complete with minimum downtime

Installed and configured Forms and Reports 12.2.1.0 and upgraded to 12.2.1.3 using Oracle Weblogic

Implementing Windows Cluster Services and SQL Server Active-Passive and Active-Active Clusters

Strong knowledge on Oracle Cloud Infrastructure(OCI) especially on Exadata Platform by migrating many On- prem Oracle databases to Exadata X7-2 (OCI) and applications to Exalogic

Automated the tuning process to proactively identify any performance issues during the steady support and after the application migrations

Manage user and privilges in CDB and PDB databases

Creation, Mnaage, Backup and recovery of CDB and PDB databases

Support engineering work for Oracle 13c OEM. Support tasks include SOP creation on various OEM tasks needed to maintain over 2 thousand OEM targets across the ecosystem. Supported OEM targets are mainly middleware applications, Linux hosts, Databases, ODA s and all Exadata appliances

Experience in binding software (application servers, OAS, Apache)

Monitoring Exa-data Db-Servers and Cell-Servers, PDUs, InfiniBand and Admin Switches using OEM, ILOM, ExaCLi, ExaDCLi, CellCLI and DCLI and running Health check, ExaChk, OSWatcher OEM13c, OEM 12c.

Managed the Oracle Datawarehouse with size 100+TB on Exadata and upgraded from 11g to 12c.

Migrated the OWB from 11g to Oracle Data Integrator (12c) using Datawarehouse Migration utility. More than 3000 OWB mappings were converted and validated. Oracle Migration utility for OWB to ODI 12c was used whenever possible and manual conversions were performed for complex OWB mappings.

Optimized the nightly incremental load to complete in 2 hours from 12 hours. This included code changes, hints, some indexes and sql profile baselines to optimize the offending sql s.

Worked with Development team to proof-read the function, packages and procedures for optimal performance.

Migration to Oracle Exadata smart scan helped further with the load timings.

Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc. Daily log analysis using pgbadger tool and query tuning.

Manage Grid, Cluster ware, RAC database health checks using Oracle tools such as OraCHK, ExaCHK, Cluster Health Advisor

Migrated and Upgraded from SQL Server 2008 to 2012

Used Toad and Command line to manage the Oracle databases

Handled Logical Data and Index partitioning for large tables in SQL Server 2008, 2012 and 2016

Installed and Configured SQL Server Reporting Services (SSRS)

Setup the always ON for SQL Server

Installed the active-active and active-passive cluster configuration for SQL Server

Involved in Oracle Spatial database configuration and schema creation.

Worked with Oracle LMS team for Oracle Audit

Experience in Oracle Spatial and Graphs for implementation and unified content metadata model for public cloud

Validate semantic and structural consistency.

Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.

Designed and Implemented (SaaS, IaaS, PaaS) on AWS/GCP and Oracle Cloud Infrastructure (OCI) to move on premise Applications and Databases to Public cloud.

Completed the POC for 18c database upgrade

Installing, Configuring and Administrating the databases on Oracle Public Cloud.

Identified the JVM related memory issues using jConsole.

Migrated Oracle Databases to postgresSQL.

Maintaining the monitoring profiles for AWS/Oracle Cloud (SaaS/PaaS) Services - EC2 Parameters (CPU, Memory, Disk, Response time, etc.).

Administration of Progress/OpenEdge 9.1,10.xx and 11.xx databases

Extensively used http watch for apps/performance related issues

Installing, upgrading, configuration and troubleshooting of add on products like QAD Alerts, MSWPSW, EAM, QXtend

Extensive experience in coordinating activities with different business stakeholders

Implemented wiki with mysql as the backend database

Installation of OpenEdge database service pack, patches and hot fix.

Troubleshoot Database Performance Tuning issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS), Tivoli Storage Manager, NetApp SAN Storage

Increased performance of reporting procedure by suggesting and introducing materialized view instead of pulling data from warehouse

Worked on EMC Symetrix DMX, EMC CLARiiON NAS devices, DMX SAN storage devices

Design and Provided Disaster Recovery processes or strategies in the Hybrid and Public cloud

Designed and developed logical and physical data models using CASE tools such as ERWin and Oracle Designer 12c and using manual methods as well

Created RAC Database on Dev Hosts using DBCA Templates and refreshed them with the latest snapshot of data from Prod Environment

Optimized MySQL queries and troubleshoot performance issues to ensure efficient server performance

Performed MySQL replication setup and administration

Extensive experience in user management (Roles, privileges, synonyms, create Tables and main indexes). User access provided to designated users in certain group(s)

Installed and configured RMAN for 11g

Implementing Windows Cluster Services and SQL Server Active-Passive and Active-Active Clusters

Installed and configured OID for 11g

Designed custom scripts solution using Oracle Standby Database and notify the DBA team of any problems

Design and migrate Oracle Goldengate environments into AWS cloud infrastructure

Installation, setup and configuration of Dataguard in multiple datacenters

Setting up and Performing annual/semi annual DR tests using Dataguard for Crown Jewels

Installed and configured delphix to reduce database footprint

Setup Active/Active Goldengate implementations utilizing goldengate custom exception handling implementation with custom alerting/monitoring proactive data synchronization scripting

Custom triggers and Goldengate exception handling procedures developed as this implementation is front-end hardware load balanced across the Data Centers

Setting up High Availability Oracle GoldenGate systems on Oracle 12c RAC environments. Use OGG to do Migration from OLTP to Exadata Machine

Setting up 11g OBIEE on Enterprise Linux servers

Sungard Senior Oracle DBA

Wayne, PA March 2007 to February 2012

Responsibilities:

Upgraded Oracle 9i to 10g and 10g to 11g

Implemented the 3 Node Oracle 10g RAC on Sun Cluster and did all the trouble shooting to make the CRS and RAC Setup a stable one

Installed and Configured Oracle 10.2.0.1 Grid Control

Upgraded the 10.2.0.1 Grid Control Setup to 10.2.0.4

Installed and setup Oracle Golden Gate for replication

Implemented the MAA (Maximum Availability Architecture) having 10g Physical Data Guard for 3 Node RAC System

Installed Oracle 10.2.0.3 on Production DB Servers, applied OPatches to fix the known bugs and Upgraded 15 production databases sizing between 700GB and 50 TB from Oracle 9.2.0.7 to 10.2.0.3

Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum Performance Mode for re hosting of Apria s data center using Data Guard

Involved in Data Warehousing, Data Modeling, Database Design and Creation

Used Oracle Warehouse Builder for designing, deploying, and managing data warehouse

Member of SOX team in implementing security on DB side

Worked on various application deployments like setting up a new student s info for the fees/Course Systems, deploying new database / application level code changes and working closely with the Release Engineering teams to fix the database/application bugs

Involved in upgradation of more than 20 Databases each sizing at least 500GB from 9i to 10g & also involved in Migration from SQL Server2005 to Oracle 10g

Designed and developed logical and physical data models using CASE tools such as ERWin and Oracle Designer 10g and using manual methods as well

Setup backup and recovery procedures using OEM, RMAN and third party tools like Veritas. Used hot backups and cold backups, incremental and full backups.

Liberty Travels Senior Oracle DBA

Mahwah, NJ Jan 2004 to March 2007

Responsibilities:

Creation and setup of Dev/TEST/QA environment from Production database.

Installation, Configure, setup of 10g RAC.

Add new nodes to RAC 10g Cluster to distribute the load.

Performed several RDBMS upgrades from 8i to 9i, 8i to 10g, 9i to 10g on HP 64 bit platforms.

Setting up and Auditing RMAN Hot and Cold Backups, Exports.

Managing Veritas Clusters for HA Implementation.

Involved in ASO Implementation.

Configuration of Oracle Enterprise Manager (OEM 9i & 10g) tools for monitoring, performance enhancement and debugging.

Installation, setup and configuration of logical and physical Standby Database using DataGuard.

Configured & supported oracle Advanced replication (Multimaster)

Installation, Configuration & management of Shareplex for multimaster replication/log based replication.

Writing Shell scripts for Alerts for backup and recovery, Import and export procedure.

Involved in Perl Scripting

Writing error handler procedures for, update and delete conflict and writing the cause of error to log files.

UNIX shell scripting in csh, ksh to be controlled from Crontab.

Database Refreshing / Replication from production to testing using hot backup.

Rendering 24*7 Oncall Production database support.

Pension Benefit Guaranty Corp (PBGC) Senior Oracle Application DBA

Washington, DC Oct 2002 to Jan 2004

Provided production support and maintained a 24X7 tracking database.

Administered in Oracle Parallel Server, in managing a cluster environment (on Veritas CFS) that provides highly available and highly scalable database servers using SRVCTL utility.

Installation, Upgrade and Configuration of Oracle (8i,9i & 10g).

Installed and created 10g databases and 10g OEM.

Configuration, maintenance and tuning of Oracle 9iRAC and 10gRAC.

Installation, setup, configuration & Implementation of 10g RAC and 10g Dataguard.

Configuring Recovery Manager (RMAN).

Design and implement of database backup strategy and performed full incremental and Cumulative backup using RMAN. Troubleshooting with RMAN backup problem.

Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.

Cloning databases using scripts as well as RMAN.

Used Shareplex to minimize the downtime for Migration & to meet the high availability requirements

Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.

Expertise in Scheduling Control-m for scheduling jobs.

Setup, Installation, configuration and UNIX System Administration. UNIX shell scripting. UNIX CRON jobs.

Managing Veritas Clusters for HA Implementation.

GECITS Oracle DBA

Erlanger, KY February 2000 to Aug 2002

Responsibilities:

Creation of database, tables, users, roles in Oracle7.0.

Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints

Developed E-R and data flow diagrams,

Performed Data Modeling and architected the data warehouse.

Developed several stored procedures.

Space Management that includes table space creation, adding new datafiles,

Creating rollback segments, etc. Shell Scripting in csh and ksh

Development of reports in Pro*C and ReportWriter 2.0 Security administration i.e. managing privileges and roles

Backups and Recovery i.e. exports/imports, hot archive log backups, cold offline backups, etc

Bank of Punjab Oracle DBA/Developer

Chandigarh, India Dec 1998 to Feb 2000

Responsibilities:

Installation, Upgrade, patching and managing Oracle Applications 10.7NC & Smart client and 11.0.3

Tuning Concurrent Managers, Defining Work Shifts, etc.

Installation, Upgrade and Configuration of Oracle (7.1.6, 7.3.4, 8.0.5, 8i).

Extensive Performance Tuning, Memory (SGA) Tuning, Tuning Concurrent Managers, etc

Applying Patches both Server side and Client side.

Used Designer 2000 for database design

Cloning databases.

Setting up new environments (Development, Testing, Conference Room Pilot, Production etc)

Upgrading to Oracle Server 7.3.4 and then to 8i.

Setting up advanced replication.

Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.

Mobile: 732-***-****

E-mail:adru0m@r.postjobfree.com

Contact this candidate