SUMMARY

• 8+ years of experience with the analysis, design, administration and implementation of 32 - bit, 64-bit Microsoft SQL SERVER in clustered and Standalone Server Environment.
• Experience installing MS SQL SERVER 2000,2005,2008,2008 R2 and 2012 updating with hot fix and service packs.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Proficiency in implementing different types of disaster recovery scenarios like Replication models like Snapshot, transactional, log shipping and Configure Database Mirroring in Cluster Environment.
• Expertise in trouble shooting database issues like space issues, dead locks/Blocks & performance.
• Expert knowledge on SQL Server 2014 on features like AlwaysOn Availability Groups, Backups and restores on cloud, updateable columnstore indexes and encrypted database Backups.
• Experienced in SQL Server 2008 Database development, including: Management Suite, SQL Profiler, QueryAnalyzer, Database Tuning advisor T-SQL and Stored Procedure and Trigger development.
• Extensive experience and knowledge of Backups and Restore, indexing, performance tuning and security .
• Extensive experience with DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, Alerts, DTA,SQLCMD and dedicated admin connection.
• Experience with SQL Server 2008 features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Perform data/database/process consolidations or warehousing as coordinated with applicable internal staff.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Created Linked Servers between SQL Server 2005 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Developed and tuned SQL Server Integration Services packages and reporting services (SSRS) reports and models.
• Expertise in Migrating large number of DTS packages to SSIS Packages.
• Excellent in high level design of ETL, DTS Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations provided by SSIS such as Aggregate, Data Conversion, Conditional Split, Bulk Insert Fuzzy Grouping, Fuzzy Lookup and Merge.
• Experience in Creating Report Subscription, Data Driven Subscription, Report Snapshots and caching, linked, cascaded and parameterized reports, complex drill down reports using SQL Server reporting services. Configuring and maintaining Report Manager and Report Server.
• Strong analytical and troubleshooting expertise, attention to detail, and dedication to support production under tight schedule.
• Coordinate with all levels of management and application development teams on implementations and change.
• Work with business and IT customers to retire out of date, one-off environments, and migrate into shared infrastructure.
• Very Strong Experience with OLTP and OLAP Environment.
• Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Database administration: MS SQL Server 2012, 2008, 2005, 2000, 7.

Operating System: Windows 2008/2005/2003/2000 Advanced Server, NT.

Languages: T-SQL, C, C++, VBScripts, HTML

Database Tools: SQL Profiler, Database tuning advisor, Index analyzer

Tools: Performance Monitor, SQL Lite Speed, Visio, ERWIN, Capacity Manager,Red Gate (SQL Compare & SQL Data Compare)

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, Illinois

Senior SQL Server DBA

Responsibilities:

• Administered, maintained, and monitored 56 Production SQL Server 2008 Databases across 8 Servers located physically and DBaaS.
• Performs day to day database system administration, including: daily checklists, backup verification, log review, security maintenance, performance tuning (analysis, indexing, updating statistics, etc...).
• Participated in data mart requirements gathering sessions, recommendations done for SQL Server Physical vs DBaaS, created architecture diagram, coordinated on setting up of DBaaS instances for Data warehousing group.
• Worked on Data Encryption - TDE on SQL Server databases as per the requirements.
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server databases.
• Extensively worked on Dynamic SQL Scripts to fix orphaned users, database backups, dropping temp tables etc.
• Implemented Powershell remoting and script execution. performance tuning and testing on stored procedures, indexes, and triggers using Database Engine tuning advisor and SQL server profiler.
• Manage DB objects (like tables, indexes, stored procedures, triggers, views, functions etc) health using all different types of DBCC commands.
• Created users and roles for login/group login authentication and validating permissions.
• Implemented full and differential backups and transaction-log backups
• Checking T-Log growth in a regular basis.
• Scheduling backups and automating weekend maintenance tasks (Re-indexing, update statistics) by setting up SQL Server Agent jobs.
• Writing scripts to perform database refresh, database health checks.
• Partition the database by creating the new file groups and moved large tables for high performance.
• Migrated new domain acquisitions into the existing enterprise Microsoft Active Directory domain.
• Performing Query Optimization using SQL query execution plan.
• Run the SQL Profiler to identify the Dead Lock issues.
• Involved in Configuring and monitoring 2-way Transactional and Snapshot Replication, database capacity issues and other production related issues.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Designing and implementation of database backup maintenance and recovery procedures.
• Performed monthly and daily DBA tasks according to the Company’s administration norms.

Environment: SQL Server 2008 R2, Windows Server 2008 R2, .NET Framework 3.5, Powershell, Business Objects, SSIS, Microsoft Visio.

Confidential, New York, New York

SQL Server DBA/Developer

Responsibilities:

