Database Administrator Warehouse Architect

SUMMARY:

Having around *+ years of IT experience in Finance, Health environments with primary skills on Development, Analysis, Design and Implementing Client/server application using Microsoft SQL Server and BI suite for both OLTP & OLAP.

Extensive experience in Installation, Configuration and Administration of SQL server in a Stand-Alone environment.

Expert level skills in creating objects like Tables, Views, Functions, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T-SQL statements.

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC, Re-indexing, Updating Statistics and online indexing. Expertise in SQL server Backup/Restore, having knowledge in upgrading of SQL servers.

Have extensive experience in DBCC and DMV's to check the health of the server and had experience working with Service Broker for audit purposes.

Solid experience on High availability& Disaster recovery techniques like Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active-Active).

Implemented Always-on Availability Groups.

Experience in creating and implementing maintenance plan with stored procedures, T-SQL Scripts to ensure smooth running of SQL server.

Experience in storage capacity planning, experience in regular maintenance activities like performance tuning, query tuning, update statistics, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions, and fragmentation issues using DMV’s and DBCC commands.

Ability to work independently or as a part of team to accomplish business objectives.

Experience in working with internal stakeholders and external clients to understand the requirements for building the reports and packages to deliver files and reports to clients.

Involved in creating stored procedures, triggers, functions, Indexes, tables, views and other T-SQL code and SQL joins for applications by maintaining best standards to perform efficiently.

Expertise in Analyzing and Optimizing the slow-running queries, cost-based queries using SET operations, Query plans, Statistics and Indexes.

Involved up gradation and migration from MS SQL Server 2008 to MS SQL Server 2012.

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, businesspeople and developers across multiple disciplines.

Good Knowledge in designing Visualizations using Tableau dashboards.

Experience in using Atlassian products SNOW and JIRA.

TECHNICAL SKILLS:

Databases

MS SQL Server 2000/2005/2008/2012/2014/2016,2017,2019

Languages

SQL, T-SQL, PowerShell.

Tools

SQL Server Integration Services (SSIS) Oracle Data Integrator (ODI), Cognos data Manager, CyberArk, SNOW, Azure,

SQL Server Tools

SQL Server Management Studio, Spotlight Diagnostic manager, Snapcenter, Delphix, SQL Profiler, Export & Import (DTS), Spotlight Enterprise, Spotlight Diagnostic manager, SQL DM, Visual Studio 2008/2012, SQL Compare.

Business Intelligence Tools

Business Intelligence Development Studio (BIDS), SSRS, SSIS, SSAS, Tableau

EDUCATION:

MS, Business Information Systems, New Jersey Institute of Technology, Newark, NJ DEC 2018

B.E., Electronics & Telecommunications Engg, S.I.T. Pune University, Lonavala, India JUNE 2015

PROFESSIONALEXPERIENCE:

Client: QVC.INC

Location: West Chester, PA Nov 2021- Till Date

Project Name – Azure EDW

Responsibilities:

The SQL Server DBA working as a member of the Enterprise Data Warehouse Administration team supporting the implementation of an Azure Data Warehouse.

Execute SQL commands against the Azure Data Warehouse, Databricks Delta Lake, and SQL Server Databases in Azure.

Implementing data and schema changes in Azure.

Assist in migration from on-prem to Azure Cloud.

Proactively monitor Synapse workload (Dedicated SQL pool) and engage internal/external teams as appropriate to resolve errors/failures/throughput bottleneck.

Execute Change Tasks including but not limited to security provisioning, schema creation, DB role creation, DDL execution, data restoration, etc.

Assist Application Developers and testers with re-engineering / deploying code from an Infrastructure Support standpoint.

Review workload and provide recommendations for performance optimization and operational efficiency.

Identify, troubleshoot, and resolve issues/backlogs related to slow/failed/abandoned Databricks processes & jobs in Dedicated SQL pools.

Document and advise developers and end-users about best practices and housekeeping.

Work on incidents/onboarding issues related to Pivoting to Cloud from on-prem data stores.

