Resume

Sign in

Project Support

Location:
Chennai, Tamil Nadu, India
Posted:
August 10, 2018

Contact this candidate

Resume:

Professional Summary:

IT Professional with * years of Experience in Oracle, PostgreSQL and My-SQL Database.

Knowledge in Cassandra and MongoDB Database Unix and Linux Platform

Currently working in APPSCORE SOLUTIONS, Chennai for Allianz Australia Insurance Limited project

Proficient in managing day to day activities and fixing database issues.

Proficient in Managing Backup and recovery by planning and performing weekly/monthly backups using Online and Offline methods.

Expertise in creation and maintenance of Database objects.

Exposure in Open-source Backup’s and Monitoring Tools.

Excellent Communication With client and end-user’s

Excellent communication, interpersonal and leadership skills along with very good understanding and experience working in a highly qualified environment.

DINESHKUMAR.A

E-mail: ac6mao@r.postjobfree.com

PH: +91-770*******

Oracle Synopsis:

Administration, Maintenance and Monitoring of Oracle 8i,9i,10g,11g,12c databases with 24x7 availability of more than 1000 Oracle databases in different environments.

Monitoring the disk space availability and tablespace resize/adding data files as per requirement.

Taking full database level/user level/table level logical backups using exp,imp and expdp,impdp.

Managing Backup and recovery by planning and performing weekly/monthly backups using Online and Offline with RMAN Utility.

Successfully performed patching for most of the environments including production.

Writing shell scripts for automating most of DBA activities like performing RMAN Backup, monitoring disk space availability, checking dataguard sync etc..and executed it successfully.

Dataguard Switchover Activities and monitoring Load log sync in D-R Site.

Postgresql Synopsis:

Worked as a team member to provide 24x7 on-call production database support.

Proficient in PostgreSQL DBA activities including configuration settings, database index creation and maintained and Query optimization.

Experience reorganization of tables and indexes within databases when needed.

Experience and Maintained standby databases, in both local and remote locations, for fail-over purposes.

Implementing and maintaining database security (create and maintain users, roles and assign privileges).

Experience in BART tool Backup in Enterprise Database.

Experience in Streaming Replication and High-Availability.

Checking Log sync and Apply if Any missing.

Experience in Performance Tunning Environment,handled Fine-Tunned Database.

Install and Monitoring PEM server and Managing more than 10 server.

Configure and monitoring of badger for monitoring purpose.

Ability to function as a team player and alternatively work independently to achieve the objectives.

Up-gradation from 9.4 to 9.5 and changing environment server to server.

My-SQL Synopsis:

Installed and configured MySQL on Linux and Windows environments.

Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and SIT/OAT environments on both Linux (5.0, 5.1) and Windows OS.

Upgrading from MYSQL 5.5 to 5.6 in different operating systems.

Expertise in database migration from MyISAM format to Innodb storage engine to increase performance and betterment of integrity constraints.

Performed MYSQL Replication setup and administration on Master-Slave.

Experienced in Database Migration from Postgres to MYSQL using MySQL Workbench Migration Wizard.

Experience in monitoring and maintaining development, testing and production environments.

Implemented and Configured MYSQL, PostgreSQL Replication for hot Standby and also handled.

Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.

Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.

Academic profile

B.C.A from Jamal Mohamed College,Trichy. Affiliated byBharadhidasan University, with 64% in 2014.

HSC in Rajah’s. Hr. Sec. School, Thanjavur with 76% in 2011

SSLC in Little Flower. Hr. Sec. School, Mannargudi With 64% in 2009.

Certifications:

Certified for completion of Oracle DB Administration Core -12c course internally with APPSCORE SOLUTIONS.

Attended a certification course on DB Moniteringby Sakthi DB Technology, Chennai.

Achievements:

Achieved A-Team Award in Logistics Project in infosys for performing patching on all the OTA and Production databases without any failure.

Achieved A-Team Award in My project in Appscore solution for effectively handling Performance related issues and also for configuring manual monitoring scripts through our primary Monitoring Tool.

Achieved Client Appreciation to create a Monitoring tool and configure for performance issue.

Professional Experience:

Working as a Software Engineer in APPSCORE SOLUTIONS from June 2014 to present.

Technical Skills:

Operating System

Linux, Solaris, HP-UX, AIX, Windows 7,2003.

RDBMS

Oracle 9i, 10g, 11g, 12c,Postgresql 9.4,9.5.9.6 MYSQL 5.4,5.5

Languages

SQL, Shell Scripting.,pl/sql

Replication Tools

Slony,DGMGRL,PG_ADMIN

Utilities

SQL*Plus, Export/Import, Data Pump, OID, AWR, ADDM,Pg_dump,Pg-ctl,pg_upgrade, OEM 12c, RMAN, MWatch (Mindtree’s monitoring tool used by CTS and TechMahindra as well).

