SUMMARY

• 7+ Years of Experience in installing, configuring, creating, managing, monitoring, and troubleshooting SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014 databases in both Physical and Virtual environments.
• In depth understanding of the SQL Server Query and Relational Engine their components and internal processes.
• Excellent skills in database Backup, Restoration, Recovery, Replication, Mirroring, Linked Servers, Database Maintenance Planning.
• Experienced in investigating and applying necessary SQL Server database Service packs, hot fixes and Security Patches.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Hands on experience with SQL Server security aspects such as creation of users, creation of logins, configuring permissions, assigning roles to users, creating schemas, creating proxy accounts and implementing security certificates.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics, and Index tuning Wizard.
• Proficiency in implementing different types of disaster recovery scenarios like Replication models like Snapshot, transactional, log shipping and Configure Database Mirroring in Cluster Environment.
• Proficient in high level design ofETL, DTSandSSISPackagesfor integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, etc.).
• Extensive understanding and experience on how to identify research and develop solutions to database performance issues.
• Experience with the Incident Tickets, Change Requests and Knowledge management.
• Worked closely with management, applications development staff, and users on database solutions to business problems.
• Actively involved in monitoring system performance by using SQL Profiler, Database Engine Tuning Advisor, and Windows performance monitor, Event Viewer, DMVS, and Resource Governor to achieve better performance.
• Using SQL Server logs/Profiler to solve Blocking, Dead Locks/Long running queries.
• Highly proficient in the use of T - SQL for developing stored procedures, triggers, tables, user profiles, user functions, data integrity, SQL joins and query writing.
• Defined and administered database standards, controls, procedures and documented the same.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Provided after hours and 24/7 Database Maintenance and Production Support.

TECHNICAL SKILLS

Databases: MS SQL Server 7.0/2000/2005/2008/2008 R2/2012/2014, Access.

Database tools: Management Studio, Enterprise Manager, Query Analyzer, SQL ProfilerData Transformation Services, Upgrade Wizard, Replication, Crystal Reports 9.0/10.

Programming languages: SQL, TSQL, XML, C++, C, VB 6.0.

Tools: SQL DB Access, Performance Monitor, Backup Utility, Net Backup, Red Gate, Data Stage 5.0.

Operating Systems: Windows 95/98/Me/XP/NT/2000, UNIX, Windows Server .

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential, Cambridge, MA

Responsibilities:

• Installed, configured, applied latest service packs and cumulative patches (hot fixes) inSQLServer 2008/2008R2/2012.
• Ensured the integrity and security of productionSQLServers.
• Worked on very large databases having terabytes of data.
• Implemented Transactional Replication and Merge Replication, monitored and troubleshooting it.
• MigratedSQLServer 2000/2005 & .
• Find the problems and prepared the documents for problem solving.
• Created Maintenance plan for Back-ups, re-indexing, integrity checking and database shrinking.
• Implemented Log Shipping inSQL2005 from Primary Server to Secondary Server to support disaster recovery solution.
• Worked on Database Recovery Plans and Implementation of the Mirroring inSQLServer 2008R2.
• Responsible for creating, maintaining and monitoring mirrored servers.
• MonitoredSQLServer Performance on regular basis and gather data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• UsedSQLprofiler, system monitor and query analyzer for, monitoring, Optimization, Tuning ofSQLServer, Long running Queries and Indexes.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and ProductionSQLServer databases.
• Captured and analyzed the long running Stored Procedures usingSQLServer Profiler and tuned the same to optimize application and system performance.
• Maintained Change Control, Version Control and Release Management process for all database objects like tables, views, procedures, and triggers.
• Maintained a stable process of database refresh from production to QA/Dev environments.
• Provided 24x7DBAProduction support for more than 2000SQLServer Databases in Production on Clustered and stand alone Servers to achieve Optimum Performance.

Database Administrator

Confidential, Denver, CO

Responsibilities:

• Installed and configured SQL Server 2005, SQL Server 2008 on WINDOWS 2003/2008 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Worked extensively on installation, upgrade and migration of MS SQL Server 2005/2008.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Configuring, Monitoring, and Troubleshooting of Replication and Log shipping.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Worked closely with internal developers to analyze SQL database designs to enhance performance.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, and Point-in-time recovery through RESETLOGS.
• Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.

SQL Administrator

Confidential, Dallas, TX

Responsibilities:

• Responsible for Installation and Maintenance of SQL Server 2005/2008 R2 on Development, UAT and Production Environments.
• Installed SQL Server 2008/2008R2 on windows 2003/2008 servers, Installed service packs and security fix on production, test and development servers.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development.
• Created stored procedures for maintaining SQL Server and did rebuilding of the indexes at regular intervals for better performance.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication, log shipping and SQL Server clustering
• Set up transactional, snapshot replication and maintain the active replication(s).
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• Performance tuning and optimization of Query of SQL server.
• Creating and maintaining user’s logins and Roles.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log.
• Responsible for design, setup, installing and configuring SQL Server 2005 databases, including setting up and maintaining critical databases in Active/Active cluster nodes in SAN Environment. Also, actively involved in system and user audit.
• Developed Stored Procedures, Functions as per the application needs using SQL Server 2005/2008.
• Responsible for Performance Tuning Database Queries, Stored Procedures, Views to improve performance.
• Implemented Transactional Replication and Mirroring with SQL SERVER 2005 and SQL Server 2008.
• Job Monitoring and making sure all jobs run successfully every night.
• Demonstrated expertise utilizing ETL tools, including SQL SERVER Integration Services(SSIS)
• Created and Scheduled jobs, alerts, activity logs, error logs to capture any possible errors.
• Designed and implemented plans to migrate the servers from MS SQL Server 2005 to MS SQL Server 2008
• Handled and supported business users for change requests.
• Performed SQL Server Partitioning of large databases for optimal performance.

SQL Database Administrator

Confidential

Responsibilities:

• Responsible for installing, configuring MS SQL Server 2005 servers and databases, configuration, tuning and provide support to all Test and development servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Reconfigured the default locations of the data files, log files and error log files onto the Client environment for all the servers.
• Worked on Data Migration of SQL Servers .
• Trouble shooting various SQL Server 2005 and 2000 Database connectivity issues from the web applications.
• Provided the Client connectivity of the application firmware to the SQL Servers.
• Configured Log Shipping setup on production servers.
• Backup and restore the Very Large Databases (VLDB) over 5TB.
• Implemented and maintained Transaction replication for high availability and worked on Replication related issues.
• Created Notifications and alerts for replication jobs and out of sync issues.
• Daily periodically monitored maintenance jobs from the mails setup.
• Worked with Development & application teams in the time of Project releases.
• Ensured security logins and database access permissions to the users on time.
• Created and scheduling maintenance jobs in new environments.
• Configured SQL Mail and Database Mail to get automated Alerts in the production Servers.
• Wrote and edited stored procedures, functions and triggers required for Sql agent jobs.
• Configured and altered alert configuration settings for the jobs and issues.
• Periodically (daily, weekly, or monthly) performed a database reorganization on all the indexes on all the tables in all databases to rebuild the Indexes so that the data is no longer logically fragmented.
• Reconfigured Log Shipping and Database Mail after migration.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor for individual application developers.
• Scheduled meeting with team lead and providing issues of the week gone through and challenges if any.
• Provided 24x7 technical supports to the production databases mission critical.