MS SQL Server DBA
Resume:
PRAGNESH GOSWAMI
Senior MS SQL Server DBA
PROFESSIONAL SUMMARY:
Over 14+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008 and 2005 in Production, Test, UAT & Development Environments
Extensive experience in installation, configuration, and maintenance of MS SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008, and 2005
Expert in Upgrading/migrating databases from SQL server 2012/2008/2005 to SQL server 2022/2019/2017/2016/2014
Extensive experience in Data Mapping and Database migration/testing for SQL Server Environments
Experienced in working with production 24/7 Environment
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.
Extensive experience 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 HA/DR using Failover Clustering (A/A and A/P), Database Mirroring and Log shipping capabilities of MS SQL Server 2022/2019/2017/2016/2014/2012/2008/2005 to provide robust database solutions
Expert in implementing/installing Always ON functionality on SQL Server 2022/2019/2017/2016/2014/2012
Expert in supporting databases in Microsoft Azure Cloud (IAAS & PAAS)
4+ 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 and AWS (EC2 & RDS)
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
3+ years’ experience in PowerShell Scripting.
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 2022/2019/2017/2016/2014/2012/2008/2005 by creating logins, groups, Database Users, Roles and assigning proper permissions according to business requirements
Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP)
Team player with good communication, interpersonal and business analysis skills
TECHNICAL SKILLS:
MSSQL Server 2022/2019/2017/2016/2014/2012/2008/2005, Windows Server 2022/2019/2016/2012/2008, 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, TDE, Perl, Visual Basic, VB.Net, TOAD, SQL* Loader, PowerShell, Performance monitor (Perfmon), IDERA Diagnostic Manager, Apex SQL Monitoring Tools, AppDynamics, Foglight SQL Monitoring Tool, Red-Gate SQL Backup Tool, Lite Speed Backup Tool, VMWARE.
EDUCATION/CERTIFICATIONS:
Master of Business Administration, Johnson and Wales University, RI, USA 2009
Bachelor of Engineering, Gujarat University, Gujarat, India 2005
PROFESSIONAL EXPERIENCE:
Conduent Inc, Remote 03/2021 – Current
Sr. MS SQL Server DBA
Description: Conduent Inc. is an American business services provider company headquartered in Florham Park, New Jersey. It was formed in 2017 as a divestiture from Xerox. The company offers digital platforms for businesses and governments. As of 2025, it has over 53,000 employees working across 22 countries.
Responsibilities:
Managed and maintained 2000+ SQL servers in large-scale environments for DEV, TEST, UAT and PROD systems of SQL Server 2022/2019/2016/2014/2012 and 2008
Installed, configured and managed MS Azure and On-premise SQL Servers in Government Healthcare Services (GHS) environment
Configured Azure services PaaS/IaaS and migrated database from On-Premise to Microsoft Azure
Experience in creating and maintaining Azure SQL databases using the right tiers
Created and managed Azure SQL Database elastic pools
Performed day to day Database Maintenance tasks – Database monitoring, Backups, Space management, Resources Utilizations, Security access, Roles – Permissions on all SQL servers
Worked on Database maintenance, patching, and DR
Worked on PowerShell scripts for SQL server Monitoring and running backups.
Maintained Database Health by using DBCC Commands and DMVs
Implemented TDE encryption more than 1000+ SQL servers
Optimized critical queries resulting in a 20% performance improvement
Worked with developers to do the database schema changes and database restore requests
Experience in SQL Server instance Amazon Cloud - EC2
Running SQL Server in the Amazon Cloud - RDS Backup and Restore
Experience in SQL Server Amazon Cloud-RDS Monitoring and RDS Limitation
Experience in Migration from SQL Server to AWS and upgrading the platform to AWS
Designed and implemented Always ON availability groups for HA and DR solution (3 & 4 replicas)
Migrated/Upgraded databases from SQL Server 2008 R2/2012 to SQL Server 2017/2019
Created linked server in UAT and Production Environment
Implemented Transactional and Snapshot Replication on basis of business specification
Provided after-hours support for Production deployments
Experienced with database sizing and capacity planning for production servers
Participated in requirement gathering of existing database capacity, performance, security, scalability, etc.
Participated in an on-call rotation to provide 24/7 support and resolve critical database incidents
WELLS FARGO, CHARLOTTE, NC 10/2019 – 03/2021
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.
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.
Worked on Database encryption and Column level Encryption
Migrated/Upgraded databases from SQL Server 2012/2014 to SQL Server 2017/2019
Migrated data from enterprise-hosted databases to cloud-hosted data services like AWS (EC2 & RDS)
Migrated databases from On-Premise to Microsoft Azure (IAAS)
Managed and Administered databases in SCOM
Implemented AlwaysON availability groups for HA/HA – DR solutions
Implemented Snapshot Replication on basis of business specification
Experienced in troubleshooting production servers and fixed the user and application issues
Provided guidance on the optimal cloud design for database performance
Assisted developers with complex query tuning and schema refinement
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
Shared domain and technical expertise, providing technical mentorship and cross-training to peers and team members
CO-OP FINANCIAL SERVICES, DULUTH, GA 09/2018 – 09/2019
Sr. MS SQL Server DBA
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 servers 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 exclusively on Microsoft Azure for cloud-based implementation of SQL Server
Set up and Managed Auditing, alerts and monitoring in Azure environment
• Upgraded/Migrated databases from SQL Server 2008/2012 to SQL server 2014/2017 in PCI & Non-PCI environments
• Implemented and Supported databases in AlwaysOn availability groups for HA/DR environment
• 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
• 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
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.
Responsibilities:
Provided 24/7 support for Production environment on on-call basis
Installed, Configured and Maintained SQL Server 2017, 2016, 2014, and 2012 in PROD, UAT, DEV, and SIT environments
Configured and Maintained SQL Server Clustering
Implemented AlwaysON availability groups for 2 replicas
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/2012 to SQL Server 2014/2016/2017
Good experience with Database and Column level Encryption
Worked on TDE encryption
Created AWS Multi-Factor Authentication (MFA) for instance RDP/SSH logon, worked with teams to lock down security groups
Good experience with Azure Active Directory
Ensured the integrity and security and auditing the SQL Servers
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, UAT, DEV, and SIT environments
Created Linked Servers between SQL Server 2014, 2016, 2017 and Oracle databases
Managing security tasks like granting and revoking permissions
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
Installed SQL server 2016/2014/2012 instances on VMware server
Expert in using VMWARE Server
Performed side by side migration and followed both pre- and post-checklist for database migration
Migrated SQL Server Databases from SQL Server 2008/2008 R2 to 2012/2014/2016 on after hours as well as weekends
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
Implemented best practices for Database Monitoring, Backups and Restores
Used Lite speed backup tool for database backups and restores
Import data from different data source to create Power BI reports and dashboards
Created Power BI Visualizations and Dashboards as per the requirements
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
Planned, Implemented and Managed AlwaysON availability groups for HA/DR solutions
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
Implemented Database Mirroring with high-performance and high-safety mode
Configured and maintained Log Shipping for DR environment
Provided 24/7 support for Production environment
STANLEY BLACK AND DECKER, TOWSON, MD 04/2013 – 02/2015
Senior MS SQL Server DBA
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 are the result of the merger of Stanley works and Black & Decker on March 12, 2010.
Responsibilities:
Managed PRODUCTION database servers with 24/7 support and On-Call environment
Managed offshore team (3 resources) for migration project
Migrated multiple SQL Servers from SQL Server 2008/2008 R2 to 2012
Planned Database Migration steps, Mappings and Data transfer for migration of SQL Servers
Implemented and maintained MS SQL Server 2012 in Production, Dev, and Test environments
Implemented Database Mirroring on SQL Server 2012 for DR
Performed In-Place and Side by Side Migration/Upgrade of SQL Servers
Involved in developing stored procedures, triggers for the application
Installed SQL Server 2014 on windows server 2012 in Dev and Test environments
Maintained / managed database agent jobs, check for failures and resolve failure issues
Used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
Resolved performance related issues like Blocking, Deadlocks and long running queries
Worked on IDERA Diagnostic Manager tool for performance issues
Created, maintained the users, roles and granted appropriate privileges
WELLS FARGO, DES MOINES, IA 05/2012 - 03/2013
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’s headquarter is in San Francisco, California.
Responsibilities:
As a Production support DBA responsible for maintaining SQL Servers database servers in production, Development and QA Environments
Installed SQL Server 2012/2008 R2/2008 on windows server 2008 R2/2008 and applied service packs and security fix
Installed Active/Active and Active/Passive clustering to provide high availability solution for 6 different environments
Implemented Database Mirroring on SQL Server 2008 R2 server for DR/HA
Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR
Implemented and managed transactional replication for data refresh
Upgraded and Migrated databases from MS SQL Server 2005 to MS SQL Server 2008 R2/2012
Created the standard documents for Disaster recovery testing and implemented them
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
Extensively worked on SSIS for data manipulation and data extraction, ETL Load
Created the backup schedule for production, test and development servers
WOLTERS KLUWER, WICHITA, KS 12/2010 - 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.
Responsibilities:
Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments
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
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
Configured snapshot and transactional replications
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
Involved in setting up database mirroring for production server
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
Contact this candidate