Database Administrator Sql Server

PHANINDRA KUMAR GARIKIPATI Email: ************@*****.**.**

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

Professional Summary

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.

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.

Technical Skills

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

RDBMS : SQL Server 2022/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 2022/2019/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 2022/2019/2017/2016/2014/2012 R2/2008 R2,

Azure, power shell,Windows 2016/ 2012,COMMVAULT,

service now.

Position : Team Lead 3-DBA

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

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.

Position : Team Lead 2-DBA.

Responsibilities’:

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.

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 Navision 2016/2015/2013R2, PowerShell.

Position : Team Lead 3-DBA & 2 ERP.

Responsibilities’:

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.

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.

Work responsibilities include:

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.

Project #5:

Project Name : Inventory Management System (IMS).

Company : VELJAN Pvt Ltd.

Role : Database Administrator.

Duration : May 2005 – April 2010

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

2008/2003.

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

Contact this candidate