Hardeep Singh
Calgary
Summary
With over 14 years of experience as a Senior Database Administrator at Tata Consultancy Services, I specialize in database maintenance, security, migration, upgrades, troubleshooting, performance optimization, and high-availability solutions, on both on-premises and in Azure Cloud. Certified in ITIL Foundation, MCSA: SQL 2016 Database Administration, and Oracle Database Administrator Certified Professional. Proficient in Oracle RAC, Oracle Data Guard, SQL Server Availability Groups, SQL Server Failover Clusters, Database Disaster Recovery, Oracle Enterprise Manager, GoldenGate Replication, and Azure SQL PaaS databases, skilled in SSIS, SSRS, PowerShell, and Shell scripting. Eager to contribute to the Government of Alberta's infrastructure team by leveraging technical skills and innovative solutions.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Senior Database Administrator
Tata Consultancy Services
05.2019 - Current
- Company Overview: Client: North American leading energy infrastructure company
- Team Management: Led a team of six DBAs, ensuring efficiency and productivity, and streamlined database tower transition from the client
- Managed databases, addressing daily issues for optimal performance, and resolved customer requests and Alerts/Incidents in ServiceNow, followed change, problem and vulnerability management protocols
- Planned storage capacity for systems on-premises and Azure Cloud, optimized Azure Blob Storage to save costs
- Disaster Recovery: Executed Database Disaster Recovery (DR) solutions, strengthening data protection and recovery processes
- Performance Issues: Implemented performance improvement strategies using RDBMS tools
- Installed SQL Server and Oracle databases within standalone and cluster environments, implemented high availability for Oracle databases using Oracle RAC, Oracle Data Guard and SQL Server with SQL Server Failover Cluster and AG
- Azure SQL PaaS and SQL Server on Azure IaaS Server: Created Azure SQL products in both IaaS server and PaaS databases and instances
- Backup Solutions: Maintained backup solutions with Oracle RMAN and SQL Native Backups
- Security: Enable Transparent data encryption (TDE) on SQL databases, and encrypted SQL Connections
- Built SSRS reporting solutions and SSIS packages for security reviews
- License Optimization: Reduced database license costs by 40%
- Scripting: Developed PowerShell and shell scripts for daily checks and monitoring
- Data Integration: Developed SSIS scripts for data integration and maintenance
- Database Maintenance: Managed and installed Oracle Data Guard, Goldengate replication, SQL PaaS Databases, SQL PaaS Instances, SQL Log Shipping, SQL Replication
- Deploying user codes in production databases under approved changes
- Collaboration with Application Team: Coordinated with the application team to upgrade/patch application, create/schedule application backend reports, create new databases, downtime for maintenance on the databases, troubleshoot issues
- Patch Management: Applied patches from Microsoft and Oracle
- Managed Oracle-to-PostgreSQL data migration, ensuring integrity and performance in cross-platform transitions
- Client: North American leading energy infrastructure company
Senior Database Administrator
Tata Consultancy Services
12.2016 - 04.2019
- Company Overview: Client: Leading Dutch defense, shipbuilding, and engineering conglomerate company
- Led a team of five DBAs, successfully transitioning and streamlining the database tower from the client, ensuring optimal performance and security
- Database Installation, upgrade and migration
- Working on Service Now tickets, database related SCOM Alerts, Change Management, Problem Management
- Developed and maintained backup solutions, created Azure SQL PaaS products, and managed migration and upgrade of databases in Azure Cloud and on-premises
- Automated daily tasks, reducing manual efforts by 90%, and implemented custom solutions for Oracle database monitoring using SCOM which help in maintaining availability of the Oracle databases
- Setup Monitoring for SQL Server Using SCOM
- Client: Leading Dutch defense, shipbuilding, and engineering conglomerate company
Senior Database Administrator
Tata Consultancy Services
11.2013 - 12.2016
- Company Overview: Client: Leading international hotel and resort chain based in the United States
- Database Team lead managed team of nine Database administrators
- 24 X 7 Administered, supported, and monitored databases proactively, resolving database issues and maintaining servers
- Solving customer-raised severity tickets in Assysts and ServiceNow, alerts, and incidents from OEM
- Planning storage capacity to manage systems and infrastructure
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance
- Install and create new SQL Server and Oracle databases in Standalone and Cluster environments
- Apply latest patches from Microsoft and Oracle
- Maintaining and Upgrading Oracle RAC, Oracle Data Guard, GoldenGate, Oracle pluggable database (PDB) and OEM
- Define and Create Metric Extension, Scheduling Database Report using OEM
- Automation of database jobs using shell and Powershell Scripts and schedule them in Cron or Windows's task scheduler
- Automation of data load using shell scripting and SQL
- Loader
- Setup and manage replication of data between multiple databases using GoldenGate
- Develop, implement, and manage database high availability solutions in SQL Server and Oracle Databases
- Migration of SQL and Oracle databases to AWS cloud
- Client: Leading international hotel and resort chain based in the United States
Database Administrator
Tata Consultancy Services
01.2011 - 10.2013
- Company Overview: Client: American wholesaler and retailer of grocery products
- Administered 24 X 7 production databases, ensuring proactive problem recognition and resolution, Monitoring availability of Database Instances, Backups and simultaneously handling alert logs for error
- Database physical administration, including datafile management, control file management, redo log management and archive log files management
- Solved customer-raised severity tickets in HP OpenView, CA Service Desk, Lotus Notes, alerts, and incidents from OEM
- Installed and upgraded Oracle and SQL Server databases, configured ASM Disks & ASM database creation, and managed Oracle Cluster, Oracle RAC for optimal performance and security in Solaris and Linux servers
- Client: American wholesaler and retailer of grocery products
Education
Bachelor Of Technology - Computer Science
Guru Gobind Singh Indraprastha University (GGSIU)
Skills
- Oracle Database Administration
- Oracle Data Guard
- Oracle RAC
- SQL Database Administration
- SQL Server High Availability
- SQL Server Reporting Services
- SQL Server Integration Services
- PostgreSQL
- Shell Scripting
- PowerShell Scripting
Certification
ITIL Foundation Certificate in IT Service Management, EXIN - 12/01/2015
Oracle Database Administrator Certified Professional, Oracle - 06/01/2016
MCSA: SQL Server 2012, Microsoft - 01/01/2019
Timeline
Senior Database Administrator
Tata Consultancy Services
05.2019 - Current
Senior Database Administrator
Tata Consultancy Services
12.2016 - 04.2019
Senior Database Administrator
Tata Consultancy Services
11.2013 - 12.2016
Database Administrator
Tata Consultancy Services
01.2011 - 10.2013
Bachelor Of Technology - Computer Science
Guru Gobind Singh Indraprastha University (GGSIU)
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Josephine CarlosJosephine Carlos
Licensed Practical Nurse at AgeCare SetonLicensed Practical Nurse at AgeCare Seton