Summary:

• Over 8 years of Database Design and Development experience on SQL server 2008/2005 SQL Server 2000 in OLTP and OLAP environment.
• Extensive experience with SQL database Administration that includes SQL Server Installation, Upgrades, Disaster Recovery, Capacity Planning, Backups and Recovery
• Extensive experience in various High Availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Good understanding of Microsoft Systems Center Operation Manger SCOM
• Imported and exported data from heterogeneous sources using various techniques like BCP and DTS
• Wrote complex T-SQL queries and Stored Procedures for the reports
• Configured and administered Transactional Replication
• Involved in Capacity Planning and adding new storage space as needed
• Expertise in generating reports using SQL Server Reporting Services SSRS 2008/2005.
• Experience in developing and monitoring SSIS Packages and DTS.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2005
• Expertise with T-SQL in writing complex queries ,triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and maintaining data integrity.
• Experience in Designing the Data models for OLTP OLAP database system.
• Strong Data Modeling experience using ER diagram, Dimensional data modeling,

Logical/Physical Design, Star Schema modeling, Snow-flake modeling using tools like

• Experience with the .NET framework including C , ASP.NET and Web Service.
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial and pharmaceutical environments.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
• Extensive experience with Database Backups, Recovery Procedures, Backup Strategies and Scheduling.
• Involved in 24/7 support model for trouble shooting database and server related activities.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Experience working with ITIL V2 Change Management and Agile development methodologies.

Technical Skills:

Monitoring Tools: Attention, E-health, System-Edge, System central Operation Manager,

Spectrum, Data Fabric Manager Net-app Volumes , Fog-light, Lite-

Speed.

Storage Technologies: Vm-Ware, SAN, NAS.

EXPERIENCE:

Confidential

Role: SQL Server DBA

Responsibilities:

• Responsible for 140 database servers. Support included Production, Test and Development.
• Provided 24/7 support for mission critical systems and resolving performance issues and also was involved in Capacity planning and Architectural review in new projects.
• Performed Sql server installation using both silent and Manual Install.

System Centre Operation Manager SCOM

• Created customize and Authored Management packs using SCOM 2007 according to company standards.
• Tested and Deployed SCOM 2012 Management Packs.
• Tested the new management packs for SCOM according to company standards and documented.
• Created various Dash-boards views and Groups in SCOM for monitoring the database servers across various environments.
• Assisted in Customizing Management Pack for SCOM according to DBA and Company's Standards for Disk related alerts, CPU utilization, Daily Availability Reports, Database related alerts.
• Standardized the alerting system from SCOM to reduce the redundancy and noisy alerts.
• Customized Management Pack for database growth for capacity planning.

Clustering

• Installed and Configured SQL server 2008 active/active clusters on windows 2008 with six-nodes and 4-nodes clustering, High Availability, both in slip stream and Manual Install.
• Upgraded and Configured SQL clusters from windows servers 2003 to windows server 2008.
• Involved in project upgrade for ERP supported Sql servers from Sql server 2005 to Sql server 2008 R2 clustering.
• Supported SQL server databases in ERP, SharePoint, BizTalk applications, Microsoft Dynamics- CRM.

Power Shell

• Deployed and Developed Customized Power Shell Scripts for the quarterly SQL Service Account password change across the Enterprise.
• Automated and customized various processes across the enterprise using power shell scripting for Daily Backup Reports, Newly Created Databases.
• Tested clustered boxes using power shell scripts in various scenarios for Mission Critical Applications.
• Configured SCOM alerting systems for database servers across the enterprise using power shell deployment.

Disaster Recovery

• Involved in Documentation, Designing and performing various Disaster Recovery strategies for critical applications using San-replication, log-shipping, High- Availability.

Log Shipping

• Designed Log-shipping for the disaster recovery planning for the BIZ-TALK BAM and Messaging databases for SQL instance in cluster environment from one datacenter to another datacenter in cross country site using Log-shipping- Multi-Instance Cluster Environment for High-Availability.
• Deployed Log-shipping both in Stand-by and No-recovery mode feature for mission critical applications.
• Created log-shipping for Microsoft SharePoint Content databases using Lite speed for SQL server 2005.

Replication

• Installed and Configured Translation replication for the citrix multi-layer environment in Sql Instance cluster-replication Environment.

Performance Optimization

• Assisted developers in monitoring and modification of SQL query using SQL profiler, Query Execution Plan, Index tuning and Fog-light.
• Utilized tools like Performance Monitor, Resource Monitor, to identify the bottle necks and performance optimization at the Instance and Server Level.
• Involved in Datacenter Migration projects with regard to SQL server databases.
• Monitored and Modified performance
• Installed and Performed proof of concept for SQL server 2012, according to company standards in san-box environments, and implemented in other environments.
• Utilized and Configured Resource Governor to manage the SQL Instance server workload in Multi Instance Environment and System management.

Patchingcycle

