Candidates About

                                                                                                                                                                                                                                        

                                                                          Suraj Kumar Kshirsagar

Sr. SQL Server DBA,

SUMMARY

11years 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 Consultant. Below are the detailed synopsis:

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

·         Provide 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

·         Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

·         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.

·         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.

·         Through knowledge on High availability like windows/SQL Clustering, Replication and Mirroring.

·         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.

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

·         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.

·         Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations

·         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.

Professional experience

COMPANY: KFORCE Inc. Client : JP Morgan Chase, COLUMBUS, OHIO                    AUG-2017 – Till date Role: Sr. SQL Server Database Management Analyst Environment: SQL Server 2005, 2008 R2, 2012, 2014 and 2016.

Responsibilities:

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

·         Experience implementing advanced features in SQL Server including, but not limited to, Snapshots, mirroring, and clustering.

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

·         Excellent documentation and technical writing skills.

·         Solid experience to setup and support SQL Server Mirroring, Log Shipping, Mirroring/log forwarding, Clustering and other methods of disaster recovery

·         Microsoft DBA Certification.

·         Thorough day to day experience on maintenance of critical SQL Server 2000, 2005, 2008, 2008 R2, 2012 and SQL Server 2014 databases.

·         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.

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

·         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.

·         Installing 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.

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

·         Backups/restores, DBCC, reorgs & update statistics

·         Solid experience in database migration from one platform to another, patching, upgrade, data loading, security, capacity planning, performance monitoring and tuning

·         Ability to analyze traces, debug stored procedures, triggers and package

·         Experience in database design and some logical modeling knowledge

·         Solid understanding of Windows operating system, LDAP and Active Directory

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

·         Demonstrate good written and verbal communication skills in English language

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

·         Excellent time management and organizational skills

·         Demonstrate 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

•                    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 and Always ON(Combination of both Mirroring and Failover Clustering)

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

•                    Incident Management, Change Management using HPSM tool.

•                    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, 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.

•                     Experience 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                            NOV-2013 –AUG-2015 Role: Lead SQL Database Consultant Environment: SQL Server 2005, 2008 R2, 2012, 2014

Responsibilities:

•                    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.

•                    Installed SQL Server 2008 R2 on a 2 node Windows cluster.

 

Company : Wipro Technologies Client : Westpac Banking Corporation, SYDNEY, Australia                         SEP-2012 –NOV-2013 Role: SQL Server Project DBA Environment: SQL Server 2005, 2008 R2, 2012.

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.

•                    Followed change management system for all the planned activities scheduled on PROD, DR, TEST and DEV servers.

•                    Followed the process for BMC Remedy change management system for Change approvals by attending CAB meetings and convincing change managers.

•                    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, indexing etc.

•                    Installing, Administering and maintaining High availability solutions like

•                    a) Log shipping

•                    b) Mirroring

•                    c) Failover Cluster

•                    d) 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 Profiler, Perf Counters,

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

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

•                    Experience in Light Speed Backup Tool and IDERA diagnostic manager

•                    Monitoring the CPU, Memory utilization on servers.

 

Wipro Technologies, Hyderabad, INDIA                                                         Jan2007 – June-2012 Role: SQL SME; Sr 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

•                    Monitor database and transaction log file sizes.

•                    Check the database log for errors

•                    Verify the DB is set up for email notification and is operational.

•                    Check for any Cluster related error

•                    Replication Sync Status

•                    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: