DB Technical Archi | Optimhire."> DB Technical Archi | Optimhire." />
Amit kumar  D.

Amit kumar D.

SQL DBA/ Azure Data Engineer

Delhi , India

Experience: 12 Years

Amit kumar

Delhi , India

SQL DBA/ Azure Data Engineer

60000 USD / Year

  • Immediate: Available

12 Years

Now you can Instantly Chat with Amit kumar !

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.

Show More

Portfolio Projects

DBA Mananger

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.

Show More Show Less

Health Sector Client in US

Company

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 Less

German specialty chemicals company

Company

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 Less

DBA

Company

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 Less

Skills

SQL 2012
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • Hindi - Native/Bilingual

  • English - Fluent

Available Timezones

  • Eastern Daylight [UTC -4]

  • Central Daylight [UTC -5]

  • Mountain Daylight [UTC -6]

  • Pacific Daylight [UTC -7]

  • Eastern European [UTC +2]

  • Eastern EST [UTC +3]

  • Greenwich Mean [UTC ±0]

  • Further EET [UTC +3]

  • Australian EDT [UTC +11]

  • Australian CDT [UTC +10:30]

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]