Anroop Reddy

618-***-****

ad39er@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 12 Years of global experience (USA, India & EUROPE) as SQL consultant (DBA) in Cloud platform & On-premises with a proven track record in database administration, performance tuning, and team leadership. Adept at managing high-availability and disaster recovery solutions, designing efficient database systems, migrating databases, and ensuring data security. Strong communicator and problem solver with a commitment to delivering high-quality results.

Hands-on experience in Database administration Azure SQL Databases, Azure SQL VM’s & AWS RDS, EC2.

Experience in migrating SQL Servers from On-Prem to Azure including Standalone, Multi instance and AOAG Group servers.

Experience in Transaction replication, Always on Availability Groups, database migrations and database upgrades.

Experience with SQL Server 2022/2019/2017/2016/2014/2012/20008R2/2008 installation and post configuration of SQL Server

Created a key vault in Azure to store encryption keys for use in SQL Server databases

Planned patching calendar for quarterly wise and executed SQL Server patching for all for SQL Servers.

Migrated critical SQL Servers from SQL 2012/2014/2016 to higher versions with minimal down time.

Proficient with SQL Server tools, including SSMS, DMA, Query Analyzer, Profiler, SQL Server Agent, SSRS and SSIS and Power Shell.

Good knowledge in PL/SQL & PowerShell scripting to automate the work.

Proficiency in ETL process by using SQL queries or BI tools like SSIS, SSRS, SSAS, ADF, ADL, AWS Redshift.

Good knowledge in Performance tuning & optimization, Bottle neck issues.

Implemented hardening process on all SQL server environment for Security.

Worked on different database technologies like (oracle, MySQL, PostgreSQL, Cassandra).

Migrated/upgraded 50+ SQL Servers from SQL Server 2012/2014 to SQL Server 2017/2019 in one year. Worked on datacenter consolidation projects to minimize project costs.

Implemented SQL Server Always ON Availability Groups for critical applications. Configured and administration of database mirroring in SQL Server

Expertise in designing complex stored procedures, leveraging TSQL features such as DECLARE, SET, and EXECUTE for streamlined database operations.

Optimized SQL queries and PL/SQL code for performance and efficiency, considering factors such as indexing, query execution plans, and data volumes.

Configure transaction replication for large SQL Server databases from database backup with minimal downtime.

Analyzed and recommended various capacity planning techniques for new Database environments and streamlined existing Database environments.

Routine tasks: Monitoring and Maintaining the security, integrity, availability of Servers, monitoring SQL Server logs, jobs and database backups, performance tuning, building packages and responding to users and developer issues.

Experience in providing Disaster recovery solutions (RPO & RTO) performed yearly DR tests for various mission critical Databases.

Great experience in Customer facing, handling escalations and responding to SLAs within stipulated times.

Expertise in resolving various Database performance issues involving Dead Locks, Database Blockings, Indexes, Statistics, Execution Plans, Query tuning and overall system health including Disk IO, Memory, CPU related issues.

Worked on Dynatrace, New relic and Spotlight Database monitoring tools for SQL Server monitoring.

Worked in 24X7 mission critical Database environments.

Experience in ON-CALL DBA work and availability round the clock for any escalations and unplanned outages.

TECHNICAL EXPERTISE:

Database

SQL AZURE (IAAS, PAAS), AWS RDS and MS SQL Server 2019, 2017,2016, 2012, 2008 R2/2008/2005, OEM 13c, PostgreSQL

Data Security

Veritas NetBackup & Backup EXEC

Operating Systems

Windows Server 2005 to 2019, Linux

Languages

TSQL, PL/SQL, Python, JSON

Technical & Functional Tools

SSMS, PGadmin, SQL Server Enterprise Manager, Query Analyzer, MS, SQL Profiler, OEM, DMA, SCCM, PowerShell, Solar wind, SC Ticketing tool, Kanban Board.

Virtualization

VMware, Hyper-V.

Certification

MCTS - win 2008 administrator, Microsoft Fundamental, Agile, Scrum Foundation, ITIL V4

PROFESSIONAL EXPERIENCE:

T-Systems international - Plano- Tx. 02/2023 - Present

Sr Consultant – SQL DBA & Backup specialist

Description: T-Systems locations in more than 20 countries and over 27,000 employees & headquartered in Germany and has a presence in Europe, T-Systems is one of the leading providers of digital services and integrated end-to-end IT solutions, driving the digital transformation of companies in all industries and the public sector

Roles and Responsibilities:

Presently associated with T-Systems as a senior consultant. I have been working in the information technology department. My Expertise is in areas of relational database systems including installation, administration, configuration, troubleshooting, monitoring and tuning in highly available environment. And I have knowledge on Cloud platform (Azure/AWS) to provide solution for Application migration. Working on Veritas Netbackup for backup solution. I am passionate in learning & utilizing it in day-to-day life

Team responsibility as a Lead with development and operation support in areas SQL Server Databases and backup / recovery for Applications.

Managing and working with offshore /onshore teams for 24x7 support to maintain max Availability environment.

Hands-on experience in Database administration on-prem and Azure SQL Databases, Managed Instance and Azure SQL VM’s

Provided mentorship for DBA team to regulate the DBA tasks and knowledge transfer for new team member.

Migrating SQL Servers from On-Prem to Azure including Standalone, Multi instance and AOAG Group servers.

Day to day operations tasks in above domains to insure maximum availability with minimum SLA bridge and by using Service now ticketing tool Maintained Incident Management, Problem Management, and Change Management services

Agile way of Methodology and using Kan-ban board with Jira tool to ensure the tasks.

Experienced with Administrative work on Microsoft Azure, AWS RDS, and Team Foundation Server administration

Handling the major incidents, upgrades, hardware migration for vendors / application with Change management.

Building reports for higher management to forecast capacity planning and "good to know" information to understand current happening in IT organization.

Providing support for Azure SQL and AWS RDS including Azure blob storage & S3 buckets

Installing and configuring the SQL server components.

Configured AOAG for sql 2019 versions to maintain HA for critical applications

utilizing TSQL's SELECT statement to retrieve and analyze data from multiple tables

By using PowerShell scripting, we have deployed hardening process for all SQL servers.

Updating servers with the latest secure patches and hot fixes through PowerShell script.

Migrated 100 + SQL Servers from On-Prem to Azure including standalone.

Migrating databases from one server to another server and fixing the orphaned users.

Maintaining VLDB Like 15 to 20TB Database

Keeping the SQL Server components, VM’s and Data disks in right server size

Created PLSQL scripts to automate updates in DB with help of SQL Agent jobs

Daily maintenance check by using sync on AOAG

shell scripting used for automatic installation of SQL server 2017, 2019 & 2022

Table partitioning done for Lage tables to increase the performance

Analyze and troubleshoot performance issues related to stored procedures, identifying and implementing optimizations to improve execution time and resource utilization.

Configured database backup path from On Prem NFS share to Azure Blob storage/ AWS S3 for full and log backup jobs.

Performing Health checks of the Production servers.

Performed the Performance Tuning, query optimization (PTO), Disaster Recovery (DR), Troubles shooting, backup and restore procedures.

Implemented clustering, replication, and other high availability measures.

Monitoring servers for managing application services on the server by using SCOM.

Planned patching calendar for quarterly wise and executed with PowerShell script for SQL Server patching for all SQL Servers.

Migrated critical SQL Servers from SQL 2008/2012/2014/2016 to higher versions with minimal down time.

Using various SQL Server tools, including SSMS, DMA, Query Analyzer, Profiler, SQL Server Agent, SSRS and SSIS and Power Shell.

Managed and configured the integration between Azure Key Vault and SQL Server on Windows VMs

Hands on in PL SQL scripting for development assist to application.

Refreshing databases from Production to Stage and Development environments.

Worked on datacenter consolidation projects to minimize project costs.

Environment: MS SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019. Windows Server 2005, 2008, 2012, 2016, 2019 Standalone & Cluster environment. Veritas NetBackup & Backup EXEC as a central backup solution. OEM to manage oracle databases, VMware.

MAN Energy Solutions - MH - India 03/ 2015 – 01/ 2023

Sr SQL DBA

Description: Founded in 1758, MAN Diesel Turbo’s and renamed in June 2018 as MAN Energy Solutions, range of goods includes complete marine propulsion systems, turbo machinery units for the oil and gas as well as the process industries and complete power plant solutions. Customers receive worldwide after-sales services marketed under the MAN PrimeServ brand. The company employs around 15,000 staff at more than 100 international sites.

Roles & Responsibilities:

Fortunate to be part of startup member for operations group in India. Worked intensively to build competencies and trust relation with IT center in Denmark & Germany. India IT center support and maintain IT infrastructure in competencies like SQL AZURE (IAAS, PAAS), MSSQL Server, oracle, NetBackup, VMware, Nasuni/NetApp/EMC Storage, MS technologies. Have very good understanding about support contract with vendors like Microsoft, IBM, VERITAS, ORACLE, Fujitsu etc.

