SUMMARY:

• Cloud/Azure experience entails Azure Services, Migrated On - Premises databases and Legacy databases to Azure, setup development and test environment, Managed Databases in SQL Azure and SQL Server, Upgraded Databases, setup jobs, alerts, Monitoring Performance, Setup VMs, and Database Environment
• Installed, Configured, VM Machines, and Managed Database Instances in Virtual Environment
• Database Administration in MS SQL Server (2016/2014/2012/2008 R2/2008/2005) in Production, Development, UAT, and Test Environment.
• 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.
• Monitoring Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed.
• High Availability and Disaster Recovery solutions (Log shipping, Mirroring, Replication, SQL Server Fail Over-clustering and AlwaysOn)
• Capacity planning and implementing disaster recovery solutions, Backup, Restore, Point-in-Time Recovery, RTO and RPO.
• Data modeler on Logical and Physical data modeling.
• SQL/T-SQL for creating, altering and maintaining database and database objects.
• SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• ETL/SSIS Packages for integrating data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Database and Instance Architecture Design.
• Upgrade/ migrate SQL Server, MySQL and Oracle Databases and Instances.
• Documentation, writing SOP (Standard Operating Procedures), decommissioning Servers after Migration.
• Operating Systems (O/S) - Windows Server 2008 R2, Windows Server 2012 R2
• Security Management: SQL Servers and Databases, users and Logins, Data Encryption TDE and Column and Row Level Encryption, and Dynamic data masking and Always Encrypted.
• System Databases configuration and Management such as TempDB, MSDB and Master DB
• Partitioning, shrinking, Link server Etc.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

SQL Database Administrator

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2016, 2014 and 2012 in Development, UAT, Production Environment, On Premises, Cloud Environment and VM Machine
• Worked as Production Support Engineer overseeing SQL Server 2008R2 to 2016 on a very large scale
• Provides database assistance and problem support to application developers, business analysts and business users
• Provides support in capacity planning, forecasting, and Database Designing
• Provide Production Support and Deploy Changes/SPs/Queries in Production Environment
• Help developers improve the performance by optimize and troubleshoot or modifying SQL Server slow running queries, indexes, Stored Procs and Views
• Performed database/infrastructure physical design, and configured storage for data and log files, Backward and Forward Engineering, Creating E-R Diagram.
• Provide technical leadership to Upgrade SQL Server 2005 and 2008 instances and databases to 2012/2014/2016
• Migrate Database from Oracle 10g/11g, MySQL, MS Access to SQL Server 2008R2/2012/2014
• Setup, Configure, & Manage Azure SQL Database Instances on Azure VM Machine
• Have created Azure SQL Database in Microsoft Azure Cloud (PAAS) and Migrated On Premise SQL Server Database into Azure SQL Database
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2014/2012 with Synchronous Asynchronous automatic-failover mode.
• Developed, Implemented & Managed DR (Disaster Recovery) Solutions by Performed regular backups, restores for prod/test/dev environments including mission critical database.
• Designed and Implemented RPO, RTO and SLA, Setup Retention Policy, Backup Verification. Point-in-Time Recovery, jobs, Alerts, Notification with Maintenance plan in SQL Server.
• Responsible for Monitored Server Activity, Error Log, database health, space usage, cleaning history and solving problem as needed
• Applied SP (Service Pack) on SQL Server on a routine maintenance work
• Worked on Database refresh in Dev/Test servers with PROD data and reinstate the server
• Managed Security User Privileges Granting/deny/revoke access server and database level
• Implemented & Managed Database and Data Security Solutions including monitoring and troubleshooting
• TDE (Transparent Data Encryption), Row Level Security, Dynamic Data Encryption, Role based Security Policy
• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index (Cluster/Non-Cluster), Views, Stored Procedures, Triggers, Functions, Constraints and variables, CTEs and PowerShell
• Experienced in using DBCC commands to manage database consistency and repair as needed
• Performed performance tuning for Server, Database, SQL/TSQL queries and stored
• Used different Native and Third-Party tool for Performance Related monitoring and Troubleshooting purposes like Execution Plan, SQL Server Profiler, Database Tuning Advisor, SolarWinds, Activity Monitor
• Used Query Store, DMVs and DMFs to monitor the server health, diagnose problems, and performance tune
• Configure and manage SQL Server tables with data partitioning
• Installed and Configured SQL Server Services (SSRS), Developed, Deployed and managed Reports, Upgraded and Migrated Reports and Reporting Server, Managed Security for Reports and Reporting Server
• Installed and Configured SQL Server Integration Services (SSIS), Developed SSIS packages to perform various ETL operations, Deployed and Managed SSIS Packages, Upgraded and Migrated SSIS ETL Packages and SSIS Instance, Managed Security for SSIS Package
• Managed Client Requests and Provide on Call Support.

