About Me
- Over 11 Years of SQL DBA experience. SME\Team manager.
- DB Technical Architect.
- Rich DBA experience in supporting over 4500+ SQL Server instances comprising of versions (2014/2012/2008...
- Cloud DBA
- Experience with Azure Data engineering tools i.e. Azure Datalake, Data factory. Cosmos DB etc.
- Cross skilled on Azure & AWS cloud and Microsoft Certified Solution Architect for Azure.
- Cross Skilled on Bigdata and Hadoop development along with administration. Having good understanding on Hadoop ecosystem, HDFS, MapReduce, PIG, Hive, HBase and how to process Bigdata using these technologies. Have built Hadoop clusters in all three standalone, pseudo and fully distributed mode and have developed MapR programs. Planning for Cloudera certification.
- Trained on Automation Anywhere RPA tool.
Skills
Software Testing
Data & Analytics
Programming Language
Networking & Security
Web Development
Database
Others
Development Tools
Portfolio Projects
Company
DBA Mananger
Role
Project Manager (Team Lead)
Description
Description: Telecom Giant in West US outsourced its infrastructure to Accenture. I am leading the infrastructure for Database environment including MS SQL and Oracle databases. Environment includes heavy transaction OLTP databases as well as Data warehousing databases with about 10-12 TB sizes. Along with Infrastructure support I am also involved in Application support and role is to optimize data warehousing application and processes with my expertise from database end.
Responsibilities:
- SQL server maintenance.
- Performance Tuning.
- SQL standalone/Cluster Installations.
- Configuration of AAG clusters.
- Performing Database maintenance activities like Backups, Restoring, and Re-indexing etc.
- Creating Maintenance plans and jobs for automation of the repetitive task & Monitoring the Scheduled jobs
- Analyzing, Identifying and Resolving performance issues of the server
- Configuration and troubleshooting of high availability and disaster recovery features like log shipping, mirroring, replication, clustering etc.
- Analyzing and troubleshooting the SQL Server processes and jobs.
- Solving Disk space, Log files full and database file full related issues on SQL servers.
- Proactively working on Performance and Blocking issues on servers by auditing Databases.
- Installations, patching, cumulative upgrades, hot fixing, backing up and recovering high impacting databases, monitoring and administration of jobs. Installations are made on both stand-alone as well as clusters.
Application Support Role: Application DBA
- Understanding the application processes running at database end and optimize the processes
- Proactively monitor the database maintenance jobs and optimize to reduce run time allowing more time available for application process
- Understanding database growth and recommend database growth strategy and capacity planning.
- Monitor and alert high capacity usage and alarming situations proactively to application teams
- Working with Data Architects for Performance tuning with queries with help of indexes and stats updates.
- Supporting application teams with run support and improvement plans with database expertise.
Skills
SQL Server 2014 MySQLTools
SQL Server 2012Company
Health Sector Client in US
Description
2. Project: Health Sector Client in US
Role: Database Manager/Database Architect
June 19 – Till Date
Description: Health sector client in US outsourced its CRM application infrastructure support to Accenture. I am leading the infrastructure for Database environment including MS SQL on Azure both in IAAS and PAAS modes. Environment includes heavy CRM databases with AAG configurations for HA of about 4-13TB in size along with reporting databases which are synced with help of log shipping to offload reporting from transaction databases.
Responsibilities:
- SQL server maintenance.
- Performance Tuning.
- SQL standalone/Cluster Installations.
- Configuration of AAG clusters.
- Performing Database maintenance activities like Backups, Restoring, and Re-indexing etc.
- Creating Maintenance plans and jobs for automation of the repetitive task & Monitoring the Scheduled jobs
- Analyzing, Identifying and Resolving performance issues of the server
- Configuration and troubleshooting of high availability and disaster recovery features like log shipping, mirroring, replication, clustering etc.
- Analyzing and troubleshooting the SQL Server processes and jobs.
- Solving Disk space, Log files full and database file full related issues on SQL servers.
- Proactively working on Performance and Blocking issues on servers by auditing Databases.
- Installations, patching, cumulative upgrades, hot fixing, backing up and recovering high impacting databases, monitoring and administration of jobs. Installations are made on both stand-alone as well as clusters.
Environment: SQL 2012/2016, Win Server 2012, Redgate monitor tool for SQL.
Show More Show LessSkills
SQL Server 2016Tools
SQL Server 2016Company
German specialty chemicals company
Description
3. Project: German specialty chemicals company
Role: Database Manager/Database Architect
Jan 19 – Till Date
Description: German specialty chemicals company outsourced its migration from On-premise/Datacenter to Cloud migration as well as infrastructure support to Accenture. I am leading the infrastructure for Database environment including MS SQL/Oracle/MySQL on-premise environment to cloud migration and after migration environment support. Environment includes varied sized databases with AAG/FCI clusters as well as log shipping and mirroring for HA and DR purposes. I had a team of 10 members and completed transition for the project.
Responsibilities:
- SQL server maintenance.
- Performance Tuning.
- SQL standalone/Cluster Installations.
- Configuration of AAG clusters.
- Performing Database maintenance activities like Backups, Restoring, and Re-indexing etc.
- Creating Maintenance plans and jobs for automation of the repetitive task & Monitoring the Scheduled jobs
- Analyzing, Identifying and Resolving performance issues of the server
- Configuration and troubleshooting of high availability and disaster recovery features like log shipping, mirroring, replication, clustering etc.
- Analyzing and troubleshooting the SQL Server processes and jobs.
- Solving Disk space, Log files full and database file full related issues on SQL servers.
- Proactively working on Performance and Blocking issues on servers by auditing Databases.
- Installations, patching, cumulative upgrades, hot fixing, backing up and recovering high impacting databases, monitoring and administration of jobs. Installations are made on both stand-alone as well as clusters.
Environment: SQL 2012/2014, Win Server 2012, Splunk tool for automation using T-SQL scripting.
Show More Show LessSkills
SQL Server 2014Tools
SQL Server 2012Company
DBA
Description
Description: Mining sector client in US outsourced its infrastructure support to Accenture. I was leading the infrastructure for Database environment including MS SQL on-premise environment. Environment includes varied sized databases with AAG/FCI clusters as well as log shipping and mirroring for HA and DR purposes.
Responsibilities:
- SQL server maintenance.
- Performance Tuning.
- SQL standalone/Cluster Installations.
- Configuration of AAG clusters.
- Performing Database maintenance activities like Backups, Restoring, and Re-indexing etc.
- Creating Maintenance plans and jobs for automation of the repetitive task & Monitoring the Scheduled jobs
- Analyzing, Identifying and Resolving performance issues of the server
- Configuration and troubleshooting of high availability and disaster recovery features like log shipping, mirroring, replication, clustering etc.
- Analyzing and troubleshooting the SQL Server processes and jobs.
- Solving Disk space, Log files full and database file full related issues on SQL servers.
- Proactively working on Performance and Blocking issues on servers by auditing Databases.
- Installations, patching, cumulative upgrades, hot fixing, backing up and recovering high impacting databases, monitoring and administration of jobs. Installations are made on both stand-alone as well as clusters.
Environment: SQL 2012/2014, Win Server 2008/2012, SQL Idera monitoring tool for SQL.
Show More Show LessSkills
SQL 2012Tools
SQL Server 2012