PHANIDHAR VARANASI
Senior Software Engineer
Hyderabad
Summary
10+ years of IT experience which includes Build & Release Management (Cloud & Infra) ,
Database Administration Worked on MS SQ Servers 2008R2, 2012, 2014 and 2016 in Production, Development environments with a proven track record in many aspects of
Database Administration, High- Availability, Disaster recovery, Installation, upgrades, security, Database mirroring, Log shipping’s, SSIS. Created Dashboards on Power BI and SSRS
Overview
10
10
years of professional experience
3
3
Certifications
Work History
Sr Software Engineer - Cloud & Infra Management
LTI Mindtree Ltd
9 2019 - Current
- Experienced working on Deployments through CI/CD Pipelines
- Experienced in working on Azure Data Factory and CI/CD pipelines
- Experienced in creating CI/CD release pipelines and also experienced in working on Azure DevOps tools like Azure Boards, Azure Pipelines, and Azure Repos.
- Design, implement, and maintain automated build
- Continuously integrate code changes from development teams into shared repositories and ensure automated builds are triggered with every commit
- Experienced in monitoring activities by using PowerShell, XTS, Kusto, SSMS by raising JIT (Just in Time) request for USG (US Government) and DOD (Department of Defense) environments
- Facilitate the continuous deployment process in Azure environment,
including staging, testing, and production, while ensuring smooth and error-free transitions - Collaborate with development, testing, and operations teams to plan, schedule, and execute releases, ensuring minimal downtime and maximum availability
- Support the entire production and staging environments for reliability, uptime, with 99.99%
- Monitor application deployments, identify and resolve issues related to build failures, deployment errors, and performance bottlenecks
- Work closely with infrastructure teams to ensure the availability and reliability of build and deployment environments, including IIS and other application servers.
- Manage version control application configurations, settings, and deployment scripts to ensure consistency and repeatability of the release process
Database Administrator & Data Analyst
Hewlett-Packard Global soft Ltd
09.2018 - 09.2019
- Migration of database from on-premise to azure.
- Designing, creating and implementing BI solutions
- Monitoring free space of database on all environments
- SQL Installations & Configuration of SQL Server 2000 / 2005 /2008/2012/2014/2016
- Setting up and Troubleshooting High Availability technologies like Log Shipping, Database Mirroring & Always On.
- Solving Disk space related issues and Log and database file full issues.
- Troubleshooting Log shipping, Database Mirroring issues.
- Efficient Backup and Recovery Techniques
- Troubleshooting job failures.
- Rebuild or Reorganizing Fragmented Indexes, Updating Statistics on tables
- Movement of Database files to other drive Locations.
- SQL server upgrades and migrations.
- Applying Service packs & patches, CU and Hot-fixes.
- Managing Production/Test/Dev/Build servers in SQL Server.
- Setup and configured Replication, Mirroring and log shipping on Production / dev / test / Build servers.
- Refreshing test/dev/build databases with production copies
- Usage of Logical, Aggregate, Text, Date & Time, Lookup, Reference, Database and Array functions
- Summarization and creating tabular form report using PivotTable
- Data Analysis: Exploratory Data Analysis, Data Cleansing. Data Visualization
- Data Manipulation: Power Query Editor
SQL Database Administrator
eSoft Consulting Ltd
06.2014 - 08.2018
- Database Administrator (SQL Server) responsible for day to day support Activities
- Handling meetings on daily and weekly basis, Preparation and Presenting Reports to Client on Weekly and Monthly trends of tickets, Pages, Issues and Challenges
- Responsible for dealing with escalations & Crisis/ Incident calls Monitor SQL Health’s Implement Hi-Availability (Log shipping, Mirroring, Always On)
- Worked on Design for Database Servers (SQL Server) Monitor daily SQL jobs, event logs, error logs and performance of the database
- Creating logins and assigning proper permissions to the created logins, mapping logins to the database and granting appropriate permissions Involved in Installing SQL Server and its service packs, and client installations as required Monitoring free space of database
- Checking the status of backup, troubleshooting the failed backups and restoration of databases Implementation of SQL Logins, Roles and Authentication modes as a part of Security Policies for various categories of User Support
- Ensuring documentation is constantly updated without any miss Work on Pages / Tickets & monitor the queue and reach SLA
- Handled On call Support
Education
Bachelor of Technology - Information Technology
Bapatla Engineering College
Bapatla, India 05.2001 -
Skills
Power BI
Certification
Oracle 11g Certified Associate IZ0-O51 and IZ0-052
Hobbies
Travel and photography
Timeline
AZ-104Microsoft Certified: Azure Administrator
02-2023
AZ-900: Microsoft Certified: Azure Fundamentals
01-2022
Database Administrator & Data Analyst
Hewlett-Packard Global soft Ltd
09.2018 - 09.2019
Oracle 11g Certified Associate IZ0-O51 and IZ0-052
07-2016
SQL Database Administrator
eSoft Consulting Ltd
06.2014 - 08.2018
Bachelor of Technology - Information Technology
Bapatla Engineering College
05.2001 -
Sr Software Engineer - Cloud & Infra Management
LTI Mindtree Ltd
9 2019 - Current