SUMMARY:

An experienced SQL Server DBA with detail oriented, analytical and troubleshooting having more than 7 years of professional experience in different Microsoft products as a SQL Server DBA. As a DBA professional and troubleshooting experience include SQL Server database administration, data modeling, gathering and analyzing business requirement and Operating Systems. Solid working experience in managing large databases, backup/recovery, configuring and managing HA solutions, 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 database third party tools like OpNet, SolarWinds, Idera, ERWin, Visio, and Toad Data Modeler.

Cloud/Azure experience includes Azure Services, PaaS, IaaS, and Migrated from premises databases and Legacy databases to Azure, deployed products on Azure, Setup development and test environment on Azure

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, VMware

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

Cloud/Azure: Azure Services, PaaS, IaaS, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure

ETL/Data Warehouse Tools: SSIS/DTS, BCP

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

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

Third Party Tools: SolarWinds, OpNet, RedGate, Idera, ERWin, Visio, Toad Data Modeler

Domain/AD: Active Directory, DNS

Hardware/Storage: SAN, RAID, iSCSI

Ticketing Tools: BMC Footprint, ServiceNow, JIRA.

SSMS: SQL server 2008 R2,2012,2014

PROFESSIONAL EXPERIENCE:

Confidential, Woodbridge, VA

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 Fail-Over Clustering using SQL Server 2012
• Experience in AlwaysOn environment
• Maintained server and database security including database encryption (TDE)
• 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
• Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
• Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server like 2000/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
• 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

Confidential, Washington, DC

SQL Database Administrator/ SQL DBA

Responsibilities:

• Migrated and Upgraded from SQL Server 2005 to 2008/2008 R2
• Configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• 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, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• 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.
• Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.
• Set up security and access profiles and procedures for database system administrators.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
• Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures.
• 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

Confidential, Richmond, VA

SQL Database Administrator/ SQL DBA

Responsibilities:

• Configured, Installed, and Maintained SQL Server 2000 & 2005 in development, test, and production environment
• Installed and Configured Operating Systems, Windows Server (2000 & 2003)
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications, Log Shipping
• Upgraded databases from SQL Server 7.0/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
• Writing T-SQL and Stored-Procedures
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Data Modeling, developing E-R Diagram using ERWin and SQL Server Data Diagram
• 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 as well
• Working experience 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
• Monitor Server Activity, Error Log, space usage, and solving problem as needed