Tejpal Singh
North Melbourne,Australia
Summary
Accomplished Senior SQL Server DBA with a proven track record at NTT Database Solutions, adept in migrating and optimizing database environments to cloud platforms like AWS and Azure. Excelled in enhancing system performance and security, leveraging skills in SQL Server Administration and collaborative problem-solving. Demonstrated expertise in PowerShell scripting and SQL performance tuning, contributing to significant infrastructure improvements.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Senior SQL Server DBA
NTT Database Solutions
10.2019 - 08.2022
- Migrated Hyper-V SQL environment to AWS IaaS VMCs. Installed and configured new SQL clusters, AGs, databases, firewall ports, and endpoints during migration.
- Created efficient solutions by leveraging DBATools with PowerShell.
- Administered SQL Azure instances for Air New Zealand.
- Managed database backups and restore operations using Veeam and TSM.
- Managed and enhanced disk space allocation in Virtual Machine Manager and AWS VMCs.
- Assisted development teams with implementation and identified opportunities for improved system performance.
- Collaborated with infrastructure and development teams to enhance infrastructure.
- Participated in production support on-call rotation to manage and resolve critical issues outside business hours.
- Optimized SQL Server performance tuning, including indexes management and TDE.
- Implemented database security measures including RBAC and encryption to protect sensitive data.
- Administered PowerBI gateways and connections.
- Managed SQL Always-On AGs, SQL clusters, Log Shipping, Replication and Mirroring, linked server connections, etc.
- Managed diverse SQL Server versions ranging from 2008 to 2022.
- Installed, upgraded, and managed SQL Server databases including SSIS, SSRS, and SSAS.
- Executed routine patches for SQL Server every quarter.
- Guaranteed up-to-date information within database records.
IT Engineer (SQL DBA)
Spark New Zealand
07.2016 - 10.2019
- Served as Primary Database Administrator for SQL Server versions 2005 to 2016, managing both operations and projects.
- Upgraded Windows failover clusters & the entire SQL environment from SQL Server 2008/2012 to SQL Server 2016 for KiwiRail.
- SQL patching and database refreshes.
- Hands-on experience in SSRS, SSIS, and SSAS.
- Windows administration and maintenance tasks.
- Developed effective database maintenance plans.
- Developed expertise in managing Windows Failover Clustering, AlwaysOn, Database mirroring and log shipping configurations.
- Enhanced efficiency by conducting database consistency checks, refining execution plans, and managing indexes.
- Maintain database integrity through backups.
- Executed automation tasks using PowerShell.
- Offered expert technical advice to assist with problem-solving.
ICT Database Administrator
KiwiRail NZ
Auckland, NZ
07.2013 - 01.2016
- Managed multiple database systems such as Microsoft SQL Server, Oracle, and DB2.
- Delivered complex technical, analytical, and professional services for program/member services.
- Enhanced database security and established data backup procedures.
- Managed access permissions, enhancing system security.
- Implemented effective storage and archiving procedures.
- Coordinated efforts between IT project managers, database developers, and multimedia specialists.
- Created thorough documentation for databases focusing on data standards, procedural guidelines, and terminology definitions.
- Developed and maintained effective disaster recovery protocols.
- Performance tuning and optimizing query performance.
- Developed and maintained SSIS and SSRS reports.
- Managed database transitions from SQL to Oracle.
- Executed database backups and restorations using TSM & Commvault.
IT Applications Support Analyst (Level 3 Support)
KiwiRail NZ
Auckland, NZ
09.2010 - 06.2013
- Maintained uninterrupted on-call assistance for vital proprietary IT systems.
- Crafted innovative applications enhancing business expansion.
- Delivered advanced application support to optimize system infrastructure.
- Worked with software vendors to find ideal business solutions and resolve unidentified issues.
- Provided support to business users while resolving application errors and data discrepancies.
- Contributed to the success of various smaller projects including Electronic Pen Testing Project and Digital Archiving of scanned invoices.
- Documented support procedures and participated in user meetings.
Service Support Analyst
KiwiRail NZ
Auckland, NZ
09.2008 - 09.2010
- Assisted users in troubleshooting logging and connection issues on Citrix servers.
- Managed Active Directory and Exchange accounts for all KiwiRail employees.
- Answered questions and troubleshot problems regarding software and hardware functionality.
- Supported troubleshooting of MS Outlook issues, remote access problems, VPN difficulties.
- Coordinated with site contacts to reboot routers, switches, and other network devices.
- Maintained and updated existing knowledgebase content with current information.
Education
National Diploma in Computing - Computing Level 6
Cornell institute of Information & Technology
03.2008
Bachelor of Science - Chemistry Honors
Rourkela Municipal College
Rourkela, India04-2003
Skills
- SQL Server Administration
- Windows system administration
- IaaS on AWS VMCs
- Azure Database Administration
- SCCM
- SCOM
- Logic Monitor
- Power BI dashboards and gateways
- Data Engineering
- Azure Synapse Analytics
- Azure Data Lake Gen2 Storage
- Azure Databricks
- Azure Data Factory
- SQL Performance Tuning
- PowerShell scripting via DBATools
- Indexes Management
- SQL scripting
- Maintenance plans
- Veeam, TSM, and Commvault backup technologies
- SSAS
- SSIS
- SSRS
- Application Support
- Windows Failover Clustering, AlwaysOn Availability Groups, Database Mirroring, Log Shipping
- Linked server connections (Oracle, Snowflake, etc)
Accomplishments
- Got promoted from Service Support Specialist to IT Applications Support Analyst at KiwiRail.
- Got promoted from IT Applications Support Analyst to SQL Server Database Administrator at KiwiRail.
- Received multiple client appreciation emails throughout my professional life especially in my latest role.
- Was awarded with NTT Monthly Badge for the month of May 2023 in the APAC region.
Certification
- 2024–11 - Microsoft Certified: Azure Data Engineer Associate
- 2023-06 - Architecting on AWS 3 Day Workshop - Lumify – Auckland
- 2022-12 - Microsoft PowerBI Data Analyst Associate (PL-300)
- 2022-07 -Administering Microsoft Azure SQL Solutions (DP-300)
- 2021-07 - Microsoft Certified: Azure Data Fundamentals (DP-900)
- 2017-01 - MCSE & MCSA in SQL Server 2014/2016
Timeline
Senior SQL Server DBA
NTT Database Solutions
10.2019 - 08.2022
IT Engineer (SQL DBA)
Spark New Zealand
07.2016 - 10.2019
ICT Database Administrator
KiwiRail NZ
07.2013 - 01.2016
IT Applications Support Analyst (Level 3 Support)
KiwiRail NZ
09.2010 - 06.2013
Service Support Analyst
KiwiRail NZ
09.2008 - 09.2010
National Diploma in Computing - Computing Level 6
Cornell institute of Information & Technology
Bachelor of Science - Chemistry Honors
Rourkela Municipal College
Similar Profiles
Brinda TurakhiyaBrinda Turakhiya
Business Analyst at JP Database SolutionsBusiness Analyst at JP Database Solutions
KANIKA SHARMAKANIKA SHARMA
Manager - Business Finance at NTT DATA Business Solutions Pvt Ltd.Manager - Business Finance at NTT DATA Business Solutions Pvt Ltd.
Jaikirat Singh BalJaikirat Singh Bal
Team Lead (IC Role) at INK IT Solutions (NTT Data)Team Lead (IC Role) at INK IT Solutions (NTT Data)