Phani Kumar Kolasani
Infra. Technology Specialist
Mangalore
Summary
Experienced database administrator proficient in SQL Server with over 10.5 years of expertise as looking for career change to cloud operations working in the agile model in last 4+ years in developing, supporting and maintaining AWS and Azure for different business operations.
Overview
10
10
years of professional experience
2
2
years of post-secondary education
Work History
Infra. Technology Specialist
Cognizant Technologies Services
Bangalore
08.2020 - Current
- · Working in agile environment for day-to-day activities and gathering requirements to work on the business needs on different projects which include in administrating and developing different RDS solutions.
- · Working as Sr. DBA for Medtronic CVG BU, having very huge databases (~70 TB) and legacy systems.
- · Managed to Migrate ON-prem to AWS EC2 Migration using snowball devices, data sync tools of AWS and automate the system checks and T-log migration activity using PowerShell and T-SQL.
- · Configure and implement SQL Sentry tool, create and automate alerts in SQL Sentry for better administration of SQL server instances.
- · Worked on end-to-end business application in AWS which include MariaDB RDS, S3, AWS Glue, Power shell, Python and pipelines.
- · Worked on module in business application to create SSRS reports and automate the process to upload them to the share point for an individual 3k clinics.
- · Installed and maintaining the PostgreSQL in the Unix environment, configured and scheduled automated backups.
- · creating and implementing docker in AWS lambda, encrypting and decrypting the database data using AWS KMS keys with the help of python.
- · Implemented the solution to export the data from MariaDB RDS to the share point site using python.
- · Worked and supported generative AI (Azure Translator) project for the database activities in MariaDB RDS by supporting the all the DB level activities.
Senior Database Administrator
Medtronic
Bangalore
07.2019 - 08.2020
- Working as Sr. DBA for Medtronic CVG BU, having very huge databases (~70 TB) and legacy systems.
- · Managed to Migrate ON-prem to AWS EC2 Migration using snowball devices, data sync tools of AWS and automate system checks and T-log migration activity using PowerShell and T-SQL.
- · Configure and implement SQL Sentry tool, create and automate alerts in SQL Sentry for better administration of SQL server instances.
Sr. Database Administrator
Nuware Systems LLP
Bangalore
03.2016 - 07.2019
- Manage MSSQL database administration assignments for global asset management firm AllianceBernstein Holding L.P.
- · Served as Sr. DBA implements and managing projects from business requirements analysis to solutions delivery and support.
- · Created Power shell application for SQL server recycle automation tool, which minimize manually activity by 70%, which will Blackout, Start-stop/Failover-failback SQL resources and perform health check any failed, cancelled and skipped jobs, DB status and errors in error log using Windows forms and HTML.
- · Created automation restore scripts for Azure migration activities.
- · Configure HA/DR strategies like replication, log shipping, Always-ON and clustering.
- · Worked on SSRS migration project and configure In-scale deployment for SSRS.
- · Worked in SSIS DB configure, backup, restore activities and migration of DTS to SSIS DB
Database Administrator
Wipro Technologies
Chennai
12.2013 - 03.2016
- Worked as DBA implements and for multiple accounts for semiconductors and oil and petrol business units.
- · Involved in SQL server cluster instances migration project to Pure storage.
- · Created power shell scripts which will monitor blockings, long running transaction, TEMPDB monitoring, DB backup status and disk space alerts which send mail to DBA’s.
- · Stabilize complete environment as per industry standards like and force application team to follow process.
- · Perform and schedule SQL patching activities on all DEV/QA/PROD environments in STANDALONE and CLUSTER instances.
- · Performed migration of SQL server 2008 to SQL server 2012 including log shipping and replication.
- · Worked in configure and maintenance of IIS admin services.
- · Configure and implement yearly DR/HA activities and implement log shipping and replication for DR and reporting services.
Education
Master of Science - Major in Computer Science
Acharya Nagarjuna University
Guntur, India 07.2011 - 05.2013
Skills
Database administrator
Timeline
Infra. Technology Specialist
Cognizant Technologies Services
08.2020 - Current
Senior Database Administrator
Medtronic
07.2019 - 08.2020
Sr. Database Administrator
Nuware Systems LLP
03.2016 - 07.2019
Database Administrator
Wipro Technologies
12.2013 - 03.2016
Master of Science - Major in Computer Science
Acharya Nagarjuna University
07.2011 - 05.2013
Similar Profiles
Vishal GhelotVishal Ghelot
Senior Process Executive at Cognizant Technologies ServicesSenior Process Executive at Cognizant Technologies Services
Lohithashwa ThippeswamyLohithashwa Thippeswamy
Manager, Global Pricing Team at Cognizant Technologies ServicesManager, Global Pricing Team at Cognizant Technologies Services
Yoha JaishankarYoha Jaishankar
Senior Process Executive (Accounts payables /Receivables & Payroll) at Cognizant Technologies Services Pvt LtdSenior Process Executive (Accounts payables /Receivables & Payroll) at Cognizant Technologies Services Pvt Ltd