SUMMARY

• An experienced MS SQL Server Database Admin/Developer having more than 7 (Seven) years of professional experience in Database Design, administration, ETL Processing, Report Development, Data Modeling, SQL/TSQL Scripting, Gathering and analyzing business requirement and Administering Windows Server Operating Systems.
• Solid working experience in managing and troubleshooting large databases, backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints and views etc.
• Working experience entails strong knowledge on using third party tools like Idera, SpotLite, ERWin, Visio, and Toad Data Modeler.
• Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.

TECHNICAL SKILLS

Database Expertise: SQL Server 2014, 2012, 2008 R2, 2005, 2000, MS Access

Database Migration: SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

Operating System: Windows Server 2012, 2008 R2, 2003 R2, & 2000

Cloud/Virtual Environment: VMWare and Azure: Create and Management Database Instances

Languages: SQL, T - SQL, HTML, DHTML, XML, JavaScript, ASP, ASP.net

ETL/Data Warehouse Tools: SSIS/DTS, BCP

Reporting: SSRS (SQL Server Reporting Services) - Enterprise Reporting

Data Modeling Tools: ERWin, Toad Data Modeler, & Visio

Third Party Monitoring & Management Tools: SolarWinds, OpNet, RedGate, Idera, & SpotLite

Networking: Active Directory, DNS, TCP/IP

Hardware/Storage: SAN, RAID, iSCSI

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

SQL Database Administrator/SQL DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2014, 2012, and 2008 R2 in development, test, and production environment
• Configured and Maintained AlwaysOn, Fail-Over Clustering using SQL Server 2012
• Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
• Installed and Configured SQL Server Reporting Services (SSRS)
• Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, Excel, CSV files
• Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/ R2 and 2008 R2 to 2012
• Migrated MS Access Databases into MS SQL Server 2008 R2, and 2012
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
• Performed database and SQL/TSQL Performance Tuning
• Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
• Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications
• Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check)
• Worked on Data Modeling projects, Backward Engineering, Developed E-R Diagram and used multiple tools like ERWin, Toad Data Modeler, and SQL Server Data Diagram
• Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Deployed SSIS packages to move data across server, move logins, load data from different data sources
• Setup jobs from SSIS Packages
• Used Imp/Exp Tool to Export & Import data from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Manual, on Demand and setup jobs for Database Backup, and design backup strategy
• Deployed and Restored database including Point in Time Recovery
• Monitor Server Activity, Error Log, space usage and solving problem as needed

Environment: Windows Server2012 R2 & 2008 R2, IIS, SQL Server 2016, 2014, 2012, 2008 R2, SharePoint, RedGate, ERWin, & SolarWind

Confidential, Washington, DC

SQL Database Administrator/SQL DBA

Responsibilities:

• Migrated and Upgraded from SQL Server 2008 R2 to SQL Server 2012
• Installed, Configured, and managed Database Instances and Servers
• Configured database software, associated database tools and performance monitoring software
• Performed database/infrastructure physical design, database upgrades & applied patches
• Performed acceptance testing to verify database changes have no adverse consequences.
• Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, Functions, Procedures.
• Developed & maintained scripts for queries, procedures, triggers and so on
• Implemented & managed database Clustering Failover and AlwaysOn
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
• Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
• Set up security and access profiles and procedures for database system administrators.
• Handled Data partitioning for large tables
• Managed security by defining roles and rights.
• Monitored database performance and troubleshoot to fix any issues like query performance
• Working individually, as a member of a team, and lead small teams to collaboratively design and model systems at a high level prior to construction

Environment: Windows Server2012 R2 & 2008 R2, IIS, SQL Server 2012, 2008 R2, SharePoint, RedGate, ERWin, Foglight & SolarWind