SUMMARY

• Over Four (04) years of experience in SQL Server DBA for Very Large and Complex databases using SQL Server 2012, 2008R2, & 2005.
• Strong technical background includes performing business analysis, Documentation and Specifications, T - SQL, Stored Procedures, Triggers & Functions.
• Installation, Configuration & Maintenance of Active Directory (AD), SQL Server Management Studio (SSMS), Creating & Manipulation of data, tables, views, indexes, using SSMS & T-SQL Scripts following Relational Data Model (RDBMS), the ER Diagram.
• Run queries between SQL servers & other data sources using ODBC/OLE DB.
• Outstanding experience in Database Upgrade (Lower to Higher Version) and Migration as RDBMS, Database Monitoring tools, Application Support.
• Microsoft SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience in managing large database in 24/7 Environment (Test, Dev. & Prod)
• Concepts & Knowledge in Administering Web Server IIS (Internet Information Services) and deployed Web applications in Development, Test and Production Environment.
• Concepts & Knowledge with SAN/RAID & public Cloud tool of MS Azure Technologies.
• Motivated, proactive, Team player, manage projects efficiently for on-time delivery.
• Excellent verbal, written & presentation skills & Independent problem solving
• Proven ability to manage multiple tasks with different vendors.
• Excellent coordination, organizational, interpersonal skills & collaboration.

TECHNICAL SKILLS

Database & Server: MS SQL Server 2012/2008 R2/2005, MS Access 2007.

Operating Systems: Windows Server2012R2/ 2008R2/2003, Win XP, VMware

Programming Languages: Worked & Deployed SQL, T-SQL, SPs, Trigger, ASP, ASP.Net

ETL Tools: SSIS/DTS, BCP

Reporting Tools: SQL Server Reporting Services (SSRS) and Analysis Services (SSAS)

Database Design: Database Normalization/Denormalization, ERD, Flow Charting

Database Migration: Upgrade & Patch Management, Migration to SQL Server using SSMS

Networking & Protocol: Active Directory, TCP/IP, DHCP, LAN/WAN

Hardware/Storage: Concepts & Knowledge on PowerShell, SAN, RAID & Public CloudThird Party Tools Idera, OpNet, Toad Data Modeler

PROFESSIONAL EXPERIENCE

Confidential, Springfield, VA

SQL Database Administrator/DBA

Responsibilities:

• Administered production and development servers running MS SQL Server 2012, MS SQL Server 2008R2 and MS SQL Server 2005.
• Installed and Configured, and Managed SQL Server 2012 and 2008R2 managed in development, test and production environment following ERD Database Design.
• Installed, Config & Maintained Database High-Availability/Recovery Solution of Mirroring, Log Shipping, Replication & Clustering & Concepts on Always On
• Installed, Configured & Administered Business Intelligence (BI) tools; Integration Services (SSIS), Analysis Services (SSAS) & Report Services (SSRS).
• Managed security of Reports and Report Server, Developed Ad-hoc Reports
• Upgraded Databases from SQL Server /2008 R2, from SQL Server 2005 to SQL Server 2008 R2/ 2012
• Migrated Databases from Oracle Databases to SQL Server 2008R2 and 2012, and MySQL Databases to SQL Server 2008 R2
• Applied Service Pack & HOT Fixes on SQL Server 2000, 2005, 2008R2 and 2012
• Applied Patches on Windows Server 2003 Enterprise Edition
• Worked on many data modeling projects. Created and managed E-R Diagram Data Modeling tools. Used Toad Data Modeler
• Experienced in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views; Developed, Maintenance Plans & Monitoring
• Experienced on database monitoring, performance tuning and Query Optimization & monitoring SQL Server Error Log, space usage and solution
• Scheduled and maintained new and existing jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, database statistics, rebuild or reorganize indexes.
• Created notification if there is any failure, error, warning or disk issue.
• Wrote T-SQL, Trigger, Stored-Procedures and assisted Database Developers to optimize SQL queries and Stored Procedures and Triggers.
• Exported & Imported data from Flat file, Excel file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Working experience in OLTP, OLAP databases, Warehouse data modeling.
• Exported & Imported data to/from Oracle, My-SQL, and Access & SQL Server
• Strong knowledge and working experience in Database Backup & Disaster Recovery & Backup strategy for production & development environment.
• Experienced with Point-in-Time Recovery, Restored Database from backup
• Managed security by creating Groups, Logins & users with proper authentication & grant appropriate permission on Server - Database - Object level.
• Concepts & Knowledge on public cloud tool of MS Azure Technologies.
• Concepts & Knowledge on PowerShell Technologies.
• Attended weekly/monthly meetings with other DBA, Project Manager, Dev. and Test Team regarding project status, deadline, technical issues & solution.

Environment: Windows Server 2012 R2, 2008 R2, IIS 7.5, SQL Server 2012, 2008 R2, 2005, AD, ASP, ASP.Net.

Confidential, Fairfax, VA

Junior SQL Database Administrator/DBA

Responsibilities:

• Maintained database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Monitor SQL Server Error Log, space usage
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, and solving problem as needed.
• Installed and Configured SQL Server 2008R2 and SQL Server 2012 for testing different features and stability
• Use Windows PowerShell for Manage the file system, Manage services, Manage processes, Manage Registry.
• Use CMD command for recovery Master, and MSDB databases and other necessary tasks.
• Concepts & Knowledge on Microsoft SharePoint 2010.
• Applied SP (Service Pack) on SQL Server 2005, 2008 and 2008R2
• Applied Hot Fixes on SQL Server 2005, 2008 and 2008R2
• Maintained Fail-Over Clustering using SQL Server 2008R2 and 2012
• Installed, Configured and Maintained Database Mirroring of SQL Server 2008 and 2012
• Configured Log Shipping from Production database for Reporting purposes
• Configured and Maintained Replications.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed Reports using SSRS
• Deployed Reports
• SQL Server R2
• SQL Server 2008R2 to SQL Server 2012
• MCAS (MS Certified Administering SQL Server): SQL Server 2012 - Administration
• MCDW (Microsoft Certified Implementing a Data Warehouse): SQL Server 2012
• MCTS (Microsoft Certified Technology Specialist): SQL Server 2008R2
• MCITP (Microsoft Certified IT Professional): SQL Server 2008 - Administration