Participate Actively in Agile Scrum and Governance meetings to help develop user stories and resolve business requirements and functional specifications.

Assisting development teams and Business users to improve database designs and procedures on T-SQL best practices.

Gathering business requirements and designing, implementing multiple projects along with production support.

Performing Capacity planning of SQL server environment and providing recommendations to Management to sustain business growth.

Rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails, and adding new jobs (scripts).

Software and firmware maintenance of the Database storage servers in the Database machine including a routine health check, patching, and upgrades according to the suggestions from the SQL server support department.

Provided 24*7 Production Support.

Client: Genworth Financial

Location: Richmond, VA May 2020 – Oct 2021

Role: SQL Database Administrator

Responsibilities:

Working on Disaster Recovery (DR) processes including Database Mirroring & Log Shipping.

Administering SQL Server High Availability and Disaster Recovery strategies.

Working on the POC for Always On Availability group configuration, failover of availability group.

Setting up, managing, and maintaining Backups, Exports, Imports, and Recovery strategies on all databases.

Experience in Mirroring configuration, implementing, and maintaining standby databases on different platforms.

Participated and Performed in the annual DR Drill Activities.

Implementing Snapcenter as Backup and restoring tool for Disaster Recovery (DR) solution for all the environment.

Worked on the POC for Spotlight Enterprise – SQL server monitoring tool and Deployed on the PROD Servers.

OEM setup for Monitoring and Alerts Management.

Working on Server gateways for MSSQL, Oracle & DB2.

Migrating huge database from SQL Server 2014 to 2016.

Part of the Azure Cloud migration POC and Planning team.

Participate Actively in Agile scrums and Governance meetings to help develop user stories and resolve business requirements and Functional specifications.

Assisting development teams and Business users to improve database designs and procedures on T-SQL best practices.

Gathering business requirements and designing, implementing multiple projects along with production support.

Performing Capacity planning of SQL server environment and providing recommendations to Management to sustain business growth.

Documenting, creating POC on testing newer versions of Releases SQL server 2017, 2019.

Creating Standard operational procedure and templates.

Recovered a database which was completely decommissioned using backups.

Extensively worked on patching the SQL Server all over the company each quarter.

Establishing connectivity to databases and monitoring system performance.

Experience in databases applying patches, patch sets and critical patch updates.

Administering, maintaining, developing, implementing policies and procedures for ensuring the accessibility.

Successfully maintaining multiple databases.

Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.

Rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).

Software and firmware maintenance of the Database storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from SQL server support department.

Effective in on-site/offshore model and co-ordination. Very Good experience in working with Multiple vendor environment.

Provided 24*7 Production Support.

Environment: MS SQL Server Business Intelligence Development Studio 2012,2010,2008/2008R2, SSIS, SSAS, SSRS, XML, Oracle, SQL Server Management Studio, Azure, Spotlight 13.2, OEM 12c, 13c, SharePoint 2013, Snapcenter, Delphix, Imperva, ASP.NET, T-SQL, Tableau.

Client: First Republic

Location: San Francisco, CA February 2019 – May 2020

Role: SQL Database Administrator

Responsibilities:

Installed Configured, and Managed SQL Server 2016/2014/2012.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

Migrated SQL server 2008R2 to SQL Server 2017 in Microsoft Windows Server 2016 Enterprise Edition.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

Expert in implementing the snapshot isolation and DDL triggers.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Day-to-day administration of live production SQL Servers with monitoring and troubleshooting performance using DMVs, SQL activity monitor and SolarWinds.

Migrated SQL server Databases to SQL 2017 of PROD, DEV and UAT environments.

Experience in Always On Availability group configuration, failover of availability group and failover of availability group mirroring databases.

Worked extensively on Data Refreshes from Production to Test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups, and SQL Agent jobs without having any performance impact on Production server.

Performed Database Integrity Checks, Database Maintenance plans.

Performed Re-indexing, Rebuilding the indexes, Statistics updates, online indexing for better performance.

Work with offshore team to coordinate development work and operational support. Split up the tasks with offshore team and track them through JIRA tickets.

