SUMMARY

• Senior MS SQL Server Database Administrator with Seven+ years of experience managing SQL Server in PRODUCTION, DEVELOPMENT, QA and UAT environments
• Expertise in Managing PRODUCTION Databases on MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 in VIRTUAL and PHYSICAL environments.
• Expertise in ACTIVE/ACTIVE and ACTIVE/PASSIVE Clustering
• Experience in Setting up AlwaysON availability groups
• Experience in implementing Disaster Recovery (DR) and High Availability Solutions (HA) using Database Mirroring and Log Shipping.
• Provided 24/7 and On - call Support for PRODUCTION environment
• Expertise in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database Designing and Query Optimization.
• Extensive use of PowerShell Scripting.
• Expertise in VMWARE and managing multiple SQL Server Instances on Physical and VMWARE
• Hands on experience in implementing SNAPSHOT,TRANSACTIONAL and MERGE replication
• Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL Backups
• Used third party tools like Redgate, SQL Litespeed and Netbackup for Backups
• Used IDERA, FOGLIGHT and SQL Sentry for Monitoring and Performance tuning
• Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server 2008 R2
• Expert in performance tuning SQL Server using PROFLER, QUERY EXECUTION PLAN and INDEX TUNING WIZARD
• Extensive use of SQL Server DMV's for Performance Tuning.
• 5+ years experience in SSIS/SSRS
• Created heavy duty SSIS packages and deployed the packages from development to different environments
• Worked heavily on SSIS transformations and layed out strong SSIS packages
• Expertise in MS SQL Installation, Migration, Upgrade, Configuration & Maintenance of multiple SQL server environments.
• Performed Capacity Planning, Data Modeling and Logical/Physical database design.
• Performed Logical/Physical Modeling and Reverse engineering with ERWIN and VISIO
• Strong experience in performing database consistency checks and planning and scheduling Recovery Procedures.
• Experience in developing and managing Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Locking.
• Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility and efficiency.
• Experience in resolving Database Performance, Capacity and Distributed data issues.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer and scheduling jobs with SQL Server Agent and SQL Profiler.
• Created extensive reports using SSRS ( Tabular, Matrix)
• Experience working with Very Large Databases (VLDBs) and Good knowledge of RDBMS and Data Warehouse concepts.

TECHNICAL SKILLS

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

Operating Systems: Windows 2000/XP/Vista/2007/Windows8, VMware

ETL Tools: SQL Server Integration Services (SSIS), INFORMATICA, SQL Server DTS

Other Tools: Microsoft Visual Source Safe, IDERA, Redgate, Foglight, Sentry

Data Modeling Tools: Erwin, Microsoft Visio 2007

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, SSRS Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers

PROFESSIONAL EXPERIENCE

Confidential, Fulton, MD

Senior SQL Server DBA

Responsibilities:

• Worked primarily as a PRODUCTION support DBA giving 24/7 Support on SQL 2012/2008 R2
• Worked on Migration Project to migrate SQL Server from Lower Version to Higher Version
• Migrated SQL Server from SQL Server 2008R /2014
• Managed OLTP, DSS applications/databases in Physical and Virtual Environment
• Worked extensively on Virtual and VMware Environments.
• Worked on managing SQL Server Environment in High Availability(HA) and Disaster Recovery(DR)
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Managed Production environment for High Availability in Active/Active and Active/Passive mode
• Worked on AlwaysOn availability groups and replicas for reporting, backup and performance
• Installing and Configuring SQL Server 2014/2012 AlwaysON availability groups for high availability
• Involved in Monitoring Performance of different production servers.
• Worked on PowerShell Scripting
• Maintained various databases for Production and Testing using SQL Server 2014/2012/2008 R2.
• Planning the location of data, index and Transaction log files on the disk.
• Performance tuning and optimization of procedures and queries.
• Extensive use of SQL Server DMV's for Performance Tuning.
• Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes.
• Worked on creating SSAS cubes and laying out SSAS designs
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Created extensive SQL Server Integration Services (SSIS) packages for ETL. created database logical/physical modeling with ERWIN
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Heavy migration using SSIS, DTS and Data Integrator.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: SQL Server 2014/2012/2008 R2, VMware, Virtualization, AlwaysOn SSAS, SSIS, SSRS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2012, ERWIN, LiteSpeed Backup, IDera Diagnostic Manager

Confidential, Washington, DC

Senior SQL Server DBA/Developer

Responsibilities:

• Managing Production SQL Servers on VIRTUAL and PHYSICAL environments
• Installing and Configuring SQL Server 2005/2008/2008 R2/2012.
• Supporting the business 24/7, maintaining 99.999 uptimes depending on the application and business SLA requirements.
• Involved in upgrading SQL Server 2005 instances to SQL Server 2008 R2
• Involved in database design, database standards, T-SQL code reviews.
• Configured Active/Active and Active/passive SQL Server Clusters.
• Implemented Mirroring and Log Shipping for Disaster recovery
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Scheduled package execution in SSIS
• Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created extensive reports using SSRS ( Tabular, Matrix )
• Configured transactional and snapshot replication and managed publications, articles.
• Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level.
• Maintained database response times and proactively generated performance reports.
• Automated most of the DBA Tasks and monitoring stats.
• Responsible for SQL Server Edition upgrades and SQL Server patch management.
• Created a mirrored database for reporting using Database Mirroring with high performance mode.
• Created database snapshots and stored procedures to load data from the snapshot database to the report database.
• Involved in data modeling for the application and created ER diagrams using Erwin and VISIO.
• Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Trouble shooting and supporting all user problems by using SQL server profiler, network traces, Windows logs etc.
• Migrated DTS Packages to SSIS Package.
• Monitored event and server error logs for troubleshooting.

Environment: MS SQL server 2005/2008 R2/2012, Windows 2003/2008 R2, Enterprise Manager, Query Analyzer, SQL Server Profiler, SSIS, SSRS, Erwin, VISIO.

Confidential, Charlotte, NC

SQL Server DBA

Responsibilities:

• Installed SQL Server 2008 in production, test and development environments.
• Managed servers in Clustered, Mirrored and Log Shipping environment
• Managed SQL Servers in Virtual and Standalone environments for OLTP and DSS systems
• Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
• Designed and implemented database changes.
• Reviewed and tune up SQL queries, stored procedures, views and triggers.
• Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
• Help in-house developers improve performance of their stored procedures, TSQL codes and database design.
• Managed health of SQL Servers including backups, restores and monitoring.
• Provide a working model of transaction processing environment for capacity assessment and planning.
• Developed a methodology for the ongoing assessment of database performance and the identification of problem areas.
• Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.
• Provided technical support during the development, design enhancement and implementation of production databases.
• Worked with the transaction processing area to develop both the physical and the logical database administration functions.
• Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Worked with vendors in evaluating and implementing new technologies.

Environment: MSSQL Server 2005 and 2008, MS Windows Server 2003, 2008, SSIS, SSRS.

Confidential, Radnor, PA

SQL Server DBA

Responsibilities:

• Responsible for Query optimization and Performance tuning.
• Rebuilding of indexes to improve data retrieval performance
• Managed Microsoft Clustered SQL Server 2000 and 2005 environments.
• Involved in Migration from SQL 2000 to SQL 2005.
• Managing server logins, database users and permissions.
• Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Used the SQL server integration services (SSIS) as a part top transfer logins from SQL server and to move data from one server to another server.
• Configuration and Administration of IIS 6.0, Windows 2003 server.
• Created the Database Objects like Tables, Views, Functions, Stored Procedures and Triggers.
• Managing security tasks like granting and revoking permissions

Environment: Windows Server 2000/2003, VMware, SQL Server 2005, Windows 2003, DTS, T-SQL.

Confidential

SQL Server DBA

Responsibilities:

• Database Administration for Development, Test and Production servers with MS SQL Server 2005 on Windows 2000/2003.
• Administered MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring user accounts, creation of groups, granting the privileges to users and groups.
• Created DTS package to export and import data from SQL Server to Access, text and excel files.
• Checked performance tuning, indexing and query optimization.
• Used database consistency checks using DBCC utilities.
• Implemented Snapshot Replication and Transactional Replication.
• Developed administrative tasks of SQL Server of performing daily backups and recovery procedures.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.

Environment: Windows Server 2000/2003, MS SQL Server 2005/2000, XML and Erwin.

Confidential

SQL Server DBA

Responsibilities:

• Database Administration for Development, Test and Production servers with MS SQL Server 2000/2005 on Windows 2000/2003.
• Created backups for databases.
• Involved in Performance tuning.
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system with ERWIN.
• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Designed physical data models.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created DTS package and schedule the jobs for batch processing.
• Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it

Environment: Windows Server 2000/2003, MS SQL Server 2005, 2000 and Erwin, Stored Procedure, Views, Triggers.