Anup Shah

Senior SQL Server DBA

PROFILE

•Senior MS SQL Server DBA with 12 years of IT experience with Database Administration on MS SQL SERVER 2019/2017/2016/2014/2012 and older versions in Production and Sub-productions (Dev/Test/QA/ Lab) Environments.

•Hands-on experience with Installation/Configuration, Upgradation/Patching, manage multiple MS SQL Server 2019/2017/2016/2014/2012 and older versions on Windows 2019/2016 and older versions and Decommissioned SQL Databases and SQL Server Instances 2012 and older versions.

•Worked on Physical, VMware and Virtual infrastructures Environment.

•Expertise in Data Migration from MS SQL server versions 2012/2008R2 to 2019/2016/2014.

•Worked and supported major projects like Data center Migrations, Tech-uplifts, Server Consolidations.

•Worked on installing/configuring/migrating and supporting On Premise SQL Servers to Microsoft Azure PAAS/SAAS Managed Instance (MI)/IAAS for legacy applications and their databases.

•Experienced in Design, Development, Testing, Implementation Client/Server, and Cloud/Web based applications.

•Maintained databases with sizes ranging from Large to Very Large Databases -VLDB (40 terabytes).

•Extensive knowledge of Backups, Restoration and Disaster Recovery Planning.

•Expert in design and setup High Availability & Disaster Recovery technology (HA/DR).

•Implemented Always On availability groups, FCI, AG Listener and replicas for reporting, Windows Server Failover Clustering (WSFC) for SQL load balancer/performance, Mirroring, Log shipping and Replication.

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

•Excellent Experience in Managing Security through Logins, Users, Permissions, SSL Certificates, Credentials as per Company’s Security Policies

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

•Experience working with DB Schemas like Star Schema and Snowflake Schema used in Relational, dimensional, and multi-dimensional modeling.

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

•Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMVs, and 3rd party tools.

•Expert in troubleshooting and resolving performance bottlenecks and problems.

•Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services).

•Worked with complex Data Warehousing applications using ETL tools Informatica Power center in OLAP and OLTP.

•Designed & documented high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.

•Schedule and monitor ETL batch jobs using Tidal, Autosys, SSIS Packages.

•Supported Unix/Linux platforms and other Databases like Postgres DB.

•Diverse background with fast learning skills and creative analytical skills.

•Support On Call 24 *7 productions activities during extended hours and weekends.

EXPERIENCE

Client: Toyota Motors North America Inc. (TMNA), Remote NJ July 2020 – Current

Role: Sr. SQL Database Administrator\Developer

Industry: Automobile

As part of HXF Core project, primarily worked as Database Architect with Design, Analyze and Build SQL Servers 2019 & 2016 with Solutions Architects to onboard in-build and vendor applications. Worked on Tech-uplifts, Data Center migrations, Server Consolidation projects. Also, Managed & Supported multiple SQL instances and Databases for 20 + NAMC’s sites for manufacturing, Sales, and R&D units.

Responsibilities:

•Daily High -level SCRUM calls with Designer, Solution Architects, Infrastructure Windows-Unix admins & Security Admins to discuss the new applications design requirements, VM and DB Servers Build process including Disk and Storage capacity planning, Security accesses.

•Installed, configured, troubleshoot and managed SQL 2019/2016 Enterprise & Standard editions for standalone, cluster, single/multi-instance environment and performed SQL Server patching and DB cumulative updates.

•Performed In-place upgrade from SQL 2012 to 2016 and side by side upgrade from SQL2012 to SQL 2019.

•Performed Infrastructure assessment of On-Premises servers to Cloud Migrations.

•Migrated database from 2008 R2, SQL 2012, SQL 2014 to SQL 2016/2019 and

• cloud with PAAS and SQL Azure VM (IAAS) Environments as tech uplifts projects.

•Install, configure and migrate SQL Server Instances and databases to both On Premise and Azure Managed Instances (MI), Azure VMs.

•Used DMA (Data migration assistant), Azure Migration Service to evaluate breaking changes, compatibility issues before migrating to managed instances.

