SR SQL DBA

ANUP SHAH

Senior MS SQL Server DBA

Summary of Qualifications:

Senior MS SQL Server DBA with Extensive knowledge in Managing SQL Server environment

10+ years of IT experience with Database Administration on MS SQL SERVER 2017/2016/2014/2012/2008R2/2008/2005 in Production, Development and Testing Environments.

Hands-on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2017/2016/2014/2012/2008 R2/2008/2005 on Windows 2008/2003/2000.

Worked on Physical, Virtual infrastructures Environment.

Worked on Unix/Linux and Windows based Operating system.

Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Cloud/Web based applications

Expert in implementing/installing/configuring/migrating and supporting SQL Server to Microsoft Azure and AWS- Amazon Web Services (cloud-based environments)

Maintained databases with sizes ranging from Large to Very Large Databases (30 terabytes).

Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.

Expertise in Data Migration from MS SQL server 2000/2005/2008 to 2016/2014/2012/2008 R2.

Expert in design and setup HA & DR technology.

Implemented Always On Distributed availability groups, Listener and replicas for reporting, backup and performance.

Expert in Installing and configuring SQL Server Cluster in Active/Passive and Active/Active environments.

Implemented Sync and Async MIRRORING for Disaster Recovery Implementation

Experience in implementing different types of Replication topologies involving Snapshot, and Transactional replication.

Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies

Extensive experience in developing SQL Stored Procedures, Views, Triggers, and Complex Queries

Automated Database Consistency Checks (DBCC), Fragmentation checks and Index Reorganization/Rebuilding Operations.

Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Normalization, Indexes etc.

Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's, and SQL Query Analyzer and performed Query Optimization.

Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services) and SSAS (SQL Server Analytical Services).

Schedule and monitored batch jobs using Tidal, Autosys, SSIS.

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

Strong working experience with Oracle database administrator tasks

Diverse background with fast learning skills and creative analytical skills.

Support productions activities during extended hours and weekends.

Technical Competencies:

Operating Systems: Windows 2012/2008 R2/2003, Windows 7/8 Professional

RDBMS: SQL Server 2017/2016/2014/2012/2008 R2/2008/2005/2000, MS Access, Oracle

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, BIDS, SSIS, Always On

Web Technologies: XML, HTML, JAVA Script

Languages: T-SQL, C, JAVA

Reporting Tools: SQL Server Reporting Services, Crystal Reports, Power BI, Ad-hoc

Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.

Networking TCP/IP, Named Pipes, VIA

Other Tools: Lite Speed, Erwin, Test Director, Varalogix-Q, Idera Diagnostic Manager, Foglight, PowerShell

Professional Experience:

Client: MUFG Bank, Exchange Place, NJ May 2019 – Feb-2020

Role: Senior MSSQL Server DBA

Industry: Banking

The main role is to manage and support to mission critical AML (Anti Money Laundering), Transaction monitoring, CDL, KYCR, N-tier dashboard which relates to the data-warehouse.

Responsibilities:

Installed, Patched, Maintained, and Upgraded MSSQL Severs Server 2017,2016, 2014, 2012 on windows 2012, 2008 and 2003 servers and monitoring tools.

Decommissioned 2008 R2, 2008 and SQL Server 2005 SQL servers and Application servers

In- depth analysis for AML – Actimize database growth and archived historical data for better performance

Monitor batch processing and job status using Tidal Scheduler.

Participated to Installation and configurations of DevOps tools for Developers and Operation teams to integrate the system by providing DBA support.

Worked exclusively on Microsoft Azure and Amazon AWS on premise for cloud-based implementation of SQL Server

Migrated Databases on MS Azure platforms.

Manage a reliable database management plan, including performance tuning, monitoring, backup and recovery, replication strategies, etc.

Worked on Compression and partition of the very large AML- actimize database (30 TBs).

Verify Daily Backup Latency Report from different SQL servers.

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

Automate notifications when SQL databases experience an unexpected outage. Also, configured available toolsets to automate proactive notification when defined thresholds are reached. Responded to alerts messages from all levels of the Database.

Worked closely with Identity Access Operation team to design & manage AD level groups and permissions.

Created Linked Servers between SQL servers 2008R2/2012/2014 as per developer's request.

Experienced in performance enhancement for Data Warehouse processes as well as slow running queries and troubleshoot ETL jobs for ingesting data from various sources.

