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.