Environment: SQL Server 2008R2, 2012, 2014, IIS 7.5, 8.5, Windows Server2008R2, 2012, ASP, ASP.net, Java, ETL and AD (Active Directory)

Confidential, Richmond, VA

SQL Server Database Administrator

Responsibilities:

• Database Migration, Installation, Upgrades and Patching.
• Recommend Server H/W, SQL Server Editions and versions for a new Build.
• Designing strategy towards Capacity Management for DB tracks.
• Define/Recommend/Maintain Database Standards and Architecture.
• Working with application development team to review and deploy changes during database object release include with system upgrade.
• Have hands-On experience IASS, PASS, SASS in RDS and EC2 Environment.
• Migrating cloud AWS in Different method in RDS and EC2 Instances.
• Setup HA Solution Log shipping Automated Migration from On-premises to EC2 Instances.
• Monitor RDS performance and EC2 and look for any potential performance problems/bottlenecks.
• Defining processes and ensuring that the processes are adhered to oversees and is responsible for successful completion of Installation, configuration and migration.
• Recommend and Review Backup and Recovery Strategies and test plan for failure scenario.
• Designing SQL Server Security (Server hardening, Auditing, SOX compliance).
• Implementing high Availability Features (Failover Clustering, Database Mirroring, Log Shipping and Replication.)
• Install, configure and Administering SSRS, SSIS and SSAS.
• Advance Database Performance tuning (Perform SQL Profiler, Database Engine Tuning adviser etc.)
• Perform root cause analysis and troubleshooting technical issues.
• Implement storage management strategies
• Install, configure and use third party backup and monitoring tools such as Red Gate, Quest Lite Speed, SCOM.
• Maintaining & updating database inventory
• Handling tickets / requests.
• Documenting new features, processes and procedures and issue resolutions.
• Improves and maintains customer and employee satisfaction
• 24x7 “on-call" Production support rotations.

Confidential, Washington, DC

SQL Server Database Administrator

Responsibilities:

• Migrated and Upgraded from SQL Server 2005, 2008/R2 to 2012 R2
• Configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Customized support for Client’s Applications and provided client will won the responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, functions, procedures.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Monitored data activities such as database status, logs, space utilization, extents, Checkpoints, locks and long transactions.
• Suggested Application level tuning changes for code, queries, SQL objects that may not be performing up to the optimum database performance standards.
• Adhered to Change Control Procedures and developed & executed scripted changes requests in accordance with change control procedures.
• Set up security and access profiles and procedures for database system administrators.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005, 2008 & 2008 R2.
• Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in co-ordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Monitored the database server performance and if required go for tuning of the T-SQL queries, Stored procedures.
• Working individually, as a member of a team, and lead small teams to collaboratively design and model systems at a high level prior to construction
• Provided 7 x 24 Production support for the database and application issues

Environment: SQL Server 2005, 2008R2, 2012, 2014, IIS 7.5 Windows Server, 2003R2, 2008, 2012, ASP, ASP.net, Java, AD, PeopleSoft Application, Oracle, My SQL, Service-Now, OpNet, and SQL SentryOne