Sql Server Service

Suraj Kumar Kshirsagar

Sr. SQL Server DBA,

Ph. +1-650-***-****

*****.***********@*****.***

SUMMARY

12+ years of IT experience as Microsoft SQL SERVER DBA. I have thorough knowledge of MSSQL Server 2005, 2008, 2008R2, 2012, 2014 and 2016 on Windows Standalone systems, Windows cluster servers and VERITAS cluster servers. Good knowledge on windows platform Operating systems, hands on experience in planning, designing, implementing, backups, restore, clustering, creating and maintaining jobs for automating MSSQL Server, Configuration and maintenance of Disaster Recovery and High Availability features in MSSQL Server. Good handling capability in Space management. Currently working for KFORCE (with Client as JP Morgan Chase) as a SQL Database Management Analyst. Below are the details:

Strong knowledge of Database/SQL performance tuning in a high concurrency environment.

Worked on 25+ Terabytes of databases in DIGITAL Line of Business (LOB) supporting Chase.com and Chase Mobile Alerts system. Day to day maintaining High Availability, Disaster recovery and Resiliency for the Critical Application Framework (CAF) Databases in Sustenance Engineering Digital Reliability Operations team and various Enterprise Management Teams.

Provided 24x7 support for critical production systems.

Perform scheduled maintenance and support release deployment activities after hours.

Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

Experience working with Windows server, including Active Directory

Excellent written and verbal communication. Flexible, team player, “get-it-done” personality Ability to organize and plan work independently Ability to work in a rapidly changing environment. Ability to multi-task and context-switch effectively between different activities and teams

MCTS, MCITP, and/or MVP certified. Experience implementing advanced features in SQL Server including, but not limited to, Snapshots, mirroring, and clustering

Excellent documentation and technical writing skills.

Thorough day to day experience on maintenance of critical SQL Server 2000, 2005, 2008, 2008 R2, 2012, SQL Server 2014 and 2016 databases. Through knowledge on High availability like windows/SQL Clustering, Replication and Mirroring.

Installing MSSQL server 2000, 2005, 2008R2, SQL Server 2012 and SQL Server 2014 on standalone, Windows Clusters and VERITAS cluster servers. Meets business needs by developing stored procedures, user-defined functions, triggers, data transfer/ETL packages, reports, data extracts, etc.

Installations of Service Packs, patches and cumulative updates on SQL Server all versions.

Participates as a member of the Infrastructure team, in identifying and recommending improvements to systems and processes within the team to ensure flexible and responsive delivery.

Designs, implements, documents, and maintains an enterprise support environment for multiple database instances. Documents all database administration guidelines, standards and procedures in a run- book and ensures that the run-book is followed in all situations.

Responds to complex customer-reported systems problems. Evaluates and recommends use of software (including new DBMS versions and service packs), tools, guidelines, and procedures.

Ensures that all aspects of the DBMS are properly security, at the right level of granularity, according to security policies. Audits security and user activities on a regular basis in order to ensure compliance.

Develops database solutions by designing proposed system—defining database physical structure and functional capabilities, security, backup, and recovery specifications. Experience with backups, restores and recovery models.

Use of the good practices that are critical to preserving the strength and integrity of the firm. Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes

Assist developers with complex query tuning and schema refinement.

TECHNICAL SKILLS:

Databases:

MS SQL Server 2014, 2012, 2008, MS SQL Server 2005, Azure Cloud SQL server Reporting Services & Integration services

Programming:

C, C++ & T-SQL, Python, R

DBA:

Database Administration of MS SQL Server 2016,2014,2012,2008, 2005,2000

Operating System:

Windows NT/2000/XP/2003,2008/2008R2/windows2012/Windows 2012R2,Unix

Tools:

Backup Utility, Symantec Net backup, HP Data Protector, SQL LiteSpeed, Perfmon, SQL Profiler, Idera, Foglight

Markup Languages

HTML, XML

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

COMPANY: KFORCE Inc.

Client: JP Morgan Chase and State of Ohio COLUMBUS, OHIO AUG-2017 – Till date

Role: Sr. SQL Server Database Administrator

Environment: SQL Server 2005, 2008 R2, 2012, 2014 and 2016.

Responsibilities:

Implemented advanced features in SQL Server including Snapshots, mirroring, and clustering.

