APARNA CHERUKURI

SQL Database Administrator

737-***-****

adz4z6@r.postjobfree.com

Summary of Professional Experience

Having14+yearsof experience in IT industry with strong skills in requirement analysis, database architecture, data modeling& database administration using Microsoft Technologies like SQL database Administration(DBA) as Production Support Database Administrator (MSSQL DBA),SQL Server DatabaseDevelopment, Azure Data Engineering, AzureSynapse, PowerBI&MSBI(SSIS,SSRS).

Extensive Experience in providing Production support for Database and Applications

Experience in On-Premise to Azure Cloud Migration Activities using DMA Tool.

Used Azure Data Factory (ADF) to perform Incremental Loads from Azure SQL DB to Azure Synapse.

Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics.

Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks.

Optimized Azure Data Factory (ADF) Pipelines with Various Partitioning Techniques

Involved in Azure Integration Runtime (IR) Configurations and Data Integration Units [DIUs]

Sound knowledge in Database Backup, Restore and Disaster Recovery procedures

Experience in Creating Jobs and Sending Alerts using Database Mail.

Experience of high availability SQL Server solutions, including Log Shipping, DB Mirroring

Having experience Database Upgrade from SQL 2005 to SQL 2008/2008R2/2012/2014

Worked on migration of on-Prem to Azureenvironment

Experience in Configuration of Clustering.

Having hands on experience in Always on

Experience in configuration of SSRS and implementation of SSIS packages

Experience on Replication setup and troubleshooting the replication problems on Production servers.

Hands on experience in query tuning and optimization for various applications, Stored procedures and troubleshooting performance issues

Having good knowledge in understanding the business requirements and Designing the physical data model

Having hands on experience in netbackup backup, restoration and backup strategy configuration

Sound knowledge on handling all the blocking issues which affects the performance

Daily Maintenance of SQL Servers included reviewing SQL error logs, Event Viewer

Basic understanding Implementation of SQL Server clustering of databases between the servers

Experience on various Power BI Data Modelling activities including Power Query (M Language) and DAX.

Experience on Data Modelling from Excel, CSV, Web Sources, Power BI Datasets

Experience on Developing Various Power BI reports using Visuals and Visual Properties including Charts, Maps, Funnel, Bars, Clustered & Aggregated Components.

Experience on Drilling Options: Drill-down, Drill-thru, Drill-up, Expand to next/all levels

Experience on Navigation Options including Bookmarks, Drill-thru, Buttons & Actions

Experience on Power Query Datasets in On-Premise and in Cloud [Data Flows]

Experience on Transformations including Merge, Append, Group By, Pivot, Transpose

Experience on Number Transformations, String Transformations, Date-Time Transformations

Experience with Column (Field) Grouping, Hierarchies Creations and Usage.

Extensively worked on Power BI Personal Gateways and Enterprise Gateways

Creating Power BI Dashboards with Tiles and Pins from Reports, Insights and Workbooks.

Working with Power BI Report Server for Paginated Reports and Using Report Builder Tool.

Sharing Reports, Dashboards, Organizational Content Packs and App Workspace.

Experience on Query Settings, Query Edits, Advanced Editors and Parameters [Static, Dynamic]

Strong Knowledge on Power BI to import data from various sources such as SQL Server

Working Experience in implementing, maintaining, and documenting database applications.

Excellent communication, presentation skills

Possess strong business and technical vision with effective communication skills.

Certifications

Microsoft Certified Professional in “Azure Data Engineer”

Microsoft Certified Professional in “SQL Server 2016 Database Administration”

Microsoft Certified Professional in “SQL Server 2012 Database Administration”

Education Details

Master of Science from University of Madras, India, 2007

Bachelor of Science from Acharya Nagarjuna University, India, 2005

Technical Skills

SQL Server (SQL2019/2016/2014/2012/2008R2/2008/2005/2000)

Azure Datawarehouse (Synapse)

Azure Data Factory (ADF)

Azure Data Lake (ADLS)

Azure (IAAS/PAAS/SAAS)

SQL Server integration services (SSIS)

SQL Server Reporting Services (SSRS)

C#

Oracle

Power BI

PostgreSQL

Professional Experience

Texas Higher Education Coordinating Board Austin, TX July 23 – Sep 23

SQL Database Administrator

Worked as Lead Consultant for THECB for Cloud migration. Worked on supporting on-prem database maintenances and report migration and to migrate the older version of databases from On-Prem servers to Azure environment Azure SQL Managed Instance and supporting the reports configurations & data mapping.

Report data mapping for the CAPPS migration

Performance tuning

Supporting the on-prem database issues

Working on migration of databases from On-Prem to Azure cloud

Working on troubleshooting the performance issue

Performing regular database health checks for maintaining the databases

Working on development related issues

Worked in On-Premise to Azure Cloud Migration

Working on configuration of SSIS packages and SSRS reports for the reporting purposes

Providing support to the customer in case of any issues

Walmart Bentonville, AR Dec 21 – June 23

Lead SQL Database Administrator

Worked on supporting the databases for Walmart INC (Health & Wellness) as a lead to migrate the older version of databases from On-Prem servers to Azure environment Azure SQL Managed Instance and supporting the reports configurations for the sales data and managing the Data warehousing databases.

Roles & Responsibilities:

Working on troubleshooting the performance issue

Performing regular database health checks for maintaining the databases

Working on development related issues

Worked in On-Premise to Azure Cloud Migration

Working on configuration of SSIS packages and SSRS reports for the reporting purposes

Providing support to the customer in case of any issues

Working on supporting the data synchronization

Working on configuration of Always Onset up for High Availability on the Production database servers

Worked in On-Premise to Azure Cloud Migration Activities using DMA Tool.

