SUMMARY

• Overall 15+ years of IT experience in MS SQL Server Administration, Azure SQL and AWS RDS.
• Strong experience in Installing, Managing, Monitoring and Troubleshooting of MS SQL Server 2005, 2008/R2, 2012, 2014, 2016, 2017 and 2019.
• Automated daily activities, backup report and other DBA related jobs report using VB Script and Shell script.
• Install Oracle software and configure databases and provide resolutions for databases.
• Creating users, assigning necessary roles to connect to database & fixing oracle client and Oracle server connectivity issues.
• Installing & configuring Oracle server in windows server and export & import database schema.
• Experience in Migrating Oracle database to SQL Server Database and Azure SQL Database conversion.
• Hand on experience in implementing Always - on, Clustering, Log Shipping, Replication and Mirroring for high availability solutions.
• Regular overview on the performance of Database queries using Performance Monitoring, Profiler and Event Viewer graphs.
• Extensive experience with Monitoring, Tuning and analyzing Performance issues.
• Experience in performing Integrity checks Methods includes configuring the database maintenance plan wizard and DBCC utilities.
• Experience in Installing, Configuring and Managing SQL Server 2017 on Linux server.
• Experience in Configuring and Managing SSRS, SSAS and SSIS.
• Creating Maintenance plans and Troubleshooting SQL Server Agent Scheduled jobs like Backup, Integrity, Optimization, and Log Shipping jobs regularly.
• Experience in Automating Database maintenance plans for checking database Integrity and Capacity planning.
• Experience in Upgrading SQL Server 2005, 2008/R2, 2012, 2014, 2016 and 2017.
• Created Jobs, Alerts, SQL Mail Agent and scheduling SSIS Packages, using BCP and Bulk Insert commands while working with Flat files.
• Installation, Configuration and Maintenance of SQL Server Active/Active and Active/Passive Cluster and configured the Always-on high availability technique in SQL server environment.
• Developed various T-SQL stored procedures/functions for the Application and Involved in SQL Database design and Database objects, created Database Objects such as Tables, Views, Triggers and Indexes using SQL server 2008/2012/2016/2019.
• Good experience in implementing Disaster Recovery (DR) strategies.
• Good experience on Microsoft Azure technologies such as Azure SQL databases, Azure storage (Blob storage, file storage), Azure AD.
• Hands on experience in Azure Infrastructure as a Service (IaaS) and Platform as Service (PaaS).
• Good experience on AWS cloud computing such as EC2 Instances, S3 buckets, Amazon RDS, etc.
• Creating S3 buckets, applying bucket policy documents to newly created buckets.
• Creating Elastic Pools, Resource Groups, Storage Accounts, Basic Virtual Network and DNS configuration, Windows Server installation version 2012/2016 and SQL Server installation and configuration
• Migrate On-Premises Instances and Databases to Azure SQL and Amazon RDS.
• In PaaS created SQL Database, Auto backup schedule to storage account, Geo Replication configuration, Dynamic Data Masking configuration.
• Involved in SQL Knowledge Transition of new projects in UK and US.
• Involved in Data Center Migration Project.
• Minimized the downtime of migration from 35 hours to 30 minutes using SQL Server HA Techniques and backup options we have.
• Migration of SSAS 2012 database cubes to 2019.
• Automating sync of logins and user privileges between the secondary replicas and primary replica.
• Involved in all environments Production, UAT, Development and Test.
• Backup & Restore of databases using TSM & TDP, Symantec NetBackup and Idera.
• Experience in monitoring tool SolarWinds, Idera, Sumologic and Nexpose.
• Experience in creating logins to the Users and giving permissions.
• Involved in SQL Knowledge Transition for new projects in UK and US.
• Hands on experience in ITIL process (Incident, Change and Problem management) using ServiceNow, Service Center, Service Desk and Remedy.
• Having good exposure on PowerBI reporting and developed reports in PowerBI.
• Excellent ability to work as part of a team and independently and able to manage time too effectively to meet deadlines and prioritize workload.
• Worked in Process-driven environment, by following processes like Problem Management and Change Management.
• Providing 24X7 production On-Call support on a rotational basis.

TECHNICAL SKILLS

Operating Systems: Windows Family, Linux

Cloud Technologies: Microsoft Azure, AWS

Languages: SQL, T-SQL, MongoDB

Administration: MS SQL Server 2005\2008 R2\2012\2014\2016\2017 and 2019.

Database Tools: Enterprise Manager, Query Optimization, Profiler, Perfmon

Change Management Tool: BMC Remedy, Service Center and ServiceNow.

Backup Tools: NetBackup, TSM, Symantec Backup Exec, Idera, Redgate.

Monitoring Tools: Idera, OpsRamp, Sumologic

PROFESSIONAL EXPERIENCE

Lead Database Administrator

Confidential, Irving, TX

Responsibilities:

• Working on Installation, Managing, Monitoring and Troubleshooting SQL Server Databases on 2008 R2, 2012, 2014, 2016, 2017 and 2019 versions.
• Upgrading Microsoft SQL Server 2012, 2014 and 2016 with latest service packs.
• Migrating Microsoft SQL Server databases from older versions to newer versions such as from SQL Server 2008 R2 to 2012, 2014, 2016 & 2017.
• Developed various T-SQL stored procedures/functions for the Application and Involved in SQL Database design and Database objects, created Database Objects such as Tables, Views, Triggers and indexes using SQL server 2008/2012.
• Prepared plenty of PowerShell scripts and scheduled them for database Audit purpose such as permissions script - owner and sysadmin access, backups evidence script.... etc.)
• Preparing PowerShell scripts to automate database maintenance activities.
• Working on enabling TDE (Transparent Data Encryption) on critical databases for additional layer of security
• Creating S3 buckets, applying bucket policy documents to newly created buckets.
• Working on creating “Master" keys, "Symmetric" keys and "Certificates" on SSIS configuration databases and HR databases to encrypt secure data.
• Creating users, groups & IAM roles and assigning policy documents to newly created users based on client requirements.
• Creating S3 buckets, applying bucket policy documents to newly created buckets.
• Enabling versioning and cross region replication for S3 buckets.
• Worked with Azure in Infrastructure as a service (IaaS) and Platform as a service (PaaS).
• Creating Resource Groups, storage accounts, Basic Virtual Network and DNS configuration, Windows Server installation version 2012/2016 and SQL Server installation and configuration .
• Working on migrating SQL server databases from on premises to Microsoft Azure cloud platform.
• Creating SQL Database, Auto backup schedule to storage account, Geo Replication configuration, Dynamic Data Masking configuration.
• Regular overview on the performance of Database queries using Profiler and Event Viewer graphs.
• Installing & configuring Oracle server in windows server and export and import database schema.
• Resolved database connections issues of SQL Server, Oracle client connections (TNS names resolution and Listener connectivity issues)
• Resolving Maintenance job issues, space issue by coordinating with Wintel, Storage, Network and App teams.
• Monitoring and performance tuning of SQL database versions using SQL profiler, execution plans, SQL reports and Idera tool.
• Analyzed databases in deep, provided the detailed report which included unused indexes, missing indexes, expensive queries and table size for each database.
• Responsible for implementation and release of database changes to different environments.
• Implementing Always-On, Clustering, Log Shipping, Replication and Mirroring for high availability solutions.
• Involved in table partition for performance improvement of 10 TB database size.
• Resolve issues of Replication, Clustering, and Always-On
• Providing solution to application team on Always-On, replica DB read only, and use replica to run backups, reporting and select statements which reduces the load on primary replica.
• Backup & Restore of databases using TSM & TDP, Netbackup, Idera.
• Migration of SSAS 2012 database cubes.
• Configuration and Administration of SSRS\SSAS\SSIS.
• Upgrading SQL Server 2000, 2005, 2008\R2, 2012 and 2014.
• Perform daily, weekly, and monthly data maintenance tasks
• Handling incidents and change requests in Remedy and ServiceNow.
• SQL Jobs - Creation and Maintenance.

Environment: Windows Server 2019, 2016, 2012, 2008 R2, 2003, Linux, SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2005, Access, SSAS, SSRS, SSIS/DTS, Always-On Availability Groups, Always-On Failover cluster, Clustering, Mirroring, Replication, Logshipping, Table Partitioning, Microsoft Visual Studio, TDE, TCP/IP, SSMS, Query Analyzer, Extended Event, SQL Server Profiler, Performance Monitor, Tuning Advisor, Execution plan, Activity monitor, Job Activity Monitor, DMVs, DBCC, Index Tuning Advisor, SQL Server Configuration Manager, SQL CMD, SQL, TSQL, Connectivity Components, Compression, Netbackup, Idera, Solarwinds, ServiceNow, OpsRamp, PowerBI, Azure SQL, AWS, S3 bucket, VB Script.

Subject Matter of Expert

Confidential

Responsibilities:

• Working on Installation, configuring, administrating and securing SQL Server 2005\2008\R2\2012\2014\2016.
• Monitoring and troubleshooting Databases.
• Regular overview on the performance of Database queries using Profiler and Event Viewer graphs.
• Developed various T-SQL stored procedures/functions for the Application and Involved in SQL Database design and Database objects, created Database Objects such as Tables, Views, Triggers and indexes using SQL server 2008\2012.
• Implementing Clustering, Log Shipping, Replication and Mirroring for high availability solutions.
• Performance tuning on long running T-SQL Queries in SQL server and monitoring and resolving space issues, Job failures, Blockings and SQL related tickets.
• Worked on SQL server Migration from SQL server 2008R2 to 20
• Mirroring, Clustering and Always-On Configuration, monitoring and resolve the issues and built and configured the Stage/Test and Dev environment based on customer requirements.
• Responsible for space allocation, backup strategies.
• Regular overview on the performance of Database queries using Profiler and Event Viewer graphs.
• Experience in upgrading SQL Server 2005, 2008/R2 and 2012.
• Involved in Knowledge Transfer of new project in UK.
• Good experience in 24/7 in SQL production support.

