Navdeep Singh Sandhu

Phone: 778-***-****

Database Architect/DBA

Required Skill

Years of Experience

Company Name(s)

Overall Database Administration

14+ Years

Avocette, BestBuy, Kronos, HCL, Tech Mahindra, IBM, SDG

Oracle 11.x, 12c and above

SQL server 2008,2012,2016,2019

Postgres 10

14+ Years

Avocette, BestBuy, Kronos, HCL, Tech Mahindra, IBM, SDG

Linux and Windows Platforms

14+ Years

Avocette, BestBuy, Kronos, HCL, Tech Mahindra, IBM, SDG

Overall Cloud experience (AWS,Azure)

6 years

Avocette, BestBuy, Kronos, HCL, Tech Mahindra

Experience of working with a range of Services in AWS including EKS, EC2, S3, VPC, Lambda, RDS, Elasticache

6 years

Kronos, HCL, Tech Mahindra

Experience Migrating Databases from 11.2.04 and below to Oracle 12c and 19

SQL server 2008 to higher version

Oracle to Postgres

10 Years

Avocette, BestBuy, Kronos, HCL, Tech Mahindra, IBM, SDG

Experience working on large scale cloud migration projects and have track record of delivering cloud migration projects on schedule

5 Years

Kronos, HCL, Tech Mahindra

Oracle to AWS Migration

SQL server to AWS migration

4 years

Kronos, HCL, Tech Mahindra

Container technologies including Kubernetes and Docker (Devops)

4 years

Kronos, HCL, Tech Mahindra

Experience in installation and configuration of Oracle/SQL server/Postgres in Virtualized Environments

14 Years

Avocette, Bestbuy, Kronos, HCL, Tech Mahindra, IBM, SDG.

Experience using Oracle Data Guard with RAC in an ASM Environment

SQL Server AlwaysOn, replication and log shipping

12+ Years

Avocette, Bestbuy, Kronos, HCL, Tech Mahindra, IBM, SDG.

Oracle Golden Gate

3 Years

Tech-Mahindra, SDG

Production Support

14+

Avocette, Bestbuy, Kronos, HCL, Tech Mahindra, IBM, SDG

Patching – Including Disaster Recovery

10+

Avocette, Bestbuy, Kronos, HCL, Tech Mahindra, IBM, SDG

Monitoring

14+

OEM12c,13c, Solarwind DPA, Prometheus Grafana

Tickets(ITIL system)

14+

ServiceNow, ITG Kintana, Jira

Certifications/Education

AWS Certified Solutions Architect Professional.

Oracle Cloud Infrastructure 2019 Certified Architect Professional

Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle Cloud Infrastructure 2019 Certified Architect Associate

Bachelor of Technology Punjab Technical University

Commenced professional journey in 2008 as Database Administrator with technology provided by ORACLE and Microsoft SQL Server. As Technology moves, in 2013 started working on AWS cloud using Amazon RDS service for Oracle 11g and SQL Server migration, DevOps and POCs.

In addendum to managing user access with IAM roles, Security groups.

AWS Certified Solutions Architect Professional.

Oracle Cloud Infrastructure 2019 Certified Architect Professional

Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle Cloud Infrastructure 2019 Certified Architect Associate

Experience maintaining build automation in CI systems (e.g., Jenkins).

Deploy AWS EC2 Instances to build oracle databases.

Deploy AWS Compute services (EC2 Auto Scaling, Lightsnail, ECS, Elastic Beanstalk).

Hands-on experience of deploying cloud infrastructure using AWS services including

EC2(On-Demand, Reserved and Spot Instance), RDS (Oracle, MSSQL, Postgres and MYSQL), EBS S3, EC2 auto scaling.

Experienced in installing, configuring and upgrading EnterpriseDB/Postgres databases and clusters.

Migration of Oracle Database to the PostgreSQL database

architecting, configuring, setting up Enterprise Fail over manager for HA solution

Metrics and alert notification using AWS SNS and AWS Cloud watch and cloud trail.

Migrate Database and infrastructure using AWS DMS Service.

Migrate infrastructure using AWS SMS.

Estimating AWS costs and identifying cost control mechanisms.

Good knowledge of shell scripting using Bash & Python.

Extensive knowledge of working with WebLogic and Apache Web Servers.

Managing Docker Container on AWS With GUI.

Database migration from on-premise to cloud using DMS.

Managing repositories using AWS ECR Service.

Extensive Hands-on Oracle DB, MS SQL Server, PostgreSQL, Couchbase, AZURE SQL DB Service.

Professional Experience

Tata Consultancy Service (Remote work) 04/2022- 03/2023

Cloud Migration Specialist (Databases)

Client: Nutrien

Project 1: Worked on DB migration from on-prim to AWS cloud. My work includes:

Database migration Feasibility check

