Post Job Free

Resume

Sign in

MS SQL DBA

Location:
Duluth, GA, 30096
Posted:
January 25, 2021

Contact this candidate

Resume:

PRAGNESH GOSWAMI

Senior MS SQL Server DBA

SUMMARY:

Over 10+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008, 2005 and 2000 in Production, Test, UAT & Development Environments

Extensive experience in installation, configuration, and maintenance of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008, 2005, and 2000

Expert in Upgrading and migrating from SQL server 2012/2008/2005/2000 to SQL server 2019/2017/2016/2014/2012

Extensive experience in Data Mapping and Database migration/testing for SQL Server Environments

Experienced in working with production 24/7 Environment

Expert working in Virtual Environment using VMWARE for SQL Server

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support

Published Power BI reports from Power BI desktop to Power BI service

Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection

Extensive experience in working in OLTP, OLAP, PCI, Non-PCI and SOX environments

Experienced in working of Client/Server and Web based applications using Visual Basic 6.0, ASP, ASP.NET (1.1/2.0/3.5), ADO.ENT, C#, VB.NET, and Web Services.

Experience with SAP Application support while maintaining and administering SQL databases

Experienced in Database Backup, Recovery and Disaster Recovery procedures.

Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification

Extensive experience in Maintaining High Availability using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2019/2017/2016/2014/2012/2008/2005 to provide robust database solutions

Experience in PowerShell Scripting.

Expert in supporting databases in Microsoft Azure Cloud (IAAS & PAAS)

3+ years of experience for managing and maintaining databases in Cloud based systems (Azure/AWS)

Expert in implementing/installing/configuring and migrating SQL Server to Microsoft Azure

Implemented Always ON functionality on SQL Server 2017/2016/2014/2012

Expert in Active/Passive and Active/Active Clustering

Expert in implementing Log shipping and Mirroring for HA and DR

Expert in Performance tuning using SQL Server DMV's

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities

Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.

Expert in Active Directory / SQL based Security of SQL Server 2019/2017/2016/2014/2012/2008/2005 by creating logins, groups, Database Users, Roles and assigning proper permissions according to business requirements

Experience in creating roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks

Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP)

Experience with Reporting Services (SSRS) and Analysis Services (SSAS)

Created maintenance plans to perform index defragmentation, re-indexing and update Statistics

Team player with Good communication, interpersonal and business analysis skills

TECHNICAL SKILLS:

MSSQL Server 2019/2017/2016/2014/2012/2008R2/2008/2005/2000, Windows Server 2019/2016/2012/2008/2003/2000, DTS, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), Microsoft AZURE, Amazon Web Services (AWS), Amazon Redshift, OLAP Tools, SQL, Perl, Visual Basic, VB.Net, TOAD, SQL* Loader, IDERA Diagnostic Manager, Apex SQL Monitoring Tools, Foglight SQL Monitoring Tool, Red-Gate SQL Backup Tool, Lite Speed Backup Tool, VMWARE.

EDUCATION/CERTIFICATIONS:

Bachelor of Engineering, Gujarat, India

PROFESSIONAL EXPERIENCE:

WELLS FARGO, CHARLOTTE, NC 10/2019 – Present

Sr. MS SQL Server DBA

Description: Wells Fargo & Co. is an American multinational financial services company headquartered in San Francisco, California, with managerial offices throughout the United States and Overseas. It is the world's fourth-largest bank by market capitalization and the fourth largest bank in the U.S. by total assets. Along with JPMorgan Chase, Bank of America, and Citigroup, Wells Fargo is one of the "Big Four Banks" of the United States. As of June 2018, it had 8050 branches and more than 13,000 ATMs. The company operates across 35 countries and has over 70 million customers globally.

Responsibilities:

Managed SQL server databases through multiple product life cycle environments, from Development to Mission-Critical Production systems of SQL Server 2019/2017/2016/2014/ and 2012

Configured and Maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security

