TECHNICAL SKILLS

Database: SQL Server 2008, 2012, 2014, 2016

SQL Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Database Tuning Advisor, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration SQL Configuration manager

Reporting/ETL Tools: SSRS, SSIS

Programming Language: Transact - SQL, ASP.net, HTML, C#, C++, CMD, PowerShell

Operating Systems: MS Windows Server 2008, 2012, Windows XP, Windows 7

Monitoring Tools: System Monitor, Counter, SQL Diagnostic Manager by IDERA, Windows Event Logs, Activity Monitor

Other Tools: SSMA (SQL Server Migration Assistant) and ODBC/DB Link, Red-Gate, SharePoint 2010/2013, VISIO, VMware

Methodologies: Agile Scru

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

SQL Database Administrator

Responsibilities:

• Install and configure different versions of SQL Server in Development, Test, Stage and Production environments.
• Upgrade earlier versions SQL Server 2008, SQL Server 2012 and SQL Server 2016.
• Work with business analyst to deploy databases and manage database availability.
• Rebuild servers when master database was corrupted.
• Develop and apply Disaster Recovery strategies.
• Configure and manage SQL Server Always-On High Availability Groups with multiple secondary nodes.
• Experience on public cloud infrastructures and migration of on-premises SQL server databases into the cloud (Azure).
• Work with developers to tune-up performance of SQL and T-SQL queries.
• Performance tuning & optimization of servers in Production and Test environments.
• Create and manage database security, data encryption and apply object level security.
• Develop Database Maintenance Plan for different business requirements.
• Used DBCC and Alter statements for different database administration tasks such as checking database consistency, reorganizing and rebuilding indexes, updating statistics.
• Used DMV (Dynamic Management View) for different database administration tasks such as backup history, indexes fragmentation levels, statistics and status of different jobs.
• Export & import database objects from/to Oracle, MySQL, Access Database, flat files (text, excel, and CSV files) and MS SQL Server.
• Experience in using SSIS/DTS, BCP to import & export data from flat files, excel, MS Access, and other OLEDB databases to MS SQL Server databases.
• Working experience with SAN and RAID.
• Providing customer support, dealing with non-technical and upper level management.
• Experience in providing end-user support on a day-to-day basis.
• Provide 24x7 supports for critical production systems.

Confidential, Bethesda, MD

SQL Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008 R 2/ 2012/2016.
• Performed regular database maintenance tasks such as rebuilding indexes, update statistics, database integrity check, storage management, monitoring performances.
• Applied Hot Fixes, Patches, Cumulative Updates, Service Pack, Service Pack), Upgrades.
• Managed Backup and Recovery systems based on RTO and RPO, use Native SQL server Backup/Recovery Tools, Red Gate SQL Backup Pro.
• Refreshed database from production and attach the database from data file when needed.
• Created and manage database security, data encryption and apply object level security.
• Implemented SQL Server Always-On High Availability Groups with multiple secondary nodes.
• Applied patches and CUs on Always-On Availability group replicas in production and non-production environment.
• Worked on public cloud infrastructures and migration of on-premises SQL server databases into the cloud (Azure).
• Designed high availability architecture for database availability.
• Maintained performance tuning and optimization of servers in Production and Test environments.
• Used Activity monitor, Wait stats, Stored Procedures, DMV, DMF, SQL Profiler, Extended Events, Error log, Windows Performance Monitor to find out health and performance problems for the servers.
• Wrote automating database maintenance processes and monitoring using T-SQL scripts.
• Worked on query optimization and tuning using Database Engine Tuning advisor, Activity Monitor and analyzing Execution Plan.
• Performed research into database performance issue and come up with solutions to address those concerns.
• Enjoyed working in a team environment and independently as well.

Confidential, Tampa, FL

SQL Database Administrator

Responsibilities:

• Installed, configured, and managed SQL Server 2008/2012/ 2014/2016 in Development, Test, and Production environments.
• Ensuring system availability, data integrity; monitor/troubleshoot backup and recoveries, performance, disk space, and network connectivity.
• Coordination with the team, providing technical assistance, support to system operations staff and end-customer client organizations.
• Handled common database functions, such as upgrade, backup, recovery, and migration.
• Resolved, troubleshoot database issues, and performed upgrades, conversions and deployments.
• Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolved locking conflicts and resource utilization.
• Written automating database maintenance processes and monitoring using TSQL scripts.
• Provided project database consulting including query analysis, and database implementation.
• Refined and automated regular processes, track issues, document changes.
• Assisted developers with complex query tuning and schema refinement.
• Implemented SQL Server ALWAYSON High Availability groups with two secondary nodes.
• Performed scheduled maintenance and support release deployment activities after hours.
• Configured and Maintained; Log shipping, Mirroring, Replication as part of a high availability solution.
• Exported & imported database objects from/to Oracle, Access Database, flat files (text, excel, and CSV files) and MS SQL Server.
• Installed, configured, and Managed SQL Server Reporting Services (SSRS).
• Generated Report using SSRS (SQL Server Reporting Services).
• Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster).
• Monitored Server Activity, Error Log, space usage, and solving problem as needed.
• Managed and resolved trouble tickets (Remedy) for database-related issues submitted.
• Designed database backup and restore plan, recovered database from back up in disasters, implement point in time recovery solutions.
• Created database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
• Written SQL queries, Triggers, Functions, creating Tables, Views and Indexes.
• Audited and generated monthly management reports using third party tool.
• Created the database, tables, table spaces, data objects, setting privileges, indexes, user login and password (Security).
• Provided 24x7 supports for critical production environment.