Worked on 25+ Terabytes of databases in DIGITAL Line of Business (LOB) supporting Chase.com and Chase Mobile Alerts system. Day to day maintaining High Availability, Disaster recovery and Resiliency for the Critical Application Framework (CAF) Databases in Sustenance Engineering Digital Reliability Operations team and various Enterprise Management Teams.

Implemented SSL certificates in the Production SQL Server Instances both clustered and standalone servers.

Configured and setup SQL Server Mirroring, Log Shipping, Mirroring/log forwarding, Clustering and other methods of disaster recovery

Maintained critical SQL Server 2000, 2005, 2008, 2008 R2, 2012 and SQL Server 2014 databases.

Participated as a member of the Infrastructure team, in identifying and recommending improvements to systems and processes within the team to ensure flexible and responsive delivery.

Performed complex database administration assignments essential to the production and development of DBMS applications.

Maintained Designs, implements, documents in an enterprise support environment for multiple database instances. Documents all database administration guidelines, standards and procedures in a run- book and ensures that the run-book is followed in all situations.

Responded to complex customer-reported systems problems.

Evaluated and recommends use of software (including new DBMS versions and service packs), tools, guidelines, and procedures.

Ensured that all aspects of the DBMS are properly security, at the right level of granularity, according to security policies. Audits security and user activities on a regular basis in order to ensure compliance.

Developed database solutions by designing proposed system—defining database physical structure and functional capabilities, security, backup, and recovery specifications.

Installed MSSQL server 2000, 2005, 2008R2, SQL Server 2012 and SQL Server 2014 on standalone, Windows Clusters and VERITAS cluster servers. Meeting business needs by developing stored procedures, user-defined functions, triggers, data transfer, reports, data extracts, etc.

Participated in Installations of Service Packs, patches and cumulative updates on SQL Server all versions.

Performed Backups/restores, DBCC, reorgs & update statistics as per the Database teams’ protocols.

Migrated databases from one platform to another, patching, upgrade, data loading, security, capacity planning, performance monitoring and tuning.

Analyzed traces, debug stored procedures, triggers and package

Experience in database design and some logical modeling knowledge

Experienced on handling and debugging issues with Windows operating system, LDAP and Active Directory

Handled of Database Architecture, Operating Systems, Client/Server Architecture, Middleware and Hardware (Servers, SAN, Network)

Demonstrated good written and verbal communication skills in English language

Collaborated effectively with other operational support teams and vendors to support the service. Team focus and customer oriented

Handled day to day project and BAU work with Excellent time management and organizational skills

Demonstrated ownership and good skills on problem management, problem solving and prevention of SLA breach under Incident / Problem Management processes.

COMPANY: WIPRO TECHNOLOGIES (Worked from 3rdOCT-2006 to 4thAUG-2017)

Client: Quest Diagnostic Corporation, Norristown, PA JUN-2016 –AUG-2017

Role: Sr. SQL Server DBA

Environment: SQL Server 2005, 2008 R2, 2012, 2014 and 2016.

Responsibilities:

•Handled 1000+ production Servers

•IDERA Diagnostic Manager Tool installed on all the production servers and configured BPPM tool to trigger alerts to the DBA email via HPSM ticketing tool.

•Performed key role in handling Production database server during business hours and NON-Business hour at ONSITE in a 24/7 support environment.

•Responsible for all database related issue in production servers

•Performed Database Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring, Indexing, etc.

•Worked on Installing, Administering and maintaining High availability solutions like Log shipping, Mirroring, Failover Cluster, Replication and Always ON (Combination of both Mirroring and Failover Clustering)

•Experienced in using tools like SQL Server Profiler, Database Engine Tuning Advisor (DTA), Performance Monitor and DBCC commands and Dynamic Management Views (DMV).

•Worked on process driven culture where worked on ITIL components like Incident Management, Change Management using HPSM tool.

•Performed weekly/Monthly Maintenance tasks like Patching, installing Service Packs

•Worked on Database related issues like T-log full, Disk full, DB Suspect state, recovering corrupt databases, point in time recovery etc.

•OS Related tasks like Rebooting Servers, analyzing Server performance, scheduling Windows Scheduled tasks, troubleshooting production issues using Performance counters, Event Viewer etc.

•Provided performance reports using DB Performance monitoring using tools like IDERA, Profiler, Performance Counters, etc.

•Implementing Service Improvement Plans like Preparing Monitoring Scripts, Disk space alerts script, setting up DB Alerts etc.