• Developed, Created, Customized automated patching schedules activity using Database and Middleware automation for deployment of SQL service pack upgrades and cumulative updates.
• Authored and Assisted in preparation of Standard Operation Procedure for DBA SQL team.
• Designed and executed Large Scale Migration of MS SQL 2000 and MS SQL 2005 production database environments to MS SQL Server 2008 R2 and MS SQL Server 2012.
• Develop database Best practices and security access policies utilizing Microsoft best practices.

Data Analytics.

• Successfully managed Extraction Transformation and Loading ETL process by pulling large volume of data from various data sources using SSIS.
• Worked with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Conversion, Term Extraction, Conditional Split, Derived Column, Pivot etc.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Deployed Policy Based Management practices and Data Collector parameters for the Critical Systems in the Enterprise for SOX systems and Federal Audited systems.
• Deployed different SSIS packages on development and test environments.
• Procedural Life-cycle-Management for database servers on legacy environments for possible upgrades.
• Actively participated in agile development process including SCRUMS, development sprints and project scoping.
• Co-ordinate various activities across the Infrastructure teams for process improvements.

Environment: SQL Server 2005/2008, 2012, Cognos, .NET Framework, Visual Studio 2005, ASP.NET, ADO.NET, WINDOWS 2000/2003, SSRS, SSIS, SAN, Net-AP, Vm, Power Shell.

Confidential

Role: SQL Server DBA

Responsibilities:

• Provided support to 60 database Servers. Support included Production, QA and Development
• Upgraded databases from 2000 to SQL 2005 and SQL 2008
• Installed and Configured SQL Server 2005/2008 on Stand-Alone and Active/Passive clusters on Windows 2003.
• Provided 24x7 support
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
• Created and Authored Management packs using SCOM.

Performance Optimization

• Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes.

ETL Deployment

• Developed SSIS packages to transform data between various data sources
• Developed reports using SSRS
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
• Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.
• Imported and exported data from heterogeneous sources using various techniques like BCP and DTS
• Wrote complex T-SQL queries and Stored Procedures for the reports
• Configured and administered Transactional Replication
• Configured Certificates and keys to configure Data Encryption in SQL 2005.
• Involved in Capacity Planning and adding new storage space as needed
• Configured Linked Servers.

Data Modelling

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Managed Security by creating login/groups and assigning appropriate permissions
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers.
• Provided Secondary Support to IIS Web Servers.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues
• Prepared Documentation for database, procedures and views

Environment: SQL Server 2005/2008, Cognos, .NET Framework, Visual Studio 2005, ASP.NET, ADO.NET, WINDOWS 2000/2003, Erwin.

Confidential

Role: SQL DBA/Developer

Responsibilities:

• Managed the complete migration of SQL Server 2000 databases to SQL Server 2005
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created SSIS Packages to import xml data daily from Web services to SQL Server and to export database updates back to Web Services in xml format
• Provided organizational reporting and timely reports utilizing SSRS SQL Server Reporting Services
• Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and snapshoting via SharePoint User Interface.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data
• Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.

Data Modelling

• Analyzed existing logical data model LDM and made appropriate changes to make it compatible with business logic.
• Created Physical Data Model PDM for the OLTP application using ER Studio.
• Created Data Models using IDEF1X methodology.
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Worked at conceptual and physical using IE methodology database level to implement and build corporate enterprise information strategies.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.

Administration

• Managed Query Optimization and Performance Tuning of Stored Procedures, Functions etc
• Managed production servers with multiple databases, with a couple over 3 terabytes both in clustered environment with mirroring and replication
• Wrote triggers After and Instead Of and stored procedures to capture updated and deleted data from OLTP systems.
• Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard.
• Implemented Log Shipping and Transactional Replications as part of disaster recovery plans.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases
• Scheduled jobs for backup, and created alerts for error reporting.

Environment: SQL Server 2005/2008,SSRS 2008/2005,SSIS 2005,SSAS, T-SQL, ODBC, Excel, Access, Windows 2000/XP, IIS 5.0

Confidential

Role: SQL Server DBA

Responsibilities:

• Provided support to 75 database Servers. Support included Production, QA and Development
• Worked on Migration from SQL Server 2000 to 2005
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
• Wrote complex T-SQL Scripts for generating reports
• Wrote stored procedures and designed triggers
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output
• Worked on OLAP and OLTP
• Interacted with development and testing team
• Importing and exporting of Databases using various techniques like BCP, DTS
• Analyzed and Installed Security patches as required

Environment: SQL Server 2005, .NET Framework, ASP.NET, ADO.NET, WINDOWS 2000/2003

Confidential

SQL Developer

Responsibilities:

• Designed databases for OLTP applications
• Created tables, indexes and constraints.
• Created Triggers, Stored procedures for implementing the business logic.
• Managed Database files, transaction log and estimated space requirements.
• Configured and monitored database application.
• Designed and implemented several complex reports
• Managed ongoing activities like importing and exporting, backup and recovery.
• Administered of all SQL server database objects, logins, users and permissions in each registered server.

Environment: SQL server 2000, Visual Basic 5.0, Win NT.