Senior Associate Database Administrator

Naga Babu Ganta

+1-361-***-**** *************@*****.***

Career Objective:-

To build a long-term career in an organization with opportunities for career growth and use cutting edge technologies to solve issues in an effective/creative manner in a challenging position.

Designation and Organization:-

Senior Associate Pacific Life – Cognizant Technology Service Dec 2019 - Till Now

Senior Associate M&T Bank– Virtusa Pvt Ltd Feb 2018 – Nov 2019

Technology Analyst Capital Group Companies - Infosys Ltd Dec 2014 – Feb 2018

System Engineer GE Healthcare – Tech Mahindra Jun 2012 – Nov 2014

PROFESSIONAL SUMMARY

12 years of experience in database administration for Oracle, Postgresql, MS SQL databases on AWS, Linux and Microsoft Windows platforms. Senior Database Administrator with extensive experience in Installation, Upgradation, Migration, Backup and Recovery, Cloning, Replication, Oracle Golden Gate, Database Security, Memory Management, Performance Monitoring, Tuning, RAC, Data Guard, Grid Control, Replication configuration, Space management, Capacity Management.

Migration of databases from non-cloud infrastructure to AWS Cloud.

Installation and configuration of new databases on Could and non-Cloud infrastructure.

Perform Scalability, Fault tolerance, High Availability Performance testing, recommendation and implementation

Extensive knowledge on database administration for Oracle 19C, 12C, 11g, 10g with a large-scale database environment up to 4TB and mission critical OLTP systems in a variety of environments like EC2, IBM-AIX, RHEL and Windows.

Experience in planning, creation, administration and troubleshooting of Oracle, MSSQL and Postgresql, OLTP (multiple instances) databases.

Configured and maintain Data Replication Tools like Oracle Golden Gate, Oracle Gateways and Linked servers in MSSQL

Create and manage the databases in azure and OCI cloud environments

Experience in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Cloud Control, Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.

Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and fail over on RAC database for high availability.

Strong experience in migrating database from Non-ASM to ASM.

Hands on experience in Oracle RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery).

Solid experience in configuring disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with and without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.

Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

Have implemented replication using two types of standby databases such as logical standby and physical standby databases supported by DATAGUARD for high availability.

Excellent experience in various data load techniques like export/import, Data pump, SQL loader

Experience on Data Replication using Materialized views, import/export.

Writing scripts in the UNIX based environments for managing the user’s roles and privileges, scheduled backups (using data-pump /cold backups), manage statistics, Disk space management.

Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.

Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Installed, managed and administrated the MS SQL Server 2012/08/05 Production and Non Production Servers.

Setup development, testing and production environment with SQL Server 2017 and 2012 R2 Enterprise edition.

Performed installation of SQL Enterprise 2017 64bit version on standalone servers in enterprise data centers. Patch applications.

Performed Failover drill tests to check the High Availability during disasters

Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.

Created Logins for the users and manage their permissions.

Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Good understanding on High Availability concepts Alwayson, Log shipping and mirroring concepts

Handson Experience in Backup and restore, point-in-time recovery in MSSQL databases

Experience in installation, configuration, migration and upgrade of MSSQL servers

Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans

Configured DB mail by creating accounts and profiles.

Provided On call Production support.

Implemented partitioning on large table to get the performance.

Used table hints in the queries to avoid locks in the server.

Created missing indexes on the tables by running Data Base Engine Tuning Advisor.

Created jobs and scheduled jobs according to Requirements in MSSQL

Scheduling the cron jobs in linux servers for Oracle and Postgresql

Created Linked Server between SQL Servers.

Implemented SQL Server Clustering on VM Ware.

Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.

Worked with SQL Server Profile to Generate Traces.

Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Used SQL Profile to capture the activities of the database and used the trace file as workload file to the Database Tuning Advisor for index recommendation.

Migrating the databases from postgres and MSSQL to oracle using the Sql developer

Install, configure, and upgrade PostgreSQL software and Set up databases and schemas to meet application requirements.

Refreshing the Testing environment with the latest data from production using the pg_dump utility

Implemented PostgreSQL streaming replication for main production database.

Backing up and restoration of database using the tools like pg_basebackup and barman

Manage database users, roles, and permissions and Enforce database security policies, including encryption, access controls, and auditing.

Perform routine maintenance tasks like vacuuming, analyzing, and reindexing

Configuring and managing the Streaming and Logical replications

Perform routine maintenance tasks like vacuuming, analyzing, and reindexing

Certification: -

OCI Foundation Associate

Oracle Database @ Azure

Professional Trainings:-

●Oracle 10g Administration

●IMS certified professional by Mahindra Satyam.

●Bash Shell Programming

●Oracle Enterprise Manager training

Technical Skills:

Operating Systems

IBM AIX, Red Hat Linux,Microsoft Windows, AWS,Azure and OCI Cloud

Databases

Oracle 19C, 12C/11g/ Oracle 11g/10g Real Application Cluster (RAC), ASM, Postgresql 14

Tools and Utilities

PgAdmin,SSMS,Oracle GoldenGate, RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations

Languages

SQL, PL/SQL, UNIX Shell Scripting,CGI Webpages

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

PROJECTS :

Pacific Life Insurance, California Dec 2019 to till date

Pacific Life Insurance Company is an American insurance company was founded in 1868 and is headquartered in Newport Beach, California. Together with Pacific Life, the Foundation has contributed more than $142 million to community and national nonprofit organizations. Grants are made to organizations that address a broad spectrum of social needs.

Roles And Resposibilities:-

Install, configure, and upgrade PostgreSQL software and Set up databases and schemas as per the user requirements

Manage database users, roles, and permissions

Install and configure the PgAdmin tool and administer the databases using PgAdmin

Configure the backups using the pg_basebackup utility

Jobs schedule using the crontab in linux servers

Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Configured High Availability concepts Alwayson, Log shipping and mirroring between the MSSQL databases

Handson Experience in Backup and restore, point-in-time recovery in MSSQL databases

Experience in installation, configuration, migration, and upgrade of MSSQL servers

Enforce database security policies, including encryption, access controls, and auditing

Perform routine maintenance tasks like vacuuming, analyzing, and reindexing

Scheduled backup and maintenance jobs in sql server agent

Configure the monitoring in OEM for Oracle Databases and postgresql,Mysql databases using plugins

Install, configure postgresql software and upgrade PostgreSQL databases

Automating the tasks using shell and batch scripts

Database upgrades and patching in Oracle databases

Upgraded the Oracle Databases from Oracle 12c to 19c

Design and management of databases in Oracle cloud infrastructure.

Defining the cloud migration strategy from on premises to oracle cloud infrastructure

M&T Bank, New York Feb 2018 to Nov 2019

M&T Bank Corporation (Manufacturers and Traders Trust Company) is an American bank holding company headquartered in Buffalo, New York.It operates 1,000+ branches in 12 states across the Eastern United States.Wilmington Trust is a subsidiary of M&T Bank Corporation, offering global corporate and institutional services, private banking, investment management, and fiduciary services.

Roles And Resposibilities:-

Daily health checks on all servers, resolving the issues and updating the status with client.

Experienced in providing 24X7 support to maintain all Databases up and running in production environment

Implementation and maintenance of Replication using the Golden Gate

Implementation and maintenance of Physical and logical Standby Databases

Upgrade the databases from Oracle 11g to Oracle 12c

Applied the quarterly patches to Oracle databases

Capital Group Company, New York Dec 2014 to Feb 2018

CenturyLink, Inc. is an American telecommunications company, headquartered in Monroe, Louisiana, that provides communications and data services to residential, business, governmental, and wholesale customers in 37 states.[5] A member of the S&P 500 index, the company operates as a local exchange carrier and Internet access provider in U.S. markets and is the third-largest telecommunications company in the United States in terms of lines served, behind AT&T and Verizon.[6] It also provides long distance service. And, a IT Service provider for Fortune 500 Companies.

Roles And Resposibilities:-

Handling the listener issues and purging the listener log to avoid the connectivity issues.

Handling the RMAN backup failures and confirming the having consistent backups of production databases.

Performed RMAN Point in time Database recovery and refresh the nonprod databases using rman duplicate

Worked on performance issues and tune the queries using the SQL advisor

User Management and Security Management Activities to meet Company Standards.

GE Healthcare, Chicago Jun 2012 to Nov 2014

GE Healthcare (GEHC), a $15 billion unit of General Electric Company, provides transformational medical technologies and services in medical imaging and information technologies, medical diagnostics, patient monitoring systems, performance improvement, drug discovery, and biopharmaceutical manufacturing technologies. As to support the business, client has a mixture of OLTP databases implemented on Oracle 9i/10g and 11g versions e functionality.

Roles And Resposibilities:-

Hands on experience and good understanding of Oracle9i/10g and 11g.

Daily health checks on all servers, resolving the issues and updating the status with client.

Experienced in providing 24X7 support to maintain all Databases up and running in production environment

Monitoring mount points and Space management of archive logs and application Backup dumps and taking proper action within SLA timelines.

Proactively involved in automation of alert log file on timely base to capture any ORA errors, and space utilization issues to hit to DBA mailbox.

Experience on Storage tasks, space management including creation and maintenance of data files and tablespaces and other database structures like rollback segments, resizing redo logs etc

Handling the new requests of user management tasks like creating, dropping user and assigning him different roles, privileges and profiles.

Handling the performance issue’s on database servers and taking the action in time as per SLA and after identifying the root cause to avoid the recurrence of the same.

Deploying and configuring the scripts on all data centers and automated the shell script jobs in timely manner.

User Management and Security Management Activities to meet Company Standards.

Database links were created to access the data from remote databases of GEHC.

Performing dev database refresh with Prod copy as per the requirement using rman duplicate.

Handling the schema refreshes or selective objects export and imports from one database to other servers, based on client requests.

Managing Database connectivity’s issues and tuning their Performance

Education: -

B.Tech (Computer Science Engineering) from Regency Institute of Technology affiliated to Pondicherry University.

Contact this candidate