•Performed migration of the databases from SQL Server 2000 to SQL Server 2008 R2; SQL 2005 to SQL 2012; 2008 R2 to SQL 2014 in a cluster environment.

•Set up transparent database encryption (TDE) on SQL Server databases.

• Experienced in architecting, designing and administrating multi node clustering with Active/Active, Active/Passive Architecture.

COMPANY: WIPRO TECHNOLOGIES (Worked from 3rdOCT-2006 to 4thAUG-2017)

Client: Microsoft Corporation, Mountain View, CA AUG-2015 – JUNE 2016

Role: Database Engineer

Environment: SQL Server 2005, 2008 R2, 2012, 2014

Responsibilities:

•The work involved Repairing, Rebuilding servers, Hardware Maintenance & handling incidents in Hotmail properties.

•Analyze server failures that resulted from hardware and/or software failures, and perform repair operations using applicable documentation and coordinating hardware replacement with Site Services.

•Taking manual backups and restoring to backup server during outage scenarios. Rebuild and/or install Operating System, Application, Monitoring tools, SQL Server and storage configuration. Work is to be performed with coordination of Windows Service Web Communications teams including but not limited to System Engineering team, development team, Lab service and Site services

•Working on DB issues feasibility study and implementation processes on Windows backend SQL production servers.

•Documenting Trouble Shooting Guides (TSGs) on new issues and giving KT to the offshore team.

•Track and report replacement hardware usage statistics and trend.

•Track and report on server hardware failure rates for every server SKUs and components.

•Coordinate hardware replacement and ensure appropriate inventory levels are maintained for every server/cluster in all data centers.

•Participate in High Priority conference calls to address production issues when requested.

•Install monthly/emergency security patches, SQL hotfix, Windows hotfix, lPAK’s, perform Service account password reset, renewal/setup of SSL certificates and other regular database maintenance work.

•Co-ordinate server maintenance activities with internal Microsoft support teams.

•Participating in weekly and monthly service delivery meetings with the customer.

•When Microsoft introduces new tools to manage the deployment process, train, accept and adopt these tools as requested by Microsoft

•Track, maintain and report deployment related key performance indicators (KPI) on Efficiency, Quality, and Volume

•Participate in Feature Specification and Release Reviews to ensure complete understanding of the features being deployed.

•Work on automation scripts using Windows PowerShell.

•Upgraded/Migrated the databases from SQL Server 2000 to SQL Server 2008 R2 in a cluster environment and SQL 2005 to SQL 2012; 2008 R2 to SQL 2014.

•Good Knowledge in implementing different Replication Models (Snapshot, Merge and Transactional) with different topologies.

COMPANY: WIPRO TECHNOLOGIES (Worked from 3rdOCT-2006 to 4thAUG-2017)

Client: SP-AUSNET and ORIGIN Melbourne, Australia Westpac Banking Corporation, SYDNEY, Australia SEP-2012 –AUG-2015

Role: Lead SQL Database Consultant

Environment: SQL Server 2005, 2008 R2, 2012, 2014

Responsibilities:

•Worked on VERITAS Cluster Production Servers with SQL Server 2005 and SQL 2008 R2.

•Worked as a Project DBA with different application teams to build SQL Server for critical applications in a banking environment.

•Performed key role in handling Production database server during business hours at onshore

•Responsible for all database related issue in production servers

•Database Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring, And Re-indexing etc.

•Installing, Administering and maintaining High availability solutions like

•a) Log shipping

•b) Mirroring

•c) Always ON Availability Group on Windows Failover Cluster

•d) Replication

•DB Performance monitoring using tools like Profiler, Perf Counters,

•Migrated the databases from SQL Server 2000 to SQL Server 2008 R2 in a cluster environment.

•Good knowledge and working exposure in Storage Concepts of RAID levels and SAN environment.

•Configured transactional, snapshot and merge Replication

•Created Database Backup and Recovery procedures

•Design, optimize, and maintain all relational databases and ensure proper operational uptimes

•Develop, test, and deploy database standards, processes and procedures

•Preparing Document failures and the corrective actions

•Stage, test, and document all database upgrades

•Maintain a good work relationship with customers and vendors

•Ensure 100% adherence to all IT and department policy, processes and procedures

•Basic understanding on SSIS, SSRS (Reporting Services) and Analysis Services