Perform Data analysis from importing different sources (Flat/XML/CSV/XLS files) and validate with reference tables.

Analyzed and investigate an CDL application related issues and participate with Development team to resolve it.

Worked with Oracle DBAs to support and resolve remedy tickets.

Conduct end-to-end analysis that includes data gathering and requirements specification, analysis, ongoing scaled deliverables and presentations

Interacting with development, Release Engineer and App support teams to implement new production changes and patches.

Worked closely with Change Management Team and Developers using TFS and other source control tools for deploying code versions from Development to Productions environments.

Automated daily DB refresh task through PowerShell.

Environment: Windows 2012/2008 R2/2003/2000 Server, UNIX/Linux, MS SQL Server 2016/2014/2012,2008 R2,MS Azure, AWS, Always On, T-SQL, SSMA, TSM Tape backup, DTS, SSIS, SSRS, Power BI, MS Office 2013 suite- Excel,, Performance Monitor, SQL Profiler, Oracle 10g.

Client: BNY Mellon, NYC, NY Nov 2018 –April 2019

Role: Senior MS SQL Server DBA

Industry: Banking\Financial Services

The Greenfield project is mainly involved with Datacenter Migration activities. Primary role is to review existing architectural designs of HA/DR and suggest new designs to mission critical applications.

Responsibilities:

Managed 300+ Production SQL Servers in Virtual and Physical Environments.

Installed, configured, and migrated SQL Server 2016,2014, 2012, 2008 R2 and SQL Server 2005 on windows 2012, 2008 and 2003 servers, applied service packs and security fix for all servers.

Involved in development activities including hardware installation and configuration, and participation in database design, architecture, and SQL scripting.

Provided status report of ongoing waves in daily kick-off meeting with CIO

Participated in the project of data center migration from 2008R2/2012/2014 to 2016.

Participated to integrate the system for automation end to end provisioning.

Worked closely with DB infrastructure team to maintain a reliable database management plan, including performance tuning, monitoring, backup and recovery, replication strategies, etc.

Troubleshoot and re-configured Always ON Distributed Availability groups with listeners.

Performed system and network monitoring, batch processing and job completion, problem escalation and resolution, and other routine tasks using Unix and Windows operating systems.

Used SQL queries (SQL Joins) and performed data Analysis using MS Excel VLOOKUP.

Interacting with development, Release Engineer and App support teams to implement new production changes and patches.

Prepared RCA- (Root cause Analysis) report documented and shared with team on SharePoint folder.

Determined service level requirements, analyzed current capacity, and planned Capacity Planning.

Grab the Data from DBAR Master excel sheet and filter and validate as per the Waves for Datacenters Migration.

Support and resolve JIRA tickets for operational issues during migration process.

Environment: Windows 2012/2008 R2/2003/2000 Server, MS SQL Server 2016/2014/2012,2008 R2, T-SQL, SSMS, Oracle RAC, MS Office tools- Excel, PowerPoint, Word, SSIS, SSRS, SSAS, Lightspeed

Client: Bank of Tokyo\MUFG Bank, Exchange Place, NJ June 2017 – Oct-2018

Role: Senior MS SQL Server DBA

Industry: Banking\Financial Services

The main role is to manage and support to mission critical AML – actimize databases which relates to the data-warehouse.

Responsibilities:

Installed, Patched, Maintained, and Upgraded MSSQL Severs Server 2016, 2014, 2012, 2008 R2 and SQL Server 2005 on windows 2012, 2008 and 2003 servers and monitoring tools.

Setup and Monitored backups, implement and test recovery techniques. Diagnosed and corrected performance problems long running backup jobs.

Responsible for communicating with senior managers, members of the Business and other AML monitoring units to ensure findings are incorporated in all aspects of the AML program

Monitor batch processing and job status using Tidal Scheduler.

Investigate and performed RCA- (Root cause Analysis) for slow running batches of actimize databases and provided best solution.

Participated to Installation and configurations of DevOps tools for Developers and Operation teams to integrate the system.

Worked exclusively on Microsoft Azure and Amazon AWS for cloud-based implementation of SQL Server

Worked on AWS SQL databases for App migration into private cloud.

Worked on AWS Database Migration Services for migrating data from MS SQL to RDS.

