PHANINDRA KUMAR GARIKIPATI Email: adx1vu@r.postjobfree.com

Mobile: +91-897*******

Professional Summary

Holding 16+ years of total IT experience as Database Administrator.

Having 12+ years’ experience on SQL Server Database Administrator (2019/2017/2016/2014/2012 /2008 R2/2005).

Experience on Backup & Restore using Sql server & Third-party Backup tools like COMMVAULT, CA Arc serve, VERITAS.

Experience in creating plans and migrating SQL Server, SQL 2012/2014/2016/2017 to SQL 2019 using side-by-side and in-place approach in virtual machines.

Working experience on AlwaysON, Clustering, Log shipping, Database Mirroring installing, configuring, and supporting.

Experience in Azure SQL configuration for the database and automation of tuning, vulnerability Assessment, Auditing and Threat Detection.

Experience on Replication using SQL server and Third-party replication tools using CA XOSOFT.

Tuning SQL queries using SQL profiler.

Working Experience on SSAS, SSRS, SSMS & SSIS.

5+ years’ experience as an Oracle Database Administrator (19C,13C,12c, 11g,10g & 9i).

Having experience in IBM-DB2.

Performance tuning using advanced Indexes.

Experience in DRP Installation, Configuration, Testing & Documentation.

Expertise in installing different versions of Oracle on Linux and Windows operating systems.

Experience on Designing CUBES using VISUAL STUDIO.

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.

Expertise in Logical, Physical Backup and Recovery.

Extensively used 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.

Supporting Oracle Forms & Reports using Forms6i & Reports6i.

Implemented Oracle’s software striping on table spaces for optimal performance using different disk drives.

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.

Experience

Working as an Sr. MAT SQL DBA Consultant with Syntax, Hyderabad, India Sept 2021 to till date.

Worked as an Sr. Cloud Solutions Engineer with Suneratech, Hyderabad, India Sept 2018 to Sept 2021.

Worked as an IT Architect with Incadea India, Bengaluru, India Aug 2016 to Aug2018.

Worked as a Database Administrator with Punja & Sons LTD, Lautoka, Fiji. From May 2010 to July 2016.

Worked as a Database Administrator with VELJAN PVT LTD., Hyderabad, INDIA from May 2005 to April 2010.

Educational Qualifications

B.E in Electronics and Instrumentation engineering from Andhra University -2005.

Professional Qualifications

Oracle 9i PL/SQL certified Associate (OCA).

Oracle 9i DBA Certified Associate (OCA).

Oracle Forms Certified Professional (OCP).

Technical Skills

Languages : SQL, T-sql, PL/SQL.

RDBMS : SQL Server 2019/2017/2016/2014/2012/2008 R2 & 2005,

Oracle19c,13c,12c,11c & Oracle 10g, IBM-DB2.

Cloud : Azure, AWS.

ERP : Navision, ERPLN 6.1, BAAN4, Oracle.

Utilities : SQL Developer, SQL*Loader, Export, Import, RMAN, TKPROF, Toad.

Operating Systems : WINDOWS 2016/2012 R2/2008 R2,Unix & LINUX.

Third Party Tools : COMMVAULT, CA Arcserve Backup, CA XOSOFT, VERITAS, CA service

desk Manager, JIRA, Service now.

Projects Profile

Project #1:

Project Name : Syntax Production Systems.

Company : SYNTAX, HYDERABAD, INDIA.

Role : MAT SQL DBA Consultant.

Duration : Sept 2021 – Till Date.

Environment : Sql Server 2019/2017/2016/2014/2012 R2/2008 R2, Azure,

power shell,Windows 2016/ 2012,COMMVAULT, service now.

Project Description:

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.

Work responsibilities include:

Administration of MS SQL databases for various customers.

creating plan and migrating SQL Server, SQL 2012/2014/2016 to SQL 2019 using side-by-side and in-place approach in virtual machines for various customers.

Working on AlwaysON, Clustering, Log shipping, Database Mirroring installing, configuring, and supporting.

Experience in Azure, SQL configuration for the database and automation of tuning, vulnerability Assessment, Auditing and Threat Detection.

Ran the Database Migration Assistant to upgrade the existing SQL Server to Azure SQL Database.

Automated processes to reduce workflow by creating maintenance plans that runs daily to reorganize, rebuild, and update statistics, backup, and cleanup task 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.

Project #2:

Project Name : Tracfone-PSS/DSS (Production/Development System Support)

Company : Suneratech, Hyderabad, India.

Client : Tracfone, Miami, Florida, USA

Role : Sr.Cloud Solutions engineer.

Duration : September 2018 to Sept 2021.

Environment : Sql Server 2014/2012 r2/2008 r2, Oracle 19c, 13c, 12c

Linux, Windows 2012 r2 / 2008 r2, IBM-DB2, PowerShell,

CA Service desk, JIRA.

Project Description:

(Suneratech) is a leading cloud-based platforms and enterprise solutions provider specializing in Oracle & SQL, applications, and technologies. ... Based out of San Jose, California, Suneratech employs over 850 technologists spread across multiple locations in the Americas, Asia, Australasia, and Europe.

(TracFone Wireless, Inc) is an American prepaid, no-contract mobile phone provider head office is in MIAMI, FLORIDA. TFWI is a subsidiary of Mexico's largest telecommunications company, América Móvil, and offers products and services under several brands

Responsibilities’:

Supporting & Trouble shooting Sql server 2016/2014/2012 r2 & 2008 r2, Oracle 19c, 13c,12c.

