Summary:

• 8 years of experience in Administering and Maintaining the 32bit, 64-bit MS SQL SERVER in Production, Staging, Development and Testing in Clustered and Stand alone Server Environment.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Configured HADR Always ON on SQL Server 2012.
• Hands-on experience with SQL Server 2008 new features like Change Data Capture CDC , Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE .
• Experience in installing MS SQL SERVER 2000,2005,2008,2008 R2,2012 updating with hot fix and service packs
• Implemented Side by Side Migration of MS SQL SERVER 2000/2005 to 2008.
• Experience in Migrating DTS packages to SSIS packages.
• Experience in implementing DISASTER RECOVERY AND HIGH AVAILABLITY concepts like Native Log Shipping, Custom Log Shipping, Mirroring and Replication Snap Shot and Transactional with Updatable Subscriptions .
• Good knowledge on delivering predictable performance, scalability, business continuity, data protection using Microsoft Azure SQL Database and SSDS.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption TDE .
• Managed, analyzed, and mobilized information, using Sybase.
• Implemented SQL Server 2005 concepts like Data partitioning ,Snap shot Isolation, Database Mirroring, Database Snapshot, DDL triggers, try-cache blocks, Online indexing, SQLCMD and dedicated admin connection.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon, activity monitor, Event viewer for performance analysis.
• Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experience in Backing up, Restore the database manually and by Scheduled Jobs.
• Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals logins and Mapping users to roles. Securable and Permissions .
• Have good knowledge on 2014 SQL Server features such as In Memory OLTP engine, Column stored index, Contained databases.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
• Have good knowledge in advancements of MS SQL SERVER 2014.
• Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Have good experience in configuring IIS and XML.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large VLDB and Complex Databases.
• Expertise in analyzing and estimating the Execution Plan for better Query Optimization.
• Extensively used Repositories like Team Foundation Server TFS , Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Extensively worked on different Data-cleansing techniques deduplication, validation.
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in generating Reports SSRS in Business Intelligence Development Studio BIDS .
• Experience in handling Partitioned cubes in SSAS both in star and snow flake schema.
• Experience in creating CUBES in BIDS with Fact and Dimension Tables.
• Worked in OLTP and OLAP environment that includes Production 24x7 , QA and
• development databases in SQL Server.
• Explicitly used third party tools like Litespeed, Remedy, Foglight and Red gate.
• Created linked servers between Oracle 10g and SQL SERVER and also deployed SSIS packages for data transfer.
• Good knowledge of Oracle Database 9i/10g Administration and Creating Pl/sql packages, procedures and functions.
• Worked with a team of business analysts, Project Managers, data architects, application developers, ETL developers and Testing Team.
• Involved in all phases of the SDLC soft ware development life cycle .
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.

Technical Skills:

Professional Summary:

SQL Server DBA

Description: Fifth Third Bank has a rich legacy of community support. In 1948, it became the first financial institution in the United States to establish a charitable foundation. Today, it continues to invest the time, resources and people to help build a better tomorrow in the communities it serves.

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio 2012 , SQL Server Enterprise Manager 2008R2 and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2008R2 databases by In-place upgrade process and Side-by-side Migration from SQL SERVER 2008/2008R2 to 2012. Also used upgrade advisor tool in up-gradation.
• Worked on ALWAYSON 2012 and managed the Disaster Recovery and High Availability solutions.
• Implemented Database Mirroring in SQL Server and participated in Disaster Recovery Drill processes.
• Extensively worked on Log-Shipping for synchronization of Databases.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Migrated DTS packages into SSIS packages.
• Created subscriptions to provide a daily basis reports. Used Reporting Services SSRS to schedule reports to be generated on predetermined time.
• Configured Transactional replication on migrated server.
• Integrating data from different sources and created a central repository of data, a data warehouse DW .
• Have good knowledge on storing, retrieving and managing data by using Column stored index.
• Installing, Configuring and Maintaining SQL Server 2012/2008R2/2008 on Active/Active Clustering with latest Service Packs/Hot Fixes.
• Installed, authored, and managed reports using SQL Server 2008R2 Reporting Services.
• Monitored the performance for the physical and virtual environment using IDERA
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Generated reports in SSRS using BIDS Business Intelligence Development Studio
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection.
• Managed and mobilized information from data centers to the point of action using Sybase.
• Creating and implementing 2008R2 concepts like DMV's, DMF's, Data partitioning, online indexing.
• Configured more than 2 GB ram on 32 bit Environment.
• Tuned stored procedures by adding the try catch blocks for error handling.
• Removed excess indexing by using the index include clause.
• Implemented the online indexing on 24X7 environments.
• Created the documentation for issue diagnostics reports.
• Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
• Involved in DATA Analysis like Analyzing and Accessing collection of Data.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To perform installations performance tuning, manage capacity planning user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.

Environment: Microsoft Windows 2008/2003 Server, Microsoft SQL Server 2012/2008/2008R2.

CONFIDENTIAL

Senior SQL Server DBA

• Description: CONFIDENTIAL government is organized under the City Charter and provides a mayor-council system. CONFIDENTIAL
• has five boroughs which CONFIDENTIAL.
• CONFIDENTIAL government manages many commissions including buildings, finance, law, education, environmental protection and city planning. The project was mainly focused on maintaining the information of their 'Office of Administrative and tribunal hearings' by extracting data from various databases.

Responsibilities:

• Install and configure SQL Server Instances and Management tools using SQL Server Setup.
• Administer SQL Server using Client/Server tools like SQL Server Enterprise Manager and Query Analyzer.
• Create Database Maintenance Plans for the Performance of SQL Server which covering Database Integrity Checks, Update Database Statistics and Re-indexing.
• Complete Back-up and Restore for Disaster Recovery.
• Manage replication servers.
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Databases.
• Data migration import export - BCP from Text to SQL Server.
• Experience with SQL Server Reporting Services SSRS to author, manage, anddeliver both paper-based and interactive Web-based reports.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server.
• Have done reporting and data analysis using Data Warehousing.
• Performed a spot check of the data manually for Data Cleansing.
• Designed ETL packages dealing with different data sources SQL Server, Oracle, Flat Files, Excel Files,and XMLs etc. and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Managed trouble shooting of Client connections, viewing error log and applications.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS Decision Support System for various applications.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• To set up SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Monitoring the servers using spot light third party Quest software.
• Maintaining the database consistency with DBCC at regular intervals

Environment: SQL Server 2005/2008/2008R2 Enterprise, Transact- SQL, Query Analyzer, SQL Profiler, BCP, DTS, MS-ACCESS, Team Foundation Server 2010

CONFIDENTIAL

Technical Database Administrator

Description: Confidential is a windows based Disease Management application tool which integrates accepted medical guidelines into patient management protocols for use by physicians. It provides evidence based health risk assessment, personal and administrative reporting. HealthCare automates and simplifies a set of routine diagnostic, treatment planning and patient tracking functions performed by physicians and their assistants on a daily basis.

Responsibilities:

• SQL Server 2005 64-bit Failover Cluster Installation on Windows Server 2008 x64-bit.
• SQL Server 2008 Installation.
• Writing batch scripts to do automation of database tasks.
• Writing scripts to manage different servers for auditing purpose.
• Running packages as for system promotion requirements.
• Solving Memory Problem related with SSIS Packages.
• SQL Server Analysis Services 2000 installation and Reporting Services 2005 installations on existing SQL Server Instances and SQL Server 2005 installations.
• Performance tuning on different Production Servers.
• Used the data warehousing capabilities of Microsoft SQL Server Enterprise to build faster warehouses, manage growing data volumes, integrate with Microsoft business intelligence products.
• Created and implemented DTS/SSIS Packages for importing and exporting data to other data storage.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Extensively worked on Dynamic Management Views DMV's and Dynamic Management Functions DMF's .
• Running profiler to troubleshoot Blocking issues, Deadlocks issues and Slow running Queries.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Solving memory related problems by changing server configuration settings.
• Rebuilding indexes with different fill factors and update statistics manually.
• Building Maintenance plans for database maintenance.
• Writing stored procedures as for business requirements.
• Used several SSIS control flow and data flow transformations as part of ETL
• Created SSIS Packages to export and import data from CSV files, Text files,Excel Spreadsheets and various other sources to manage translations to Regional Sites.
• Shrinking the data files as the space requirements.
• Effectively used PL/SQL advance features like collections, ref cursors, dynamic sql and bulk loading.
• Managing users and security.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Used Team Foundation Server 2010 for maintaining source control, data collection, reporting, and project tracking
• Involved in Configuration and Administration of Share Point 2007 environment.
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2005/2008/2008R2, T-SQL, Windows 2003/2008 Server, Vb.net,Asp.net, Erwin

CONFIDENTIAL

Senior SQL Server DBA

Description: CONFIDENTIAL is the leading company in manufacturing, development, distribution and sales of computerized gaming equipment, software and networking systems worldwide. The company supports global operations through an extensive sales and distribution network throughout Confidential.

Responsibilities:

• Administrated and Managed SQL Server 2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Migrated In-place and side-by-side SQL Server 2000 databases to SQL Server 2008/2005 databases and mentored other technical staff.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs Dynamic Management Views .
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Deployed SSIS packages with minimal changes using XML configuration file.
• Involved in scheduling, creating snapshots and subscriptions for the reports SSRS 2005/2008 .
• Installing, Configuring and Maintaining SQL Server 2008/2005 64 bit on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Maintained Production and Test Database Environment in SQL server 2008/2005.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file. Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2005/2008, IDERA Management Tools, Windows 2003 Server, MS Visual Source Safe, IIS 6.0, XML.

CONFIDENTIAL

SQL SERVER DBA/Developer

Description: CONFIDENTIAL is a multinational financial information provider founded in 1999. Capital IQ grew very rapidly to become one of the leading providers of software, data and analytics to the financial services community.

Responsibilities:

• Performance tuning of the SQL 2000 servers in order to reduce I/O and Memory contentions.
• Reviewed and offered recommendations for Database system configurations, responsible for tuning data, indexes, and queries as well as providing assistance on these areas to development teams. Troubleshoot SQL Server performance issues for internal and external customers.
• Deployed the SSIS Packages and created jobs for efficient running of the packages. Import/export packages.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Involved in scheduling, creating snapshots and subscriptions for the reports SSRS 2005/2008 .
• Developed SQL Server Maintenance Plans.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup recovery and performance monitoring.
• Writing stored procedures and DTS packages for maintenance tasks in Production environment.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
• Export or Import data from other data sources like flat files using Import/Export of DTS
• Recovering the databases from backup in disasters
• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
• DBA support for a development team customizing and testing new releases of client-server applications
• Analyze various aspects of Stored Procedures and performed tuned as needed to increase productivity and reusability of code.
• Written Tested and Documented Program code and implemented programs.
• Actively involved in hardware and network specification, installation and configuration, and participated in database design, architecture and SQL scripting.

Environment: SQL Server 7.0/2000, Windows 2000, SQL Profiler, SQL Profiler