SUMMARY

• 8 years of experience as Database Administrator, Developer in Production, Development and Testing Environments.
• 24/7 On Call Support for Production server
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non - Clustered environments wif single and Multi Instances.
• Strong working knowledge wif 32 and 64 bit Windows 2000/2003/2008 servers.
• Experience in migrating the databases from SQL Server 2000 to SQL Server 2005/2008/2012.
• Extensive experience in Upgrading SQL Instances using Side by Side and In-place Upgrade.
• Experience in scheduling Backups, Restore and Maintenance plans using Native and Third-party tools (Lite Speed)
• Experienced in using different Recovery models Simple, Full and Bulk-logged depending on Application requirement.
• Experienced in high availability solutions wif SQL Server Failover Clustering, Database Mirroring in (Synchronous and Asynchronous modes).
• Implementing high availability wif AlwaysOn Availability Groups and failover clustering
• Experienced in implementing Log shipping and Replication (Snapshot, Transactional and Merge Replications)
• Experienced in Installing, Configuring, Developing and Deploying SSRS using local, scale out and scale up Topologies.
• Experience in Designing, Developing, Testing and Deploying SSIS packages.
• Experience in creating and automating jobs, alerts, and SQL Mail Agent and SSIS packages in SQL Server.
• Experience in analyzing execution plan, me/O statistics, index tuning for SQL queries.
• Good skills in optimizing the performance of the database and running Database Consistency Check scripts for databases.
• Creating Linked Servers for OLEDB Databases.
• Extensive experience wif data modeling, logical and physical database design.
• Experience wif establishing and maintaining security integrity controls.
• Solid experience wif creating alerts, schema management, database reorganization, data loading.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues.
• Experience in Performance Tuning Query Optimization, Client/Server Connectivity, and Database consistency checks using DBBC utilities.
• Worked in development environment, wif knowledge of Query estimation, Index tuning wizard and database Optimization techniques.
• Hands on experience wif SQL Server and T-SQL in constructing triggers, joins, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Implemented Third party tools Litespeed, IDERA SQL compliance, SQL Diagnostic manager, SQL solutions deadlock detector, Redgate SQL Compare for schema comparison, SpotLight performance monitoring and performance improvement.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.
• Personally explored on new deprecated features of SQL Server 2014 over 2008 and 2012.

TECHNICAL SKILLS

Languages: T-SQL, HTML, XML, C/C++.

Operating Systems: Windows 2000/2003/2008/ XP/VISTA/7

Databases: MS-SQL Server 6.5/7.0/2000/2005/2008/2012, MS Access

ETL Tools: Data Transformation Services, SSIS

DB Utilities: SQL Server Management Utility, Query Analyzer

Third party Tools: SQL DB Control, Red gate, Lite Speed, Idera, Quest, SQL Solutions Etc.

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MD

SQL Server DBA

Responsibilities:

• Responsible for installation and maintenance of all the SQL Server 2005/ 2008 R2 /2012 SP2 CU5 servers wif the design, document, development, enhancement and support of MS SQL Server databases.
• Involved in Architectural design for the databases and database tables and capacity planning.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, security TEMPprincipals and AAG.
• Handling Memory configurations for SQL Server 2012 on Windows 2012.
• Responsible to assign permission to user(s), role(s), and object. Support column level permission and Administrate security for server’s logins (Windows and SQL Accounts).
• Recently managed data security for Government data project and implemented new features of MS SQL Server 2008R2/2008 such as Backup Compression and Transparent Data Encryption (TDE).
• Creating master keys, certificates, enable data encryption and Maintain safe backups for encryption certificates.
• Involved in setting up the SQL Server Integration Services (SSIS) and SQL Data Transformation Services (DTS) for data migration and Extracting and Transforming data between different servers.
• Implementing and administrating Transactional replication as disaster recovery solution
• Configure, maintain and troubleshoot replication for databases as large as 40 TB.
• Implemented methodologies such as making changes to the distributor properties, subscription stream parameters etc., to improve the latency of heavily replicated articles.
• Prepared scripts for manual configuration replication both by snapshot and by database refresh.
• Troubleshooting log reader latency issues, distributor latency issues, data consistency issues while replicating deferred updates.
• Prepare and notify the management about daily status of replication and latency
• Taking schema only backups and refresh the databases wif schema, compare schema on the databases and finding out the abrupt changes
• Developed new database Maintenance plans which involves Create statistics, Update statistics, rebuilding the Indexes, Database Integrity checks for all the newly built SQL Server 2008 R2 servers.
• Performed all aspect of database administration, including backup, recovery and Log Shipping for SQL 2008 R2.
• Identifying and analyzing deadlocks investigate the statements and provide suggestions to developers.
• Design and schedule jobs regarding reclaiming space in a timely manner for better performance of the servers.
• Monitor the indexes fragmentation status and schedule the reorganize and the rebuild jobs accordingly.
• Experience in scheduling Backups, Restore and Maintenance plans using Native & Third-party tools (Lite Speed)
• Migrating DTS Packages into SSIS using Upgrade Advisor and DTS Designer.
• Rebuilding the Indexes at regular intervals for better performance.
• Tuned SQL queries and Stored procedures using SQL Profiler.
• Experienced in implemented Log shipping and Replication (Snapshot, Transactional and Merge Replications)
• Involved in the performance fix deployments, new code deployments, Migration of the servers, Rebuilding databases.
• Provided on-call support for performance activities such as data purging and operations processing and maintenance tasks.
• Work wif Microsoft support to troubleshoot disk related performance issues and unidentified abrupt system shutdown issues.
• Provided suggestions for Implementing default server level MAXDOP setting that improved query runtime.
• Involved in the troubleshooting application access issues / application slowness issues. Worked and resolved deadlock issues that caused timeout errors.
• Involved in database and log backups & restoration, backup strategies, scheduling.
• Backing up master & system databases and restoring them when necessary.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work wif technicians from other departments.
• Spontaneously responding to the tickets assigned to me and fixing any database issues and working on projects that me have been assigned to as a resource from the Database Management team.

Confidential, Charlotte, NC

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2) on Test, Development and Production Environments.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
• Experience working wif TSM Backups and Restore.
• Disaster Recovery Planning, Testing and Analyzing and continuous update of documentation.
• Implemented Always-ON (AAG) on SQL Server 2008 R2
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Creating Logins and Roles wif appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Configured Database Mail for failure Job notifications
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler
• Worked wif database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
• Experience working wif IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Worked wif DTS Packages to load data into Data Warehousing System.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Extensively worked on performance issues like Update statistics and Autostats
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Optimized the database server usingDMV’s and DMF’sand performed acode reviewandtuningfor the best performance of the application.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Mentored team members to optimize SQL Queries.

Confidential, Milwaukee, WI

SQL Server DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005)/(2008), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases wif clustered and stand-alone environment
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Integrated SQL traces wif Perfmon log to have better graphical analysis to find system bottlenecks.
• Implementation of SQL Principal, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Encrypted data and log files using transparent data encryption (TDE) solution.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Provided support to application team by analyzing/ Resolving slowness issues. Provided suggestions to rebuild indexes, create non-clustered indexes on Temp tables, suggested developers to use query hints like ‘NOLOCK, MAXDOP’ etc..
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008 on the server and client machines, provide connections and manage databases.
• Create and maintain various databases for Production, Development Servers using MS SQL Server 2005/2008.
• Planning the location of data, indexes, and Transaction log files on the disk.
• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency.
• Resolve locking and blocking issues.
• Experience in memory configuration for SQL server on 32-bit boxes
• Tuning the Production server to get the performance improvement.
• Running Index tuning wizard for optimal query performance.
• Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery
• Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Experience working wif SQL Solutions tool in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Providing 24*7 support to SQL application developers in implementing the applications on production server.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation
• Maintaining both DEVELOPMENT and PRODUCTION Servers in sync.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created the SSIS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in Performance Tuning for source databases, target databases.

Confidential

MS SQL Server Developer/DBA

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2000 and 2005 in development and production environments.
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins wif permissions in SQL Server 2005 as per the developer’s request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between SQL server 2000 and 2005 servers.
• Involved in Migration from SQL Server .
• Created Database Diagrams using ERWin Data Modeler.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Involved in the creation of cubes in the MS SQL Analysis Services.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designed and implemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Involved in resolving dead lock issues and performance issues.

Confidential

SQL Server Developer

Responsibilities:

• Installation and configuration of MS SQL Server 2003/2000/7.0
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Involved in Optimization and normalization of database and tables.
• Involved in conceptual and physical modeling of data using ERWin tool.
• Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
• Part of team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Responsible for transferring of database and database objects from Development to Production Server using DTS.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.