Identify and define migration strategy

Migrate on-prim Oracle/SQL server Database to Postgres RDS using DMS and SCT

Configure PGADMIN to Access Postgres RDS

Design and define its backup and restore strategies

Performance analysis and troubleshooting post migration issues.

Follow ITIL Procedures to create required CRs in ServiceNow with proper CI and subtasks as well as all respective stakeholders.

Define security and storage management for database.

Define IAM rules with the Help of Solution Architect

Professional Experience

HSBC Bank Canada (remote work) 11/2021-04/2022

Project 1: Worked on DB migration from on-prim to AWS cloud. My work includes:

Database migration Feasibility check

Identify and define migration strategy

Migrate on-prim Oracle/SQL server Database to Postgres RDS using DMS and SCT

Configure PGADMIN to Access Postgres RDS

Design and define its backup and restore strategies

Performance analysis and troubleshooting post migration issues.

Follow ITIL Procedures to create required CRs in ServiceNow with proper CI and subtasks as well as all respective stakeholders.

Define security and storage management for database.

Define IAM rules with the Help of Solution Architect

NTT Data Services, Nova Scotia, (remote work) 10/2020 -10/2021

Consultant

Project1: Worked on Transparent Data encryption (TDE) for their healthcare customers. My work includes Database encryption for SQL server 2012,2014 and 2016. This includes:

Database performance analysis before and after TDE

Coordination with all stakeholders for activities

Impact on backups due to TDE

Post TDE support

Design and Define DB refresh/cloning for TDE to Non-TDE environment and vice-versa

Follow ITIL procedures to create required change request in ServiceNow with proper CI and subtasks.

Project2: Migrate and upgrade their Databases from lower version to Higher version (2012 to 2016 and 2014 to 2016). Upgrade consist of 2 process 1. DB upgrade 2. DB TDE. It was in-place upgrade for multi-TB sized database. This Includes:

Requirement gathering and resource estimation, analysis

Application Compatibility

Backup and restore compatibility check for Backup tool (Quest litespeed)

Database encryption

Performance analysis before and after upgrade, TDE respectively

Follow ITIL Procedures to create required CRs in ServiceNow with proper CI and subtasks as well as all respective stakeholders.

Avocette Technologies, New Westminster, B.C, Canada 10/2019 – 03/2020

Consultant

Project 1: Migrating and upgrade their database infrastructure (16 Oracle DB and 20 SQL server DB) to higher version (from SQL Server 2008 to SQL Server 2017 and Oracle 11g to Oracle 18C) with minimal downtime. Migrate SQL Server Databases to Azure Cloud.

Create Azure VM for Oracle Database and application migration.

Hands-on to Azure Kubernetes Services.

Deploy Azure VM Instances to build oracle databases.

Configure Azure Cloud Service to configure Clustering.

Azure storage using Storage account for archive.

Azure Public and Private IP management and Load Balancing.

Database migration using Azure Database migration Services.

Project 2: Performance tuning of mission critical SQL Database. DB was using lot of Temp variables to search and building xml files using application logic. Build Full text indexes to keep track of updates and gather DB stats. Schedule maintained plan for weekly DB stat gather.

Troubleshoot WebLogic application server while migration.

Database installation and configuration on windows and UNIX environment.

Database performance tuning using Explain plan, index, DB stats etc.

Database Backup and recovery strategies.

High availability/scalability using SQL server Replication, Availability groups and Oracle RAC, Oracle data guard.

Database Health check for daily operations.

Storage and resource management.

DB user creation and privilege management.

Database Security and Patching.

Skillset used

Technology used

Database Upgrade and Management

Oracle 11g, 12c and 18C

SQL server 2008,2017

High Availability Solution

Oracle RAC 11g,12c,18c

MS SQL Server Always on High Availability

Disaster Recovery Solution

Oracle Data Guard

MS SQL Log shipping, failover group

Backup & Recovery

Oracle RMAN, Export/Import Data pump

MS SQL Server Backup/restore data import export

Cloud

Azure

Best Buy Canada Ltd, Burnaby B.C, Canada 03/2019 – 10/2019

Senior Specialist

Project 1: Replace underneath storage used by all Oracle Database with minimal DB downtime. Worked on migration plan and DB Capacity Plan and on-demand provisioning of storage for future use.

Project 2: Worked with Team to migrate Oracle and SQL Databases from Vancouver Data Center to Denver Data Center with almost zero downtime. As part of migration Team, participated in migration plan, DB connectivity, user management and client configuration. Address after migration issue specially related to network and TNS entries.

Project 3: Database upgrade from version Oracle 10g to Oracle 11g and address post-upgrade issues and user complains. Upgrades consist of 2 phase processes. First create DB clone so that Original DB remain unaffected and available in 5 to 10 mins with many changes. Second phase upgrade cloned DB to version 11g on the same server and RAC cluster to make it 3 node cluster.