Provided 24x7 supports for Critical Production systems.

Databases created and maintained in shared farm servers and dedicated servers

Good experience with Database and Column level Encryption

Worked on Database encryption

Implemented Transactional and Snapshot Replication on basis of business specification

Migrated/Upgraded databases from SQL Server 2012/2014 to SQL Server 2016/2017/ and 2019

Migrated data from enterprise-hosted databases to cloud-hosted data services like AWS RDS

Migrated databases from On-Premise to Microsoft Azure (IAAS).

Managing Database, Azure Data Platform services (Azure Data Lake (ADLS), Data Factory (ADF)

Developed database migration documentation (playbooks)

Participated in requirement gathering of existing database capacity, performance, security, scalability, etc.

Provided guidance on the optimal cloud design for database performance

Assisted developers with complex query tuning and schema refinement

Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code

Created automated daily and weekly system maintenance tasks such as database backup, database integrity, and database indexing

Experience in implementing hybrid connectivity between Azure and on - premise using virtual networks and VPN

Participated in regular Business continuity planning (BCP) activity for various applications

Maintained change control and release management process for all database objects like tables, views, procedures, and triggers

Performed scheduled maintenance and Supported release deployment activities after hours

Environment: MS SQL Server 2019/2017/2016/2014/2012, SSIS, SSRS, SSAS, Windows Server 2019/2016/2012/2008, Clustering, Mirroring, Replication, Log Shipping, AlwaysON, Foglight monitoring tool, Lite Speed Backup Tool, VMWARE.

CO-OP FINANCIAL SERVICES, DULUTH, GA 09/2018 – 09/2019

Sr. MS SQL Server DBA/Database Analyst

Description: CO-OP Financial Services, formerly known as CO-OP Network, which is also known as CU Cooperative Systems, Inc., is a company that operates an interbank network connecting the ATMs of credit unions in the United States, with locations also in Canada and certain United States Navy bases overseas. It is the largest credit union-owned interbank network in the US. It is headquartered in Rancho Cucamonga, California.

Responsibilities:

Managed PRODUCTION database server with 24/7 Support and On-Call environment

Worked on managing 200+ SQL Server Instances in Production/Dev/Beta and Cloud based environment

Day to day Production support including checking daily logs, daily failed jobs, backup/recovery procedures, periodic maintenance

Worked on Database maintenance, patching, and DR

Maintained Database Health by using DBCC Commands and DMVs

• Worked exclusively on Microsoft Azure for cloud-based implementation of SQL Server

Set up and Managed Auditing, alerts and monitoring in Azure environment

• Migrated databases from On-Premise to Microsoft Azure (IAAS)

• Upgraded/Migrated databases from SQL Server 2008 R2/2012 to SQL server 2016/2017 in PCI and Non-PCI environments

• Implemented and Supported databases in AlwaysOn availability groups for HA/DR environment (3 Replicas)

• Migrated application code and objects from Development/Test environments to Production

• Created and Managed Database(s) on Microsoft AZURE

• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers

• Extensively worked with developers to push out builds and releases in Production/Test environments.

• Provided solution to developers to make their queries faster

• Extensive used of DMV’s and wait types to analyze performance bottlenecks and give resolution

• Used third party tools like IDERA Diagnostic Manager for performance issue

• Maintained Log Shipping for DR environment

• Used Red-gate tool to monitor SQL servers and Lite speed backup tool for database backups and restores

• Worked on Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)

• Extensive knowledge and experience of SQL Security

Created Users, Logins, Roles and granted appropriate permissions

Removed personal IDs for PCI compliance from the Production and Test environments

Environment: MS SQL Server 2017/2016/2014/2012/2008R2, SSIS, SSRS, SSAS, Windows Server 2016/2012R2/2012/2008 R2/2008, Clustering, Log Shipping, AlwaysON, Microsoft AZURE, Red-gate Monitoring Tool, Lite Speed Backup Tool, VMWARE.