•Experience in MS SQL Server installation, configuration, performance tuning, and client/server connectivity.

•Database consistency checks using DBCC

•Tuning and Optimization of Transact – SQL, Stored Procedures

•Experience in creating databases based on functional requirements and system design

•Author professional correspondence to customers and vendors.

•Installed SQL Server 2012 on a 2 node Windows cluster and 3 node cluster.

Wipro Technologies, Hyderabad, INDIA Jan2007 – June-2012

Role: SQL SME; SQL Server DBA; Account: Microsoft and BP.

Environment: SQL Server 2005, 2008 R2, 2012.

Responsibilities:

•As a part of PSITOPS team we supported 4000+ Servers with terabytes of data. It was a critical environment where we had Microsoft Operation Manager (MOM 2005 and MOM 2007) alerting system on all the servers. Based on the alerts, the tickets were created and assigned to our queue. The alerts consisted of backups failures, log file full, data file full, cluster failures, replication failures, Log shipping and mirroring issues, blockings, performance issues. This project had huge visibility across Microsoft comprising of director level people. It’s very important to have all the SLA met.

•We have almost met 100% SLAs metrics on daily basis so far with no operational failures. The environment is a complete integration of SSIS, SSRS, SSAS and SQL SERVER 2005, 2008, 2008 R2 databases.

• Performed key role in handling Production database server during peak times.

•Responsible for all database related issue in production servers

•Database Maintenance activities like Backup Monitoring, Database Health Check, Daily jobs monitoring, Indexing, etc.

•Installing, Administering and maintaining High availability solutions like Log shipping, Mirroring, Failover Cluster & Replication.

•Incident Management, Change Management using Remedy

•Weekly/Monthly Maintenance tasks like Patching, installing Service Packs

•Database related issues like T-log full, Disk full, DB Suspect state, recovering corrupt databases, point in time recovery etc.

•OS Related tasks like Rebooting Servers, analyzing Server performance, scheduling Windows Scheduled tasks, troubleshooting production issues using Performance counters, Event Viewer etc.

•DB Performance monitoring using tools like IDERA, Profiler, Performance Counters,

•Implementing Service Improvement Plans like Preparing Monitoring Scripts, Disk space alerts script etc.

•Created technical documents and SIP (Service improvement plans) to monitor the failures.

•Created SQL Server technical documents for the team which was very useful to train the new joiners.

•As there were no 3rd party monitoring tools in this account, we have created SQL Server alerts using the DB mail to check the below issues: -

•Ensure Database Availability

•Verify Successful Database Backup Execution

•Verify Successful Transaction Log Backup Execution

•DISK SPACE MONITORING

•Actively participated in the Disaster Recovery Drills in the weekends (every six months) to ensure that the DR is ready to be switched as production.

•Completed SQL Server 2008 R2 and SQL 2012 Cluster installation.

Achievements:

•Appreciations on preparing Technical documents which was useful for training the new comers in the team.

•Consistently Top performer in all the projects till date.

•Consistently achieved the Targets. Maximum closure on IR’s/tickets.

•Awarded with Thanks a Zillion Certificate and Feather in my Cap Awards for excellent work, dedication, commitment and ownership during volume spike and maintaining the SLA’s.

•Awarded with Feather in my cap award in Microsoft account, BP Account and ORIGIN Energy Account.

•Worked in three different countries/Continents (India, Australia and USA) and various domains like OIL & ENERGY, Banking and Financial, Healthcare, Manufacturing, etc.

Education

•Masters in software Engineering from BITS PILANI. (Work Integrated Course from Wipro)-NOV-2011

•Bachelors in Computer science from Avanti Degree College, Osmania University, Hyderabad, India in MAR-2006

•Microsoft Certified IT Professional (MCITP) in SQL 2005 and SQL2008.

•Intermediate from Board of Intermediate Education.

•SSC from Board of Secondary Education.

Personal Information

•Sex: Male

•Name: Suraj Kumar Kshirsagar

•Contact: +1-650-***-****

•Marital Status: Married

•Date of Birth: 10/13/1985

•Nationality: Indian

•Languages known: English, Hindi, Marathi, Telugu

•Working on H1 B visa in COLUMBUS, OHIO, K-FORCE.

•LinkedIn Address: www.linkedin.com/in/suraj-kumar-kshirsagar-487a3b80

I do hereby declare that the above given statements are true and correct to the best of my knowledge.

Contact this candidate