SQL Server Administration consist of day-to-day operations, user requests.

Couchbase Database Administration.

Couchbase Clustering.

Couchbase Node and cluster management, rebalance.

Couchbase Manage/create/edit/delete/Flush Buckets.

Couchbase Manage Security using users, groups, roles.

Couchbase Manage Authentication using LDAP.

Couchbase Manage Connections and Disks.

Implemented oracle 11g,12C Active data guard.

Database troubleshooting and performance tuning.

Database recovery in case of crash and DB cloning on user requests.

Implementation of High Availability solutions with Oracle 11g/10g RAC, Data Guard.

Skill Set

Technology

Database Administration

Oracle 9i,11g,12c,18c

Microsoft SQL Server 2012,2014,2016

CouchBase v6

High Availability Solution

Oracle RAC 11g,12c,18c

MS SQL Server Always on High Availability

Disaster Recovery Solution

Oracle Data Guard

MS SQL Log shipping, failover group

Backup & Recovery

Oracle RMAN, Export/Import Data pump

MS SQL Server Backup/restore data import export

CouchBase cbbackup and cbrestore Tools

Monitoring and Alerting

Oracle Enterprise Manager 11g,12c,13c

Nagios, SolarWinds

Scripting

Bash Shell Scripting

Kronos India Pvt Ltd, Noida, India & USA 05/2015 – 02/2019

Administrator (Shared Platform Services)

Providing Oracle & SQL Server databases support for 150+ Business critical databases in Production, Development and Test environments for various OLTP and Enterprise Data Warehouse in Financial project.

Database security and user management for SQL Server,Postgres and Oracle databases.

Install, Patch and upgrade Oracle database from 9i to 12c and SQL Server from 2008 to 2016.

Design and Configure Oracle RAC and SQL HA for Database high Availability.

Configure oracle enterprise manager Oracle databases monitoring and alert system.

Configure SQL jobs for scheduled work.

Installation/configuration and implementation of PEM, BART, xDB/EFM, Performance Dashboard.

Configure Oracle Data-guard and SQL Replications/log-shipping for Disaster recovery.

Wrote Unix shell scripts for Server monitoring and for scheduled jobs.

Managing, design and troubleshooting Oracle,SQL server and Postgres backups and recovery.

Create database cloned environment from Production environment.

Deploy AWS EC2 Instances to build oracle and SQL Server databases

Migrate Oracle and SQL database to AWS RDS using SCT and DMS.

installing, configuring and upgrading EnterpriseDB/Postgres databases and clusters.

Migration of Oracle Database to the PostgreSQL database

Installing and configuring the PostgreSQL DB

Container security using RBAC.

Pod Networking and DNS in Kubernetes.

Running and Managing PODs.

Deploy CI/CD using Jenkins.

configuration management using Ansible.

Deploy Kubernetes using AWS ECS service and EC2 Container services.

Shell scripting for automation.

HCL Technologies, Noida, India 08/2014 to 01/2015

Associate Consultant

Client: NBC Universal Inc. USA

Supported more than 1000 databases with team size of 25 persons. Provides level 3 support for all mission critical databases and time bound activities.

Capacity Management & planning for on-demand provisioning. Server, storage, and database.

Implemented oracle 11g,12C Active data guard, SQL server, SQL High Availability.

SQL Server and Oracle Database troubleshooting for performance improvements.

SQL Server and Oracle database recovery in case of crash.

Implementation of High Availability solutions with Oracle 11g/10g RAC, Data Guard and

SQL Server High Availability & Replication and mirroring.

Configure User authentication using Windows AD for SQL server.

Migration of on-premises Oracle Databases and SQL server Databases to AWS Cloud.

Deploy AWS EC2 Instances to build SQL server and Oracle databases.

Deploy AWS Compute services (EC2 Auto Scaling, lightsnail, ECS, Elastic Beanstalk)

Configure AWS VPC, Security groups, ELB, Global accelerator, Route 53,VPN,CloudFront to configure Network.

AWS storage using EBS, S3 and Glacier, Storage gateway, Transfer family, Snowball.

Configure AWS VPC, Security groups to configure Clustering.

AWS storage using EBS, S3 and Glacier for archive.

AWS Elastic IP management and Elastic Load Balancing.

Cost and Capacity Management using EC2 Spot instance, EC2 Autoscaling, AWS Batch.

AWS Database using AWS RDS,AWS ElastiCache.

Database Migration using AWS DMS and SCT.

Application Integration using Amazon MQ,SNS,SQS.

Database migration using DMS and SCT.

Security, Identity & Compliance using AWS IAM, Cognito, Inspector, AWS KMS,WAF,AWS SSO, and AWS Directory Service.

