Sql Server Data

JIMMY KAPOOR

A-***, Anmol Apts, Plot *A Sector-* ● Dwarka ● ND 110075

● Mobile: +91-981-****-*** ● **************@*****.***

Profile

13+ solid years of experience in Operations (Dev-Ops, App Support and SQL Database Administration) within different domains; Service, Financial, Healthcare and Insurance industry.

Proven history of improving operations and increasing profitability (reduced man hours by automating and making repeatable processes to achieve expected results) by targeting the noise making alerts/ tickets within L3 space.

Planned and successfully executed 41 service improvement plans in last three years alone.

Ability to troubleshoot performance issues, setup/ troubleshoot merge replication and setting-up of high availability solutions from Microsoft and HP technologies for mission critical applications.

B.Sc by education, I have 13+ years of professional experience in varied roles in IT from MS Developer, BAU MS SQL to Sybase DBA and getting involved in people management.

Excellent interpersonal, technical and analytical skills to positively contribute to org’s bottom - line.

Related Experience

Mar 15 to Present

Consultant, Wipro Technologies (Catholic Health Initiatives Support) Hyderabad, India

Dec 12 to Feb 15

Sr. DB Advisor, DELL Services (Hilton and AMO Leveraged Support) Noida, India

Aug 11 to Nov 12

Sr. DB Advisor, DELL Services (Client : HPHC,Boston, MA) Boston, MA, US

Jan 11 to Aug 11

Sr. DB Advisor, DELL Services ( AMO Leveraged Support) Noida, India

Mar 09 to Dec 10

Sr. DB Advisor,DELL Services (Client : HPHC, Boston,MA) Noida, India

Feb 08 to Feb 09

DBA Lead, DELL Services (Client : MIVA,UK & US) Noida, India

As a DB Lead am responsible for keeping business critical applications up and running. To achieve this a certain time and effort is put in application readiness so that business critical periods don’t have any/ minimum downtime.

Bringing transparency to service engineering, am responsible to project application(s) health in a consistent graphical manner using tools like SSRS/ power pivot which will look into Web, SQL and Application aspects of Apps. Graphical representation gives our leadership confidence at a glance, related to systems.

Am responsible for defining processes for testing application availability, be it vertical BVTs or processes to alert L3 teams of SQL which are taking more resources than expected, hence making it easier to identify the issues (if any), whenever they occur.

Activities (Accountability and Ownership):

Design and Execution:

a.Designed Performance analysis best practice and scalable white paper for different application(s), this was used to automatically call an application green or not.

b.Process to call out an Issue/ alert in terms of problem statement, business impact, root cause, future course of action to avoid it from re-occurring and follow up in RR

c.Process to track and follow up on the outcome an incident. Keeping stake holders informed about the progress till technical root cause analysis completed.

d.Documented SQL jobs, tasks, windows & web service with a business impact, define priority and plan of action within alert email for L3 team(s) to react quickly.

e.Helped improve Organization level Channel Partner Expectation (CPE)

i.Put up a process to check erroneous emails sent to end customers through Email application managed by my team which had a huge dollar impact.

ii.Put a check/ alert to identify long running/ stuck SQL jobs, help improve flow of data from upstream and downstream applications

iii.Identified most business critical events and prioritize them over others, huge dollar impact

iv.Made sure we implement ONLINE operations for weekend maintenance jobs to cause minimum/ no disruptions

f.Responsible for defining best practices and training peers for renewing security Certificates and passwords across all applications in our org.

g.Responsible for categorization and reconciling ticket data to understand the top noise generators and mapping them with KB articles and bugs to get them prioritized.

h.Determine the SQL Server Installation options. Install SQL Server Management tools using SQL Server Setup Program in a Cluster Mode. Test the Installation of SQL Server.

i.Fine tuned stored procedures and added / changed tables for data load and transformation, and data extraction.

j.Optimized SQL queries for efficiency and provided queries and procedures for the front-end application.

k.Used Bulk Insert to copy data from text file to SQL Server. Maintaining the data, database backups & restoration, backup strategies, scheduling backups.

l.Modified and normalized existing procedures tables. Designed and developed client specific distributed and partition views.

m.Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

n.Configure SQL Mail, Database Email and SMTP Email on SQL Server.

o.Ensure data integrity across systems, working closely with other reporting sections

p.Assist developers in building and reviewing Stored Procedures

q.Successful migration of applications from DB2 to SQL Server.

r.Worked on DB2 users so that connectivity between DB2 and SQL Server can made.

s.Ability to train and mentor team members on new and existing processes/technologies.

t.Experience in customer handling, support escalations.

u.Involved in incorporating 50+ applications in remedy so that in case of any issue or failure and it generates ticket automatically and assign the same to concerned team.

Building cohesive team(s):

1.Envisaged the idea of having one outlook calendar and email respective person for birthdays and org anniversaries.

2.Created a team of equally passionate people who would pulse the floor and give positive canned feedback to have sustainable processes with less burn outs.

July 07 – Feb 08

Infrastructure Team Lead, DGM India Internet Marketing Pvt. Ltd, Gurgaon, India

