Sql Server Data

Anuj Porwal

Microsoft SQL Server Database Administrator

India Pune MCSA +91-807*******

Email : ****.********@*****.***

https://www.linkedin.com/in/anuj-porwal/

About me

6.5+ years of rich IT industry experience in Product based companies as a Microsoft SQL Server DBA in supporting multiple SQL Server servers running on different versions (ranging from 2005 to 2016), holding technical discussions, offering high quality consultation and risk assessment for deployments of MSSQL Server and Dependent Applications, planning strategies for high availability and disaster recovery whilst taking care of routine maintenance activities and troubleshooting issues with the help of relevant tools and technologies available, providing customized solutions based on requests, project/program management services & client solutions for Microsoft and almost all major financial, Healthcare and Telecommunications domain clients. Experience includes :

installation & configuration, upgradation, patching, data migration, SQL Server Clustered/Non-Clustered databases administration, backup and recovery, Security, performance tuning and optimization, T-SQL, index optimization.

Well versed with High Availability and Disaster Recovery mechanisms which includes Database Log shipping, Replication, Mirroring, Clustering, AlwaysOn.

Database maintenance planning and implementation of data encryption using TDE and Always Encrypted feature.

Omniscient with sizing, performance tuning and scaling SQL Server environments

Working knowledge of SQL server Reporting/Integration/Analysis services (SSRS/SSIS/SSAS).

Working knowledge of PostgresSQL database configuring backup\recovery and maintenance tasks.

Providing high level Technical and on-call support to the Team in weekday and on weekends.

Working as a technical lead and taking interviews for technical rounds up to specialist level for SQL DBA projects.

Perform a variety of SQL Server tasks related to problem resolution and monitoring, administration, performance, security and corporate strategy with ITIL process.

Possess good Analytical, Problem Solving, Decision-Making and Knowledge of Managing/Leading Teams with good technical Skills. Exceptional technical escalation handling skills, ability to motivate, coach and mentor the Team to achieve common goals with Project Objectives. Capable of handling parallel tasks for Management for reporting to Organization unit level.

Career Profile

MS SQL DBA with INFOSYS LTD(https://www.infosys.com/ ) (Feb 2013 – Jul 2015) Role: Senior System Engineer.

Cloud Operations DBA with eGain Comm. (http://www.egain.com ) (Aug 2015 – Oct 2016) Role: Senior Database administrator.

SQL server DBA with SunGard (Now FIS Global https://www.fisglobal.com/ ) (Nov 2016 – till date) Role: Specialist – Database Administration

Professional Certifications

Technical

Microsoft Certified Technology Specialist (MCTS):

SQL Server 2008, Implementation and Maintenance(70-432). Microsoft Certified Solution Associate (MCSA):

Querying Microsoft SQL Server 2012 databases(70-461).

Administering Microsoft SQL Server 2012 Databases(70-462).

Implementing a Data Warehouse with Microsoft SQL Server 2012(70-463). Process Oriented

ITIL Foundation Certificate in IT Service Management.

ITIL Service Operation Certificate in IT Service Management. Trainings

90 days of training in J2EE at Infosys Technology Ltd.

45 days of training/certification in Oracle Database 10g: Introduction to SQL at NIIT Noida.

30 days of training/certification in Oracle Database 10g: PL/SQL Fundamentals at NIIT Noida.

2 days of training/certification in SSRS (SQL Server Reporting Services) at Infosys Technology Ltd. Educational Qualification

Class/Course College/Institute Board/University Percentage Grade Year B.Tech. (IT) AKGEC, Ghaziabad GBTU, Lucknow 78.78% Hons 2012 H. S. C. Bh. V. Inter College, Auraiya UP Board 84.20% Hons 2007 S. S. C. Bh. V. Inter College, Auraiya UP Board 78.67% Hons 2005 Technical Skills

Database Servers MS-SQL Server 2005, 2008 / R2, 2012, 2014, 2016 Database Technologies SQL Server Enterprise Manager, Management Studio, Migration Assistant, Query Analyzer, SQL Profiler, ETL, DTS, BCP, SSIS, T-SQL, MS Office 2007/2003/XP/97. Languages T-SQL, PL/SQL, C, Java, HTML, DHTML, VB Script, PowerShell. BI Tools BIDS – SSIS, SSAS, SSRS

Ticketing and KB Tools ITSM-eServiceDesk, Primus, Techease, JIRA, SNOW, TeamSupport Operating System Windows Server 2003, 2008, 2008R2, 2012 and 2016 DBA Tools Performance monitor, Spotlight, Fog light and Idera Backup Tools Commvault

Project Expertise

Database Development

Proficient in Relational Database Management Systems (RDBMS).

T-SQL (DDL, DML, DCL), Designing and Normalization of the database tables.

Knowledge of advance query concepts (e.g. group by, having clause, union so on).

Complex query design, stored procedures, views, functions, Triggers and Indexes.

Creating, Managing & Optimizing Performance for Views, Procedure, Triggers, Table & Functions. Operational/functional Automations Done

SQL server/database audit implementation to capture DDL changes and sensitive tables DML changes.

Built a stored proc which can automatically decrypt and mask any encrypted database based.

UAT Client database automatic refresh in which an authenticated user can initiate the refresh from application side.

Built a SP for Granting access to support group access dynamically for varying number of stored procedures and functions for all specific client databases.

Built a SP to grant ad-hoc access to any user/ revoke user access and update the ticket automatically.

Logins rename for complete environment from internal User Ids to corporate required Login names.

Idera reports (for Disk and health checkup) customization through SSRS.

Disk drive growth estimation script for PROD SQL servers.

Automated script for all databases restore during DRE activity.

Automatic Hardening parameters check/implement script which is getting used to check/implement the SQL servers hardening across all the environments/servers.

Have built automated reports which will alert us only when there is any issue for log shipping.

Automatic cleanup of all disabled/AD removed or unauthorized logins from across all the servers.

Access Map script for automatically mapping the Logins access which was before a restore of a database.

Weekly consolidated CPU Utilization and Data growth report using the Idera repository and formatting it in charts using SSRS for all prod servers.

Automatic TDE encryption certificates creation with matching thumbprint and encryption enable for all PRD and UAT server’s client databases as per corporate security mandate.

Encryption certificates and databases encryption keys rotation for across the servers (for expired Transparent database encryption certificates) and have set a monitoring in both products to report a database for which TDE certificate is going to expire or is already expired.

Automatic read access provisioning to support group on all PRD/UAT client databases.

As per client request for all PROD servers, developed a report which is scheduled to report us/business daily for all in progress, failed, successful and not scheduled backups.

Working on automation for SQL server patching using PowerShell. Reporting Services/ Database Warehouse Management (SSRS)

Installation/Un-installation and configuring SSRS on DBA Inventory servers on requirement basis.

Extracted data from internal data warehouse system to SSRS, Created ad-hoc reports.

Analyzed data models, data relationships, and dependencies for greatest optimization.

Designed and developed stored procedures, queries and views necessary to support SSRS reports.

Modified SP's and formulated coding and scripting to be utilized for reports within the organization.

Created and managed subscriptions for Reports, report level permissions to secure business information.

Have created Drill down, drill through and Chart/map-based reports for management reporting.

Have built and improved the performance of DBA health checkup reports which were running for more than hours to below 5 mins.

Integration Services/ Database Warehouse Management (SSIS)

Installing/Configuring, maintenance and migration of Integration Services/packages.

Proficient in using SSIS to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.

Troubleshooting and Optimizing SSIS package performance. Deployed and Scheduled SSIS Packages. As Core SQL Production DBA

SQL Server Performance Monitoring and Tuning

- tempDB and user DBs file configurations, Log files usage and growth parameters analysis.

- Missing indexes, Fragmentation, Re-indexing, Update Stats, Conflicting and long running SQL jobs analysis.

- Physical memory and CPU usage and network analysis by setting up the performance counters and monitoring through Sptlight/Foglight/Idera tools.

- Review and optimize SQL queries, stored procedures, views and triggers from other developers to avoid blocking/deadlock issues and to achieve maximum efficiency and scalability

- Extended events and Profiler run by selecting the required events, Execution plan analyzing, SQL Server Hardware sizing and bottleneck tuning.

- Building a centralized monitoring server for DBA side performance metrics capture and reporting purpose.

Space Management and Capacity Planning

- Space utilization monitoring, Quarterly Space analysis and forecasting.

- Database growth monitoring on weekly basis and identifying the servers/disk for disk expansion in advance.

Database Backup and Recovery

- Created the backup and restore strategy for production, development and test environments.

- Designing and Implementing backup strategies (Full, Differential & Transactional log) for databases that included native backups as well as third party software, with appropriate clean up jobs to manage the available disk space effectively.

- Recommending appropriate database recovery models, Restoration of Databases, enforcing checksum for backing up databases as and when required.

Managing databases

- Creating and configuring Database & locating the data\log file to dedicated drives

- Modifying the log\data files, moving the database by Attach\Detach, Backup & Restore.

- Performing consistency checks of databases and tables using various DBCC commands and handling issues related to corruption of databases.

- Good knowledge of new features like Row and Page compression mechanism, CDC, Data Compression, Backup compression, Resource Governor, Performance Data Collector and Transparent Data Encryption and Always Encrypted feature.

- Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments.

- Maintain the data\log file growth, shrinking the data\log files, add new data\log files whenever needed.

- Troubleshooting Corruption related issues.

- Configuring monitoring and alerts for blockings, long running queries.

Database Objects

- Create\update\delete tables, Database Refresh and movement, Applying Scripts provided by developers.

- Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data

SQL Server Security

- Managing/Providing access on the server, setting-up authentication modes, Create SQL Server Logins and users, fixing Orphan users.

- Implementing and maintaining security model, Object permissions based on business need and different user roles.

Data Security

- Encrypting the databases using transparent data encryption(TDE).

- TDE certificates/private keys backup with strong passwords and saving them to secure vault.

- UAT server TDE certificate creation with matching thumbprint as on PROD server to make UAT refresh possible.

- TDE Certificate/database encryption keys rotation as per corporate requirement.

SQL Server Agent, DB mail, Maintenance Plans, Linked server

- Creating, Modifying Jobs with SQL agent, Scheduling, Modifying Jobs with SQL agent.

- All types of job failure troubleshooting related to SSIS packages/TSQL/logical errors etc.

- SQL Mail and DB Mail configuration, Configuring Operator and Alert, Configuring Linked Server, troubleshooting issues related to access and providers.

Installation/ Up-gradation and migration of SQL Server

- SQL server Hardening, Best Practices Implementation.

- Configuration settings for instance, Server and database Audits creation.

- Hands on experience in performing in-place as well as side-by-side up gradation and patching of SQL Servers on Standalone as well as Clustered environments.

- Upgraded databases/objects, including logins, stored procedures, and jobs from MSSQL 2008 to MSSQL 2016.

- Data migration from one SQL server to another.

- Design & Implementation of SQL Server migration from Physical to Virtual environment and vice versa.

- Troubleshooting various issues with installation of SQL Server including MSI/MSP related errors and permissions related errors.

High Availability and Disaster Recovery

1. Transaction Log Shipping

o Configuring Log Shipping with different Modes [Restoring, Standby], Monitoring/ Troubleshooting through job alerts & System tables [TSQL].

2. Replication

o Configuring Replication (Transactional/peer to peer)- Set Up the Distributor, create a Publication, subscribe to the Publication, monitor/ Troubleshooting Replication using SQL Server Replication Monitor

& System tables [TSQL].

3. Database clustering

o Validating Windows Cluster configuration and setting up SQL Server Clustered instances on physical as well as Virtual Environments. Performed activities like Add Node, Add Disk, Set Disk Dependency, patching in clustering.

o Implementing, Managing of SQL server instances in A/A and A/P windows clustering. Moving databases instances to different nodes. Hands-on experience on 2 and 3 node cluster (AA & AP). o Issues troubleshooting for cluster role not coming up. Patching and Password change activity for SQL service account used in clustered environment.

4. AlwaysOn Availability

o Have set up AlwaysOn Availability Group databases on 4 nodes setup (2 in HA and 2 in DR). o Have setup a mixed environment with 2 nodes in AlwaysOn and 3rd node in Log shipping. o Configuring the AlwaysOn groups and listeners. Patching and troubleshooting the synchronization issues for databases in AO.

ITIL Responsibilities

- Involved in Change Management, Problem management activities using Service Now/JIRA tool before implementing database changes in production and development activities.

- Problem Management: Documenting RCA for high severity tickets, Performing RCA

- KB articles creation, review and publishing.

Recognition/Award/Rewards

1. Quickest learner and self-manageable person award by eGain Comm. 2. Have been nominated 2 times for FIS Laureate from project side. 3. Have won 2 times employee of the quarter award in FIS and received a reward of 250$ and 500$. 4. With outstanding performance, promoted to specialist level by manager in mid-year as an exception with FIS policies.

5. Multiple Kudos/Wow card for automating the routine tasks and resolving critical production issues. 6. Multiple BAU side appreciations for providing the best solutions to custom requirements from clients. Personal Details

Name: Anuj Porwal

Father’s Name: Mr. Shiv Kishor Porwal

Date of Birth: 15th Aug 1990

Gender: Male

Marital status: Single

Current Address: B1-703, CASA Imperia, Jamdade Basti Near Wakad Bridge, Pune - 411057

Passport No: K5311933

Contact this candidate