Dharam Pal Singh

Technical Architect(Database specialist)

Contact

***** ******** **

Fremont, CA.

925-***-****

adv40z@r.postjobfree.com

https://www.linkedin.com/in/dharam-pal-singh-65a53813/

Profile

15+ years of experience as RAC DBA/Apps DBA/Big data admin and a database specialist, managing day-to-day database operations and DBA charters for production databases and projects. This includes database administration, planning, design, build/delivery, deployment, monitoring, standards, compliance, etc. for production, production operations, monitoring, the project builds & delivery, deployments, etc. Team management, recruitment, and evaluation of talent, as well as the ability to grow, coach, and develop the team Manages 24/7/365 operations in a business-critical environment. Depth knowledge of Oracle Databases(19c,12c,11g,10g,9i with cluster) RAC, Oracle Enterprise Manager, Encryption, Redaction, Masking, Cloning, Performance Tuning/Monitoring, Optimize Resource allocation for Databases and Applications, Backup and DR Strategy, Oracle EBS R12,11i installation and Administration on UNIX. Experience in non-relational database systems MongoDB and AWS database services and architecture (RDS, PostgreSQL). Experience in Cloud data warehouse database snowflake.

Skills

SQL

HiveSQL

Python

Oracle

MS SQL

Snowflake

MongoDB

Oracle ERP (11i, R12)

Hadoop

HDFS

Map Reduce

AWS (EC2, ELB, VPC, S3, CloudFront, IAM, RDS, Route 53, CloudWatch, SNS, SQS)

Education and Certificates

Master of Computer Application

B. Sc (Mathematics Hons)

Oracle Apps 11i Certified Professional (dba)

Oracle Certified Professional 11g

Oracle Database 10g R2 RAC

Oracle Certified Professional 10g

Oracle Certified Professional (9i)

Sun Solaris System Administrator (SSA) 10 Certified.

ITIL v3 foundation certificate.

Visa Status:

Valid H1B Visa.

Experience

Mphasis: Jan 2011 - Present

Senior Lead Database Administrator,2021 – Present.

Confidence (BANK), San Francisco, CA.

Mphasis Ltd, Pune, India 2015-2021

Currently handling Oracle ODA Linux server with 19c Cluster.

Managing migration, cloning, upgradation, and DB backup and restore.

Diagnostic Ability - Ability to go the core of the problem.

Experience to handle data Gard to sync data from primary to secondary.

Handing MongoDB databases on Linux severs.

Managing Cloud data warehouse databases on Snowflake cloud (AWS).

Handling MS SQL server databases (migration, clone databases configuration replications). Commitment towards work and deadlines. Requirement gathering. Patch Analysis, patching like upgrading, CPU and PSU etc. Managing project and DBA team.

Mphasis Ltd, Pune, India 2011-2015

Senior Lead Database Administrator

Oracle EBS R12 installation on AIX. Oracle Application Database Administration (Version 11.5.9, 11.5.10, 12.0.4,12.0.6,12.1.1,12.1.3).

Commitment towards work and deadlines. Diagnostic Ability - Ability to go to the core of the problem. Installation and managing 11g R2 RAC installation on AIX, SUN servers. Cloning of the oracle apps from single to single and single to multi and multi to single nodes using rapid clone. Managing the application system by using AD Utilities. Granting and monitoring user access rights and privileges through roles and profiles. Managing Concurrent Managers, Used Oracle Application tools for maintaining databases and applications like adpatch, adadmin, and adctrl, etc.

Have worked on Oracle RAC, Golden Gate, Data Gard, ASM, and RMAN).

Worked as admin on Big data Hadoop cluster with HiveSQL (2012-2014)

Wipro Infotech, Gurugram, India, 2007- 2011.

(Worked on multiple clients)

Implementing the new architecture with 10gRAC. Cloning of the oracle apps from single to single and single to multi and multi to single. Managing the application system by using AD Utilities. Cloning from RAC database to Non-RAC database through RMAN Duplicate command. Migrating the database from NON-ASM to ASM and vice-versa. Support End to End Testing for Production Release. Monitoring, maintenance, and troubleshooting of RAC servers. Upgrading the RAC database from 10.2.0.3 to 10.2.0.4 on AIX 6.1 platform. Implemented Backup and Recovery strategies using RMAN for Oracle 10g databases in Solaris 10 Platform. Installation of oracle application R12 (Single node and multi-node) on RAC with ASM on AIX 6.1. Applying Patches on oracle apps R12 (patch 12.0.6) on the application’s Tier and database patch 10.2.0.4 on the database Tier. Granting and monitoring user access rights and privileges through roles and profiles, Managing Concurrent Managers, Used Oracle Application tools for maintaining database and application.

Activities

Identifies, evaluates, and manages the adoption of database administration tools and processes, including automation. Develops and maintains procedures and documentation for databases. Contributes to the setting of standards for the definition, security, and integrity of database objects and ensures conformance to these standards. Manages database configuration including installing and upgrading software and maintaining relevant documentation. Monitors database activity and resource usage. Optimizes database performance and plans for forecast resource needs.

Contact this candidate