PARVEEN KUMAR RANA

Database Administrator

Phone: +1-416-***-****

adx852@r.postjobfree.com

LinkedIn

Objective:

Highly experienced Database Administrator with 17 years of experience in the field. My proficiency extends to cloud technologies, BI tools, and data management, including aspects like installation, configuration, migration, and performance troubleshooting. I have demonstrated expertise in SQL code optimization, managing databases on Azure VM, Azure SQL Managed Instances (SQLMI), AWS VM and onprem. Seeking a challenging opportunity where I can employ my wide-ranging skills to contribute to the growth and success of the company.

Skill Set:

Databases: SQL Server 6.5, 7.0, 2000, 2005, 2008, R2, 2012, 2014,2016, 2019 and 2022, good working knowledge of Sybase, MySQL, Postgres and NoSQL DBs (InfluxDB)

Cloud: Azure SQL Database, Azure Manage Instance, AWS RDS, Azure synapse analytics, Azure Databricks (ADB), Azure Data factory (ADF), ADLS.

Version Control: Git

Operating Systems: Windows 2022, 2019, 2016, 2012, 2008 and 2003.

Languages and Tools: SQL, Powershell, Symantec Backup Exec, Redgate SQL Backup, DynaTrace, NewRelic, DataDog, Idera SQL Diagnostic Manager, Confio Ignite, SQL Safe Backup and Garfana.

BI and other Tools: Power BI, SSIS, SSRS and SSAS

Certifications

Microsoft Certified: Azure Solutions Architect Expert

Microsoft Certified: Azure Database Administrator Associate

Employment

PointClickCare (Toronto, Canada) Dec 2014 – Current

Senior Database Administrator

Set up processes and mentored the team in best practices for patching OS and SQL servers running on AG and standalone environments.

Successfully migrated a large (2 TB) MySQL database running on AWS RDS to Azure Database (MySQL) using mydumper and myloader utility, ensuring minimal downtime.

Led the migration of a complete data center (7000+ databases) to Azure, utilizing PaaS for smaller databases, IaaS for larger databases, and DBaaS for critical software.

Implemented Availability Groups (AG) on databases hosted on IaaS and customized an auto-scheduling alert mechanism for efficient monitoring and alerting.

Designed a data pipeline using Azure Synapse and Databricks to enhance performance insights, resulting in cost savings of $55k per month.

Demonstrated expertise in managing and troubleshooting issues with multiple VLDBs (15+ TB), with a total database size of 4 PB+.

Automated the backup file transfer process from local to AWS S3 bucket and added email notifications in case of process failures.

Managed 400+ transaction replication databases and automated the process of rebuilding transaction replication or creating new replications as needed.

Successfully migrated/upgraded SQL Server 2016 from one AWS VPN to another AWS VPN.

Created reports for weekly trending and analysis of database infrastructure, facilitating efficient hardware ordering.

Created and configured a Git repository for DBAs to store their work, enabling streamlined deployment processes, and documented all steps for the team to follow.

Actively participated in disaster recovery policy planning and conducted regular DR tests.

Implemented a big table aging process for large tables across 7000+ databases, optimizing storage and performance, and created comprehensive documentation for the team.

Developed scripts for automating cluster builds, instance installations, SQL Server configurations, as well as post-validation tasks.

Created scripts to automate cluster decommissioning and release space in SAN.

Developed a script to generate XML for MultiScript tool, enabling the execution of queries across multiple databases.

Collaborated with the development team to troubleshoot performance tuning issues and provided recommendations for code changes and index creation.

Coordinated with network/system administrators and application administrators for necessary patches and maintenance of database servers.

Automated various processes, resulting in approximately 200 Jira cases per week, and worked with the DevOps team to implement self-service portals for streamlined operations.

Implemented a notification mechanism (SSIS + complex stored procedure) to send alerts to the integration team and generate reports for clients, enhancing productivity and resource efficiency.

Wrote PowerShell scripts for DBA administrative activities such as backup, job status, maintenance tasks, and executing scripts across multiple or specific databases.

Managed two SSRS servers and created over 100 reports for business-related capacity planning and day-to-day DBA monitoring tasks.

Working closely with the development team/production DBA to optimize queries and identify bottlenecks.

Strategic Mapping Inc (Toronto, Canada) Aug 2013 – Dec 2014

Sr. DBA / SQL, BI Developer

Successfully led the migration of 10+ SQL Servers (100+ databases) to the Azure cloud platform, ensuring seamless data transfer and minimal downtime.

Developed and implemented a comprehensive dashboard for day-to-day DBA tasks, providing real-time visibility into job status, database and disk size, log shipping health, and backup status, streamlining monitoring and troubleshooting processes.

Created a baseline for all production servers using PerfMon counters and leveraged the ReLog utility to export the data into SQL Server. Utilized SSRS to generate insightful reports for establishing performance benchmarks and facilitating issue resolution.

Implemented log shipping across all production servers, configuring a seamless data replication mechanism between a Windows Azure VM (SQL Server) and the Data Centre SQL Server machine, ensuring data integrity and disaster recovery readiness.

Leveraged SQL Server Data Tools (SSDT) project and integrated it with Team Foundation Server to effectively manage SQL objects, ensuring version control and collaboration among the development team.

Automated the backup and restore process for developers and testing teams, providing them with the flexibility to obtain fresh copies of the Integration server and restore them on-demand into the development and UAT environments, enhancing overall efficiency.

Architecturally redesigned the reporting process to address performance bottlenecks. By implementing a streamlined data pipeline and redirecting all reports to fetch data from the optimized source, report generation time was significantly reduced from minutes to just 30 seconds, improving overall operational efficiency.

OFS Software (Georgia, U.S.A.) Aug 2012 - Jul 2013

Sr. DB Developer/Technical Lead

Gathered requirements, translated business needs, and documented source-to-target mappings and ETL specifications.

Utilized a variety of SSIS transformations and tasks to perform data integration, including bulk insert, expressions, script tasks, execute SQL, slowly changing dimensions, conditional split, aggregator, merge, merge join, lookup, cache transform, and character map.

Ensured adherence to IT standards by reviewing detailed designs and conducting code reviews.

Contributed to defect analysis during UAT, collaborated with users to understand data and code changes, and optimized database performance through stored procedure tuning, and index creation.

Primus Telecommunication (Virginia, U.S.A.) Mar 2007 - Aug 2012

DBA Team Lead

Profound experience in relational database design and implementation using SQL Server.

Also managed and train junior DBA for production day to day DBA works and activities.

Tech Mahindra (Delhi, INDIA) Mar 2005 - Mar 2007

SQL Server DBA

Conducted SQL Server installations, upgrades, backup planning, monitoring, and implemented measures for data safeguarding and maintenance.

Education

MCA (Master of Computer Applications), MD University (2007-2008)

Awards:

Gorilla Award (PointClickCare) in 2017 and 2018

Circle of Excellency (Primus) in 2011

Best employee of the year (Primus) in 2007

Contact this candidate