SUMMARY

• MCSE Certified SQL Server Database Administrator and Developer with more than 7 years of experience.
• Hands on experience supporting databases and servers in Development, Test/UAT/DR and Production instances on On - Premises and MS Azure & AWS Cloud Environments.
• Subject Matter Expert(SME) in Production Database Management and Administration, which includes installation, configuration, backup, restoration, HA/DR solution like Always-On Availability Group, Clustering, Replication, Database Mirroring, Log shipping, upgrading, migration, apply patches/Patch Management, managing ON-Call and supporting clients, troubleshooting and managing Locks, Blocks, and Deadlocks, CPU usage, Memory utilization, Disk space analysis and utilization, managing Log file growth, Job fail, backup fail, troubleshooting different Linked server like Oracle SQL, MS SQL, IBMDB2, Teradata, ensure server & database Security. Proficient with SQL Server 2008R 2/2012/2014/2016/2017.
• Excellent Knowledge and Experience in Database Development and BI Tools, which includes Data Modeling, SSIS, SSRS, SSAS, SQL, TSQL, Writing Stored Procedures, Functions, Joins, Cursors, triggers, views, Constraints, and Create, Deploying and Managing SSIS Packages using ETL Process.
• Strong Leadership working experience with the new features of SQL Server 2017/2016/2014/2012/ 2008R2, change SQL version enterprise to standard, Always on High availability groups, database mirroring, Clustering, Replication, Database Migration, server & Database credential, Backup and recovery, Managing Storage and Assigning Tickets, weekly team meeting and deal with clients.
• Cloud/Azure experience includes Azure Services, PaaS, IaaS, and Migrated on premises databases to MS Azure Virtual Machine
• Cloud/AWS, experience includes RDS and EC2 Instance Services, PaaS, IaaS, Migrated on premises databases and Legacy products on RDS and EC2 Instance, deployed products on RDS and EC2 Instance, Setup development and test environment on AWS.
• Deep understanding and working experience of SQL Server( SQL 2005, 2008/2008 R 2/2012/2014/ 2016/2017 ) includes installation, configuration, and maintenance of standalone and Clustered Servers Active/Active and Active/Passive Cluster Design
• Optimizing and Performance Tuning such as Query Optimization, Performance Tuning using execution plan, Profiler, Database Tuning adviser and Windows Performance Monitor tools to resolve Dead Locks or long running queries and slow running server.
• Strong knowledge and working experience with SharePoint 2010 and MOSS databases.
• Create and set-up Database maintenance plans and Jobs for Database monitoring, maintenance and Automation.
• Knowledge of Microsoft Best Practices with regards to configuration of SQL data/log, tempdb, backup drive locations.
• Applying Service Pack (SP) for Databases instances, and patching SQL servers with hotfixes.
• Migrating databases from other databases management plat forms like Oracle 10g, MS Access to SQL Server 2005 and 2008/2008 R2, 2012, 2014.
• Upgrading databases from MS SQL Server 2005, 2008, 2008R2, 2012, to SQL Server 2016/2017.
• Deploying Databases in Test, Dev, UAT and Production environment
• Working experience in configuring and setup mail server for database mail notification.
• Good customer support experience in providing end-user support on a day-to-day basis
• Working experience with SAN and RAID.
• Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers.
• Good experience with the phases Software Development Life Cycle SDLC such as requirement gathering & analysis, design, development, testing, implementation & maintenance in the Client/Server and web based environments based on Functional Requirements Documents
• Installed and maintained SQL Server Reporting Services SSRS 2008 R2/2012, 2014, 2016.
• Good experience in writing and debugging SQL Server stored procedures/triggers, Function, Join, sub query, TDE, Column and Row Level Security, Data Masking and documenting issues/resolutions of SQL Server Applications
• Self-motivated; proactive; a team player; Strong analytical and problem-solving skills
• Can learn new software and technologies rapidly.

TECHNICAL SKILLS

