ANUP SHAH

Senior MS SQL Server DBA

Summary of Qualifications:

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

Ten Plus Years of IT experience with Database Administration on MS SQL SERVER 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 2016/2014/2012/2008 R2/2008/2005 on Windows 2008/2003/2000.

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

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

7+ Years’ experience in Implementing, Upgrading and Migrating to SQL Server 2012/2014/2016.

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

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

Worked on VMware and Virtual Environment.

Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.

Implemented Always On availability groups 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

Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2012/2008 R2/2008/2005.

Experience in Upgrading of SQL Server from version 2000 to 2005 and 2005 to 2008/2008R2/2012.

Highly Proficient in migration of Databases, packages and Job activities from MS SQL Server 2000 to MS SQL Server 2005/2008R2/2012 and also migrating the database from development to production, and migrate the data between the databases.

Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, 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).

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

Experience in designing & implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.

Experienced in Data Migration between Homogeneous & Heterogeneous Systems using various tools (SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).

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

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

Basic experience of Oracle Database environments.

Setup and used AWS (Amazon Web Services) on cloud base environment.

Performed Server 2012/2008 R2, 2003 and IIS Systems Administration, and configuration

Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email & Pager notifications using SQL Server Agent.

Technical Competencies:

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

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

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: Bank of Tokyo\MUFG Bank, Exchange Place, NJ June 2017 – Present

Role: Senior MS SQL Server DBA

Industry: Banking\Financial Services

The main role is to manage and support to AML – Anti-Money Laundering applications 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.

Involved in Business Review meetings and worked with SMEs (Subject Matter Experts) to gather and understand the business requirements.

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

Initiated and extensively worked with Amazon Team to Install, configure the Amazon RDS and integrate with AWS (Amazon Web services)

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

Work in the production engineering group to support more than 90 production MSSQL database servers, plus servers in Dev and QA environments.

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

Work with development teams to make best index design that balances feature requests with performance concerns.

Increase availability and performance of applications by gathering and analyzing server and database metrics with various monitoring tools.

Used Compression and partition the very large AML database.

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.

Granted access to various database objects based on Remedy Request.

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

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

Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.

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

Analyzed and investigate an order management system (OMS) application related issues and participate with Development team to resolve it.

Configured TDE (Transparent Data Encryption) on Database.

Worked with Oracle DBAs to support and resolve remedy tickets.

Administered, maintained, developed and implemented policies and procedures for ensuring the security and Integrity of the company database.

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

Extensively participated in DR Test.

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

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 5 terabyte in size.

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

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 and guided developers.

Created automated solutions using T-SQL and PowerShell for Backup/Recovery, security, replication of the data etc.

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

Development of Automated solutions to decrease manual labor and increase proficiency.

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

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

Experienced in creating and managing backup and recovery solutions using lite-speed, native backups as well as network backups.

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

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, DTS, SSIS, SSRS, Power BI, PowerShell, Performance Monitor, SQL Profiler.

Client: Barclays Capital, Piscataway, NJ Jan 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 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

Implemented Database Mirroring on SQL Server 2008 environments.

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.

Implemented transactional replication for data refresh

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

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

Supported SQL Server environment in OLTP and DSS systems

Installed SQL Server Active/Active and Active/Passive Clusters in 2012,2008 R2

Upgraded SQL Server 2008R2 to SQL Server 2012, 2012 to 2014.

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)

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

Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.

Created solid stored procedures for Backup and Recovery process

Used extensive SQL Server DMV's for Performance and System Monitoring

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

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

Creating, Scheduling and deploying extensive SSIS packages from Development to Production.

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 a lot on creating, designing databases and creating Views, Stored Procs and Triggers

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

Used Various third Party tools for monitoring SQL Servers and Backing up Databases

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

Client: Marsh & McLennan, HOBOKEN, NJ Sep 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

Responsibilities:

Extensively worked in OLTP & OLAP environments that include Production, UAT and Development databases in SQL Server.

Provided 24/7 production support on a rotating roster schedule.

Suggested design and architecture structure for Databases and servers.

Implemented SQL Server 2012/2008R2 Active/Active cluster setup on Windows 2008 R2 servers.

Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.

Configured and Monitored MS SQL Server 2008R2 in Log Shipping from primary server to DR server (different geographical location) and also carried out role changes and role reversals.

