SUMMARY:

• Microsoft Certified SQL Server Database Administrator having more than Seven years of working experience in SQL Server (2016, 2014, 2012, 2008 R2, 2008, 2005, Azure), which includes Installation, Upgrade, Migration, Configurations, Implementation and Administration High Availability/DR Solutions (AlwaysOn Availability Groups, Replications, Log Shipping, Mirroring, Clustering), Apply service packs, Data Modeling, Backup, Restore, Recovery, Designing DR Solutions, Database Security, SSIS, Reports development and management in SQL Server Reporting Services (SSRS), Monitoring and Managing Database Health, Trouble Shooting, Performance Tuning, Partitioning, Transaction Management, Index maintenance, stored procedures, triggers, functions, constraints, DBCC, DMV, Used third party tools for Database Administration and trouble shooting. Working experience entails strong working experience on using database third party tools ( Idera, SolarWinds, Spotlight, Foglight, Red Gate, Erwin, Toad Data Modeler, Visio, TSM and SCOM) and managing large databases in Virtual and Stand - alone 24/7 environment.
• Working experience includes installation, configurations and Administering Operating Systems (Windows Server 2012/R2, 2008 R2, 2008 and 2003 R2), AD (Active Directory).
• Installed & Configured SQL Server 2016, 2014, 2012, 2008R2, 2008 and 2005 in Development, Test and Production environment.
• Upgraded and Migrated databases from SQL Server 2005 to SQL Server 2008R2 and SQL Server 2008 R2 to SQL Server 2012, SQL Server 2014, SQL Server 2016 and SQL Azure.
• Migrated Oracle (10g/R2, 11g/R2) Database, MySQL (4.0.3, 5.0.15) database and DB2 to SQL Server 2008 R2, 2012 and 2014.
• SharePoint upgraded and Databases migrated from SharePoint 2007 to SharePoint 2013
• Database Administration in SQL Server (2016, 2014, 2012, 2008R2, 2008, 2005), overseeing the whole SQL Server Databases footprint for the enterprise and its lifecycle management. MS Access 2010, 2007 and 2003 including Scripting and Job Automation
• Extensive working experience in Configuring, Monitor and maintain SQL Server AlwaysOn Availability Groups (AG), Failover Cluster (Active Active and Active Passive), Mirroring, Log shipping and Implemented Disaster Recovery solutions.
• Extensive experience in Owning, tracking and resolving TCR, Incidents, Database related problems (database backups, maintenance, monitoring) and fulfilling requests on a daily basis to ensure service related issues are identified and resolved within established SLAs
• Created and Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Extensive experience in Database programming (writing T-SQL, Trigger, Stored-Procedures) and assist Database Developers to optimize SQL queries and Stored Procedures
• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues
• Database Monitoring, Performance Tuning, Trouble Shooting and Query Optimization.
• Extensive working experience and knowledge in Database Backup, Database Restore, Point in Time recovery, Disaster Recovery and Database Security Management.
• Deployed databases to different environments in development, test and production environment
• Having working experience in a fast paced environment as a Database Administrator for VLDBs in SQL Server 2012, 2008R2, 2008 and 2005 running on Windows Server 2012, 2008R2, 2003 R2.
• Windows Operating Systems (2012, 2008R2, 2008 and 2003R2): Installation, Configuration, User and Security Management
• Storage Management: SAN and RAID.
• Designed, building, writing ETL scripts and maintaining data warehouses in support of the system.
• Experienced in Batch processes, SSIS, DTS, BCP (Bulk copy), Bulk Insert, Import, Export, Database Monitoring tools and Application support
• Reporting tools - BI (Business Intelligence): SSRS (SQL Server Reporting Services) - includes installation, configuration, administration and Report Development and Management
• Have experience on other tools like SharePoint, VPN, AD (Active Directory), Portals, Bulletin Board, Visio.
• Strong experience in configuration and implementation of AlwaysOn Availability Groups (AG) in SQL Server 2012 and 2014.
• Configured & Monitor Log shipping in 2012, 2008R2 and 2008. Experienced on Planned & Unplanned Failover.
• Configured and maintained Database Mirroring including automatic fail-over option in SQL Server 2012, 2008 R2 and 2008.
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication
• Configured, Monitor and maintain local site transactional and merge replication topologies
• Configured and managing Failover Cluster (Active Active and Active Passive)Worked on High Availability solutions Clustering (Active-Active/Active-Passive), Evicting (dropping) nodes and adding node(s) in cluster 2008R2 and 2012, disk management.
• Handled multiple SQL Instances on Cluster for Server Consolidation projects built on SAN using RAID levels.
• Extensive working experienced in Performance Tuning and Trouble Shooting using native tools like
• PerfMon, Resource Monitor, Activity Monitor, Event Viewer, Profiler, Extended Event, Execution
• Plan, DTA (Database Engine Tuning Advisor), DBCC, Stored Procedures, Triggers, DMV’s and
• Created Jobs to monitor database health, disk space, backup verification and sending alerts, notification to operator.
• Encrypted databases and created certificates as per Company security Policy. Managed security at Server
• Level, Database level and Objects level by giving limited permission to Users as per request

