Sql Server Software Engineer

MCTS - SQL SERVER **** DATABASE ADMIN

Microsoft Certified Database Administrator with 8+ yrs. of rich and

extensive experience in Developing, Designing, Deploying and Managing

Databases and Business Intelligence Solutions using MS SQL Server

2000/05/08, DTS/SSIS, SSAS and SSRS

DATABASE SKILLS & CORE COMPETENCIES

MS SQL SERVER 00/05/08 BACKUP & RECOVERY DATA SECURITY

SSIS (ETL Tool) SSAS (Data Warehousing) SSRS (Reporting)

Performance Tuning Query Optimization Failover Clustering

Replication Database Mirroring Server Monitoring

MDX Queries Log Shipping T-SQL Programming

PROFESSIONAL EXPERIENCE

1. TRICORE SOLUTIONS - Managed Services 2011 - Till Date

. Working with over 30 Direct Clients and 750+ Database Servers on

Different Platforms.

. Serving as Primary DBA for 4 Dedicated External Clients and assisting

them in Setting up their Database Servers from scratch.

. Install & Configure Database Servers, Related Features and Service

Packs / Hotfix.

. Planning & Implementing High Availability Strategies, Setting up

Cluster nodes, DB Mirroring, Log Shipping, Backup & Recovery and

Replication

. Extensive Automation & Monitoring for Database Down, Ping Failures,

Backup Audit, Disk Space, Job Failures, Blocking, Long Running Queries

and many others.

. Deploying & Managing SSIS ETL packages and Maintenance Plans.

. Troubleshooting, Performance Tuning & Detecting Bottlenecks (CPU, IO,

Memory etc.)

. Recommending & Following Best Practices, Performing Server Audit &

Health Checks.

2. YASH TECHNOLOGIES (US Experience - H1B) 2008 - 2011

CLIENT: VERIZON, IRVING, TX

. Served as Lead DB Admin responsible for maintaining 10 Active/Active

Production Clusters and 8 Development and QA Servers on Cluster.

. Supervised & Trained new hires for project as well as technical

requirements.

. Improved overall data processing time & Performance by 75% with large

volume of data.

. Authored complex code and ETL packages for transforming business

requirements.

. Mentored & Completed crucial Initiatives having high visibility from

top management.

. Responsible for Onshore-Offshore knowledge transfer, team management

and business Requirement gathering from Direct Clients.

. Planned Disaster-Recovery Strategies that guaranteed High

Availability.

. Migrated the entire system having terabytes of data, numerous servers

and databases.

. Enhanced End user reporting and decision making experience by

designing complex Multi-Dimensional Cubes (SSAS) and Reports (SSRS).

CLIENT: HEALTHCORE (BCBS), WILMINGTON, DE

. Delivered Fast Service to meet customer satisfaction and fulfill their

requirements.

. Created Complex workflow using SSIS package for consolidating data

from 26 different data sources with different formats converging into

single database.

. Accelerated the whole development life cycle starting from requirement

gathering, analyzing, developing, testing and deployment.

. Configured E-Mail Alerts and Triggers, Implemented Try/Catch for Error

handling and optimized Indexes for overall performance.

. Developed and Automated Customized Reports for pre-defined user needs

and analysis.

3. BIRLASOFT (INDIA) 2007

CLIENT: CREDIT SUISSE

. Served as Senior Software Engineer responsible for developing database

solutions, Troubleshooting and Data modeling

. Learned and Implemented Reconciliation Solutions on INTELLIMATCH, a

well-known Bank Reconciliation tool. Compares large volume of bank and

trading transactions.

. Followed SOX Compliance and kept 7 years of data online requiring high

performance tuning and online software development lifecycle approval

and implementation process.

. Dealt with moving large volumes of data between servers and generating

reports

4. VERIZON (INDIA) 2004-2007

. Served as Senior Database Analyst for various high visibility and

crucial projects.

. Awarded on numerous occasions with Pat on Back Award, Spot Award,

double promotion and achievement awards.

. Travelled twice to US on B1 visa for Knowledge Transfer, Training and

Client Meetings.

. Evolved as a well experienced MS SQL SERVER database admin with proven

ability to implement complex solutions, client interaction and

mentoring new hires.

. Learned various database techniques like Server Activity Monitoring,

Using SQL Profiler, Execution Plans and querying system views for

retrieving relevant information.

EDUCATION AND CERTIFICATION

. Masters Of Computer Application - Madurai Kamaraj University, Tamil

Nadu, INDIA

. Bachelors of Commerce (Honors) - Delhi University, Delhi, INDIA

. MCITP - Database Administrator 2008

CORE STRENGTHS & HOBBIES

. Possess Good Communication, Technical and Leadership Skills.

. Ability to work well under pressure.

. Nature and Kids Photography is among my interest

. Trading in Stocks and Reading new investment ideas is other hobby

of mine.

Contact this candidate