WELLS FARGO, CHARLOTTE, NC 06/2017 – 08/2018

Senior MS SQL Server DBA

Description: Wells Fargo & Co. is an American multinational financial services company headquartered in San Francisco, California, with central offices throughout the country. It is the world's third largest bank by market capitalization and the third largest bank in the U.S. by total assets. Wells Fargo remains the second largest bank in home mortgage servicing and debit cards. Along with JPMorgan Chase, Bank of America, and Citigroup, Wells Fargo is one of the "Big Four Banks" of the United States. In 2017, it had more than 8000 retail financial centers and more than 15,000 ATMs. The company operates across 35 countries and has over 70 million customers globally.

Responsibilities:

Provided 24/7 support for Production environment on on-call basis

Installed, Configured and Maintained SQL Server 2016, 2014, and 2012 in PROD, PFIX, UAT, DEV, and SIT environment

Configured and Maintained SQL Server Clustering

Implemented AlwaysON availability groups for 2 replicas

Configured and maintained Log Shipping for DR environment

Experience in implementing Transactional Replication on basis of business specification

Databases created and maintained in shared farm servers and dedicated servers

Used Lite speed backup tool and Native backup tool for database backups and restores

Migrated/Upgraded databases from SQL Server 2008R2 to SQL Server 2016 and 2014

Migrated databases from On-Premise to Microsoft Azure (IAAS)

Good experience with Database and Column level Encryption

Worked on TDE encryption

Good experience with Azure Active Directory

Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment.

Ensured the integrity and security and auditing the SQL Servers

Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries

Used SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code

Created automated daily and weekly system maintenance tasks such as database backup, database integrity, and database indexing

Participated in regular Business continuity planning (BCP) activity for various applications

Configured SQL Servers with appropriate settings to resolve various resource allocation & memory issues and disk I/O issues, created baselines stats

Managed capacity planning and implement database security for multiple instances of PROD, PFIX, UAT, DEV, and SIT environments

Maintained change control and release management process for all database objects like tables, views, procedures, and triggers

Created Linked Servers between SQL Server 2012, 2014, 2016 and Oracle databases

Managing security tasks like granting and revoking permissions

Environment: MS SQL Server 2016/2014/2012/2008R2, SSIS, SSRS, SSAS, Windows Server 2012R2/2012/2008 R2/2008, Clustering, Mirroring, Replication, Log Shipping, AlwaysON, Foglight monitoring tool, Lite Speed Backup Tool, VMWARE.

CHEVRON CORPORATION, SAN RAMON, CA 03/2015 - 05/2017

Senior MS SQL Server DBA

Description: Chevron Corporation is an American multinational energy corporation, headquartered in San Ramon, California, and active in more than 180 countries. Chevron is engaged in every aspect of the oil, natural gas, and geothermal energy industries, including hydrocarbon exploration and production; refining, marketing and transport; chemical manufacturing and sales; and power generation. Chevron is one of the world’s largest oil companies.

Responsibilities:

Worked as a Production DBA with primary database comprising of SQL Server 2016/2014/2012/2008R2/2008/2005

Performed side by side migration and followed both pre- and post-checklist for database migration

Migrated SQL Server Databases from SQL Server 2005/2008 to 2008R2/2012/2014/2016 on working hours as well as weekends

Installed SQL server 2016/2014/2012 instances on VMware server

Expert in using VMWARE Server

Migrated all databases and servers from San Ramon data center to San Antonio data center

Working knowledge of Double Take SQL migration tool

Migrated SSIS packages from SQL Server 2008R2 to SQL Server 2012

Resolved all migration related issues after the databases migration and created database maintenance plan for the performance of SQL Server which covers Database Integrity Checks, Update Statistics, and Re-indexing

Implemented best practices for Database Monitoring, Backups and Restores

Used Lite speed backup tool for database backups and restores