Installed and configured SQL Server 2008R2 and 2005 with Service Packs as per the Business Requirements in UAT, Development & Production environments

Creating, Monitoring and Troubleshooting Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.

Designed and implemented high level backups/restore strategies for point in time recovery purposes based on the database environment. Used Idera SQL Safe backup tool to backup databases.

Used Performance Monitor and SQL Server Profiler (ran Trace) to optimize long running queries and thereby improved the performance of the queries.

Implemented backup and restore strategy for SQL, SSAS production and DR environments using PowerShell and T-SQL.

Worked with different teams (Application, Active directory, Engineering & QA) to deploy projects to UAT (Testing), Development, and Production environments.

Migrating SQL Server 2005 databases to SQL Server 2008 R2.

Used SQL Server Upgrade Advisor to analyze SQL server 2005 in the process of migration.

Proactively worked with developers/project team for achievement of efficient database access and resource usage for applications. This includes activities like designing indexes, adding or eliminating columns on existing indexes, and maintaining indexes/re-organizing tables, recommending SQL configuration changes.

Created packages successfully using SSIS to transfer large volume of Data.

Created ad-hoc reports using Report manger in SSRS.

Routine tasks but not limited to: Monitoring and Maintaining the security, integrity and availability of Servers, performance tuning, building packages, responding to users and developer issues and monitoring database backups.

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: Lincoln National, RANDOR, PA October 2010 – Aug 2011

Role: SQL Server DBA

Industry: Finance

The role was to give Level II support for production, development and QA databases primarily on SQL Server environment. Supporting SQL Servers and using ticketing software for change management and resolving user issues

Responsibilities:

Installed Standalone and Clustered SQL Server 2005/2008 instances in Production, Development, Test, Staging environments.

Experience in setting up High Availability environments like Active-Active and Active-Passive Clustering.

Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.

Worked extensively on Database space management, performance monitoring and alert management.

Configuring, administration and troubleshooting multiple databases which include databases in QA and Production environments in clustered and stand-alone environments.

Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements

Suggested backup strategies, Scheduled backups and Performed restoration operations.

Worked with migrating data from SQL Server 2000 and 2005 to SQL Server 2008.

Created Jobs and scheduled jobs according to the requirements.

Created linked server between SQL servers.

Dropped and recreated the indexes on tables for performance improvements.

Written complex stored procedures and functions and integrated it with the front end application.

Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Data transfers between various servers using BCP and DTS.

Worked on to automate generate Crystal reports.

Extensively used SSIS to move data from text files to SQL Server.

Created packages successfully using SSIS to transfer large volume of Data.

Environment: Windows 2008 R2/2003 Server, MS SQL Server 2008 R2/2005/2000, Business Intelligence Development Studio, T-SQL, SSMA, Lite Speed, DTS, SSIS, SSRS, BCP, SQL Profiler

Client: PNC BANK, PITTSBURGH, PA Aug 2008 – Sep 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

Responsibilities:

Provided 24/7 on call production support.

Installed SQL server 2008 and Migrated SQL Server 2005 databases to SQL server 2008 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts on a test environment to be the future production environment.

Worked on resolving major performance issues for databases

Researching on database/index fragmentation and running rebuild indexes and update statistics

Using latest sql server DMV’s for finding performance bottlenecks

Running Index tuning wizard and rebuilding indexes for faster query response.

Configured the Log shipping and scheduled jobs to setup log shipping between production servers.

Implemented and tested the point in time recovery of the production databases.

Implemented Transactional Replication between Primary Server and Sub Systems.

Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.

Created Users and Roles, and managed security and permission of different SQL Server objects.

Exported and imported data from text files and Excel to SQL Server using bulk copy insert and BCP utility.

Running DBCC consistency check, and fixing data corruption in user databases.

Experience in Tuning Databases using Performance Dashboard.

Developed several reports using SQL server Reporting services (SSRS).

Maintained stand by servers using log shipping and replication concepts.

Prepared the coding guideline documents for SQL server developers.

Extensively used SSIS to move data from text files to SQL Server.

Coordinating with the development team regarding tuning the SQL queries and stored procedures.

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

Educational Qualifications:

Gujarat University, Gujarat, INDIA

Contact this candidate