PROFESSIONAL EXPERIENCES:

Confidential, Suitland, MD

Database Administrator

Responsibilities:

• Installed, Configured and Managed SQL Server 2016, 2014, 2012 and 2008R2 in Development, Test and Production environment
• Database upgrade and Migration from SQL Server 2008R2 to SQL Server 20014 and 2016, SQL Server 2008 to SQL Server 2012
• Migrated SSIS, SSRS, Certificates, Jobs from old instances to new Instances
• Applied Service Packs and Hotfixes on SQL Server 2008 R2, 2012 and SQL
• Server 2014 Active/Active SQL Cluster Environment
• Configured and implemented AlwaysON Availability Groups on SQL Server 2014 instances.
• Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008 R2 and 2012
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintain Transactional Replications and snapshot Replications.
• Configured, deployed and control MS SQL 2012 at VMware environment.
• Planned and implemented Database backup strategy for Full, Differential, Transactional backup and Restore
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Extensive experience in writing T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Database Monitoring, Trouble shooting, and Performance tuning and resolve database related TCR, Incidents and problems.
• Created and schedule jobs to automate different activities such monitoring
• Database health, Disk space, jobs alert, index monitoring, stats monitoring etc
• Encrypted databases create certificates as per NIST STIG and Government security
• Policy. Manage, migrate and import encryption and certificates.
• Managed security at Server levelDatabase level and Objects level by giving limited permission to users as per request

Work Environment: SQL Server 2016, 2014, 2012, 2008 R2. SQL Azure, VDI, Windows Server 2012R2, 2012 and 2008R2, IIS (8.5, 8.0, 7.5).ASP, ASP.net, AD (Active Directory), SharePoint, ITSMUNIX, AIX, Linux, Oracle, VMware, DMZ, STIG.

Confidential

Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2014, 2012, 2008 R2 and 2005 in Development, Test and Production environment
• Installed and Configured SQL Server 2014 for testing different features and stability
• SQL Server 2008 to SQL Server 2012 and SQL Server 2008R2 to SQL Server 2014
• Database Migration from MS SQL 2008R2 to MS SQL 20014, MS SQL 2008 to MS SQL 2012
• DB2 Databases to SQL Server 2012 and ORACLE (10g and 11g) databases to SQL Server 2012
• Applied SP (Service Pack) on SQL Server 2008, 2008 R2 and 2012 Clustered environment
• Configured and implemented AlwaysON Availability Groups on instances of SQL Server 2012
• Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008 R2 and 2012
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Transactional Replications and snapshot Replications.
• Configured, deployed and control MS SQL 2012 at Hyper-V environment.
• Strong knowledge and working experience in Database Backup, Restore and Disaster Recovery.
• Experienced with RPO, RTO, Point-in-Time Recovery and Restored Database from backup
• Database Monitoring, Trouble shooting, and Performance tuning and resolve database related TCR, Incidents and problems. Schedule jobs to automate different activities such monitoring database healthDisk space, job alert, index monitoring, stats monitoring, Used DBCC to check database conditionsRebuilding indexes and other database Maintenance etc

Work Environment: SQL Server 2014, 2012, 2008 R2. Windows Server 2012, 2008 R2 and 2003 R2, IIS (8.0, 7.5, 6.5).ASP, ASP.net, AD (Active Directory), SharePoint, TSM, SCOM, ITSM, UNIX, AIX, Linux, Oracle, DB2, My-SQL, Hyper-V, DMZ.