• Created, Administered, maintained, and monitored Production SQL Server 2008 Databases across 3 servers, additional 6 servers presented for creation for Business Objects reporting environment and 6 servers for web form environment.
• Installation of SQL Server 2008 R2 on Windows Server Clustered environment.
• Created, modified and maintained SQL server installation and configuration documents.
• Upgraded/Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases and mentored new DBAs and other technical staff.
• Lead Disaster Recovery efforts for the Intranet and Extranet environments, tested, updated and reviewed document detailed disaster recovery plans for business critical SQL Servers
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Managing and resolving database space issues with the help of capacity manager.
• Installing and configuring Quest Litespeed on Production and Test environments.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.
• Application support for front end feeds and resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and monitoring transactional replication, Database mirroring and log shipping on Production and QA servers.
• Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
• Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Rebuilding, Reorganizing and partitioning the indexes on regular intervals and placing the huge table/non-clustered index on the separate file group to improve the performance.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Implement procedures to maintain SOX compliance audit for business critical applications.
• Configuring SQL Server settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Used Online Indexing and online Restoring in SQL 2005.
• Worked on administering Oracle Databases on security features like configuring Privilege and Role Authorizations of database users.
• Coordinate with all levels of management and application development teams on implementations and change.
• Work with business and IT customers to retire out of date, one-off environments, and migrate into shared infrastructure.
• Lead Disaster Recovery efforts for the Intranet and Extranet environments.
• Provide regular feedback to individual contributors.
• Supported 24 X 7 Production environment.

Environment: SQL Server 2005, SQL Profiler, Index Tuning Wizard,Powershell, SSMS, BIDS, Red Gate Tools (SQL Compare and SQL Data Compare), Oracle 11g, Teradata V13.10, Business Objects, Litespeed backup utility, SQL MultiScript, Capacity Manager.

Confidential, St Louis, MO

SQL Server DBA

Responsibilities:

• Identifying all the SQL Server across the environment using Idera.
• Installing and configuring SQL Server 2008 R2 to migrate several databases from SQL Server 2000/2005 as part of consolidation of SQL Servers.
• Installing and configuring lite speed engine.
• Retiring and decommissioning unused SQL databases as part of reducing cost and improving efficiency.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning and Snapshot Isolation.
• Setting up database maintenance plans as part of standardization of SQL Servers.
• Implementing Database mirroring as High availability method to meet the application requirements.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Created, deployed and managed reports using SQL Server Reporting Services(SSRS).
• Installed Red Gate SQL Compare and Data Compare tools to compare synchronize databases.
• Design and implement security features and policies.
• Work with business and IT customers to retire out of date, one-off environments, and migrate into shared infrastructure
• Coordinate with all levels of management and application development teams on implementations and changes.

Environment: SQL Server 2008, Red Gate Tools (SQL Compare and SQL Data Compare), Lite speed backup utility, SQL MultiScript, Capacity Manager.

Confidential, Torrance, CA

SQL Server DBA

Responsibilities:

• Migrated SQL server 2000 to SQL Server 2005 in Microsoft Windows Server 2003 R2 Enterprise.
• Extensively used Red Gate tool to compares and synchronize SQL Database Schemas.
• Worked on 24 instances of SQL server with around 350 databases of SQL.
• Handled up to 1.5 TB Size databases with clustered and Log shipping environment.
• Involved in data modeling and maintenance of data models using Erwin.
• Maintained Log Shipping and Perform DBCC commands for database consistency.
• Scheduling backups (full, differential backups and transaction-log backups) and automating weekend maintenance tasks (Re-indexing, update statistics) by setting up SQL Server Agent jobs.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Performance tuning and testing stored procedures, indexes, and triggers using Index Tuning Wizard and SQL server profiler.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues and explaining them about database design, database connection issues, data integrity etc
• Worked in Huge (Transactional) Replication and Active-Passive Cluster Environment.
• We handled lot of production issues like data correction and resolves error handling.
• Checked the configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc.) to avoid and optimize.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Compared Database Objects using Red gate Tool for schema Changes, Data changes during Up gradation Process from Development to Production Servers and SQL lite Speed for Monitoring.
• 24 X 7 on Call Support.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, .XML, Microsoft Visio 2003, SFTP, SQL Server Reporting services (SSRS), JAVA,J2EE,RED GATE, Power Designer.

Confidential

SQL Developer(Internship)

Responsibilities:

• Involved in complete SDLC which includes requirement gathering, analysis, design, development, Implementation.
• Actively involved with the front end .NET developers as a part of a team for gathering and analyzing User Requirements.
• Modified existing database to fit new business requirement by adding tables and relationships to support Customer Information System system.
• Worked extensively with SQL Server DBA group in the execution of SQL Scripts on production and QA Servers.
• Trouble shooting and minimized production issues.
• Created T-SQL, PL/SQL packages, procedures, functions, triggers, alerts, scripts for automation and DTS packages for ETL.

Environment: SQL Server 2000, Oracle 8i, Informatica, C#, Ms-Access, Windows Server 2003, PL/SQL.