Azure Data
Resume:
Resume
AKHILESH KUMAR Email:*******************@*****.***
Cell: +91-900*******
SUMMARY:
A highly motivated and hardworking individual with total 7 years of experience working as a SQL Server DBA as well as working in Data Warehousing within the environment of Azure Data Factory. Passionate about working with cutting edge technologies and able to prioritize work under pressure. An excellent team member and able to focus on whatever it takes to get the job done effectively and efficiently. Have good communication skills and a logical approach to problem solving.
PROFESSIONAL PROFILE:
Azure Data Factory
-Creation of Azure Data Factory
-Creation of ADF Datasets
-Access and ingest data with built-in connectors
-Schedule, run and monitor your pipelines
-Integrate with different types of data stores to gather information or data.
-Creation and modification of ADF pipelines to execute the data
-Azure environment (PaaS, IaaS) and experience in working with Hybrid model
-Experience in Azure Data Lake
-Knowledge MSSQL, CosmosDB and HBase databases
-Transform data using Spark activity in Azure Data Factory
-Used Azure Dataware House for injection of the Hadoop files
1.Provide Data Warehouse recommendation for better management of disparate data sources on a single platform and Moving Relational Data to SQL DW Using Ploybase and BCP
2.Participated in regular requirement calls with Onsite Team and Client
3.Azure Cloud Environment Setup
4.Analysis the Varies Source Systems and Existing Power BI Reports
5.Developing ADF Pipeline for Initial and Incremental Data Load
6. Experience in Microsoft Azure Services. Implemented and Explored more than 20 Azure Services like Azure SQL DB, BLOB, Azure Data Lake Store, Azure SQL Data Warehouse, Databricks,Azure Cosmos DB Azure Stream Analytic, Integration with Hive and Spark,Data lake analytics, Azure Functions, HD Insights, App Insights, etc.
Microsoft SQL server dba
•6 years of SQL DBA production support experience in Microsoft SQL Server 2005,2008 & 2012,2014,2016 Database Administration.
•Maintaining all database servers across the domain.
•Maintaining and Managing the Database health activities and database backups.
•Responsible for rebuilding/monitoring the indexes at regular intervals for better performance.
•Responsible for monitoring and making recommendations for performance improvement in databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
•Responsible for Checking of the database consistency using DBCC commands to minimize complexity.
•Maintaining and Managing the Database Log shipping, Mirroring, Replication, Alwayson and Clustering.
TOTAL EXPERIENCE:
7.10 Years
Current Organization: Cerner Healthcare Solutions
Past Organizations: Infosys Limited, TCS
Technical Expertise:
Databases:
MS SQL Server 2016, MS SQL Server 2014, MS SQL Server 2012,MS SQL Server 2008, MS SQL Server 2005
DBA:
MS SQL Server 2016, MS SQL Server 2014, MS SQL Server 2012,MS SQL Server 2008, MS SQL Server 2005
Operating System:
Windows 2003/2008/2012/2016,Unix, Advanced Server, NT & Windows 9x
Tools:
Backup Utility, MSBI, PowerShell,HPSM9 Ticketing Tool,NetApp
Network Topologies:
TCP/IP, DNS, FTP, SMTP
Cloud Technologies :
Microsoft Azure
EDUCATIONAL QUALIFICATION:
BTECH in CSE (First Class with Distinction)from SRM University,Chennai,Tamilnadu.
Intermediate from DPS,Ranchi,Jharkhand.
MAJOR PROJECTS:-
Project Title: Toll Group - Providing Global Logistics
Client Location: Australia
Role: Azure Data Engineer
Environment: MS SQL Server 2005, 2008, 2008 R2 and 2012
Windows Server 2000,2003,2008 R2 and 2012, NetApp, HPSM9
Job Responsibility:
1. Azure Cloud Environment Setup
2. Move on premise SQL data to azure lake store and Azure SQL
3. Move on Premise Log files to azure data lake store using PowerShell
4. To Automate the azure data Import and Export Process Using BCP
Moving Flat Files to Azure Blob Storage Using ADF
1.Moving Flat Files to Azure Blob Storage Using AzCopy
2.Moving Relational Data to SQL DW Using Ploybase and BCP
3.Create the ARM Template for Varies Resources Deployment
Azure Cloud Environment Setup
1.Move on premise SQL data to azure lake store and Azure SQL
2.To Automate the azure data Import and Export Process Using BCP
3.Data warehousing and Data Mart development
4.Participated in regular requirement and status calls with Onsite Team.
5.Creating data factory to copy data from one folder to another folder in Azure Data Lake store.
6.Experience on designing, planning and implementing Azure environments.
7.Experience in Writing the SQL Queries, Stored Procedures
8.Monitor and evaluate to ensure timely upgrades and additions of IaaS/PaaS and software to meet growth requirements
9.Responsible for Disaster recovery, backups/restores of Azure Resources Configurations (ARM Templates), Virtual Machines and Storage Accounts
•2.5 years of experience in Data Warehousing within the environment of Azure Data Factory
Experience in Microsoft Azure Services. Implemented and Explored more than 20 Azure Services like Azure SQL DB, BLOB, Azure Data Lake Store, Azure SQL Data Warehouse, Databricks,Azure Cosmos DB Azure Stream Analytic, Integration with Hive and Spark,Data lake analytics, Azure Functions, HD Insights, App Insights, etc.
Well versed with migration of on premises resources to cloud.
Good Experience in Agile Methodology.
Weekly meetings with technical collaborators and active participation in Design approach, scenarios review sessions with senior and junior developers.
Experienced in developing large datasets using the partitions, effective and efficient joins, Transformations and other staging process itself.
Experience in identifying and resolving major issues in production in case of major failures.
Design inconsistencies and preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
Good knowledge on Cloud design patterns- Understanding RDBMS databases and concept and implementation of No-SQL databases
Analyze logs to support and troubleshoot application, infrastructure issues in production and non-production environments
Experience in Writing the SQL Queries, Stored Procedures, Functions and Indexes according to the Requirement.
Involved in various tasks such as Control Flow(Execute Sql task, For each loop Containers, Dataflow Task, File System Task etc) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional split, Derived column etc.
•Project Title: MORGAN STANLEY
Client Location: USA
Role: Azure Data Engineer
Environment: MS SQL Server 2005, 2008, 2008 R2 and 2012
Windows Server 2000,2003,2008 R2 and 2012, commvault tools
Job Responsibility:
1. Azure Cloud Environment Setup
2. Move on premise SQL data to azure lake store and Azure SQL
3. Move on Premise Log files to azure data lake store using PowerShell
4. To Automate the azure data Import and Export Process Using BCP
Moving Flat Files to Azure Blob Storage Using ADF
1.Moving Flat Files to Azure Blob Storage Using AzCopy
2.Moving Relational Data to SQL DW Using Ploybase and BCP
3.Create the ARM Template for Varies Resources Deployment
Azure Cloud Environment Setup
1.Move on premise SQL data to azure lake store and Azure SQL
2.To Automate the azure data Import and Export Process Using BCP
3.Data warehousing and Data Mart development
4.Participated in regular requirement and status calls with Onsite Team.
5.Creating data factory to copy data from one folder to another folder in Azure Data Lake store.
6.Experience on designing, planning and implementing Azure environments.
7.Experience in Writing the SQL Queries, Stored Procedures
8.Monitor and evaluate to ensure timely upgrades and additions of IaaS/PaaS and software to meet growth requirements
9.Responsible for Disaster recovery, backups/restores of Azure Resources Configurations (ARM Templates), Virtual Machines and Storage Accounts
•2.5 years of experience in Data Warehousing within the environment of Azure Data Factory
Experience in Microsoft Azure Services. Implemented and Explored more than 20 Azure Services like Azure SQL DB, BLOB, Azure Data Lake Store, Azure SQL Data Warehouse, Databricks,Azure Cosmos DB Azure Stream Analytic, Integration with Hive and Spark,Data lake analytics, Azure Functions, HD Insights, App Insights, etc.
Well versed with migration of on premises resources to cloud.
Good Experience in Agile Methodology.
Weekly meetings with technical collaborators and active participation in Design approach, scenarios review sessions with senior and junior developers.
Experienced in developing large datasets using the partitions, effective and efficient joins, Transformations and other staging process itself.
Experience in identifying and resolving major issues in production in case of major failures.
Design inconsistencies and preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
Good knowledge on Cloud design patterns- Understanding RDBMS databases and concept and implementation of No-SQL databases
Analyze logs to support and troubleshoot application, infrastructure issues in production and non-production environments
Experience in Writing the SQL Queries, Stored Procedures, Functions and Indexes according to the Requirement.
•Project Title: DILIGENTA LIMITED
Client Location: UK
Role: SQL Server DBA/Azure Data Engineer
Environment: MS SQL Server 2005, 2008, 2008 R2 and 2012
Windows Server 2000,2003,2008 R2 and 2012, commvault tools
Job Responsibility:
24 x 7 Production Database on Call Support.
Refreshing database from production to development and test servers as per requests.
Created and maintained users and user groups
Performed daily backups and developed recovery procedures.
Checking of the database consistency using DBCC commands to minimize complexity.
Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
Monitoring the Sqlserver and OS lever issues by setting Pefrmon counters.
Involved in generating Workload file to analyze SQL server performance using SQL Server Profiler.
Capturing and tuning the long time running query’s thru Use full DMV’s.
Involved in Index operations (Rebuild & Reorganize) and database maintenance.
Maintaining and Managing the Database Log shipping, Alwayson & Clustering.
•Project Title: DIAGEO Database Maintenance and Supporting
Client Location: UK
Role: SQL Server DBA
Environment: MS SQL Server 2005, 2008, 2008 R2 and 2012
Windows Server 2000,2003,2008 R2 and 2012, commvault tools
Job Responsibility:
24 x 7 Production Database on Call Support.
Refreshing database from production to development and test servers as per requests.
Created and maintained users and user groups
Performed daily backups and developed recovery procedures.
Checking of the database consistency using DBCC commands to minimize complexity.
Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
Monitoring the Sqlserver and OS lever issues by setting Pefrmon counters.
Involved in generating Workload file to analyze SQL server performance using SQL Server Profiler.
Capturing and tuning the long time running query’s thru Use full DMV’s.
Involved in Index operations (Rebuild & Reorganize) and database maintenance.
Maintaining and Managing the Database Log shipping, Alwayson & Clustering.
•Project Title: TELEFONICA GOLBAL TECHNOGY
Client Location: UK
Role: SQL Server DBA/ Azure Data Engineer
Environment: MS SQL Server 2005, 2008, and 2008 R
Win Server 2003 & 2008 R2, BI tools
Job Responsibility:
24 x 7 Production Database on Call Support.
Restoring database from production to development and test servers as per requests.
Created and maintained users and user groups
Performed daily backups and developed recovery procedures.
Checking of the database consistency using DBCC commands to minimize complexity.
Created Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning.
Monitoring the Sqlserver and OS lever issues by setting Pefrmon counters.
Involved in generating Workload file to analyze SQL server performance using SQL Server Profiler.
Tuned the SQL queries using performance monitoring tools. & involved in tuning the database.
Capturing and tuning the long time running query’s thru Use full DMV’s.
Involved in Index operations (Rebuild & Reorganize) and database maintenance.
Maintaining and Managing the Database Log shipping& Replication.
Technical Certification
ITIL V3 2011 FOUNDATION certified by AXELOS, 2015
MICROSOFT SQL SERVER 2012/2014(EXAM 70-462)
MICROSOFT SQL SERVER 2016(EXAM 70-764)
Microsoft Azure Data Engineer (DP200)
Contact this candidate