← Back to list
Senior
Registration: 27.05.2025

Phanindra Kumar Garikipati

Specialization: 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.

Skills

T-SQL
Oracle
Azure
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

Work experience

Senior MAT SQL DBA Consultant
since 09.2021 - Till the present day |Syntax
SQL Server, Database administration, T-SQL, Oracle, Azure, PowerShell, Commvault, ServiceNow
● Syntax formally known as CSI Technologies is a leading managed cloud provider for mission critical applications and manage multi-ERP deployments (SAP & Oracle) in a secure and resilient private, public, hybrid or multi-cloud environment. ● Syntax is an SAP Gold Partner, Oracle Sell Partner, AWS Advanced Consulting Partner, Microsoft Gold Partner, and IBM Silver Partner. ● Headquartered in Montreal, Canada, and with a presence in 20+ countries, Syntax serves a growing community and supports more than 1000 customers across all business segments. Project: Syntax Production Systems. ● Administration of MS SQL databases for various customers mainly on production environment. ● Creating plan and migrating SQL Server, SQL 2012/2014/2016 to SQL 2022/2019 using side-by-side and in-place approach in virtual machines as well windows on production environment for various customers. ● Working on Replication, AlwaysON, Clustering, Log shipping, Database Mirroring installing, configuring, and supporting on production environment. ● Experience in Azure, SQL configuration for the database and automation of tuning, vulnerability Assessment, Auditing and Threat Detection. ● Data Migration using SQL scripts & by using SSIS. ● Ran the Database Migration Assistant to upgrade the existing SQL Server on-premises to Azure SQL Database. ● Automated processes to reduce workflow by creating maintenance plans that run daily to reorganize, rebuild, and update statistics, backup, and cleanup tasks for various customers. ● Analyse the data stored in the database to make recommendations relating to performance and efficiency. ● Regular housekeeping activities such as database indexing, Log clearance and data archiving. ● Taking Backup of Database Using Full, Differential and Transactional log options using native Sql server and Commvault Backup tool. ● On-call 24/7 SQL Server Production Database Administration, support, and monitoring for proactive problem resolution. ● Participated in Designing, Testing, and Implementing an Enterprise Disaster Recovery Plan (DRP). ● Handling Fine Tuning Operating System in-coordination with Server and Network administrator to utilize the maximum resources for Database and Applications. ● Solving critical production problems and performing point in time recovery plans. ● Install and maintain Software applications version upgrade, patch update, and provide user support. ● Maintains logs/documentation of work activities, system/ dBase modifications, maintenance activities, system configurations and other activities.
Senior Cloud Solutions Engineer
09.2018 - 09.2021 |Suneratech
SQL Server, Database administration, T-SQL, Oracle, IBM-DB2, PowerShell, CA Service desk, JIRA
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 Server, Database administration, T-SQL, Oracle, MS Navision, PowerShell
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
SQL Server, Database administration, T-SQL, Oracle, Visual studio, ERPLN 6.1, Baan 4, Navision 5
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
Database administration, T-SQL, Oracle 10g/9i, Forms6i, Reports 6i
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.

Educational background

Electronics and Instrumentation Engineering (Bachelor’s Degree)
Till 2005
Andhra University

Languages

EnglishProficient