Environment: MS SQL Server Business Intelligence Development Studio 2012,2010,2008/2008R2, SSIS, SSAS, SSRS, XML, Oracle, MS Visual Studio, SQL Server Management Studio, SharePoint 2013, ASP.NET, T-SQL, Data Mining, Tableau.

Client: Premier Inc

Location: Pittsburg, PA May 2018 – December 2018

Role: SQL Database Administrator

Responsibilities:

Installed Configured, and Managed SQL Server 2014/2012 and applying service packs in both cluster and stand-alone environments.

Configured and Maintained Active/Passive Windows Failover Cluster with SQL Server 2014.

Configured and maintained Transactional replication and troubleshoot replication issues.

Configured and administered Always On Availability Group.

Designed and Deployed SSIS Packages to Export and Import Data from various Databases and Files.

Performed Database Backup and Point-In-Time Recovery solutions using SQL Server Client and also moved the SharePoint databases from one drive to other in production environment.

Managed security and permissions of SQL Server.

Involved in capacity planning and monitoring data/log files size, growth and disk space.

Created Database Objects like Stored Procedures, functions, Views, Triggers.

Managed index usage and fragmentation and updated statistics in databases and worked on reindexing column store indexes.

Involved in troubleshooting and fine-tuning database performance and concurrency and resolving connection timeout issues.

Worked with service Broker for auditing purposes.

Worked on Query optimization and tuning using Extended Events session, SQL Server Profiler, Database Engine Tuning advisor, and Activity Monitor and analyzing execution plan.

Checked Database Health by using DBCC Commands and DMVS.

Enforced Policy Based Management at Database Level as well as Table Level.

Translated business requirements into technical design specifications and actively supported business users for change requests.

Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL database.

Worked on Migration SQL upgrade projects and Migrated on premise databases to the cloud (Azure).

Worked on Creating POC for migrating the databases from on premise to Cloud (Azure).

Provided 24/7 on call support for all the Production Servers.

Worked on Windows Azure machine.

Used BCP utility inside SSIS packages to import and export bulk data across servers

Created a number of cubes, dimensions using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

Responsible for Bug fixing, Session monitoring, log analysis Implemented Various Data Transformations using Slowly Changing Dimensions.

Environment: SQL Server 2014,2012, 2008 R2/2008, Visual Studio 2008/2005, SQL Server Integration Services (SSIS), SSRS, Visual Studio .Net, C#, ASP.NET, .NET Framework 3.5, Toad

Client: Tata Communications

Location: Pune, India December 2014 - August 2017

Role: SQL Server DBA/Developer

Responsibilities:

Installing and Configuring Microsoft SQL Server enterprise edition on development, pre-production and production servers.

Monitoring and Performance Tuning of SQL Server, Operating System.

Implementing High Availability feature like Always ON, Log Shipping, Mirroring for Disaster Recovery.

Successfully implemented Always ON Availability group in SQL 2012 and installed SQL server in a cluster Environment.

Created several SQL Server objects like Tables, Views, Queries, Stored Procedures, Functions, triggers and Indexes.

Installed and the managed the active directory, Created the GPO's based on the requirements and placed them as an OU.

Created tables, views, stored procedure as per design needs.

Optimized queries tuned and monitored server performance.

Monitored performance and optimize SQL queries for maximum efficiency.

Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.

Optimized ETL Packages using various SSIS features at Control flow and Data flow level.

Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.

Administered and enhanced SQL Server Integration Services (SSIS) data loads.

Responsible for creating the reports basing on the requirements using SSRS 2008.

Performed Unit testing an Integration testing.

Identified the database tables for defining the queries for the reports.

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.

Defined the report layout in SSRS and generated drill down reports, parameterized reports.

Created SQL server Reports using SSRS 2005 while identifying the data source and defining them to build the DSV’s.

Used SSIS Control Flow items (for each Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all).

Converted various sql statements into stored procedures thereby reducing the number of database accesses.

Environment: MS SQL Server Management Studio 2008/2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Microsoft Visual Source Safe

Contact this candidate