SUMMARY

• 7 years of experience in MS SQL Server implementation, maintenance, administration and 24x7 support in clustered, distributed and standalone environment.
• Architectural plan, design, deployment and configuration of SQL server in a production, development, test and UAT environments.
• Experienced in the Upgrade/Migration of MS SQL Server 2005/2008 /2008 R2 to MS SQL Server 2012, 2014 and 2016.
• Expert in implementing Replication, Log - shipping, SQL Server failover clustering, database Mirroring, Alwayson Availability Group to meet HA and DR requirements in terms of RPO and RTO.
• Implemented solid backup, restoration and disaster recovery strategy
• Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and third-party solutions.
• Experienced in handling and troubleshooting SQL Server related hardware, software, connection and performance issues.
• Responsible for securing SQL Server, login/ user management, assigning permissions and roles.
• Implemented Transparent Data Encryption to protect data within files and backups.
• Automated SQL Server Database maintenance jobs and alerts including, backup, index rebuild using T-SQL and Powershell Scripting
• Automated SQL performance monitor and data collections for capacity planning and performance tuning.
• Experienced inT-SQL scripting and creating triggers, store procedure and functions.
• Expert level of knowledge in relational database management system, including data normalization, logical design and physical design for OLTP and OLAP applications.
• Wotking knowledge in deployment and management of SQL Server in Azure envirnment as IaaS and PaaS
• Experinced in Team Fundation Server (TFS) and GIT for software version control.
• Worked closely with developers in implementing best coding practice, enhance codes and provided feed back in query performance.
• Experienced with Agile project management system including scrum and certified agile practitioner
• Knowledge of windows server administration including active directory and domain controller.

TECHNICAL SKILLS

Database: MS SQL Server 2016/2014/2012/2008/2005

Languages: T-SQL, PL/SQL, XML, Power Shell

Database Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio, SQL Server Data Tools(SSDT), Microsoft Team Foundation Services

Development Skill: T-SQL,PL/SQL,SSIS/SSRS/SSAS

ETL Tools: DTS, SSIS (SQL Server Integration Services)

Reporting Package: SQL Server Reporting Services (SSRS), MS Excel

Tools: and Methodologies: MS Project, SQL Profiler, Team Fondation Server, GIT

Environment: Windows Server 2008/2012/2016, UNIX (Solaris, RedHat), Windows 10, Windows 8 and Windows 7, VMware, Azure, HyperV

Monitoring Tools: Microsoft System Center Operation Manager (SCOM), Perfmon, SQL Activity Monitor, SQL Fragmentation Analyzer and SQL Diagnostic Manager.

PROFESSIONAL EXPERIENCE

Confidential, MD

SQL Server DBA

Responsibilities:

• Administered over 15 Terabytes of data across 100+ MS SQL servers in production, test, and development environment including multiple clustered servers.
• Responsible for installing and configuring MS SQL Server 2008R2, 2012, 2014 and 2016 applying service packs and security fixes.
• Implemented and automated SQL server maintence jobs using T-SQL Scripts and Powershell.
• Executed SQL Server troubleshotting using native tools and Powershell.
• Upgraded and migrated and managed MS SQL Server, SSAS, SSRS and SSIS.
• Designed and implemented Database High Availability (HA) and Disaster Recovery (DR) in multiple data centers.
• Conducted regular database backup and restoration operations.
• Monitored database performance on a regular basis and tackled problems proactively
• Generated server and database level performance reports and health statistic
• Managed hundreds of databases on large systems with Microsoft clusters, Database Mirroring, Replication, Database Partitioning and Advanced Compression, Central Management Services and Policy Based Management.
• Monitored system, managed performance and conducted tuning operation to optimize and enhance database performance using native and third party monitoring tools.
• Reviewed, implemented and released new database and database changes as submitted by the development and project team.
• Applied hot fix and patches to resolve known problem or follow best practices.
• Designed and implemented ETL processes using SQL Server Integration Service (SSIS) packages.
• Experienced agile software development process including working with the business to prioritize requirements into logical and manageable groups for rapid intake into the Agile development process, based on development resource capacity.

Confidential, DE

SQL Server DBA

Responsibilities:

• Responsible for installing and maintaining SQL Server database systems. Maintaining the database systems includes successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery
• Responsible for installing, configuring, and maintaining Microsoft SQL Server 2012 AlwaysOn Availability Groups and Failover clusters.
• Responsible for installing and configuring MS SQL Server, applying service packs and security fixes.
• Responsible for large scale database migrations from SQL server 2005 to SQL server 2008 R2 and SQL server 2012 and SQL server 2014.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Monitored the health and performance of SQL OS, server instances and home-grown applications using Extended Events, SQL server Profiler, PerfMon and other third-party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintained SQL Sever Clustering, Mirroring and Replication and Log Shipping between various environments.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
• Optimized database Indexes, adding/deleting them when necessary for better performance.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Involved in improving database performance using Extended Events, SQL Profiler, Trace Flags, Execution plan and DTA and third-party tools.
• Worked with installation, configuration and creation of SSRS.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Confidential, VA

Jr. SQL Server Database Administrator

Responsibilities:

• Installed and configured SQLServer2012/SQLServer2008 R2/ SQLServer2008 with backup jobs, database mail and configuration options.
• Upgraded SQL Servers with latest service packs.
• Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2.
• Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.
• Configured and maintained transactional replication for flow of data from QA and Dev. Server to the replica servers.
• Monitored data activities like database status, logs, space utilization, locks and long transactions.
• Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.
• Worked with developers to optimize the code if required to minimize the duration and look if the indexes were used appropriately.
• Involved in resolving deadlock and blocking issues for concurrent users.
• Provided appropriate access to users except system databases owners.
• Refreshed databases for pre- or post-data loads activities.
• Supported SQL server developers working on different projects with various requests.
• Converted and redesigned existing DTS packages to SSIS packages.
• Developed SSIS packages to import and export data from existing systems to upgraded system.
• Used database utility programs and 3rd party utilities to monitor database performance, such as