Worked on converting schema from one DB engine to AWS RDS using AWS Schema Conversion Tool (SCT).

Hands on experience in encrypting data using AWS Key Management Service (KMS).

Hands on experience of AWS high availability using Multi-Availability Zone (Multi-AZ) deployments

Manage a reliable database management plan, including performance tuning, monitoring, backup and recovery, replication strategies, etc.

Extensively used SSMA- (SQL Server Migration Assistant) tool for migrating Sybase ASE databases to SQL Server 2016.

Manual and Automate Data refresh from Prod to Non-prod environments as per developer’s request

Participated in Compression and partition of the very large AML- actimize database (30 terabytes).

Verify Daily Backup Latency Report from different SQL servers.

Automate notifications when SQL databases experience an unexpected outage. Also, configured available toolsets to automate proactive notification when defined thresholds are reached. Responded to alerts messages from all levels of the Database.

Worked closely with Identity Access Operation team to design & manage AD level groups and permissions.

Created Linked Servers between SQL servers 2008R2/2012/2014 as per developer's request.

Experienced in performance enhancement for Data Warehouse processes as well as slow running queries

Perform Data analysis from importing different sources (Flat/XML/CSV/XLS files) and validate with reference tables.

Analyzed and investigate an CDL application related issues and participate with Development team to resolve it.

Worked with Oracle DBAs to support and resolve remedy tickets.

Set up traces and Profiler to fix performance issues.

Analyzed deadlocks & blocking on the server.

Fixed problems related to memory, CPU, I/O, Disk, etc.

Automated daily DB refresh task through PowerShell.

Interacting with development, Release Engineer and App support teams to implement new production changes and patches.

Prepared Process Documents and share the knowledge with Off-shore Team.

Extensively participated in DR Test.

Environment: Windows 2012/2008 R2/2003/2000 Server, UNIX/Linux, MS SQL Server 2016/2014/2012,2008 R2,MS Azure, AWS, Always On, T-SQL, SSMA, TSM Tape backup, DTS, SSIS, SSRS, SSAS, Power BI, MS Office 2013 suite- Excel,, Performance Monitor, SQL Profiler, Oracle 10g, AWS RDS

Client: Mizuho Bank, Exchange Place, NJ June 2016 – June 2017

Role: Senior MS SQL Server DBA

Industry: Banking\Finance

Primary role is to manage and support their critical application which communicate with IRS system and send all financial reports as per FACTA.

Responsibilities:

Build Database environment in Development, Integration, QA, Performance and Production environment based on project requirement and company’s best practices.

Highly skilled in implementing and managing High Availability Environments like Clustering, Mirroring, Log Shipping and Replication Environment.

Expert in create, manage and documentation of database solutions based on business requirement.

Set up and configured Database mirroring for Disaster Recovery as well as for stand by solutions. Experienced troubleshooting mirroring environment.

Experienced in handling large databases up to 25 terabytes in size.

Using Excel pivot tables to manipulate large amounts of data in order to perform data analysis

Migrated and Upgraded SQL Servers 2005/2008 to 2014/2012 from Windows 2008 servers to new servers using Windows server 2012 and Always-On Availability Groups

Analyze, mapped and documented source to destination requirements and process of migration for Sybase ASE databases to SQL Server.

Migrated Sybase ASE database to SQL Server 2012/2014 using SSMA tool by converting schemas, tables, data etc.

Enforced Cyber Security for databases and involved in documentation to provide risk based solutions.

Experienced in managing PII (Personal Identifiable Information) data in all environment.

Expert in troubleshooting production problems using DMV’s, SQL Server Native tools as well as Third Party tools like SQL Sentry Performance Advisor.

Analyzed T-SQL queries and guided developers.

Created automated solutions using T-SQL and PowerShell for Backup/Recovery, security, Data refresh etc.

Routinely check and applied Service Packs as well as developed Pre-Checklists for new servers to apply latest service packs.

Participated in routine Power-down and Disaster Recovery tests and failovers. Documented and managed lesson learned to make future failover even smoother.

Managed codes/scripts from Code repository and executed as per planned releases.

Greatly reduced slow running Queries by proper indexing and updating statistics.

Experienced in deploying and managing SSIS packages using Catalog database and its security.

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