Confidential

Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2014, 2012, 2008 R2 and 2008 in Development, Test and Production environment and applied SP (Service Pack) on SQL Server 2008, 2008 R2 and 2012
• SQL Server 2008R2 to SQL Server 2014 and SQL Server 2008 to SQL Server 2012
• SQL Server 2005 to SQL Server 2008R2
• MS Access 2010 and 2007 databases into MS SQL Server 2008, 2008R2 and 2012, DB2 databases to SQL Server 2008 R2 and 2012, My-SQL 5.1/5.5, ORACLE (10g and 11g) databases to SQL Server 2008 R2 and 2012
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP. Export & Import data from/to databases like Oracle, My-SQL, and Access to/from MSSQL Server.
• Strong working experience on Conceptual, Logical and Physical Data Modeling
• Working experience on multiple data modeling projects
• Generate scripts for objects, Developed Relationship, and Created E-R Diagram.
• Backward & Forward Engineering for Logical and Physical Data Modeling using Tools - Toad Data Modeler, and Visio. Created and managed Object, Schema, Indexes and Constraints.
• Applied SP (Service Pack) on SQL Server 2008, 2008 R2 and 2012 cluster environment
• Setup all the Database Backup plans (Full, Tran log, Differential) using Maintenance Plan Wizard
• Ensured all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Experienced with Point-in-Time Recovery and Restored Database from backup
• Extensive experience in writing T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Configured and implemented AlwaysON Availability Groups on instances of SQL Server 2012
• Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008 R2 and 2012
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Clustering using SQL Server 2008 R2 and 2012
• Configured and Maintained Transactional Replications and snapshot Replications.
• Configured, deployed and control MS SQL 2012 at Hyper-V environment.
• Extensive experience in Database Monitoring, Trouble shooting, and Performance tuning and resolve database related TCR, Incidents and problems. Schedule jobs to automate different activities such monitoring database health, Disk space, job alert, index monitoring, stats monitoring etc
• Used DBCC to Shrink Database, Check Database conditions, fix database corruption, rebuild/reorganized indexes and other database maintenance purposes as well
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP. Export & Import data from/to databases like Oracle, My-SQL, and Access to/from MSSQL Server.
• SSIS Package create, deploy and manage, Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 and 2.0
• Deployed Reports and managed security of report server including folder level

Work Environment: SQL Server 2014, 2012, 2008 R2. Windows Server 2012, 2008 R2 and 2003 R2, IIS (8.0, 7.5, 6.5).ASP, ASP.net, AD (Active Directory), SharePoint, ITSM, UNIX, AIX, Linux, Oracle, DB2, My-SQL, Hyper-V, DMZ. Golden Gate

Confidential, Reston, VA

Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008R2, 2008 and 2005 in Development, Test, and
• Production environment
• SQL Server 2005 to 2008R2, SQL Server 2008 to SQL Server 2008R2
• Applied SP (Service Pack) on SQL Server 2008, 2008R2.
• Applied HOT Fixes on SQL Server 2008 and 2008R2.
• Used McKesson Paragon (EHR) tools to normalized and managed health care Database
• Setup all the Database Backup plans (Full, Tran log, Differential) using Maintenance Plan Wizard
• Ensured all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• Experienced with Point-in-Time Recovery and Restored Database from backup
• Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008 R2 and 2008 and Configured Log Shipping as Standby database from Production database for reporting purposes
• Actively monitored Database Performance and trouble shoot / resolve database performance issues using native tools and Idera. Schedule jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring etc.

Work Environment: Windows Server 2008 R2, 2008 and 2003R2 (IIS 7.5, 7.0 and 6.5), SQL Server 2008R2, 2008 and 2005. ASP, PHP, AD (Active Directory)

Confidential

Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008R2,2008 and 2005 in development, test, and production environment
• SQL Server 2005 to 2008, SQL Server 2008 to SQL Server 2008R2.
• MS Access 2003 and 2007 databases into MS SQL Server 2008 and 2008R2.
• Oracle 10g databases to SQL Server 2008 and 2008R2.
• Created and managed Index, Constraints, Keys (PK, FK)
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Data Modeling tools used using Erwin, Quest Data Modeler, SQL Server Data Diagram
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008 R2.
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008 and2008R2.
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications (Transactional)
• Strong knowledge and working experience in Database Backup, restore, Disaster
• Recovery and with Point-in-Time Recovery
• Configured, and administered SQL Server Reporting Services (SSRS)Developed Reports using SSRS, Developed Ad-hoc Reports using Report Builder 2.0, managed
• Security of Reports and Report Server
• Applied SP (Service Pack) on SQL Server 2008, 2008R2 and Applied HOT Fixes n SQL Server 2008 and 2008R2.
• Strong working experience on 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
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTSSSIS, BCP and Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server

Work Environment: Windows Server 2008 R2, 2008 and 2003R2 (IIS 7.5, 7.0 and 6.5), SQL Server 2008R2, 2008 and 2005. ASP, PHP, AD (Active Directory), Internal (Registration System, Reporting System), VMware