•Analyzed the resource requirements and configured the DTUs and v-Cores for databases in Azure SQL managed Instance (MI).

•Deployed and automated Azure Data Factory (ADF) using CI/CD (Continuous Integration/Development) using Azure pipelines.

•Implemented High Availability solution for mission critical databases in production environment.

•Designed, built, configured, and validated Always on Primary and Secondary replica along with far Replica – DR node for mission critical applications.

•Used Execution plans to perform Intensive Analysis and Health check on Stored Procedures, Table design, Views, Cursors, Unused/Missing/Overused indexes and took corrective action to get performance benefits.

•Designing and implementing Informatica mappings to extract data from various source systems and transforms like Derived Column, Lookup, Merge Join, Aggregate, Data conversion and Conditional Split as Data transformation and Load to Destination system as Data Load as part of ETL process.

•Deployed SSIS packages through SSIS catalog database.

•Identifying and optimizing performance bottlenecks in SSIS packages; Fine-tuning data flow tasks, optimizing queries, and leveraging SSIS best practices for improved ETL performance.

•Used ODBC /JDBC to connect SAS directly to the SQL database and transfer the data.

•Installed and configured SQL Server Reporting Services (SSRS) 2019 component, web services and migrated reports from SSRS 2012 to SSRS 2019.

•Supported application teams to mitigate application connectivity issues, SSL Certificates deployment from database perspective.

•Setting up and monitoring SQL Replications (Snapshot, Transactional) and QLIK tool replications.

•Worked and supported Oracle DBA tasks.

•Used SQL Sentry for overall Health monitoring.

•Managing Service Requests, Incidents and Change Tasks in ServiceNow and ensuring to accomplish within SLA.

•Supported Weekend activities like Post-Windows OS Patching SQL Server Validations, Network Upgrades, Production Change deployments.

•Provided On Call Production Support during weekends and major migration activities.

Environment: Windows 2019/2016 and older, UNIX/Linux, MS SQL Server 2019/2017/2016 and older, MS Azure (SaaS) (PaaS) (IaaS), DMA, Azure Data Studio, Azure Migration, Always On, T-SQL, SSMA, SSIS, SSRS, ETL, Oracle, DSS, OLAP, Performance Monitor, SQL Profiler, T-SQL, Toad, Informatica.

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

Role: Sr. MS SQL Server DBA\Developer

Industry: Banking

The main role is to manage and support 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 Servers Server 2019, 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

•Involved in Business Review meetings and worked with SMEs (Subject Matter Experts) to gather and understand the business requirements and present the in- depth analysis for AML – Actimize database growth and archived historical data for better performance.

•Installed and configured Windows Failover Clusters (FC), SQL instances and Always On Availability Group. (AOAG)

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

•Performed SWOT analysis and designed the Azure cloud migration approach like lift and shift, re-platform, or re-design.

•Assess the infrastructure, Databases, Applications dependencies, Risk mitigation, Securities before Cloud migration.

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

•Worked on Compression and partition of the very large AML- Actimize database.

•Verify Daily reports to ensure that all the Production environments are running fine.

•Configured automated proactive notification when defined thresholds are reached. Responded to alerts messages from all levels of the Database.

•Administered and oversaw the maintenance of SQL and NoSQL databases.

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

•Designed and created tables, views, stored procedures, and triggers using T-SQL.

•Developed T-SQL Store procedures to Automat daily routine tasks.

•Developed and Optimized SQL Server queries and improved database performance to enhance query execution times and reduce resource utilization.

•Experienced in performance enhancement for SSIS packages and troubleshoot ETL jobs for ingesting data from various sources Monitor batch processing and job status using Tidal Scheduler.

•Designed and Developed Informatica Mappings/Transformations for Data loads and Data cleansing.

•To maintain Data quality developed Data profiling, mapping, validation, and manipulation using Informatica Data Quality tool.

•Troubleshoot SSIS packages and Data validation with reference tables for different sources (Flat/XML/CSV/XLS files).

