SUMMARY

• A certified SQL Server DBA with 7+ years of experience in managing multiple MS SQL 2005/2008/2008 R2/2012/2014 servers with large, medium and small OLTP databases in production, testing/QA and development 24/7 on call support environments.
• Experienced in SQL Server installation and configuration; and patching by applying service packs, hot fixes and cumulative updates on SQL server instances and windows servers 2003R2 and 2008 R2.
• Excelled in logical and physical planning of relational databases; manage internal databases from planning and testing stages through implementation and support.
• Developed complex TSQL scripts and stored procedures to perform administrative tasks and multiple DDL, DML, and DCL activities to carry out business requirements.
• Secured windows, servers, SQL servers, databases and objects by creating and auditing logins and users, and by creating roles, passwords, and TDE encryptions.
• Executed backup and recovery, and automating maintenance tasks using SQL job agent and task scheduler.
• Ensured disaster recovery using replication and log shipping; and high availability using mirroring, failover clustering and Always On high availability groups.
• Proficient in database monitoring, performance tuning and troubleshooting by checking for database consistency, database space allocations, transaction log space allocations, query optimization, monitoring error logs, and tuning of SQL performance using different native and third party tools.
• Upgraded SQL servers and migrated databases to and from SQL Servers 2005/2008/2008 R 2/2012/2014.
• ETL of data and migration of database instances, user databases, user logins, maintenance plan, jobs, packages, and database objects between multiple SQL servers, Oracle servers and MS Access.
• Exported & imported data using SSIS, DTS, BCP and Bulk insert. Developed and deployed reports using SSRS.
• Used third party tools like Idera Diagnostic Manager for performance tuning and troubleshooting and Redgate backup pro for backup.

TECHNICAL SKILLS

Relational DBMS: MS SQL Server 2005/2008/2008 R2/2012/2014, MS Access, MS Azure

Operating System: Windows Server 2008/2008R2/2003/2000 Advanced Sever

SQL Server Tools: SSMS, SSIS, MS Cluster Services, Profiler, Query Analyzer, DTA, Enterprise Manager, Activity monitor, Index tuning wizard, SQL Trace tools, Execution Plan

BI Tools: SSIS, SSRS, SSAS

Windows Tools: PerfMon, Event Viewer, Task Manager

Migration : SSIS, DTS, bCp, SQL Loader, Import/Export Wizard

Programming: T - SQL, Store Procedures, Trigger, basic idea about .NET and ASP.NET

Data Modeling: Toad Data Modeler, ERWin, SQL Server Database Diagrams, MS VISIO 2003/2010

Applications: JIRA Ticketing System, Visual Studio, Adobe Photoshop suite, MS Office

Networking: SAN, NAS, LAN, WAN

Virtualization : VMWare

Web/Application database Server Administration: developing/administering application databases in development, test and production environment.

Third Party Tools: Red Gate Back up pro, Idera Diagnostic Manager

PROFESSIONAL EXPERIENCE

SQL SERVER DBA

Confidential, Washington, DC

Responsibilities:

• Installing, configuring and managing SQL Servers 2008/2008R2/2012/2014 and applied periodic service packs and cumulative updates on production, test and development environments.
• Exceled in SQL server logical and physical database modeling, design and implementation.
• Performing daily checkups on SQL jobs, log shipping and hardware diagnostics for hard drives, backups, and disk space, and SQL and windows error logs as part of a proactive maintenance plan.
• Scheduling jobs to automate different database related activities including backup, monitoring database health, backup validation, and database maintenance tasks.
• Upgrading SQL Server 2005, 2008 and 2008R2 to 2012 and migrated their respective databases.
• Migrating databases from Oracle 11.g and MS Access to SQL server 2012.
• Developing T-SQL scripts to create databases, database objects and to perform DML and DDL tasks.
• Ensuring security of databases at the windows, server, SQL server, and database & object levels.
• Set up and manage log shipping for disaster recovery, and set up and manage Failover clustering for High Availability. Currently testing Always On availability groups.
• Performance monitoring, tuning and troubleshooting using SQL Server native and third party tools.
• Extracted, Transformed and Loaded (ETL) data from heterogeneous data Sources like Oracle and MS Access using MS SQL Integration Service (SSIS), DTS, BCP and Bulk insert.
• Installing, configuring, and administering SSRS, SSAS; and developed and deployed reports.
• Creating alerts and notifications for events such as system errors, insufficient resources, fatal database errors and hardware errors.

DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Installed, configured and managed SQL Servers 2000/ 2005/2008/2008 R2 in production, test and development environments. Applied service packs and cumulative updates.
• Used windows and SQL Server native tools for performance analysis and set alert messages for blockings and deadlocks.
• Configured replication for disaster recovery and database mirroring for high availability purposes.
• Created DTS and SSIS packages, set up SQL agent jobs, loading data from different databases to SQL Server database, and developed reports using SQL Server Reporting Services (SSRS).
• Upgraded/migrated MS SQL Servers 2000 and 2005 and their databases into MS SQL Server 2008 and 2008 R2 in an In-place and side-by-side technique for the test and production environments.
• Migrated data using Bulk Insert, BCP, SSIS and DTS from SQL Server 2000, 2005 and Flat files.
• Set up and maintained security at the database as well as object and server levels, and Setup Auditing.
• Monitored performance and troubleshooting regularly while working also in database design and production support. Monitor Server Activity, Error Log, space usage, and solving problem as needed.
• Exported & Imported data from Flat file, CSV file, Access to/from SQL Server Database using SSIS.
• Prepared and maintained documentation for various DBA tasks.

BUSINESS ANALYST

Confidential

Responsibilities:

• Produced accurate, consistent and timely reporting.
• Developed report automation, performed large data mining and established reporting best practices.
• Identified reporting processes that are inefficient and created/changed processes that are.
• Conducted reporting and reporting infrastructure design using a variety of analytical tools.
• Established detailed documentation for all reporting, dashboards and technical solutions.