PROFESSIONAL SUMMARY:

• Microsoft Certified SQL Server Database Administrator working as a MS SQL Server Database Admin for over 6 years and as a System Engineer for about 2 years and total of 7 years of IT experience.
• Hands on experience on Database Management and Development which includes installation, configuration, backup, restoration, HA/DR solution like Log shipping, Mirroring, Replication, Clustering and Always On.
• Well versed in upgrading, migration, troubleshooting, supporting clients, Data Modeling, SSIS, SSRS, Database Monitoring, Performance Tuning, Database Security, Database Programming, Patch Management, managing concurrent applications (managing Locks, Blocks, and Deadlocks), wrote SQL/T - SQL, stored procedures, packages, triggers, views, Constraints, Cursors, functions, deployment and managing related security.
• Installed, Configured, and Managed Instances and Databases in SQL Server 2016, 2014, 2012, and 2008R2 in development, Staging and Production Environment
• Installed, Configured, and Managed Service Packs (SP) and HOT Fixes on stand-alone and HA (High Availability) instances
• Migrated and Upgraded SQL Server Databases/instances from older to higher version
• Installed and Configured of VMware vSphere, Horizon view and cloud version
• Installed, Configured and Maintained HA (High Availability) Solutions - Always On, Failover Clustering, Replications, Mirroring, and Log Shipping
• Installed, Configured, and Managed Instances of SQL Server Reporting Services (SSRS)
• Developed, Deployed and Managed Reports using different data sources like SQL Server, Oracle, Excel, CSV files
• Data Modeling, Databases Design/Architecture and capacity planning - used data modeling tools such as ERwin and Toad Data Modeler
• Database Backups and Restoring
• SQL, T-SQL (DDL, DML), stored procedures, functions, triggers and user defined functions (UDF).
• Performance Tuning, Query optimization, identifying and troubleshooting I/O and memory bottle necks, lock, block and deadlocks, monitoring sessions, and query executing
• Designed and Managed Data partitioning for large tables to increase performance
• Created and Managed Indexes including Managing Statistics
• Used different monitoring and troubleshooting tools for server, database and performance tuning purposes such as SQL Server Activity monitor, profiler, Dynamic Management Views (DMV), Query Execution plan, SQL Server Logs, Agent Logs, Solar Winds, OpNetand so on
• Designed, configured, and managed Maintenance plans, Jobs, Alerts, and Notifications
• Data dump and import from Excel and Flat file into MS SQL Server
• Designed, Developed, Deployed and Managed ETL packages using SSIS and DTS
• Installed, Configured, and Managed Operating Systems using Windows Server and Red Hat
• Installed, Configured, and Managed DNS, AD (Active Directory), IIS Web & Application Server
• Provided Technical Support for Windows, File Server, AD, Print Server and Storage
• Install, Configure, and Manage Azure VM Machines
• Setup, Configure, & Manage Azure SQL Database Instances in Azure
• Migrated On-Premises Database Servers and Data to SQL Azure Database Instances
• Migrated Database to Azure SQL from SQL Server, MySQL, and Oracle Database
• Used many different cloud related tools like DMA, SSMW, Generate Scripting, Export & Import Data Tier Application, Backup and restore, SSIS Export & Import, Deploy database to windows Azure SQL Database, Windows Azure Virtual machine

PROFESSIONAL WORK EXPERIENCE:

SQL Server Database Admin

Confidential, Washington, DC

Responsibilities:

• Installed, Configured, and Managed MS SQL Server databases and instances of 2016, 2014, 2012, and 2008 R2 in development, test, UAT, and production environment
• Migrated Databases to Azure SQL
• Deployed Databases in Azure SQL
• Designed ETL to transfer data from Oracle to Azure SQL
• Manage Database Security
• Manage Day to Day Operations
• Monitor, Troubleshoot and Administer SQL Server 2016, 2014, 2012 in Development, Test, UAT, and Production environment
• Share Ideas among team members regarding different technical and business related issues/problems
• DR planning, coordination and implementation
• Capacity planning for Database and generating the Database growth
• Documentation created many technical documents in different subject areas such as Applying SP, installation documentation, upgrade, migration, troubleshooting, HA related technologies and so on
• Configured and Managed Database High Availability (HA) Solutions multiple technologies such as AlwaysOn Group, Fail-Over Clustering, Replications, Mirroring, and Log Shipping
• Converted Log Shipping Technology to Database Mirroring Technology
• Upgraded/Migrated SQL Server Instances/Databases from older version to newer version of SQL Server such as from 2000/ R2 and 2008 R2 to 2012/2014
• 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 2012/2014
• Installed and Configured SQL Server Reporting Services (SSRS) in 2008 R2, 2012, and 2014
• Developed, deployed Reports and Managed Reports and security
• Delivered reports in different media like Report Server (Web based), excel, pdf, and excel
• Migrated SQL Server Reporting Servers and Reports
• Applied SP (Service Pack), Hot Fixes, feature updated to secure the environment
• Create and manage accounts for users and apps
• Written SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
• Deployed scripts and granted permissions as needed
• Performed performance tuning activities in different aspects using different tools like Execution Plan, SQL Profiler, Performance Monitor/Profiler, Index Tuning, Index rebuild, reorganize, setup automated jobs for index management tasks, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Resolve Dead locks/Long running queries
• Monitored users, users’ activity, sessions, Server health, Error Log, failure of different tasks/jobs, and troubleshooting the issues as needed
• Monitored Performance related issues from different areas such as application, users activities, SQL/TSQL/Query related problems
• Create and managed different type of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check) including fragmentation management
• Monitoring locks, blocks and deadlocks
• Perform Table partitioning, data archival activities
• Allocating resources as needed for better performance such as creating multiple file groups and files for data files (MDF and NDF) and Log Files (LDF) including allocating and managing TempDB and spaces for TempDB
• Developed, maintained and implemented database backup and recovery plans by using RTO and RPO in SLA level for Production, Test, UAT and Development environments including mission critical databases
• Created and Scheduled jobs to automate database related tasks such as backup, monitoring database health - disk space, memory, CPU utilization, backup verification, lock, block, users activities, performance issues and so on
• Implemented different Maintenance Plans for database monitoring and management purposes
• Created and scheduled Jobs for Maintenance purposes such as backups, Rebuilding indexes, alert, notifications and so on
• Setup many jobs for Manual and Demand for Ad-hoc purposes
• Backup and Recovery procedures by using N ative and third-party tools, Recovered/Deployed Database including Point in Time Recovery Database Recovery
• Worked on different Modeling Projects including Backward and Forward Engineering projects, Developed E-R Diagram
• Very proficient with multiple data modeling tools like ERWin, Toad Data Modeler, VISIO, and SQL Server Data Diagram (SSDD)
• Developed SSIS Packages using different data sources such as SQL Server, MS Access, Oracle, Flat file, CSV, Excel and other data sources supports ODBC, OLE DB connections
• Deployed SSIS packages to move data across server
• Used SSIS packages for many different projects such as moving logins, load data, database objects such as tables, views, procedures, functions, index management, ETL purposes and many other cases
• Setup jobs using SSIS Packages and Managed security of SSIS packages
• Migrated SSIS packages from SQL Server 2008 R2 to 2014/2016.
• Writing DDL and DML queries
• Wrote queries using JOINs, Stored procedures, Functions and Triggers
• Tune-up queries for different applications
• Worked closely with Application Team to troubleshoot performance related issues
• Managed users and group security using database and server role
• Applied TDE (Transparent Data Encryption)
• Secured data in Database and Data in Moving using SSL and IPSec
• Applied SP (Service Pack) and hot fixes as needed
• Setup, Configured, & Managed Azure SQL Database Instances in Azure
• Migrated On-Premises Database Servers and Data to SQL Azure Database Instances

Environment: Azure SQL Database, SQL Server 2016, 2014, 2012, Always On, Clustering, and Stand-Alone, ETL (SSIS), SSRS, Windows Server 2012 R2, 2008 R2, IIS Application Server, File Server, Ticketing System and other applications

SQL Server Database Administrator

Confidential, Columbia, MD

Responsibilities:

• Installed, Configured, and Managed SQL Server 2014/2012/2008 R2 in Production, Development, and Test (Clustered, Stand Alone, and VM Servers) Environments
• Worked with developers, application owners, system administrators and users to deploy software release across Development, Testing, and promoting into Production or resolve issues
• Monitored, and Performed Database Performance Tuning using SQL Server Profiler, Extended event, Database Tuning Advisor, Execution plan, Performance Monitor and Activity Monitor, DMV, DBCC, Windows Event Viewer, SQL Server Error Log, Agent Error Log
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving the problem as needed
• Have solid experience in SQL Server High Availability and Disaster Recovery solutions like Log shipping, Mirroring, Replication, SQL Server Fail Over-clustering and AlwaysOn
• Performed capacity planning and implementing disaster recovery solutions- database Backup, Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines
• Performed Database Design/Data modeling: Conceptual, Logical and Physical data modeling using ERwin and Toad Data Modeler. Performed Forward and Backward Engineering on different projects
• Experienced in writing T-SQL batches and developing Indexes, Stored Procedures, User Defined Functions, CTEs, Triggers, SQL joins, Views, Cursors, table variables, sub-queries
• Deveoped SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Performed ETL Design using SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Union
• Performed upgrade/ migrate from lower version of SQL Server to higher version SQL Server (2012/2014/2016 and Azure SQL in Cloud)
• Managed Database security, Managing users, granting/revoking access, encryption, TDE, data masking, auditing, and monitoring to comply with Microsoft and industry best practices
• Configured and Managed TempDB, partitioning, shrinking, Link server, compression, and database optimization

Environment: SQL Server 2014, 2012, 2008R2, Windows Server 2012 R2, 2008R2, 2012, IIS 6.5, 7.5, ASP, ASP.net, Java, ETL and Financial Application

Combat Engineer

Confidential, Fort Hood, TX

Responsibilities:

• Supervised and served as a member of a team, squad, section or platoon
• Responsible for providing mobility and counter mobility support to combat forces in Afghanistan during combat operations for approximately 3,000 personnel.
• Ensured safe and successful convoy operations for 8 vehicles and 30 personnel while assigned as a dismount and a driver for approximately 200 unit missions.
• Performed short and long range reconnaissance and route clearance missions to reduce the threat of explosive hazards.
• Has knowledge of the hardware and associated and software of the integrated communication system, FBCB2, which enables real-time battlefield communications. Uses system for command, control, and information purposes.