DGM is a leading internet marketing company. We provide search engine optimization, a comprehensive online advertising network, a leading UK affiliate marketing program and pay per click (PPC) campaign management; helping advertisers, publishers and agencies achieve their ROI (Return on Investment) objectives.

Our online marketing products and services are managed and delivered through talented teams that result in a direct and quantifiable return on our client’s online marketing investment.

We specialize in three core areas of online marketing: online advertising, search engine optimization and affiliate marketing.

Determine the SQL Server Installation options. Install SQL Server Management tools using SQL Server Setup Program in a Cluster Mode. Test the Installation of SQL Server.

Fine tune stored procedures and added / changed tables for data load and transformation, and data extraction.

Optimized SQL queries for efficiency and provided queries and procedures for the front-end application.

Used Bulk Insert to copy data from text file to SQL Server. Maintaining the data, database backups & restoration, backup strategies, scheduling backups.

Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Configure SQL Mail, Database Email and SMTP Email on SQL Server.

Ensure data integrity across systems, working closely with other reporting sections

Assist developers in building and reviewing Stored Procedures

Excellent management in database backup, merge and transactional replication, Log Shipping MS clustering, Poly Serve, mirroring and database snapshots

Extensive Experience using ETL tools like Data Transformation Services (DTS), and hands on experience in SQL Server Integration Service (SSIS).

Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.

Activities:

Liaising with the London technology teams to understand and define the strategic directions of the technology solutions

Liaising with the trading team and application support to understand their requirements, prioritize and deliver directly to the application support.

Building strong relationships with various stakeholders in technology and business

Automated the database refreshes and user security thereafter in Dev and UAT from Production systems in the form of Web based applications.

Managing log shipping and replication related issues on day to day basis.

Introduced best practice to push user scripts in production systems.

Involved in Disaster Recovery testing for mission critical applications.

Involved in capacity planning, building fresh SQL 2000, 2005 and 2008 servers for upcoming applications.

Proactively managing log space on production systems so that weekend maintenance activity (re-indexing and consistency checks) shouldn’t fail

Weekend work mainly covers patching production systems for SP4 and SP3 + CU9.

Started with the on-call TSI model to have/ cover 24X7 support

Sep 06 – Jun 07

Sr. Database Consultant, Outline Systems Inc and RMS India Pvt. Ltd, Gurgaon, India

Oct 05 – Sep 06

Sr. DBA, WNS Trinity (Client : FMFC, Tucson,AZ), Gurgaon, India

Apr 04 – Oct 05

SQL DBA, Birla Soft (Client Side: GE SBI, Gurgaon), Noida, India

Sep 00 – Oct 03

SQL DBA, Datamation Pvt. Ltd (Client Side: GE SBI, Gurgaon), Noida, India

Skills and Certifications

C++, C, MS SQL 6.5, 7.0, 2000, 2005, 2008 & 2012, Oracle 11i, MYSQL, Sybase, PostgreSQL, DB2

GREEN BELT (SIX SIGMA) Trained.

Microsoft SQL 7.0 & 2000 Admin. Certification.

Microsoft SQL 7.0 & 2000 Implementation Certification.

Microsoft SQL 2005 Certified

Microsoft SQL 2008 Certified

Microsoft SQL 2012 Certified

Agile Methodology Trained

Certified in operations frameworks such as ITIL 3.0

HADOOP Administration Trained.

Achievements

Challenge/ Context

Action taken

Impact on Company

Multiple times the maintenance jobs were not run successfully causing performance dips

Prepared SSRS report for Database Health-check activities and action taken

Performance degradation windows reduced by 10%

There was a big risks with manual analogue tape backups to complete

Scripted Daily Backup Report validating completion& DB free Space

Allowed business to invest in new backup technology

During ETL refreshes customers were concerned with timeouts at the user interface.

Generated packages for First time load,

Incremental Inserts & Updates. Reengineered reporting database with transactional replication.

User interface had no longer timeouts as web connections at the time of refresh were directed to offline report

Application support had inconsistent experiences while pushing the approved script to production

Introduced best practice to push user scripts in production systems using SQLCMD

Daily/ emergency deployments were in production in record time enabling 5-6hours/ week saving of DBA effort and time.

During Migrations Dev team had lot of challenges to get latest production objects

Automated database refreshes and user security thereafter in pre-prod using User Interface.

Another 8-10hours/ week of DBA time saved as the UI pointed to latest backup

Performance issues during the business week due to less free space not allowing weekend maintenance job to complete.

Managed log space to grow on production systems by 10%

Able to support growing business volumes with minimal performance dips.

Performance issue while loading flat file from multiple clients resulting old data goes for collection (10-14 hrs for data load)

Monitored the database for month and invested new hardware with RAID 10 to get read/write benefit in equal ratio

As an achievement data load goes within 2 hr and appreciated by client and resulted in Dollar benefit as collection data comes in sync.

Education

B.Sc in Science (Full Time) from Rani Durgavati University, Jabalpur in 1999

2 yrs Diploma in PGDCA from India Education Centre, Jabalpur in 2000

Contact this candidate