SUMMARY

• 8+ years of experience in Database Administration for Very large and complex databases in SQL Server 2012, 2008R2, 2008, 2005, 2000 and SQL Server 2014 installation.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Excellent understanding of SQL Server architecture and Database storage structure.
• Experience in implementing Business logic by using T - SQL (DDL, DML), stored procedures, triggers and user defined functions (UDF).
• Well experience in analyzing Performance, Query optimization and tuning, creating Indexes, writing stored procedures.
• Experience in identifying the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans.
• Solid experience and outstanding knowledge on High availability (HA) & Disaster recovery solutions (DR) - log shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive)
• Handful experience in installing SQL Server 2000, 2005, 2008 & 2008R2, applying service packs and patches on stand-alone and Cluster Environment and Configuring.
• Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and, Update Statistics to check Data Integrity.
• Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
• Experience in performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement.
• Proficient with Database Recovery models.
• Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.
• Experience in SQL Server up gradation from SQL Server 2000 to SQL Server 2005 and (Side by Side and in place) in 32bit to 64 bit architecture.
• Experience in moving system databases and user databases when needed.
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Having Extensive knowledge in Clustering at both Windows and SQL Server levels and maintenance.
• Experience in using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL Lite Speed, Commvault for performance Fog light for alerting ID era.
• Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Experience in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services.
• Experience in Administrating Windows Server 2003\2008\2008R2.
• Configured IIS in Windows server 2003
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

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

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

Databases: MS-SQL Server 2014/2012/2008 R 2/2008/2005/2000

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS).

Reporting Tools: SSRS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Red gate, Lite Speed

PROFESSIONAL EXPERIENCE

Confidential, Washington, D.C.

Sr. SQL server DBA

Responsibilities:

• Installed and configured SQL Server 2008R2 on new Servers, and Installed SQL Server 2008, 2005 and 2000 service packs with latest hot fixes.
• Involved in Implementing 2008, 2008 R2 active-passive clustering on Windows 2008 Operating system with consolidated environment of three SQL server versions 2008/2005 and 2000.
• Involved and set up of SQL Server 2008 Mirroring on production servers.
• Involved in Migration of the Server SQL Server, SQL Server and DTS to SSIS, and involved in SAN Migration for the SQL server 2000 and 2008 Servers.
• Maintained servers with multiple instance of SQL Server 2000, 2005 and 2008 with 24 CPU having 100 GB Memory.
• Configured Mirroring with Transaction Replication with principle and mirror at publisher.
• Implemented Snapshot, Transactional, and Performed mirroring as Disaster Recovery Solutions.
• Transactional replication, adding articles, and configuring with Mirroring.
• Involved developing and implementing jobs for SQL server, and involved in various production releases.
• Configured the RAID levels for data files, log files and TempDB at server level.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers and Online indexing.
• Responsible for transferring packages using SSIS and transferring SQL Server Objects from QA to Production Using SSIS Packages.
• Deployed Reports on Report Server.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Planned the Complete backing up of Database and Restoring the Database from Disaster Recovery.
• 24 X 7 Production Database on Call Support

Environment: Microsoft SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, Management Studio, OLTP, Query Analyzer, BCP, Profiler, T-SQL.

Confidential, NYC, NY

Sr. SQL server DBA

Responsibilities:

• Installed and configured SQL Server 2008R2 Instances on both cluster and stand-alone environment.
• Estimated data growth from past years history and allocated SAN Space. Managed gigantic databases across the multiple disks on SAN using the file groups.
• Databases migrated as backup restore and loaded table’s data using SSIS packages.
• Created backup strategies based on database size and scheduled Maintenance plans, automated DB refresh jobs in Test & Development environments.
• Responsible for daily routine activities backups, updating stats, refreshing databases as per requirements.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Configured and managed log shipping between DC and DR servers for Disaster recovery solution.
• Configured Database Mirroring with high performance and high availability mode.
• Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle, Teradata and SAS using third-party RDBMS driver tools.
• Involved in SQL Server Hardening.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Monitored the event logs and server logs for troubleshooting and problem solving
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms
• Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Installed and configured SSRS. Deployed RDL files on report server and managed report’s security.
• Implemented enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS), RAID levels.
• Responsible for SSIS, SSRS package executions and availability.

Environment: MS SQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows server 20 bit, OLTP, Business Intelligence Development Studio - SSIS, SSRS, Performance Monitor

Confidential, Roanoke, Virginia

SQL Server DBA

Responsibilities:

• Monitor SQL Servers for High availability such as Replication, Mirroring and Clustering.
• Build, installed, configured and supported SQL Server 2012/2008 database servers clusters.
• Migrated and Documented SQL Server 2008 R2 to SQL Server 2012.
• Install Microsoft Service Packs/Patches/Hot fixes
• Review and implementation T-SQL code changes for new production release.
• Help developers in Query tuning and improve performance of Stored Procedure.
• Co-ordinate with off-shore DBA's for day-to-day administration of live SQL Servers.
• Use Stored Procedures, SSIS packages, BCP for ETL.
• Design and implement Security policy for SQL Server and Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Use database level triggers for database consistency, integrity and security.
• Resolve Memory pressures, CPU pressures and I/O issues, caused during product releases.
• Work with customers on Application rollouts and server migrations.
• Troubleshoot performance problems and fine-tuning of databases.
• Rebuild the indexes and statistics at regular intervals for better performance.
• Work extensively in profiler and Extended Event for tuning queries using variable for characteristics and query costs, Logical read and Duration
• Monitor and modified T-SQL Performance using execution plans and Index tuning.
• Query Optimization and Performance tuning for T-SQL queries and stored procedures.
• Work in Clustered/non-Clustered Column Store indexes for OLAP performance on SQL Server 2014 and SQL Server 2012.
• Monitor and resolve issues SQL Server maintenance Jobs and Business batches.

Environment: SQL Server tools (Extended Event, Profiler, DTA, SSMS, SSCM, PerfMon, DMVs, system stored procedures), Windows 2012/2008, MS SQL Server 2014/2012/2008, T-SQL, BCP, SSAS, SSIS, SSRS, Powershell 3.0, Database upgrade advisor, Windows Event Viewer, Idera SQL diagnostic Manager.

Confidential, Cincinnati, OH

SQL Server DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2000), 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 also used upgrade advisor tool in up-gradation.
• Migrated DTS packages into SSIS packages.
• Configured Transactional replication on migrated server.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2008R2.
• Installed, authored, and managed reports using SQL Server 2008R2 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Managed trouble shooting of Client connections, viewing error log and applications.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Database mirroring, database snapshot, DDL triggers, online indexing, DMV’s, DMF’s, SQLCMD and dedicated admin connection.
• Worked on enhancing the application specific data sources and added new fields according to the requirement.
• Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
• 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.
• SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain Plan, Auto trace, TKPROF and tuned them to suit SLA.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• 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.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development,, QA, and production SQL Servers databases.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows bit, SQL/PL SQL, SSIS, Profiler.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Managed and Administrated SQL SERVER 2008 on highly transitive Production environment and Installed and setup SQL Server 2008 instances on clustered environment.
• 24x7 production support SQL server 2008 Database administration
• Implemented SIDE BY SIDE Migration of MS SQL SERVER on Windows.
• Implemented Transactional Replication on MS SQL server 2008 as a part of disaster recovery strategy
• Applied Service packs and patches and hot fixes on clustered nodes
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented the new SQL Server 2008 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks, Online Indexing, DMV’s, DMF’s, DTA,SQLCMD and dedicated admin connection, Common table Expression(CTE).
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Managed multiple MS SQL 2008 RDBMS on Web-based, transactional platform
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Documented and performed the data base health checks regularly.
• Created new tables, stored procedures and triggers IN T-SQL.
• Refactored and fine tuned the queries and stored procedures in TSQL.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio)
• Used SSIS packages to move data from dev to QA and QA to Production
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment: TSQL, MS SQL SERVER 2008,SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

• SQL Server 2005, 2008 and 2008R2 installations, configuration and security settings for Prod/Non Prod servers.
• SQL Server upgrade with service packs and hot fixes in server environment.
• Maintaining/Creating logins/users and giving permission to them as per request.
• Maintaining Best Backup strategy
• Scheduling Jobs and Maintenance plans.
• Monitoring the Backups and Recovery Jobs.
• Verifying all instances are up and Running.
• Handling database and file movement activities.
• Creating and Maintaining scheduled jobs and implementing automation for tasks.
• Handling blocking issues and troubleshooting accordingly.
• Performing file movement in prod servers on weekly basis.
• As per hardening measure, changing system/user databases default location.
• Configuring / maintaining high availability SQL Server solutions that include Mirroring.
• Using log shipping for synchronization of database.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Involved in troubleshooting, resolving data performance monitoring issues.

Environment: SQL Server 2005 with clustering, T-SQL, Windows 2003 Server, Oracle, VB.Net and ASP.Net.

Confidential

SQL Server DBA

Responsibilities:

• Normalized and De-normalized the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Configured SQL Server 2000 Environment.
• Involved in database design, development of database Tables, Roles, Users and Views in SQL Server.
• Design and Creation of logical storage (Table spaces, Segments etc.).
• Designed E-R Diagrams, logical and physical data modeling.
• Interacting with business users in getting the reporting requirements.
• Used FTP and SCP for keeping important files safe and secure.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database.
• Created tables, indexes, stored procedures and functions.
• Developed and integrated code for enhancement of the application.
• Responsible for optimizing the queries and application tuning.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Developed custom reports using Microsoft reporting Services.
• Optimization of the SQL queries to meet the performance requirements.

Environment: Windows, SQL server, T-SQL, Query Analyzer, Data Transformation Services.