Used Azure Data Factory (ADF) to perform Incremental Loads from Azure SQL DB to Azure Synapse.

Experience on various Power BI Data Modelling activities including Power Query (M Language) and DAX.

Working on Data Modelling from Excel, CSV, Web Sources, Power BI Datasets

Working on Developing Various Power BI reports using Visuals and Visual Properties including Charts, Maps, Funnel, Bars, Clustered & Aggregated Components.

Working on Power Query Datasets in On-Premise and in Cloud [Data Flows]

Environment: SQL 2019/2016/2012/2008R2, SQL Database developer, Azure SQL Managed Instance, Azure Synapse, Azure Data Factory, Azure Data Storage, SSIS, SSRS, PowerBI

7-Eleven Dallas, TX Mar 20 – Nov 21

Database Architect

7-Eleven is a multinational chain of retail convenience stores. The company headquarters are in Dallas, Texas. For IT department worked as a Senior SQL database Administrator for installing or migrating the SQL servers & databases. Supporting all project related database servers Globally like supporting the configuration of Sales application project.

Roles & Responsibilities:

Worked in On-Premise to Azure Cloud Migration

Worked on troubleshooting the performance issues.

Performing regular database health checks for maintaining the databases

Worked on development related issues.

Configured SSIS packages and SSRS reports for the reporting purposes.

Worked on various Power BI Data Modelling activities including Power Query and DAX.

Worked on Developing Various Power BI reports using Visuals and Visual Properties including Charts, Maps, Funnel, Bars, Clustered & Aggregated Components.

Provided support to the customer in case of any issues.

Worked on supporting the data synchronization.

Environment: SQL 2019/2012/2008R2, SQL Database developer, Azure IAAS, Azure Data Storage, Azure Data Factory, SSIS, SSRS, PowerBI

J.McLaughlin - Brooklyn, NY May 18 – Feb 20

Senior SQL Database Administrator

J.McLaughlin (herein referred to as JMCL) is a luxury brand with collections of apparel for men and women in over 150 stores spread across United States. The company headquarters and IT department are in Brooklyn, New York. JMCL is conducting an initiative to better serve its customers with the best possible technology solutions and has identified to leverage Cloud technologies. One of the key drivers for this initiative is to migrate its on–prem Data Centre (herein referred to as DC) to Microsoft Azure Cloud.

Roles & Responsibilities:

Worked on assessing the database on-prem environment

Migrated the databases from On-Prem to Azure Cloud server.

Worked on Lift & Shift model for migration.

Worked on configuring the Always on set up for the high availability.

Worked on configuration SSIS packages.

Worked in query tuning and optimization for various applications, Stored procedures and troubleshooting performance issues.

Environment: SQL 2019/2016/2012/2008R2, Azure SQL Managed Instance, Azure Synapse,

Azure Data Storage, SSIS, SSRS

Wood (Amec Foster Wheeler), UK Jan 16 – Apr 18

Enterprise administrator

Worked as an Enterprise administrator for MDAX project & supporting all engineering related database servers Globally like supporting the configuration of engineering application project like Smart Plant3D, AVEVANET applications.

Roles & Responsibilities:

Working as Global Enterprise database admin. Managing 800 database servers

Standardizing all the server configurations

Working installation and configuration

Implementation of managed service accounts

Working on configuration and troubleshooting database replication

Maintaining global databases

Worked on configuration and troubleshooting of Always on high availability model

Performing downgrade\decommission

Consolidation of licensing

Maintaining Enterprise database – Microsoft Dynamics AX 2012

Experience in configuration of SSRS and implementation of SSIS packages

Configuration of log shipping

Working on migration/upgradation

SQL patching

SQL Upgrading

Environment: SQL 2019/2016/2012/2008R2/2005, SQL Database developer, Microsoft Dynamics AX, SQL Server integration Services, SQL Server Reporting Services

Data Tracks India Jan 13 – Jan 16

Database Administrator

Worked on supporting the databases for IT filing application as Rainbow & worked as a lead for the development of Online Reviewer Guide project. The purpose of the project is like generating the SEC reports for the US company audit File and worked on database design and administering of European Banking Authority (EBA) projects, Solvency & CRD project.

Roles & Responsibilities:

Installing, Configuring and Administering SQL server 2012

Performing Database maintenance activities like Backups, Restoring, Re-indexing etc.

Monitoring the Scheduled jobs. Ensuring high availability of the database exploiting the concepts of Merge replication, Peer-Peer Replication, Log shipping etc.

Monitoring the Disk spaces on all the servers. Checking the general Health of the servers for identifying Bottlenecks. Analyzing, Identifying and Resolving performance issues of the server

Having hands on experience in Always on

Understanding the business requirements. Designing the Logical and physical data model.

Maintaining all the databases.

Leading the team for developing the tool. Writing Unit test cases

Development and improving the performance.

Environment: 2012/2008R2/2005, SQL Database developer

Power Soft Technologies India Jan 09 – Jan 13

SQL Server Developer

Health & benefits Team is basically involved in loading the data for the new clients into the database and understanding the requirements from the client’s team regarding the Health & Benefits plans for different participants and then work on client’s databases to implement the requirements.

Roles & Responsibilities:

Planning and implementing backup strategies for full, differential and transaction log backups.

Managing schema objects such as tables, views, indexes, functions.

Installation, configuration Microsoft SQL Server 2005/2008/2008R2 software in developer/ test/ production boxes. Confirm that backups have been made and successfully saved to a secure location.

Periodically monitor performance using both System Monitor and Profiler/SQL Trace.

Importing Exporting data using DTS, SSIS packages. Restoring DB in case of crash/emergency.

Contact this candidate