Environment: Windows 2012/2008 R2/2003/2000 Server, MS SQL Server 2016/2014/2012,2008 R2,MS Azure,AWS, Always On, T-SQL, Visual Studio, Fog light, NetApp Backup, DTS, SSIS, SSRS, SSAS, Power BI, PowerShell, Performance Monitor, SQL Profiler, SQL Idera

Client: Barclays Capital, Piscataway, NJ Feb 2014 – May 2016

Role: Senior MS SQL Server DBA

Industry: Finance

The role is to manage multiple SQL Servers in Production environments, support all major SQL Servers in Physical/Virtual environment and support clustered, mirrored and replicated environments. The role also was to support developers in builds and releases and troubleshoot major production issues on IB & Wealth Management Systems.

Responsibilities:

Managed 100+ Production SQL Servers in Virtual and Physical Environments.

Installed, configured and migrated SQL Server 2014, 2012, 2008 R2 and SQL Server 2005 on windows 2012, 2008 and 2003 servers, applied service packs and security fix for all servers.

Involved in development activities including hardware installation and configuration, and participation in database design, architecture and SQL scripting.

Participated in setting up DR and HA with SQL Server CLUSTERING, MIRRORING and LOG SHIPPING

Installed SQL Server 2012 Cluster and configured 'Always On' availability group set up on Windows Server 2012 in Development & SIT environments.

Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.

Managed all Publisher, Distributor and Subscriber database environments for the replication and Implemented transactional replication for data refresh

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

Supported SQL Server environment in OLTP and DSS systems

Managed multiple SQL Server instances in Active/Active and Active/Passive clusters

Installed and configured Async and Sync Mirroring for Production and DR environments

Setup Log Shipping for production databases to carry out DR and failover

Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Automated daily database refreshes using Power shell from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2012/2008.

Created the DTS, 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) and performed Data analysis.

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

Used extensive SQL Server DMV's for Performance of Worst performing Queries and System Monitoring

Troubleshooted and improved performance of SSIS packages.

Used DMV’s for finding Index Fragmentation and Worst performing Queries

Used Various different Transformation in SSIS for ETL packages

Created extensive reports using SSRS (Tabular, Matrix)

Segregate CIF (Customer Information) data, analyzed and prepared reports using Tablue tool.

Performance tuning, and optimization of procedures and queries.

Worked hand in Hand with developers to carry out builds and releases.

Environment: Windows 2012/2008 R2/2003/2000 Server, MS SQL Server 2014/2012,2008 R2, AlwaysOn, Business Intelligence Development Studio (BIDS), T-SQL, SSMA, DTS, SSIS, SSRS, SSAS, Tableau, PowerShell, Performance Monitor, SQL Profiler

Client: Marsh & McLennan, HOBOKEN, NJ Jan 2011 – Nov 2013

Role: Senior MS SQL Server DBA

Industry: Finance

Primary responsibility was to interact with developers and carry out migration, build/releases, give level I support and support major performance related issues on SQL Server. The role also was to develop extensive SSIS/SSRS packages for ETL and daily maintenance

Environment: Windows 2008 R2/2003 Server, MS SQL Server 2012/2008R2/2005, Business Intelligence Development Studio, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manger and other IDera tools, DTS, SSIS, SSRS, Performance Monitor, SQL Profiler

Client: PNC BANK, PITTSBURGH, PA Nov 2008 – Oct 2010

Role: SQL Server DBA

Industry: Banking/Finance

The role was more of fine tuning performance related issues and supporting SQL Server environments. Resolving user issues related to performance. The role was also to create SSIS packages for various different ETL tasks

Environment: Windows Server 2003, Microsoft SQL Server 2008/2005/2000, T-SQL, Business Intelligence Development Studio, Database engine tuning Advisor, SSIS, SSRS, BCP, SQL Profiler, MS Office tools 2007/2010- Word, Excel, PowerPoint

Client: HCL Info systems, Gujarat, India Oct 2007 - Jun 2008

Role: Jr. SQL Server DBA

Industry: Finance

Managed SQL Servers for the retail division, did major migration of sql servers from lower version to higher version.

Environment: Windows Server 2003, SQL Server 2008/2005/2000, SSIS, SSRS, SAN, DTS, MS Excell-2005,2007

Educational Qualifications:

Gujarat University, Gujarat, INDIA (Passing year 2007)

MBA- Finance, New York Institute of Technology, NY (Passing year -2010)

Contact this candidate