WORK EXPERIENCE:

 

Cognizant Technical Solutions

ROLE : AZURE DATA ENGINEER

CLIENT – Lincoln Financial Group

Chennai, TN

01/2020 - Present

 

         

●       Design and implement data solutions in Azure cloud by understanding the current state of applications and recommend better solutions for enhancements to the existing business.

●       Involved in Data Preprocessing Techniques for making the data useful for creating Data Visualization and Machine Learning models

●       Analyze, design and build Modern data solutions using Azure PaaS service support. 

●       Extract Transform and load data from source systems to Azure Data storage using ADF.

●       Create pipelines in ADF using linked services/datasets/pipelines to extract, transform, and load data from different sources

●       Developed spark applications using Pyspark and Spark -SQL for extraction , transformation and aggregation of data from various sources.

●       Hands on experience on developing SQL scripts for automation.

●       Utilized databases like mssql, DB2, data warehousing tools, tableau and other visualization tools for data intelligence and Analysis.

●       experienced in monitoring and troubleshooting of spark data bricks clusters.

●       Leveraged technology to automate daily operational activities using python scripting.

●       Excellent problem solving and analytical skills, ability to research , follow up and resolve complex issues surfaced by the team.

Cognizant Technical Solutions

ROLE : DB2 DBA LUW , MSSQL DBA

CLIENT – Manulife Japan

 

Chennai, TN

01/2012- 12/2019

Responsibilities:

 

●    Involved in migration and upgrade of mssql, DB2 luw, mysql databases.

●    Maintained , monitored and troubleshot RDBMS databases like mssql, DB2 luw, mysql and sybase databases.

●    Migrated DB2 9.7 version to 11.1 in cloud environment

●    Install and configure DB2 UDB new releases, upgrades, and fixpacks.

●    Perform database maintenance activities such as backup, reorg, runstats.

●    Scripting, design/analysis, installation, monitoring, maintaining, troubleshooting, and tuning UDB databases

●    Analyze DB2 UDB Event Monitor information, physical design, performance characteristics of tablespaces, physical I/O rates, and table access activities.

●    Proactively monitor performance, diagnose problems and tune queries and database.

●    Assisting with the creation and modification of database storage structures (tablespaces) and primary objects (tables, views, indexes)

●    Database Backup/Recovery on databases and file system backups. Redirect Restore to move application from Development, Test and Production

●    Use tools like db2explain, db2advise, db2look, db2move, db2top and db2pd to monitor, analyze and make changes in the database.

●    Development, performance monitoring and tuning for UDB 10.5 , 11.1 versions

●    Changing instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing the server.

●    Plan and implement disaster recovery and standard recovery testing using established documentation

●    Provide 24X7 on-call support to troubleshoot issues with the Production schedule.

●    Perform capacity planning and analysis and implement required changes on the database server