← В ленту ![]()
Senior
Регистрация: 27.05.2025
Phanindra Kumar Garikipati
Специализация: Database Administrator
— Holding 17+ years of total IT experience as Database Administrator on production environment.
— Having 14+ years’ experience in SQL Server Database Administrator (2022/2019/2017/2016/2014/2012 /2008 R2/2005) on Production environment.
— Experience on Backup & Restore using Sql server & Third-party Backup tools like COMMVAULT, CA Arc serve, VERITAS.
— Experience on Replication using SQL server and Third-party replication tools using CA XOSOFT.
— Experience in creating plans and migrating SQL Server, SQL 2012/2014/2016/2017 to SQL 2019/2022 using side-by-side and in-place approach in virtual machines as well windows environment.
— Working experience on AlwaysON, Clustering, Log shipping, Database Mirroring installing, configuring, and supporting.
— Experience in Azure SQL configuration for the database, migration, and upgradation from on-premises to cloud, automation of tuning, vulnerability Assessment, Auditing and Threat Detection.
— Working Experience on SSAS, SSRS, SSMS & SSIS.
— Performance tuning using advanced Indexes.
— Experience in DRP Installation, Configuration, Testing & Documentation.
— Creating Database, Table spaces, database links, rollback segments, indexes, and other database objects.
— Creating Users, Roles, Profiles and Granting and revoking the privileges to the Users.
— Creating Functions,Procedures & Triggers.
— 5 years’ experience as an Oracle Database Administrator (19C,13C,12c, 11g ,10g & 9i).
— Having experience in IBM-DB2.
— Expertise in installing different versions of Oracle on Linux and Windows operating systems.
— Experience on Designing CUBES using VISUAL STUDIO.
— Expertise in Logical, Physical Backup, Recovery, Export/Import & SQL Loader utilities.
— Experience in Configuring Standby Database for fail-over situations, Multiple Archive-Log Destinations that support Standby Databases.
— Implemented Recovery Manager Utility (RMAN) for easier and well-managed recovery procedures.
— Implemented in Oracle with new features UNDO Table space, Resumable Space Management, Segment Space Management, Data Guard (no-data-loss, Database Switchover facility), List partitioning etc.
— Tuning experience using Explain plan, Auto trace and Tkprof utility.
— Ability to Diagnose the Database and Application Performance issues and able to give the suggestions to developers to tune applications and able to tune the database.
— Expertise in installing different versions of Windows Operating systems server end.
— Support experience on Active Directory as well exchange.
— Trouble shooting Database & Application related issues on 24X7 basis.
— Installing & Configuring ERP Packages like Navision, Baan & Oracle.
— Holding 17+ years of total IT experience as Database Administrator on production environment.
— Having 14+ years’ experience in SQL Server Database Administrator (2022/2019/2017/2016/2014/2012 /2008 R2/2005) on Production environment.
— Experience on Backup & Restore using Sql server & Third-party Backup tools like COMMVAULT, CA Arc serve, VERITAS.
— Experience on Replication using SQL server and Third-party replication tools using CA XOSOFT.
— Experience in creating plans and migrating SQL Server, SQL 2012/2014/2016/2017 to SQL 2019/2022 using side-by-side and in-place approach in virtual machines as well windows environment.
— Working experience on AlwaysON, Clustering, Log shipping, Database Mirroring installing, configuring, and supporting.
— Experience in Azure SQL configuration for the database, migration, and upgradation from on-premises to cloud, automation of tuning, vulnerability Assessment, Auditing and Threat Detection.
— Working Experience on SSAS, SSRS, SSMS & SSIS.
— Performance tuning using advanced Indexes.
— Experience in DRP Installation, Configuration, Testing & Documentation.
— Creating Database, Table spaces, database links, rollback segments, indexes, and other database objects.
— Creating Users, Roles, Profiles and Granting and revoking the privileges to the Users.
— Creating Functions,Procedures & Triggers.
— 5 years’ experience as an Oracle Database Administrator (19C,13C,12c, 11g ,10g & 9i).
— Having experience in IBM-DB2.
— Expertise in installing different versions of Oracle on Linux and Windows operating systems.
— Experience on Designing CUBES using VISUAL STUDIO.
— Expertise in Logical, Physical Backup, Recovery, Export/Import & SQL Loader utilities.
— Experience in Configuring Standby Database for fail-over situations, Multiple Archive-Log Destinations that support Standby Databases.
— Implemented Recovery Manager Utility (RMAN) for easier and well-managed recovery procedures.
— Implemented in Oracle with new features UNDO Table space, Resumable Space Management, Segment Space Management, Data Guard (no-data-loss, Database Switchover facility), List partitioning etc.
— Tuning experience using Explain plan, Auto trace and Tkprof utility.
— Ability to Diagnose the Database and Application Performance issues and able to give the suggestions to developers to tune applications and able to tune the database.
— Expertise in installing different versions of Windows Operating systems server end.
— Support experience on Active Directory as well exchange.
— Trouble shooting Database & Application related issues on 24X7 basis.
— Installing & Configuring ERP Packages like Navision, Baan & Oracle.
Скиллы
T-SQL
Oracle
Azure/Aws
Aws
SQL
PL/SQL
SQL Server
IBM-DB2
Navision
ERPLN 6.1
BAAN4
SQL*Loader
Export
Import
RMAN
TKPROF
Toad
Commvault
CA ARCserve Backup
CA XOsoft
Veritas
CA Service Desk Manager
JIRA
ServiceNow
Опыт работы
MAT SQL DBA Consultant
с 09.2021 - По настоящий момент |Syntax
SQL, Database administration, T-SQL, Oracle
Cloud Solutions Engineer
09.2018 - 09.2021 |Suneratech
SQL, Database administration, T-SQL, Oracle
Project: Tracfone-PSS/DSS (Production/Development System Support).
● Supporting & Trouble shooting Sql server 2016/2014/2012 r2 & 2008 r2, Oracle 19c, 13c,12c on production environment.
● Responsible for the installation, configuration, upgrade, administration, monitoring, and maintenance of complex multi database on production environments.
● Database Backups, Recovery, Security, Optimize PL/SQL & T-SQL queries.
● Analysing and Designing replication setup to clients as per there requirement.
● Designing High availability solutions like Always On, DB Mirroring, Log shipping.
● Participate in the design and creation of complex databases.
● Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
● Manages and grants access to the various databases.
● Capacity Planning and DR tests.
● Applying latest patches, Cumulative updates, and service packs to keep the database at current patch level on production environment.
● Data Migration from old version to new version, writing SQL scripts & by using SSIS.
● Extensively using Import/export Data commands in Sql server.
● Suggesting Disk Capacity, Processors and Memory based on the Capacity planning.
● Maintain all the SQL documents include installation and data conversion Procedures documents.
● Monitor alter logs, space and object growth related problems in the databases.
● Estimating of Table sizes and Record sizes. Maintaining proper licenses.
● Trouble shooting Database related issues on 24X7 basis.
● Hardware sizing as per client requirement.
IT Architect
08.2016 - 08.2018 |Incadea
SQL, Database administration, T-SQL, Oracle
Project: Incadea.Myengine.
● Installing, configuring & Trouble shooting Sql server 2016/2014 / 2012 r2 & 2008 r2 on production environment.
● Applying latest patches, Cumulative updates, and service packs to keep the database at current patch level on production environment.
● Automated Backup & Restore process for various client databases.
● Data Migration from old version to new version, writing SQL scripts & by using SSIS.
● Extensively using Import/export Data commands in sql server.
● Analysing and Designing replication setup to clients as per there requirement.
● Designing High availability solutions like AlwaysON, DB Mirroring, Log shipping.
● Suggesting Disk Capacity, Processors and Memory based on the Capacity planning.
● Maintain all the SQL documents include installation and data conversion Procedures.
● Monitor alter logs, space and object growth related problems in the databases.
● Estimating of Table sizes and Record sizes. Maintaining proper licenses.
● Trouble shooting Database related issues on 24X7 basis.
● Hardware sizing as per client requirement.
● Installing, Configuring and Troubleshooting Microsoft Dynamics NAV 2016/2015 &2013r2.
Database Administrator
05.2010 - 07.2016 |Punja & Sons LTD
SQL, Database administration, T-SQL, Oracle
Project: Punjas ERP Package.
● Administration of MS SQL databases.
● Installing & Configuring cluster environment.
● Taking Backup of Database Using Full and Differential options.
● Designing CUBES using VISUAL STUDIO.
● Created Replication Using Snapshot, Transactional & Merge Publication.
● Expertise in Log shipping & Database Mirroring.
● Maintaining IBM & HP tape backups every day.
● Solving critical production problems and performing point in time recovery plans.
● Proven ability to handle Database of more than 1 TB in Size.
● Working on Sql Server Analysis Services (SSAS) and Sql Server Integrated Services (SSIS).
● Generating Reports Using Sql Server Reports Services (SSRS).
● Installation of Different Windows Operating System, Visual Studio-2008 & 2005.
● Creating users and give permissions on Active Directory as well exchange2010.
● Installation of Third-Party Tools Such as CA Arc serve Backup & CA XOSOFT.
● Installing, Configuring and Troubleshooting Microsoft Dynamics NAV 5.0.
● Installing and configuring ERPLN 6.1 & BAAN IV.
Database Administrator
05.2005 - 04.2010 |VELJAN PVT
SQL, Database administration, T-SQL, Oracle
Project: Inventory Management System (IMS).
● Creating Database, Table spaces, database links, rollback segments, indexes, and other database objects.
● Creating Users, Roles, Profiles and Granting and revoking the privileges to the Users.
● Expertise in Logical, Physical Backup and Recovery of Database.
● Implementing Recovery Manager Utility (RMAN) for easier and well-managed recovery procedures.
● Implementing Oracle 9i/10g with new features UNDO Table space, Resumable Space Management, Segment Space Management, Data Guard (no-data-loss, Database Switchover facility), List partitioning etc.
● Implemented features of Oracle 9i &10g like Log Miner, Transportable Table spaces, Locally Managed Table spaces.
● Management of Flash back Query, Flashback versioning, Flashback table, and User Management In 10g.
● Extensively used Export/Import utilities for selective backup.
● Configuring Standby Database for fail-over situations, Multiple Archive-Log Destinations that support Standby Databases.
Образование
Electronics and Instrumentation engineering (Бакалавр)
По 2005
Andhra University
Языки
АнглийскийСвободно владею