Azure Cloud Sql Database
Resume:
Praveen Kumar
Mobile: 469-***-****
************.****@*****.***
Summary
Azure SQL Database Administrator Profile
Snapshot: Currently working with Harsco Technologies Pvt ltd, total of around 13.5+ years of IT experience and 12+ years in MS SQL database Administration on Production Databases and Azure Cloud environment.
●Excellent knowledge and hands on experience in Migrations from on premise to Azure IAAS and PAAS servers
●Having very good knowledge on Pricing models of DTU/eDTU vs Vcore Model
●Having very good knowledge on saving the cost on Azure models
●Deploy, Configure, Maintain Compute on Azure IAAS and PAAS servers
●Implemented Infrastructure as a Service (IaaS) solutions to streamline operations and optimize resource utilization.
●Utilized database encryption techniques to enhance data security and ensure compliance with industry standards.
●Conducted performance tuning and optimization strategies for databases, resulting in improved efficiency and responsiveness of applications.
●Implemented different types of High Availability & Disaster Recovery models like SQL Always On, Clustering, Database Mirroring, Transactional Replication and Log Shipping.
●Troubleshoot Azure related issues and engage internal teams and vendor issue resolutions
●Automate deployment and troubleshoot mechanisms for quick service.
●Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
●Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
●Having hands on experience in Elastic Jobs and Run Books.
●Having good knowledge on External tables and Elastic pool Model(s)
●Having hands on experience into the Reservations and Azure hybrid benefits
●Utilized Service Now to manage and track incident and service requests, resulting in a 20% increase in resolution efficiency and improved user satisfaction.
●Developed and maintained automated workflows in ServiceNow, reducing ticket handling time by 25% and ensuring timely responses to critical issues.
●Monitored and analyzed ticketing trends and metrics through ServiceNow reports, providing actionable insights that enhanced support processes and reduced recurring issues.
●Implements workflows as well as development of Business Intelligence per department standards and procedures.
●Participates in product design reviews by providing creative and practical ideas and solutions in a teamwork environment.
●Trains end-users in the use of new system functionality or modifications to existing functions
●Supports various off-the-shelf applications including system interfaces Experience in implementing replication models like Snapshot, different types of transaction replications like Peer-to-Peer, transaction replication with updating subscribers etc.
●Expert in converting Physical SQL servers to Virtual machines using VMware.
●Implementation of Hosting SQL services in azure IAAS and PAAS servers.
●Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
●Deploy builds on multiple databases in Azure cloud.
●Managed SQL Server databases, including Availability Groups and Replication, to ensure high availability and reliability of critical systems.
●Configured and maintained database servers, processes, and backup solutions, resulting in 99.9% uptime and minimal data loss.
●Monitored system health and performance metrics to proactively address issues, enhancing system stability and performance.
●Performed performance tuning and query optimization, leading to a 25% improvement in application speed and efficiency.
●Implemented and automated regular processes and maintenance tasks, reducing manual effort by 30% and improving operational efficiency.
●Provided real-time analysis and solutions for critical issues, effectively minimizing downtime and ensuring continuous system operation.
●Assisted developers with query tuning and schema refinement, resulting in more efficient data access and improved application performance.
●Supported release deployment activities and scheduled maintenance outside regular hours, ensuring seamless updates and system stability.
●Refined system configurations and documented changes to enhance future troubleshooting and system management practices. Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
●Expert in setting standards and policies as well as securing environments.
●Expert in handling Terabyte size databases up to 5+TB in cluster environments.
●Expertise in administrating BI environment which includes SSAS, SSRS and SSIS
TECHNICAL SKILLS:
Database:
SQL Server 2019, 2017, 2016, 2014, 2012, 2088R2, 2008, 2005, 2000
Cloud Services:
Microsoft Azure
Operating Systems:
Windows & Linux
Database Tools:
SQL Profiler, Query Analyzer, SQL Server Management Studio (SSMS)
ETL Tools\Connectivity:
Azure Data Factory, ODBC, JDBC, linked Server, BCP, RDP(remote desktop Connectivity), PowerShell, Microsoft terminal Services, Windows Scheduler, control-M job scheduler, SQL Agent Scheduler
Reporting Tools:
SSRS 2019, 2017, 2016, 2012, 2008R2, 2008 & 2005, Power BI
Development Tools:
Microsoft Visual studio 2012, 2015, 2017, 2018
Professional Experience
Harsco Corporation Nov 2020- until date. Client: Clean Earth Environment Solutions, Philadelphia
Role: Senior Lead Database Engineer
Harsco Corporation is an environmental solutions company based in Philadelphia, Pennsylvania. Harsco operates in over 30 countries and employs approximately 12,000 people worldwide. The company provides solutions for complex environmental issues and serves large industries, including steel, railways, and energy.
Responsibilities:
Implementation of Hosting SQL services in azure IAAS and PAAS servers.
Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
Deploy builds on multiple databases in Azure cloud.
Manually take the schema and data backups of the databases and restore/copy databases and restore deleted databases in Azure cloud.
Import and Export data within Azure Cloud environment.
Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.
Migration of databases from On premise to Azure Cloud environment.
Setup maintenance plans for databases using Azure Elastic jobs and Azure automation methods.
Setup Audit and threat detection logs to ensure the security of the databases in Azure cloud and recover any in case required.
Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
Troubleshooting issues occurred with the databases in Azure cloud environment.
Suggest Cost optimization solutions in Azure PAAS environment.
Utilized Azure Data Factory to design and implement data integration solutions, streamlining data workflows and improving data accessibility.
Optimized performance, security, and cost-effectiveness of MS SQL databases, applying best practices and advanced techniques.
Collaborated with stakeholders, addressing technical challenges and aligning solutions with business requirements
Developed Backup plans and designed a database to track backups. Setup scripts to acquire daily backups. Redesigned the monitoring to include reporting on backup status and completion. Resulted in 99% increase in backups being completed.
Implemented different types of High Availability & Disaster Recovery models like SQL Always On, Clustering, Database Mirroring, Transactional Replication and Log Shipping.
Developed and documented a standardized SQL installation and configuration recommendations to improve security and facilitate installation and configuration of new SQL Servers.
Expertise in Side-by-Side Migrations of MS SQL SERVER 2008/2012/2014/2016/2019.
Cognizant Technology Solutions
Client: MassMutual Financial Group, Massachusetts
Role: Technical Lead August 2016-Nov 2020.
MassMutual provides financial products such as life insurance, disability income insurance, long term care insurance, retirement/401(k)plan services, and annuities. Major affiliates include Barings LLC, Haven Life Insurance Agency, and Oppenheimer Funds, Inc.
Implementation of Hosting SQL services in azure IAAS and PAAS servers.
Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
Deploy builds on multiple databases in Azure cloud.
Manually take the schema and data backups of the databases, restore/copy databases, and restore deleted databases in Azure cloud.
Import and Export data within Azure Cloud environment.
Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.
Migration of databases from On premise to Azure Cloud environment.
Setup maintenance plans for databases using Azure Elastic jobs and Azure automation methods.
Setup Audit and threat detection logs to ensure the security of the databases in Azure cloud and recover any in case required.
Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
Troubleshooting issues occurred with the databases in Azure cloud environment.
Suggest Cost optimization solutions in Azure PAAS environment.
Enabling and Managing data masking and encryption in Azure cloud environment
Enabling Geo replication to ensure availability of the Azure databases as DR plan.
Enabling Long time retention backup policy for Azure databases.
Creation of indexes, Partitions of the data in the Azure databases. Working knowledge of azure CICD. Cutting release branches for deployments for the appropriate teams.
Responsible for running the monthly ingestion files received from clients.
Fixed/organized SQL security and used CIS tools for scanning the environment.
Implemented data masking on PHI columns in SQL.
Work on Incidents raised by the internal\external customers.
Create Jobs in Automation Accounts for SQL stored procedure executions.
Worked on over 25+ various client migrations from SQL Server\DB2 to Azure cloud technologies.
Was the lead on multiple SQL upgrades from SQL 200x to 2019.
Used Foglight for monitoring servers for any issues.
Implemented different types of High Availability & Disaster Recovery models like SQL Always On, Clustering, Database Mirroring, Transactional Replication and Log Shipping.
Implemented & managed Active-Active and Active-Passive Clustering, Failover and Load Balance technologies.
Expertise in Side-by-Side Migrations of MS SQL SERVER 2008/2012/2014/2016/2019.
Maintenance, Support, Backups & Recovery: Monitored daily and weekly maintenance jobs(Backups Jobs,run DBCC run Rebuild Indexes, run update statics, run audit jobs), sent backups to tape(daily, weekly and monthly), Checked Server Error logs and validated space usage history(Log Files/data Files). Monitored replications and mirroring for servers. Monitored always-On failover and AG groups, Synchronized database between DR site and replicas. Monitored redo queue for any alerts, resumed replications to remove latency and synchronize data, Checked Server health and database health for any issues. Killed blocking process and monitored batch processes for any issue or slowness. Monitored failed jobs. Monitored TEMPDB space. Validated daily backups and log backups to meet business requirements for specified RTO and RPO.
Performance & Tuning: Provided the best Query plan, Tuned query for high I/O applications, disk Wait, high latency, and high CPU usage. Performed Index Optimization and did performance Tuning -DBCC, Update statistics, Fragmentation/index creation/data row or page level locking.
Lead the DR strategy for multiple clients in cloud and at various Colo’s.
IBM private limited
Client: L&G (Legal and General Insurance),UK
Role: Senior Operational professional
Mar 2014 to till July-2016.
Implementation of Hosting SQL services in azure IAAS and PAAS servers.
Create and configure Logical SQL servers, databases, elastic pools in Azure Cloud.
Deploy builds on multiple databases in Azure cloud.
Manually take the schema and data backups of the databases, restore/copy databases, and restore deleted databases in Azure cloud.
Import and Export data within Azure Cloud environment.
Creating and Managing logins/Access levels in Azure IAAS and PAAS environments.
Migration of databases from On premise to Azure Cloud environment.
Setup maintenance plans for databases using Azure Elastic jobs and Azure automation methods.
Setup Audit and threat detection logs to ensure the security of the databases in Azure cloud and recover any in case required.
Monitor performance and setup alerts to avoid performance issues occurring on Azure databases.
Troubleshooting issues occurred with the databases in Azure cloud environment.
Suggest Cost optimization solutions in Azure PAAS environment.
Enabling and Managing data masking and encryption in Azure cloud environment
Enabling Geo replication to ensure availability of the Azure databases as DR plan.
Enabling Long time retention backup policy for Azure databases.
Creation of indexes, Partitions of the data in the Azure databases.
Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering, Replication.
Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
Managed Great Plains Application and Databases along with Management Reporter DataMart.
Managed Master Data Service’s application and backend databases with AD authentication.
Backup and recovery of production databases and tuning them for better performance.
Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
Creating databases, logins, and users with permissions in SQL server 2005/2008/2008r2/2012/2014/2016/2017/2018.
Created Linked Servers between SQL server 2005/2008/2008r2/2012/2014/2016/2017/2018 and Oracle servers in the environment.
Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
Improved the database server performance using Performance monitor after analyzing CPU, I/O and Memory usage.
Monitored server level and DB level log events using SQL Server Audit
Worked with several teams and lead database team in the process of development of a Disaster Recovery and high availability solutions.
Design and tune the databases, high availability and disaster recovery methods by gathering SLA’s, acceptable downtime etc.
Minimized the backup-time, restore-time, disk I/O and storage required for backups with Backup Compression. Performed database and data file backups on all the databases as required.
Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from Oracle to SQL databases.
Configured Snapshot and Transaction Replication.
Creation, Testing, and Implementation of SSRS packages for Reporting Services (SSRS 2012/2016/2017) that included paper-based and interactive web-based reports.
Experience in building adhoc reports, parameterized reports, toggle reports, reports with sub reports using SSRS.
Implemented Pager options to inform corresponding DBA basis on Each Job Status.
Performed De fragmentations Techniques of most complex indexes.
Performed Backup and recovery & Automation of Backups using maintenance plans.
Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
Used Power Shell scripting in a limited manner for automating SQL jobs and deploying packages.
Created SSIS packages using ETL tools to migrate data from different source.
Net Avenue Technologies
Client: C Bazaar,Chennai IN
Role: Mssql Database Administrator
Jul 2013 to Jan 2014.
●Working with project management teams and participating in design solution meetings to gather and analyze requirements then converting them to design solution document later implementing.
●Assist client managers with development of client work orders.
●Working with other senior database developers & management.
●Responsible for performing SQL development and SSIS /SSAS/SSRS development.
●Work with other developers to facilitate creation of high performing data centric components and applications.
●Review the designs, code, and test plans of other developers and provide recommendations for improvement or optimizations.
●Supporting N-Tier applications and more than 2000 databases including Mission critical, Business critical, business supporting SQL Server and DMZ Environments.
●Installing and configuration SQL server on N +1 architecture using MS clustering software for database consolidation and virtualization projects (On VMware Platforms).
●Configuring and Supporting of DR and reporting Solutions using SQL server native tools like EMC SRDF (Symmetrix Remote Data Facility) etc.
●Upgrading SQL server environments to Higher Version as per business need and Vendor Support Matrix.
•Managing security and providing privileges to users
•Setting up/Securing Microsoft BI Environment then supporting and deploying SSIS, SharePoint portal and SSRS as services for Global and very large data warehouse projects
•Setting up database standard and policies for Enterprise support
•Supporting Mirror and Log shipping for Skype/Lync 2013 Global Project.
•Expert in finding Root Cause Analysis and presenting it to management
•Virtualizing SQL server Environments (Migrating Physical server to VMware ESX Cluster infrastructure with Vmotion to provide High Availability feature with a cost reduction)
•Managing Quarterly maintenance and Releases for Mission Critical environments
•Doing Capacity planning, forecasting Disk space, data file space, Tuning SQL Server Memory and CPU to enhance Server level performance in different database environments
•Migrating DTS and SSIS Packages
•Managing and supporting 10+ TB single database in Mission Critical Environment
•Helping System team in completing BCV process for SQL server Environment
•Excellent knowledge on Import / Export
•Monitoring Mission Critical SQL SERVER Environments using IDERA
•Experience in backups using Lite Speed for Object level recovery and EMC Networker for SQL.
•Provided production support to SQL environment
•Mentoring DBA team members
Nebula Computers
Client: Standard bank of South Africa,SA
Role: Software Engineer
Mar 2011 to Mar 2012.
•Configuring and Working on Replication and troubleshooting issue related to it.
•Configuring and Working on Database Mirroring and troubleshooting issue related to it.
•Managing Production databases, which is, configured both Replication and Mirroring.
•Installing and configuring new SQL Servers and doing post installation checks.
•Working on Upgrading the legacy SQL Servers to latest SQL Server version
•Applying latest SQL server service pack and CU to make server compliance.
•Performing number of change requests as per application team requirement
•Troubleshooting Performance issue like blocking, dead locking, High memory, CPU, Slow running query
Anion Technologies Feb 2009 to Mar 2011.
Client: Freedom Health Florida, FL
Role: Associate
●Working with project management teams and participating in design solution meetings to gather and analyze requirements then converting them to design solution document later implementing.
●Assist client managers with development of client work orders.
●Working with other senior database developers & management.
•Managing security and providing privileges to users
•Setting up/Securing Microsoft BI Environment then supporting and deploying SSIS, SharePoint portal and SSRS as services for Global and very large data warehouse projects
•Setting up database standard and policies for Enterprise support
•Supporting Mirror and Log shipping for Skype/Lync 2013 Global Project.
•Expert in finding Root Cause Analysis and presenting it to management
•Virtualizing SQL server Environments (Migrating Physical server to VMware ESX Cluster infrastructure with Vmotion to provide High Availability feature with a cost reduction)
•Managing Quarterly maintenance and Releases for Mission Critical environments
Education
●Mater of Computers from Osmania University, Hyderabad. INDIA
●Bachelor of Science from Osmania University, Hyderabad. INDIA
●Administering Relational Databases on Microsoft Azure -2022
Contact this candidate