• SQL Server 2017/2016/2014/2012/ 2008/2005/MS Access and MySQL
• MS SQL Server to SQL Server, Oracle to SQL, MySQL to SQL, On-premises SQL Server to Azure Database & AWS.
• Windows Server2016/ 2012/R2, 2008/2003 including UNIX/Linux.
• ServiceNow, JIRA, Remedy.
• NetBackup, RedGate, SolarWinds, idera diagnostic manager, SentryOne.
• VMWare (ESXi 5.5), Virtual Box, Hyper-V, V-Spare, vCenter server
• Configuration, Manages and Migration from On-premises Server to Azure database & SQL Server on Azure Virtual machine.
• SQL, T-SQL - DDL,DML,DCL,TCL, PowerShell, C#, C/C++, Java Script, Visual Basic, HTML, XML, ASP.Net, PHP
• SSIS/DTS, BCP
• SSRS - Enterprise Reporting, Tableau, Report Builder 3.0/2.0, Power BI
• Erwin, Toad Data Modeler, MS VISIO
• Active Directory, Setup TCP/IP, Setup DNS Server, Create User and Authentication, IPsec, SSL. ADO.NET, OLEDB, ODBC
• SAN, NAS, RAID, ISCSI
• Adobe Photoshop, Adobe illustrator.
• IIS: Installation, Configuration, And Deployment of Applications & Administration.

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr. SQL Database Administrator

Responsibilities:

• Database operational supports in production environment like Locks, Blocks, and Dead locks, CPU, Memory, Disk space analysis and utilization, managing Log file growth, Tempdb, Job fail, backup fail, deploy SSIS package, migrate and deploy .RDL file in Report server, troubleshooting different Linked server like Oracle, MS SQL, IBMDB2, Teradata, ensure Server & Database Security.
• Planning Capacity management, DB indexes maintenance, DB security, license usage, DB consistency, DB integrity checks and DB Backup and Recovery.
• All day-to- day activities to keep the service up and running to agreed SLAs ad to be compliance with JPMC IT control policy such as health checks, monitoring ticket queues, Change Ticket, C-Task, Incident ticket, Technical Request Ticket, End user requests and automation of processes.
• Leadership working experience Data Migration projects from lower version to higher version of different SQL Products, 2008, 2012, 2014, 2016, 2017, change SQL version enterprise to standard and vice versa to minimize company cost, Always on High availability groups, database mirroring, Clustering, Replication, Server & Database credential, Backup and recovery, managing Storage and assigning Tickets, weekly team meeting, project update and deal with clients.
• Decommission Instance and Databases then update server & Database inventory portal, and raise different Tickets like as Technical request ticket, Task ticket, incident ticket, change ticket, CTask, DR ticket, Firewall ticket then Assign task to Group-wise using ServiceNow Ticketing System.
• Implement storage/Disk management strategies, Table Partition in order to archive data in database Warehouse, SAN, NAS and RAID Technology.
• Designing and hardening SQL Server Security (Server hardening, Auditing, SOX compliance and user/group access monitoring).
• Working with Application development team and QA to refresh their development and UAT databases.
• Effectively interface between the business and technology teams in order to ensure business objectives are met and communicated to senior management.
• 24x7 “on-call" Production support rotations.

Environment: MS SQL Server 2017,2016,2014, 2012/2008 R2, Windows Server2016, 2012, 2008 R2, 2003 Enterprise Edition, SolarWinds, NetBackup, ServiceNow, ERWin, Splunk, SSIS, SSRS, BIDS, IIS 7.5, 8.5, Oracle SQL, Teradata, Big Data.

Confidential, Suitland, MD

SQL Server DBA

Responsibilities:

• Worked for the Confidential ’s SQL Team where my primary focus on performance tuning, troubleshooting and in-depth root cause analysis (RCA) for database related issues.
• Supports day to day operational activities for the production database platform like service requests and tickets, monitoring Server Activity, database health, troubleshooting long running queries, locks, deadlocks, CPU, I/O, Memory bottlenecks, Disk space usage, Backup verification and Restore, jobs, shrinking database, cleaning history and solving the problem as needed.
• Supports Database Developers to optimize and troubleshoot SQL Server slow running queries /Stored Procedures/index/Function/Views
• Worked on Database refresh in Dev/Test servers with PROD data and synchronize SID login and Users, DB consistency, DB integrity checks.
• 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.
• Provide project support of engineering based decisions and scope to assist the customer with over all layouts, design and installation of DB system, Configuration, Migration, Upgrades and Patching.
• Designing and hardening SQL Server (Server hardening, TDE (Transparent Data Encryption), Row Level Security, Dynamic Data Masking Encryption, Role based Security Policy, Security Auditing.
• Managed Security and User Privileges Granting/ deny/ revoke access Server and Database level.
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2016/2014/2012 with Synchronous Asynchronous automatic-failover mode. And push traffic to DR server using AG Listener (ApplicationIntent=ReadOnly)
• 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.
• Effectively interface between the business and technology teams in order to ensure business objectives are met and communicated to senior management.
• Provided 7 x 24 Production support for the database and application issues.

Work Environment: SQL Server, 2016, 2014, 2012, 2008r2, 2008, 2005, MS Azure Environment, AD (Active Directory), Windows Server 2012r2, 2008, IIS 8.5. JavaScript, ASP.net, In-house Application, SQL Fog-light, TFS, SharePoint, Oracle and DB2.

Confidential, Washington, DC

SQL Server Database Administrator/SQL Developer

Responsibilities:

• Database Migration projects, Upgraded/Migrated SQL Server 2005/2008 to SQL Server 2012/2014, Installation, Upgrades SQL Server versions, Patching/Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues.
• Worked on Database refresh in Dev/Test servers with PROD data
• Install, configure and Administering SSRS Report server, SSIS/DTS Package and SSAS.
• Developed and deployed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and Export & Import data from the Flat file (CSV, Excel) to SQL Server Database
• 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.
• Recommend and Review Backup and Recovery Strategies and test plan for failure scenario.
• Designing SQL Server Security (Server hardening, Auditing, DISA, STIG, SOX compliance).
• Implementing high Availability Features (Failover Clustering, Database Mirroring, Log Shipping and Replication.)
• Advance Database Performance tuning (Perfmon, SQL Profiler, Database Engine Tuning adviser etc.)
• Perform root cause analysis and troubleshooting technical issues.
• Implement storage management strategies.
• Improves and maintains customer and employee satisfaction.
• 24x7 “on-call" Production support rotations.

Work Environment: Windows Server 2012, 2008, IIS 7.5, SQL Server, 2016, 2014, 2012, 2008r2, 2008, 2005, AWS-RDS, EC2 instances, AD, JavaScript, ASP.net. Service-Now, BMC Control-M, TFS, SQL SentryOne, RedGate, Oracle, and DB2.

Confidential

SQL Database Administrator

Responsibilities:

• Installed, Configured and maintain SQL Server 2005, 2008 R2, 2012, 2014 (Clustered/Standalone and VM )in Development, Test, and Production environment
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues
• Upgraded/Migrated SQL Server 2005/2008 to SQL Server /2012/2014 and Transferred Logins, Data and Log files, backup files, and Jobs for side-by-side Upgrade/Migrate
• Data Encryption and Data Decryption for data security in Database & Column level
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security
• Configured, Monitored and troubleshoot Log Shipping/ Replication (Transactional, Merge)
• Configured and Maintained SQL Server 2012 Fail-Over Clustering and Always-On Availability group
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification
• Monitored Server Activity, Error Log, space usage and the solving problem as needed
• Rebuilding the indexes at regular intervals for better performance.
• Designed and created databases, tables, views, store procedures, function and indexes
• Developed and deployed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources
• Installed, configured and deployed SSRS reports from BIDs/SSDT. Provided access to SSRS reports.
• 24x7 “on-call" Production support rotations.

Work 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.