•Exported SAS-Datasets to CSV file and converted into SQL database with export wizard.

•Analyzed and fixed the script and tested thoroughly.

•Implementing Error Handling for SSIS packages to identify and handle data quality issues during the ETL process.

•Worked with Oracle DBAs to support and resolve remedy tickets. Prepared Process Documents and shared the knowledge with the Off-shore Team.

•Automate daily database administrator tasks using PowerShell.

•Interacting with Development, Release Engineer, and App support teams to implement new production changes and patches and Developers using DevOps tools/source control tools for deploying code versions from Development to Production environments.

Environment: Windows 2012/2008 R2/2003/2000 Server, UNIX/Linux, MS SQL Server 2019/2017/2016/2014/2012,2008 R2, MS Azure (SaaS) (PaaS) (IaaS), AWS, Always On, T-SQL, SSMA, SSIS, SSRS, ETL, DMS, Azure Migration, Azure Data Studio, Power BI, MS Office 2013 suite- Excel, DSS, SAS, OLAP, Performance Monitor, RedGate, SQL Profiler.

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

Role: MS SQL Server DBA

Industry: Banking\Financial Services

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

Responsibilities:

•Involved in daily SCRUM calls with Business stakeholders, App. Owners, SMEs (Subject Matter Experts) and discussed the challenges and daily status for major Data Center migrations. 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/2019.

•Worked closely with the DB infrastructure team to maintain a reliable database management plan, including building Always On, FCI, configure replicas and listeners, performance tuning, monitoring, and backup and recovery, replication strategies and ensured integration of the system for automation end to end provisioning.

•Migrated major application databases from On Premise to Azure Cloud Managed Instance (PAAS) and VMs (IAAS).

•Built and configured multiple VMs, Networks on multi-subnets in Azure cloud.

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

•Analyzed and developed the SQL stored procedures with the execution plans to identify the bottlenecks and query response time.

•Interacting with development, Release Engineer and App support teams to implement new production changes and patches and supported NoSQL platforms for Postgres DB.

•Designing and implementing SSIS packages to extract data from various source systems and transforms like Derived Column, Lookup, Merge Join, and Conditional Split as Data transformation and Load to Destination system as Data Load as part of ETL process

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

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

•Performed daily activities like Db refreshes, User requests, DB consistency checks, Health checks.

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

•Support and resolve JIRA tickets for operational issues during the migration process supported on call activities.

Environment: Windows 2012/2008 R2 Server, MS SQL Server 2016/2014/2012,2008 R2, T-SQL, SSMS, SSIS, SSRS, Informatica, Redgate, SQL Sentry, Office-365, ETL, Azure Key Vault, DMS, DMA, Azure Data Studio

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

Role: Senior MS SQL Server DBA\Developer

Industry: Banking\Financial Services

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

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

Role: Senior MS SQL Server DBA

Industry: Banking\Finance

The primary role is to manage and support their critical applications which communicate with the IRS system and send all financial reports as per FACTA.

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

Role: SSIS\BI Developer

Industry: Finance

The role is to manage multiple SQL Servers in Production environments, support all major SQL Servers in Physical/Virtual environments 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. Worked on ETL tools like Informatica and SSIS for ETL mapping and transformations processes.

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

Role: 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.

Client: PNC BANK, PITTSBURGH, PA May2010 – Nov 2010

Role: Intern – Jr. 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 ETL tasks.

TECHNICAL SKILLS SUMMARY

Operating Systems: Windows 2019/2016/ older versions, Unix

RDBMS: SQL Server 2019 and older versions, Oracle, MongoDB, MariaDB

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

Languages: T-SQL, XML, HTML, PowerShell

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

Applications: Microsoft Office, Erwin, Office 365, Teams.

Networking TCP/IP, Named Pipes, VIA

Other Tools: Lite Speed, Erwin, Idera Diagnostic Manager, Fog light, Redgate, PowerShell, SolarWinds SQL Sentry

EDUCATION

●Gujarat University, Gujarat, INDIA (Passing year 2007)

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

Contact this candidate