Configured linked servers to enable the SQL Server Database Engine to execute commands against OLE DB data sources of the instance of SQL Server

Import data from different data source to create Power BI reports and dashboards

Created Power BI Visualizations and Dashboards as per the requirements

Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance

Used various Transformations in SSIS Dataflow, Control Flow using for Loop Containers and Fuzzy Lookups

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

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

Wrote ad-hoc T-SQL queries for data analyzing, research, unit testing and identifying and resolving bugs

Created database Objects like Tables, Stored Procedures, Views, Triggers, and user defined data types and functions for this project

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

Planned and Implemented AlwaysON availability groups for 3 replicas

Documented and managed AlwaysON availability groups

Involved in designing cloud deployment strategies that mitigate risk while meeting infrastructure

Responsible for designing and implementing cloud –based solutions

Planned and Implemented SQL Server in Microsoft Azure and Cloud based systems

Installed, configured, and managed the AWS cloud servers

Created AWS Multi-Factor Authentication (MFA) for instance RDP/SSH logon, worked with teams to lock down security groups

Implemented Database Mirroring with high-performance and high-safety mode

Configured and maintained Log Shipping for DR environment

Experience in implementing different types of Replication models like Snapshot, Merge and Transactional on basis of business specification

Created Users, Logins, Roles and granted appropriate permissions

Performed SQL DBA activities on mission critical SQL Databases on which SAP ECC 6.0 was hosted

Maintained SOX compliance

Provided 24/7 support for Production environment

Environment: MS SQL Server 2016/2014/2012/2008R2/2008/2005, SSIS, SSRS, SSAS, Windows Server 2012R2/2012/2008 R2/2008/2003, AlwaysON, Microsoft AZURE, AWS, IDERA Diagnostic Manager, Lite Speed Backup Tool, VMWARE.

STANLEY BLACK AND DECKER, TOWSON, MD 04/2013 – 02/2015

Senior MS SQL Server DBA/Team Lead

Description: Stanley Black and Decker, Inc. formerly known as the Stanley Works, is a fortune 500 American manufacture of industrial tools and household hardware and provider of security products and locks. Stanley Black and Decker are headquartered in New Britain, Connecticut. Stanley Black and Decker is the result of the merger of Stanley works and Black & Decker on March 12, 2010.

Responsibilities:

Managed PRODUCTION database server with 24/7 support and On-Call environment

As a Production support DBA Managed Multiple SQL Servers in Production, Development and QA Environment

Managed offshore team (3 resources) for migration project

Migrated multiple SQL Servers from SQL Server 2000 to 2008 R2 and 2005/2008 R2 to 2012

Planned Database Migration steps, Mappings and Data transfer for migration of SQL Servers

Implemented Database Mirroring on SQL Server 2008 R2 for DR/HA

Did heavy duty In-Place and Side by Side Migration/Upgrade of SQL Servers

Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for production environments

Involved in developing stored procedures, triggers for the application

Created linked server in Production, Development, and QA Environment

Installed SQL Server 2014 on windows server 2012 in Dev and Test environments

Mapped Data from various sources to SQL Server Destinations

Implemented and maintained MS SQL Server 2012 in Production, Dev, and Test environments

Monitored and scheduled jobs on Production, Development, and QA servers

Managed Database backup and restore in Production, Development, and QA environment

Maintained / managed database agent jobs, check for failures and resolve failure issues

Used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries

Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans

Resolved performance related issues like Blocking, Deadlocks and long running queries

Experienced with improving SQL Server using windows performance monitor to improve the server performance

Designed robust stored procedure for business continuity

Analyzed existing stored procedure, queries, views and processes for performance bottlenecks

Deployed SSIS packages to MSDB database and file system in SQL Server 2008 and 2008 R2

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)

Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS

Created SSIS packages for Data Mapping and Data Transfer between sources

An exclusive experience working with User Controls with VB.NET code-behind files, debugging and Quality Testing of the code

Worked on IDERA Diagnostic Manager tool for performance issues

