Home

Anroop Reddy - SQL Server DBA

[email protected]

Location: Dallas, Texas, USA

Relocation: Yes

Visa: H1B

Anroop Reddy SQL Server DBA (469) -848-4813 [email protected] Dallas, TX Yes H1B PROFESSIONAL SUMMARY: Over 11 Years of experience into Azure SQL server, SQL Database Administration, Performance Tuning, Veritas NetBackup, oracle OEM and application development Hands-on experience in Database administration Azure SQL Databases and Azure SQL VM s. 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 2019/2017/2016/2014/2012/20008R2/2008 installation and post configuration of SQL Server 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. Design and Development on OLAP and OLTP database solutions, Data Warehousing Used ETL tools (SSIS) to retrieve data from source systems. Implemented hardening process on all SQL server environment for Security. worked on different database technologies like (NEW SQL, MySQL, PostgreSQL). Planning and 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 Configure transaction replication for large SQL Server databases from database backup with minimal downtime. 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. TECHNICAL EXPERTISE: Database SQL AZURE(IAAS, PAAS) and MS SQL Server 2019, 2017 ,2016, 2012, 2008 R2/2008/2005, OEM 13c, MYsql Data Security Veritas NetBackup & Backup EXEC Operating Systems Windows Server 2005 to 2019, Linux Languages TSQL, PL/SQL, Python, JSON Technical & Functional Tools SSMS, 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 Microsoft Azure (DP-300), MCTS -win 2008 administrator, Microsoft Fundamental, Agile, Scrum Foundation, ITIL V4 PROFESSIONAL EXPERIENCE: T-Systems Feb-2023 - Present Sr Consultant - SQL Server DBA & Backup specialist Description: 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 Microsoft SQL Server including installation, administration, configuration, troubleshooting, monitoring and tuning in highly available environment. I have working knowledge on Veritas NetBackup a backup solution for enterprise. And I have knowledge on Cloud platform (Azure) to provide solution for Application migration. I am passionate in learning and utilizing it in day-to-day life. Working knowledge of Windows server based operating systems and oracle DB examine on OEM. Roles and Responsibilities: Team responsibility with development and operation support in areas SQL Server Databases and backup / recovery for client project MES & SHELL. Hands-on experience in Database administration on-prem and Azure SQL Databases and Azure SQL VM s Experience in 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. Agile way of Methodology and using Kanban board to ensure the tasks. Experience with Administrative work on Microsoft Azure 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 and Hyper-V Virtual machines Installing Regular monthly security patches Updating servers with the latest secure patches and hot fixes through IPAK. Experience on In-place Upgrade on 2012 and higher. Migrated 300 + SQL Servers from On-Prem to Azure including standalone, Migrating databases from one server to another server and fixing the orphaned users. Keeping the SQL Server VM s and Data disks in right server size Move TempDB database to ephemeral disk. Update database backup path from On Prem NFS share to Azure Blob storage for full and log backup jobs. Performing Health checks of the Production servers. Good experience in Performance Tuning, Disaster Recovery, Troubles shooting, backup and restore procedures. Implement clustering, replication, and other high availability measures. Monitoring servers for managing application services on the server. Troubleshooting on various problems while taking backups and restores. 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. Proficient with database backups and recovery models. Refreshing databases from Production to Stage and Development environments. Worked on datacenter consolidation projects to minimize project costs. Environments worked: Production, PRE-Production, DEV 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 Jul 2015 Jan 2023 Sr SQL DBA Location: Pune 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 & 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 SQL Server/Oracle Databases and backup / recovery in MAN Energy Solutions. Maintain operational tasks to insure maximum availability. 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 PLM, Engineering applications etc., and their deployments and maintenance. Monitoring and troubleshooting backups of all types (SQL, Oracle, Windows, NDMP, Linux) in Veritas NetBackup. 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 & Reports. Good experience in Performance Tuning, Disaster Recovery, Troubles shooting, backup and restore procedures. Implement 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. Perform DBCC CHECKDB on all restored system and Production databases. Perform full / differential database backups of all system and production databases on Weekly and Monthly basis. Remove extra space from log and data files on Weekly basis. Supporting a wide range of backup storage targets, 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 May 2012 Jun 2015 SQL DBA Location: Hyderabad Responsibilities: Incident management: Analyzing/resolving the incidents reported in the Presto production environment and track them to closure with in SLA s. Problem management: Investigate on the issues found in the production system and create problem tickets as required and prioritize them accordingly with the development team. 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 Duties also included database creation, backup/recovery, general troubleshooting, script development and documentation. Coordinating with vendors for 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. Preparation of documentation and procedures required for reference. Migration from SQL 2000 / SQL 2005 to SQL 2008 Providing backup assistance and support to the System admin and Web Admin. Working 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. Installation of service packs of SQL Server 2008/05 on Windows Server Clustered environment. Responsible for 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 & Cluster environment. s Keywords: quality analyst access management database information technology microsoft procedural language South Carolina Texas