Environment: Windows Server 2016, 2012, 2008 R2, 2003, SQL Server 2016, 2014, 2012, 2008 R2, 2005, Access, SSAS, SSRS, SSIS/DTS, Always-On Availability Groups, Always-On Failover cluster, Clustering, Mirroring, Replication, Logshipping, Table Partitioning, Microsoft Visual Studio, TDE, TCP/IP, SSMS, Query Analyzer, Extended Event, SQL Server Profiler, Performance Monitor, Tuning Advisor, Execution plan, Activity monitor, Job Activity Monitor, DMVs, DBCC, Index Tuning Advisor, SQL Server Configuration Manager, SQL CMD, SQL, TSQL, Connectivity Components, Compression, Netbackup, Idera, Solarwinds, ServiceNow, Service Center.

Infrastructure Management Principle

Confidential

Responsibilities:

• Installing, configuring, administrating and securing SQL Server 2005/2008.
• Monitoring and troubleshooting Databases.
• Created test data for application testing, imported data from excel using import utility in SSMS.
• Involved in troubleshooting and fine-tuning of databases for its performance improvement.
• Participated in the deployment of new releases in a production environment.
• Performing and monitoring full, differential and transactional log backups.
• Scheduling and monitoring Jobs in SQL server.
• Extensively used Enterprise Manager, Query Analyzer.
• Creating Maintenance plans for database consistency checks and update statistics.
• Monitoring server performance using Performance Monitor and SQL Server Profiler.
• Monitoring Log shipping and troubleshooting the errors.
• Managed Logins, Users, Roles and User permissions.
• Responsible for space allocation, backup strategies.
• Involved in Knowledge Transfer of new project in US.
• Good experience in 24/7 in SQL production support.

Environment: Windows Server 2012, 2008 R2, 2003, SQL Server 2014, 2012, 2008 R2, 2005, Access, SSAS, SSRS, SSIS/DTS, Always-On Availability Groups, Always-On Failover cluster, Clustering, Mirroring, Replication, Logshipping, Table Partitioning, Microsoft Visual Studio, TDE, TCP/IP, SSMS, Query Analyzer, Extended Event, SQL Server Profiler, Performance Monitor, Tuning Advisor, Execution plan, Activity monitor, Job Activity Monitor, DMVs, DBCC, Index Tuning Advisor, SQL Server Configuration Manager, SQL CMD, SQL, TSQL, Connectivity Components, Compression, Netbackup, Idera, Solarwinds, Service Center, BMC Remedy.

Associate Team Leader

Confidential

Responsibilities:

• Complete Database Administration on SQL server 2005 and 2008.
• Performance tuning on long running T-SQL Queries in SQL server and monitoring and resolving space issues, Job failures, Blockings and SQL related tickets.
• Worked on SQL server Migration from SQL server .
• To maintain the jobs Scheduled to process thedata in the central server.
• To ensure the data consistency in the central server which is pushed between the databases of the central Server.
• Maintaining the jobs Scheduled during the night for the Backup of Databases.
• Responsible for space allocation, backup strategies, table maintenance.
• Implementation of Patches in production and Staging servers.
• Database Security.
• Quarterly Upgrades
• Configuring & Monitoring Log Shipping and Mirroring.

Environment: Windows 2008 R2, 2003, SQL Server 2008 R2, 2005, Access, SSAS, SSRS, SSIS/DTS, Clustering, Mirroring, Replication, Logshipping, Table Partitioning, Microsoft Visual Studio, TDE, TCP/IP, SSMS, Query Analyzer, Extended Event, SQL Server Profiler, Tuning Advisor, Execution plan, Activity monitor, Job Activity Monitor, DMVs, DBCC, Index Tuning Advisor, SQL Server Configuration Manager, SQL CMD, SQL, TSQL, Connectivity Components, Compression, Redgate, Netbackup, Idera, Solarwinds, Service Center.

System Administrator

Confidential

Responsibilities:

• Installing and configuring windows server 2005\2008.
• Installing SQL Server 2005/2008.
• Ensuring all the Production servers are up-to-date with respect to patches and hot fixes.
• Performing Consistency checks using DBCC commands.
• Designing the Backup Strategies based on the recovery Models.
• Monitoring Log Shipping, Mirroring and Transactional Replication,
• Providing credentials to the users and managing the Security
• Verifying the SQL Agent jobs history.
• Creating and Monitoring the scheduling the refresh jobs for data base maintenance.

Environment: Windows Server 2008 R2, 2003, SQL Server 2008 R2, 2005, Access, SSAS, SSRS, SSIS/DTS, Mirroring, Replication, Logshipping, TDE, TCP/IP, SSMS, Query Analyzer, SQL Server Profiler, Tuning Advisor, Execution plan, Activity monitor, Job Activity Monitor, DMVs, DBCC, Index Tuning Advisor, SQL Server Configuration Manager, SQL CMD, SQL, TSQL, Compression, Netbackup, Solarwinds, Service Center.