Experienced in troubleshooting production servers and fixed the user and application issues

Created, maintained the users, roles and granted appropriate privileges

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2012/2008 R2/2008/2003, IDERA Diagnostic Manager, Red-Gate SQL Backup Tool, VB.Net, VMWare SQL Servers.

WELLS FARGO, DES MOINES, IA 05/2012 - 03/2013

Senior MS SQL Server DBA

Description: Wells Fargo & Co. is an American multinational diversified financial services company with operations around the world. Wells Fargo is the 4th largest bank in the U.S. by assets and the largest bank by market capitalization. Wells Fargo is the 2nd largest bank in deposits, home mortgage servicing, and debit cards. Wells Fargo’s headquarter is in San Francisco, California. In 2012, Wells Fargo had more than 9,000 retail branches and 12,198 ATMs in 39 states and the District of Columbia. It has over 270,000 employees and over 70 million customers.

Responsibilities:

As a Production and development support DBA responsible for maintaining SQL Servers database servers in production, Development and QA Environments

Installed SQL Server 2012, SQL Server 2008 R2 and SQL Server 2008 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers

Implemented Failover clustering for Active/Active and Active/Passive for HA

Managed SQL Server Clusters in a SAN environment

Implemented Database Mirroring on SQL Server 2008 R2 environments for DR/HA

Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR

Implemented transactional replication for data refresh

Managed and Administered databases in SCOM

Managed all Publisher, Distributor and Subscriber database environments for the replication

Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries

Upgraded server from MS SQL Server 2000/2005 to MS SQL Server 2008 R2/2012

Mapped Data for Data Transfer and Data Migration

Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments

Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans

Created the standard documents for Disaster recovery testing and implemented them

Experienced with database sizing and capacity planning for production servers

Experienced with creating logical and physical database design for development projects

Experienced with improving SQL Server using windows performance monitor to improve the server performance

Created SSIS packages to import the data from MS Access and Oracle server to SQL Servers

Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)

Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups

Used containers for repetitive control flow tasks

Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS

Extensively worked on SSIS for data manipulation and data extraction, ETL Load

Created extensive reports using SSRS (Tabular, Matrix)

Created the backup schedule for production, test and development servers

Worked with developers to do the database schema changes and database restore requests

Involved in restore operations to refresh the data from production to test servers

Experienced in troubleshooting production servers and fixed the user and application issues

Environment: MS SQL Server 2012/2008 R2/2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2012/2008 R2/ 2008/2003.

WOLTERS KLUWER, WICHITA, KS 10/2009 - 04/2012

MS SQL Server DBA

Description: Wolters Kluwer N.V. is a global information services and publishing company. The company provides products and services for professionals in the health, tax, accounting, corporates, and financial services, legal and regulatory sectors. Wolters Kluwer has annual revenues (2011) of €3.4 billion, employs approximately 18,000 people worldwide and maintains operations across Europe, North America, Asia Pacific and Latin America. Wolters Kluwer is headquartered in Alphen aan den Rijn, Netherlands.

Responsibilities:

Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack

Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008 R2

Interacted with Developers in troubleshooting application and database issues

Identified, tested and resolved database performance issues to ensure data optimization

Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks

Implementation of system wide security policies and trouble shooting

Involved in installing SQL Server 2008/2008 R2 on Development, Production and WTC (Testing) machines

Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication

Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server

Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)

Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2

Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool

Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa

Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008

Documented all the steps and procedures for future references

Created performance baseline reports using RML tool and documented for future use

Involved in setting up database mirroring for production server

Configured snapshot and transactional replications

Monitoring and scheduled jobs on production and staging environment

Responsible in Monitoring and Troubleshooting SQL Server Performance issues

Used the Execution Plan to improve the optimization of the T-SQL code

Provided 24 x 7 Production support for the database and application issues

Environment: MS SQL Server 2008 R2/2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2/2008/ 2003.



Contact this candidate