Responsible for the installation, configuration, upgrade, administration, monitoring, and maintenance of complex multi database environments.

Database Backups & Security.

Optimize PL/SQL & T-SQL queries.

Support IBM-DB2 related issues.

Apply Company database design and implementation standards.

Ensure and maintain data integrity.

Upgrades and server migrations.

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.

Works with management to develop database strategies to support company needs.

Database Administration, maintaining database software and hardware health.

Maintain and enhance the existing databases.

Manages and grants access to the various databases.

Ensure that you or a team member is always available for maintenance.

Create and maintain documentation for all projects.

Capacity Planning and DR tests.

Mentor junior DBAs.

Assist with new customer database integrations and mappings.

Applying latest patches, Cumulative updates, and service packs to keep the database at current patch level.

Automated Backup & Restore process for 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 Always On, 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 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.

Project #3:

Project Name : Incadea.Myengine

Company : Incadea India, Bangalore, India.

Role : IT Architect.

Duration : August 2016– August 2018.

Environment : Sql Server 2016/2014/2012 r2/2008 r2, Windows 2012 r2 / 2008 r2,

MS Dynamics Navision 2016/2015/2013R2, PowerShell.

Project Description:

Incadea is a leading provider of enterprise software solutions and services to the global automotive retail and wholesale market. With a proven industry focus and expertise, Incadea is the vendor of choice for car manufacturers and their dealer networks around the world. Headquartered in Munich, Germany, and with a presence in 90+ countries, Incadea serves a growing community of approximately 92,000 end users across the globe and supports more than 3,500 dealerships of market-leading car manufacturers. Incadea’s recognized automotive industry expertise is embedded in proprietary software, which drives a suite of solutions, available in 21 languages and fully localized to the specific needs of individual markets. Main clients are BMW, FORD, TATA, BOSCH, OPEL, VOLKSWAGEN, and Yamaha Scandinavia.

Responsibilities’:

Installing, configuring & Trouble shooting Sql server 2016/2014 / 2012 r2 & 2008 r2.

Applying latest patches, Cumulative updates, and service packs to keep the database at current patch level.

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

Installing, Configuring and Troubleshooting Microsoft Dynamics NAV 2016/2015 &2013 r2.

Multitenant setup as per client requirement using PowerShell.

Project #4:

Project Name : Punjas ERP Package.

Company : Punja LTD, LAUTOKA, Fiji.

Role : Database Administrator.

Duration : MAY 2010– July2016.

Environment : Sql Server 2012 R2/2008 R2/2005, Visual studio 2008, windows

2008 R2, ERPLN 6.1, Baan 4, Navision 5.

Project Description:

Punjas ERP Package is an enterprise resource planning solution for Punja & Sons Ltd., an organization involved in multi-product and large-scale production. This client is maintaining the ERP Package with modules Inventory, Marketing, and Manufacturing & Financial. PUNJAS is one of the largest and most diversified conglomerates in the Republic of Fiji, situated in the South Pacific Ocean, close to New Zealand. A diverse and expanding enterprise with interests in manufacturing, milling, processing, packaging, printing, distribution, imports and exports, company combines state of the art techniques with a strong focus on customer satisfaction and a large distribution network in various South Pacific islands like New Zealand, Australia, PNG, Tonga, Samoa, Solomon’s, Vanuatu & Kiribati.

Work responsibilities include:

Administration of MS SQL databases.

Analyze the data stored in the database to make recommendations relating to performance and efficiency.

Setup and monitoring of Backup activities.

Installing & Configuring cluster environment.

Taking Backup of Database Using Full and Differential options.

Tuning SQL queries using SQL profiler.

Designing CUBES using VISUAL STUDIO.

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.

Monitor and administer DBMS security.

Add & remove users and allocate disk quotas.

Audit and check for security issues (Logs).

Working on Sql Server Analysis Services (SSAS) and Sql Server Integrated Services (SSIS).

Generating Reports Using Sql Server Reports Services (SSRS).

Installation of Visual Studio-2008 & 2005.

Installation of Different Windows Operating System.

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.

Project #5:

Project Name : Inventory Management System (IMS).

Company : VELJAN Pvt Ltd.

Role : Database Administrator.

Duration : May 2005 – April 2010

Environment : Oracle 10g, Oracle 9i, Forms6i, Reports 6i and windows

2008/2003.

Project Description:

Inventory Management System (IMS) is a web-enabled logistics solution for Contract Manufacturer’s, designed to manage the flow of raw materials, information, and financial transactions between Global Suppliers (Vendor Managed Inventory) and Manufacturers (Manufacturer Owned Inventory). With IMS, Manufacturer’s material needs are met throughout the manufacturing process in a cost and time efficient manner.

Work responsibilities include:

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

Worked on to configure Database Cloning.

Tuning experience using Explain plan, Auto trace and Tkprof utility.

Configuration of ASM, creating the database using ASM and migrating the database from Non-ASM to ASM database.

Performance tuning using advanced Indexes.

Implemented Oracle’s software striping on table spaces for optimal performance using different disk drives.

Creating Tables as per client requirements

Supporting Forms and Reports by using Forms6i and Reports6i.

Creating PL/SQL, SQL, SQL*Plus, and SQL Loader scripts to validate and call stored procedures, to validate and populate database objects before generating Oracle Error and Status reports.

Manipulating table structures and analyzing data using TOAD.

Contact this candidate