Deployed Storage solutions using AWS S3,Elasitc Block Storage, Snow family, Elastic file system and AWS Backup.

Deployed Network & Content Delivery using AWS VPC,API Gateway, CloudFront, PrivateLink, Direct Connect, Transit gateway & ELB.

License management using BYOL methods.

Design high availability & Scalability with AWS.

Kubernetes installation and configuration.

Container Storage management using Kubernetes Persistent Volume claims.

Container security using RBAC.

Pod Networking and DNS in Kubernetes.

Running and Managing PODs.

Deploy CI/CD using Jenkins.

configuration management using Ansible & Terraform.

Deploy Kubernetes using AWS ECS service and EC2 Container services.

Shell scripting using Bash & Python.

Tech-Mahindra Ltd, Noida, India 02/2013 to 08/2014

System Analysts

Client: AT & T USA

Supported more than 3000 databases with team size of 40 persons. Worked as Production DBA for 150 mission critical databases. Responsible for Level 3 support and primarily work on Outages with Oracle Support.

Following Change Control Management, Service Management, based on ITIL framework, SLA processes.

Migration to RAC (Single instance to multi-instance).

Database performance Tuning.

Handling Oracle Database Migration, Upgradation and Patches implementation.

Implementing high availability (HA) and disaster recovery (DR) solutions.

Managing overall Oracle release over viewing strategies and roadmap.

Backup and recovery strategies and implementation.

Deploy AWS EC2 Instances to build oracle databases.

Deploy AWS Compute services (EC2 Auto Scaling, lightsnail, ECS, Elastic Beanstalk).

Configure AWS VPC, Security groups, ELB, Global accelerator, Route 53, VPN, CloudFront to configure Network.

AWS storage using EBS, S3 and Glacier, Storage gateway, Transfer Family, Snowball.

Configure AWS VPC, Security groups to configure Clustering.

AWS storage using EBS, S3 and Glacier for archive.

AWS Elastic IP management and Elastic Load Balancing.

Cost and Capacity Management using EC2 Spot instance, EC2 Autoscaling, AWS Batch.

AWS Database using AWS RDS, AWS ElastiCache.

Database Migration using AWS DMS and SCT.

Application Integration using Amazon MQ,SNS,SQS.

On-premise database migration to AWS Cloud.

Security, Identity & Compliance using AWS IAM, Cognito, Inspector, AWS KMS, WAF, AWS SSO, and AWS Directory Service.

Deployed Storage solutions using AWS S3,Elasitc Block Storage, Snow family, Elastic file system and AWS Backup.

Deployed Network & Content Delivery using AWS VPC, APIGateway, CloudFront, PrivateLink, Direct Connect, Trasit gateway & ELB.

License management using BYOL methods.

Design high availability & Scalability with AWS.

On-premise Kubernetes installation and configuration on cloud using AWS EKS.

Container Storage management using Kubernetes Persistent Volume claims.

Container security using RBAC.

Pod Networking and DNS in Kubernetes.

Running and Managing PODs.

Deploy CI/CD using Jenkins.

configuration management using Ansible.

Deploy Kubernetes using AWS ECS service and EC2 Container services.

Shell scripting using bash and python.

IBM India Pvt Ltd, Noida, India 10/2011 to 02/2013

Database Administrator

Client: Bharti Airtel India

Supported approx. 700 databases which are multiple of Terabytes in size. As a level 2 Engineer, responsible for all types of database backups and standby databases.

Writing Shell scripting and preparing Technical Specification Document for DB monitoring, backup, and job scheduling

Backup and recovery

RAC Administration and configuration.

Database user management.

Disaster management using oracle data guard.

SDG Software India Pvt Ltd, Noida, India 08/2010 to 09/2011

Database Administrator

Client: GE Capital USA

Worked as L1 engineer responsible for all day-to-day activities which includes database health check, alert monitoring, space management, inform upper-level engineers in case of outage and escalation.

Database health monitoring.

Log monitoring in scheduled manner.

Working on client requests.

Database User management

Telecom Software Corporation Chandigarh 05/2008 to 08/2010

L1 Engineer

Client: Bharat Sanchar Nigam Ltd (BSNL): It is India’s largest government sector Telcom company.

Worked as L1 engineer responsible for all day-to-day activities which includes database health check, alert monitoring, space management, inform upper level engineers in case of outage and escalation.

Incident managing.

Backup and recovery.

DB health check

Maintaining inventory.

Education

Examination

University/Board

Institution

Bachelor of Technology

Punjab Technical university

Amritsar College of Engg. & Technology

XIIth

C.B.S.E

Jawahar Navodaya Vidyalaya Goindwal Sahib, Amritsar.

Xth

C.B.S.E

Jawahar Navodaya Vidyalaya, Goindwal Sahib, Amritsar.

Contact this candidate