PROFESSIONAL SUMMARY:

• A Certified SQL Server DBA having more than 4 years of professional experience in various Microsoft products with excellent detail - oriented approach, analytical and troubleshooting skills.

• My skill includes SQL Server database administration, data modeling, gathering and analyzing business requirement and Operating Systems.
• Solid working experience in managing large databases, backup/recovery, restore and Point-in-Time Recovery, Scheduled jobs to automate different database activities including backup, monitoring database health check, disk space, backup verification, Developed Maintenance Plans for database monitoring, Monitor Server Activity, Error Log, space usage, and solving problem as needed developing and managing reports using SQL Reporting Services (SSRS) and data migrations using SQL Server Integration Service (SSIS).
• Monitoring and Performance Tuning of stored procedures, triggers, functions, constraints, and views.
• Substantial knowledge, and strong experience in using third party tools like RedGate, Idera, SQL Sentry and Toad Data Modeler in managing SQL Server database and designing databases as well as in using Erwin, understanding AWS and Cloud Management for Software development.
• Having a very good team player skill and has an aptitude for learning can work with little supervision, self-motivated and can easily work with non-technical people while possessing a sense of urgency.

TECHNICAL PROFICIENCIES:

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

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 2014, 2012, 2008 R2 Virtualization

Languages: VMware Managed Database Servers and Databases in Virtual Environment. SQL, T-SQL, XML

ETL/Data Warehouse Tools: SSIS/DTS, BCP

Reporting: SSRS (SQL Server Reporting Services), Report Builder, VISIO 2007/2010

Data Modeling Tools: Erwin, Toad Data Modeler, SSDD (SQL Server Database Diagram)

Networking: Active Directory, DNS, TCP/IP

Hardware/Storage: SAN, RAID, iSCSI

PROFESSIONAL EXPERIENCE:

Confidential, Woodbridge, VA

SQL Database Administrator/SQL DBA

Responsibilities:

• Installed, Configured SQL Server 2014, 2012, and 2008 R2 in development, test, and production environments.

• Managed Fail-Over Clustering using SQL Server 2012.
• Configured SQL Server Reporting Services (SSRS).
• Developed and deployed different types of Reports using different data sources like SQL Server, Oracle, and Excel and CSV files.
• Delivered reports to users in a variety of formats like Report Server (Web based), excel, pdf, HTML, excel and CSV formats.
• Configured and Managed Replications, Log Shipping, and Mirroring for High Availability.
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to a new version of SQL Server like 2005 to 2008 R2 and 2008 R2 to 2012.
• Migrated MS Access Databases into MS SQL Server 2008 R2 and 2012.
• Migrated Oracle 10gR2/11gR2 and MySQL 5.1.23 databases to SQL Server 2008 R2/2012.
• Applied SP (Service Pack)/ hot fixes on SQL Server Instances to address security and upgraded related issues.
• Wrote SQL/T-SQL queries, Stored-Procedures, functions, and Triggers.
• Performed database and SQL/T-SQL Performance Tuning using different tools.
• Performed Database Design Analyzed and architectural design for Database Performance.
• Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications.
• Create and manage different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check).
• Worked on Data Modeling projects, Backward and forward 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 the problem as needed.
• Worked independently and as a team member and handled any assigned tasks by immediate supervisor.
• Understanding AWS and Cloud Management for Software development.

Confidential, Washington DC

SQL Database Administrator/SQL DBA

Responsibilities:

• Configured, Installed, and Maintained SQL Server 2000, 2005, 2008, & 2008R2 in development, test, and production environment

• Installed and Configured Operating Systems, Windows Server (2008, 2008R2 & 2012)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications, Log Shipping
• Upgraded databases from SQL Server 2000 to 2005 in testing and production environment
• Upgraded MS Access 2000/97 databases into MS SQL Server 2000, and 2005
• Applied SP (Service Pack) and patches on SQL Server 2000, 2005, Windows Server 2003 Enterprise Edition.
• Expertise in database Performance tuning.
• Wrote T-SQL and Stored-Procedures.
• Substantial experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers.
• Expertise in Data Modeling, developing E-R Diagram using Erwin and SQL Server Data Diagram including Backward & Forward Engineering with data modeling tools mentioned above
• Export & Import data from Flat file, CSV file, Oracle, and Access to/from SQL Server Database using DTS, SSIS, and BCP
• Generated Report using SSRS and in Excel, HTML, text from Database.
• Expertise in Database Backup, Restore and Point-in-Time Recovery.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitored Server Activity, Error Log, space usage, and solving problem as needed