SUMMARY:

• More than 7 years of experience as SQL DBA on Windows 2003/2008/2012 servers.
• Extensive experience in installation, configuration and administration of SQL Server 2005/ 2008/2012/2014 on premise and virtual
• Implementation and administration of Windows Failover clustering installation, configuration
• Maintaining database in a 24X7 VLDB environment and round - the-clock database operations
• Implemented a point in time recovery plan
• Created and configured database mail
• Used perfmon counters, profiler trace, dmvs’ and SSMS for performance monitoring, tuning and query optimization
• Created and maintained indexes
• Resolved DB integrity issues using DBCC commands
• Sizing new and replacement database servers
• Responsible for data security and Integrity
• Created partitioning schemes, functions and file groups
• Administer SQL Server Agent jobs, operators, and alerts using Red-Gate and DPA
• SQL DBA activities include but not limited to patch installs, backup and recovery of mission critical databases
• Supported over 65 SQL 2008/2012 servers and 128+ databases 1+ Terabyte in size
• Import and export data (Prod to Test, Dev to Test, Dev to Prod)
• In charge of migrating databases from SQL Server 2008 to SQL Server 2012 and 2014
• Setup and manage Distributor, Publisher, and subscriber on separate servers for Replication
• Implemented and maintained AlwaysOn, Log shipping and Database Mirroring
• Deploy and troubleshoot SSIS packages and SSRS reports
• Hands-on experience to troubleshoot and resolve day-to-day problems encountered using statistics updates, Index rebuilding/reorganizing
• Experience writing TSQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables

TECHNICAL SKILLS:

Databases: MS SQL Server 2014,2012, 2008,2008 R2,2005

Programming: Visual Basic 6, HTML, TSQL, OOP, Data Structure, Algorithms

Operating System: Windows 2003/2008/2008 R2/2012/2012R2 Server, NT & Windows9x

Other Software: VMware, Hyper-V, Crystal Report, VISIO2003/2010, ER Studio

Tools: DPA (Database Performance Analyzer), Red-gate

Network Topologies: TCP/IP, DNS, DHCP, FTP, SMTP, HTTP

PROFESSIONAL EXPERIENCE:

Confidential, Chantilly, VA

Database Administrator SQL

Responsibilities:

• Performed server installation and configurations for SQL Server 2012 and SQL Server 2014.
• Performed installation of SQL Server Service Packs.
• Upgraded databases from SQL Server 2000 to SQL Server 2005 to 2008 R2.
• Migrated sql databases, jobs, and other objects from 2008 to 2012, created maintenance plans for backup, tested applications that use the database and brought the new database online.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard and Red-gate backup tool (SQL Backup) for Databases of size greater than 1 Terabyte.
• Setup backup and restoration jobs for development and QA environments.
• Created and managed transactional replication for articles used by various reporting applications.
• Implemented disaster recovery solution at the remote site for the production databases using AlwaysOn Availability groups.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used Index tuning advisor to redesign and create indexes for better performance.
• Fine-tuned Stored Procedures and ad-hoc queries using Execution Plan in T-SQL for better performance.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate roles and object level permissions.
• Used SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate/Import data from various data sources, creating packages for different data loading operations for application.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from the development team before releasing them into the Production.

Technologies: Windows 2008,2012 Server, SQL Server 2014, 2012, 2008R2, 2005, 2000, T-SQL, MS clustering, Red-gate.

SQL Server Database Administrator DBA

Responsibilities:

• Responsible to provide 24 X 7 critical support to all Production, development and Test environments.
• Supported SQL 2008/2012 databases, 2 node clustering environment (A/A) including database mirroring, and AlwaysON on critical databases and databases 700+ Gig in size.
• Successfully Upgraded SQL 2008 to SQL 2012 and 2014.
• Designed, implemented, configured SQL 2014 production environment on 2 node cluster environment.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Configured and maintain transactional replications.
• Deployed SSIS packages in production environment to implement business logics.
• Configured Database Mail and Alerts.
• Moved databases, logins, and jobs from MSSQL 2008 to MSSQL 2012, 2014.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2008, 2012 & 2014.
• Tested and applied latest service packs and cumulative Hotfix for SQL 2008/2012/2014 .
• Installed and configured SQL 2008/2012 Report and Integration Services.
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data.
• Installed, configured and maintained Log shipping to create Standby Server.
• Created maintenance plan for database consistency and optimization.
• Document server and database policies and procedures.
• Created the backup and restore strategy for production, development and test environments.
• Involved in Disaster recovery and created the documentation.
• Worked on performance tuning using Performance Monitor, SQL Profiler, and Index tuning wizards.
• Enhanced performance by creating and managing indexes.

Technologies: Windows 2008/2012, SQL 2008/2012/2014, T-SQL, Replication, SSIS, SSRS, Database mirroring, MS clustering, DPA.

SQL Server DBA

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various departments and type of users.
• Rebuilding indexes using jobs at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Deploying new code base release to Testing and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on SSMS for managing databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different ETL tasks for downloading data from Excel, Flat file, CSV file to SQL Server Database.
• Migrating SQL Server 2005 databases into SQL Server 2012.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Technologies: SQL Server 2008/2005, VSS, Windows 2008 Server, MS TFS, MS-Access.

Junior Database Administrator

Responsibilities:

• Installing, configuring, administering and securing test and production servers.
• Create and optimize database objects, e.g.
• Tables, Views, indexes, cursors, stored procedures, functions, and Triggers.
• Administer, maintain, develop and implement policies and procedures for ensuring security and integrity.
• Enrolling and mapping users following company policies and procedures.
• Scheduling and automating full/differential/ transactional backups and implementing recovery strategies.
• Upgrading the SQL Server Databases, Monitoring and Performances tuning.
• Developed reports using Crystal Reports with T-SQL, MS Excel and Access.
• Developed automated procedures to produce data files using Microsoft Integration Services (SSIS).
• Implement data models, database designs, schema changes data access codes (DDL, DML, DCL).
• Installing and monitoring SQL agent jobs.
• Assisting development teams with data cleansing, migration and loading in addition to assisting and supporting development teams with reviewing, building, testing and maintaining database structures and SQL scripts.

Technologies: SQL Server 2008, Windows 2003 Server, Visio. SQL Query Analyzer, SQL Profiler.