Responsibility as a Lead with development and operation support in areas Database design & architect and backup / recovery / DR solution in MAN Energy Solutions.

Maintain operational tasks to insure maximum availability & worked in 24x7 support.

Analyze incidents to initiate change management and provide fix for the problem candidate in IT issues.

Communicate with Vendors for major upgrades, hardware migration and issues due to change in IT infrastructure.

Building reports for higher management to forecast capacity planning and "good to know" information to understand current happening in IT organization.

Prepare all necessary stuff for IT audits in domain "Information security" (Backup), Have been doing it for last 4 years.

Support various business applications like Share point, SAP, PLM, Engineering applications etc., and their deployments and maintenance.

Monitoring and troubleshooting backups of all types (SQL, Oracle, Windows, NDMP, Linux) in Veritas NetBackup.

Supported application team in creation of SQL DB on azure SQL & managed instance

Installed the SQL Server Connector for Microsoft Azure Key Vault.

Created Azure VM’s and installed sql servers for Legacy applications.

Have very good knowledge in SQL Server Up gradation and database migration.

Migrating databases from one server to another server and fixing the orphaned users.

Performing Health checks of the Production servers.

Maintained ETL process with OLTP & OLAP for transactions of data warehouse & Reports.

Good experience in Performance Tuning & query optimizing (PTO) on performance issues.

Implemented clustering, replication, and other high availability measures.

Scheduling / Rescheduling of tape backups / restores according to the priority.

Troubleshooting on various problems while taking backups and restores.

Integrate data from disparate sources and systems, including relational databases, flat files, APIs, and cloud-based platforms, to support reporting and analytics requirements by using SSIS

Perform data profiling, cleansing, and validation to ensure data quality and integrity throughout the ETL process.

Implemented Backup strategy to Performed All type of database backups of all system and production databases on Weekly and Monthly basis with PSQL scripting.

Implemented data modifications through TSQL's UPDATE and DELETE statements, ensuring data integrity and consistency.

Utilized PLSQL & TSQL transactions, employing BEGIN TRANSACTION, COMMIT, DELETE and ROLLBACK statements to maintain database integrity in multi-step operations.

Monitoring & regular jobs maintaining on VLDB like more than 15TB size DB’s

monitoring ETL jobs and logging for error handling and troubleshooting with help of Spotlight.

Remove extra space from log and data files on Weekly basis.

Created power shell scripts to automate the Hardening process on all sql servers

Supporting a wide range of backup storage targets with SSH scripting, including different types of disk-based

Environment: Pre-ops, development, QA, production servers. MS SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017. Windows Server 2005, 2008, 2012, 2016 Standalone & Cluster environment. Veritas NetBackup & Backup EXEC as a central backup solution. OEM to manage oracle databases, VMware.

Caliber Technologies Hyd - India 05/2012 – 02/2015

SQL DBA

Responsibilities:

Analyze/resolved the incidents reported in the Presto production environment and track them to closure with in SLA’s.

Investigated on the issues found in the production system and create problem tickets as required and prioritize them accordingly with the development team.

Experience in Installation, configuration of Postgres version databases.

Performing day to day Database administration activities on production servers like backup checks, space usage.

Routine checks of log and trace files to trace database activities and scheduling activities.

Creating and scheduling all DB related jobs

Validating and creating user accounts for DB

Duties also included database creation, backup/recovery, general troubleshooting, script development and documentation.

Coordinated with vendors for Sybase DB and cluster support.

Maintaining strong partnerships and working relationships with dependent internal IT groups (Infrastructure, Database Operations, Networking, Server Support, Systems Engineering, etc.) as required.

Prepared the documentation and procedures required for reference.

Migrated lower to higher version of SQL server DB and Sybase DB’s

Providing backup assistance and support to the System admin and Web Admin.

Worked independently on any DB issues.

Administrated the SQL Server 2008/2005 servers and production, pre-production, non-production databases, Application support and Performance Analysis/tuning.

Installed of service packs of SQL Server 2008/05 on Windows Server Clustered environment.

Handled database backups, restore and Disaster Recovery.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Responsible for monitoring Jobs, SQL auditing, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved file group modifications, and scheduling jobs to rebuild/reorg indexes and update statistics.

Environment: Pre-ops, development, QA, production servers. MS SQL Server 2005, 2008. Windows Server 2005, 2008Standalone, Cassandra, PostgreSQL & Cluster environment.

Contact this candidate