PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in Installation, Configurations, Implementation and Administration of MS SQL Server 2012/2008/2005/2000 in Production, Test and Development Environments.
• Experience in upgrading MS SQL Server 2005/2008/2008 R2 to MS SQL Server 2012
• Experience in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization
• Experience in creating Tables, Views, cursors, stored procedures, functions and database triggers.
• Experience in SQL server 2008\2008R2\2012 clustering. Active - Active and Active-passive.
• Experience in SQL Server 2005\2008\2008R2\2012 Replication and mirroring.
• Experience in SQL Database\Server\Instance\Cluster upgrade and migration.
• Excellent Experience in applying SQL server patches, hot fixes, cumulative updates and service packs in clustered and non-clustered environments
• Implemented Side by Side Migration of MS SQL SERVER 2000/2005 to 2008.
• Experience in Migrating DTS packages to SSIS packages
• Experience in providing 24x7 Production support.
• Experience developing and monitoring ETL Packages and DTS packages using SQL server Integration Services (SSIS), developing reporting solutions using SQL Reporting Services (SSRS).
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (Bulk Insert, BCP, DTS and SSIS).
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages based on Business or application needs
• Experience in migration of Data in Excel, Flat file and Teradata to and from MS SQL Server by using SQL Server SSIS
• Hands on experience with focus on Database design and Development using different tools of ER diagram, Normalization techniques, T-SQL (DDL and DML) Coding and installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008/2012 in Windows Environment.
• In-depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables.
• Very good in implementing security, configuring subscriptions for SSRS reports.
• Extensive experience in Database Designing such as Logical and Physical Data Modelling using Erwin and Microsoft Visio.
• Experience in using Performance Monitor/Profiler to monitor and solve performance issues like long running queries. Good experience with Execution plans and optimizing the queries.
• Experience in implementing database consistency checks using DBCC Utilities.
• Experience in creating packages, jobs, sending alerts using SQL Mail and customized extended procedures.
• Having nice experience of monitoring client servers using SCOM/Redgate/BMC Remedy (system center operation manager) tool.
• Connecting remote SQL Servers as Linked Servers and Adhoc SQL Functions like Openrowsets.
• Advanced understanding of SQL Server Disaster Recovery (DR) requirements, capacity planning, MS SQL Clustering, Performance tuning and maintenance plan set up.
• Experience in Data Migration Management.
• Hands on experience with Database Engine Tuning Advisor, creating and rebuilding Clustered and Non- Clustered Indexes.
• Installation and configuration of Microsoft SQL Server. Involved in creating Linked Servers between SQL Servers and other Heterogeneous environment
• Experience in migrating packages from DTS to SSIS.
• Experience in maintenance of Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Experience in Database Backup and Recovery procedures.
• Experience in implementing different types of Replication models like Snapshot and Transactional and Merge.
• Good at implementing Log Shipping and Database Mirroring.
• Experience in Code Optimization and improving efficiency in databases including indexing, Recompiling Stored Procedure, user defined functions and performing other maintenance tasks.
• Involved in SQL server Clustering (Active/Passive Clustering).
• Good team player, optimistic, strong interpersonal and communication skills.

TECHNICAL SKILLS

RDBMS: SQL Server 2000 - 2012, Oracle 9i/10g, MS Access, MS Excel, MYSQL

Business Intelligence Tools: SSIS, SSRS.

Development Tools: Data Migration Visual Studio (2003 - 2013), Visual Basic 6.0 MSDTS, SSIS, BCP, Data Migration, Import/Export Wizard

Languages: C, C++, SQL, PL/SQL, C#, VB. MS Visio

Web Technologies: HTML 5, Javascript, jQuery, Web Services

Web Servers: IIS 5.0 - 7.0

Version/ Source Control Tools: TFS, VSS, CVS SCOM, Idera SQL Diagnostic Manager, BMC Remedy, SQL Nexus

WORK EXPERIENCE:

Sr. Sql Server DBA

Confidential, Dallas, TX

Responsibilities:

• Actively involved in scrum meetings for requirement analysis, task analysis, progress discussions
• Used agile methodology for software development.
• Experience in Resolving the Memory contentions using SQL Min/Max Settings, SQL 2012 Resource governor and Lockpages In Memory settings, PageFile settings, Memory related DMV’s
• Identify deadlock, blocking scenarios and Perform Reindexing and Index defrag operations for the maintenance of large tables to resolve performance issues.
• Controlling Database Server file system management for data storage capacity and authority on SAN and RAID levels.
• Backup and recovery of production databases (using 3rd party tool Litespeed) on daily /weekly basis to ensure data integrity, striping the backups to ensure easy backup management.
• Perform database monitoring data and log growth, Jobs, Alerts, disk usage and cleanups, using various custom scripts in SQL Server Agent jobs, setup of Database Mail /operators for alerting.
• Database Design -reviewing\approving database designs before moving to production
• Database Code - reviewing\approving database code before moving to production
• Production Performance - reviewing production performance metrics to determine if\how changes are needed to prevent issues. Work with Tech services Database administration as needed.
• Application\Database Tuning- Proactively reviewing database specific application code (e.g. stored procedures, packages, etc.) to ensure optimal application and database performance. Work with Tech services Database administration as needed.
• Database Production\QA Turn support - responsible for creating, documenting &coordinating all Production\QA turn scripts via the Turn Center, and non-scripted changes with Tech Services Database administration. (e.g. SSIS Packages)
• Database Test Turn support - responsible for creating, documenting, coordinating, communicating and executing turns for stored procedure, tables, views, DTS packages and SSIS packages for Test.
• Database Data Loading - data loading through application code, DTS packages, SSIS packages, BCPing, FTping, or exports
• Database Data extracting - data extraction through application code, DTS packages, SSIS packages, BCPing, FTping, or exports
• Database archiving\purging - responsible for determining what data should be archived\purged.
• Database Size - Maintaining space requirements for Database and monitoring for change
• Generated stored procedure using OPEN XML clause to update the database. It accepts input parameter as XML which serialized from business object and it also uses FOR XML clause to return XML as a dataset and data access layer de-serialize into business object

Environment: T-SQL, PL/SQL, MS SQL Server 2008R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP.

Sr. Sql Server DBA

Confidential, Miami, FL

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Ability in developing XML applications using Open XML standards.
• Served as DBA in the completion of implementations, managing projects from business requirements analysis to solutions delivery and support.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment:SQL Server 2008 R2/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

SQL Server DBA

Confidential

Responsibilities:

• Performed daily tasks including backup and restore by using Tivoli TDP, SQL Server Management Studio.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved scheduling of jobs to re-index and update statistics in databases.
• Experience in using DMVs for finding out long running queries
• Troubleshooting and resolving day to day issues such as Job failures, Transactional log issues, Database full, Blocking and deadlock issues, Permission issues etc.
• Performed data Extraction, Transformation and Loading (ETL) between systems using SQL tools such as SSIS.
• Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008.
• Designing and creating databases for Testing, Development, Pre-production and Production environment.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Integration services SSIS.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, SSIS, SSRS, SSAS, .net, VB and, RedGate, Lightspeed & Tivoli TDP as backup utilities, Ticketing tool – Manage Now.

SQL Server DBA

Confidential

Responsibilities:

• Extracted data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization on SSIS, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and DW areas, troubleshooting process issues and errors.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Cooperated with DBA team to create Scheduled Jobs to run the SSIS packages.
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Created partitions and designed various storage modes to increase the performance of cubesusing SSAS.
• Created Data-driven Packages in SSIS 2008 as part of the automating the process for the Referral Process.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modelling process.
• Assess the risks and recommend/ install service packs or hot fixes when needed.

Environment:SQL Server 2005 and SQL server 2008, SSIS, SSAS, Import and Export tools, SQL Server Agent, MS Access, and T-SQL.

SQL Server Consultant

Confidential

Responsibilities:

• Installation, configuration and maintenance of the MS SQL Server 2008.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Performed the database clean-up tasks.
• Scripting the database consistency checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Conducted performance monitoring and tuning using SQL Profiler and windows performance monitor.
• Performed installation, administration, configuration and development upgrades from 2005 to 2008.
• Creating and editing the database objects (tables, relationships, trigger, store procedure, and user define functions) by using DDL.
• Editing the data in the database system by using DML.
• Environment: MS SQL Server 2008, MS Visual Studio, MS Visio, SQL Server Integration Service (SSIS), SQL
• Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), MS Visual Studio, Windows Server 2003/2008.

Environment: SQL Server 2008/05/00, Windows 2003, 2008, SSIS, SSRS, SSAS, .net, VB and, RedGate, Lightspeed & Tivoli TDP as backup utilities, Ticketing tool – Manage Now.