PROJECT – 2 (August 2017 to Present)

Project Details:

Project Name : Zurich Financial Services.

Environment : Oracle 8i, 9i,10g,11g, MYSQL 5.4,5.5, Redis, Postgres, MSSQL, Solaris, AIX,Redhat Linux & Windows 2003

Role : Database Administrator.

Support : Tier 1,2 support and frequent Tier 3 support.

Responsibilities:

Administration, Maintenance and Monitoring of Oracle 8i,9i,10g,11g,12c databases with 24x7 availability of more than 1000 Oracle databases in different environments.

Monitoring the disk space availability and tablespace resize/adding data files as per requirement.

Taking full database level/user level/table level logical backups using exp,imp and expdp,impdp.

Managing Backup and recovery by planning and performing weekly/monthly backups using Online and Offline with RMAN Utility.

Successfully performed patching for most of the environments including production.

Writing shell scripts for automating most of DBA activities like performing RMAN Backup, monitoring disk space availability, checking dataguard sync etc..and executed it successfully.

Exposure in Physical and Logical standby database administration and rebuilding standby databases.

Exposure in installation and configuration of Goldengate.

Tracking all the issues and solutions, Logging SR with Support and following up with Oracle support team.

Monitoring the top accessing users and long pending sessions to find and kill longest running sessions.

User access management of database users, AWR report generations in OEM.

Creating database links to access the data from remote databases.

Exposure in dataguard switchover and Sync Operation.

Successfully created physical standby databases.

Successfully cloned many development databases from production.

Troubleshooting Database issues, OEM agent issues, RMAN Backup issues, Catalogue database issues.

Handling the ticketing tool (JIRA) to solve the oracle issues with the phase of Incident management, Change management and Problem management

Gathering stats for tuning the performance.

Registering & unregistering of databases in catalog server.

Creating Baseline for Performance Environment to choose Better Plan.

Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/DataProtecto

Built 11gr2 both RAC and Non RAC servers on Linux both OVM and baremettal server -silent and gui mode.

Monitoring RAC Node performance in Testing and Production Environment.

Experience in ASM Disk configuring and Monitoring like adding and Manageing the disk Groups.

Postgres Role of This Projects:-

Configured and Database installation creating tables, schemas, roles and accesed POSTGRESQL.CONF files using client Request.

Migrating from Oracle DB to Postgresql DB using ORA2PG and Migration Tool-Kit .

Backup and Point in time recovery in PostgreSQL Testing Server.

Creating child partitions tables for every month in PostgreSQL

EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.

Backup the Postgresql Database server using BART and Barman Tools.

Vacuum the Table if any i/o or statistics issue’s.

Monitoring the production PostgreSQL alert logs for database errors.

Check Alert Log errors and make necessary actions to rectify them.

Switch the Database from Production to Testing and Testing to Production.

Prepare weekly and monthly reports on database health check and growth.

Creating Database Links from Testing to Production databases.

Monitoring the Replication Environment and check sync activities.

Backup of Postgresql Utility using Pgdump and pgdumpall as well as File system level backup’s.

Monitoring the database for Index, partitioning Memory and I/O utilization.

Table spaces, Page setups, and user’s creation.

PROJECT - 1 (June 2014 to July 2017)

Project Details:

Project Name : Capitron bank.

Environment : Oracle 8i, 9i,10g,11g,12c,Dataguard,RACRedhat Linux & Windows 2003

Role : Database Administrator.

Support : Tier 1,2 support and frequent Tier 3 support.

Responsibilities:

Work as part of a team and provide 24*7 support.

Maintaing and adding the datafile in the ASM disk

Monitoring the RAC node performance.

DataGuard Drill in every three months.

Creating Primary Database storage structures (tablespace, datafiles) and objects like Tables, Indexes, and Profiles.

Analyze and Rebuild Index to rectify segment fragmentation.

Creating and configuring dblink and materialized views.

Monitoring the unwanted User Session and killing them if needed.

RMAN backup and restoration.

Creation of Clone database for the test database environment using RMAN.

Recovery Catalog using RMAN.

Logical Backup of Databases using Export and Import Utility as well as using Datapump.

Schemas refresh using Exp/Imp utility.

Recovery of lost objects and datafiles.

Datafile Consistency using DB Verify.

Monitoring log switch and maintain.

Tune the Query when it necessary and Analyze the AWR report at daily.

Working with parallel option depends on server.

Working with client place experience and knowledge.

Personal Details:

Father’s Name : S.Asokan. .

Date of Birth : 29-09-1993.

Nationality : Indian

Gender : Male.

Languages Known : English,Tamil.

Current Address : No.7 A,2ndCross Street,Moortyswamygal street,Padi,Chennai-600050.

Permanent Address : A 1/19,VaduvurAdichery,Vaduvur Post,Thiruvarur-Dt-614019



Contact this candidate