Anand Kumar
Summary
Highly accomplished, Deeply Driven, Database administrator having a total of more than 10 years of broad-based expertise in the multiple areas of Oracle, MSSQL database administration with in-depth hands-on in Real application clusters (RAC & ASM) 9i, 10G,11g,12c,19c, Performance Optimization, Partitioning, Advanced Replication, Golden Gate, RMAN Backup and Recovery, Grid Control, Data guard setup , Shell scripting and 19c migration approach
Overview
16
16
years of professional experience
Work History
Sr. Manager
LTIMINDTREE
10.2022 - Current
- Handling the production call management updates with the client
- Supporting/Resolving the issues within SLA
- Golden Gate Setup and troubleshooting all issues in Golden Gate
- Golden Gate Bidirectional and unidirectional setup for both DML/DDL replication
- Pro-active performance analysis, monitoring, troubleshooting and resolution of issues
- Installation/upgrade of oracle 12c to 19c as part of tech current project activity
- Creation of New instance ,11g/12c both RAC and standalone Database
- Data Migration of 12c to 19c RBMS, designing and finalizing approach
- Handling the Monthly schedule DR Drill activities
- Apply RDBMS/GRID/GG patches
- Effective troubleshoot, research, analyze issues
- Use of SQL diagnostic and tuning tools like AUTOTRACE (AWR/ADDM Reports)
- Performance information and monitoring/interpreting alert log and trace files
- Handling Import/Export like schema, table, full database etc
- Attend daily change requests for production database
- Autosys (Jobs Running) tool and implement the scripts for automation
- RMAN cloning from PROD to Lower Env and taking care of Pre/Post Cloning activity
- Cloning Oracle Applications and Databases between DEV, UAT, CPRD and Production Environments
- Configuring Backup (RMAN) for database and restoring database
- Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action plan
- Support the team for application availability, reliability and stability on a 7 by 24 by 365 basis
- Provide support and leadership in critical production support issue resolution
- Provide support for product deployment and release management
- Work with team to achieve timely resolution of all production issues meeting or exceeding Service Level Agreements
- Learn new technology, systems, and products as changes are implemented
- Migration of Dev Environment to ORAAS
- RMAN cross platform migration
- Writing shell scripts /Automation script for frequent activity
- Like export/import, Golden gate status.
Sr. Technical Consultant
Infosys
09.2019 - 04.2022
Sr. Technical Consultant
Larsen & Turbo
10.2018 - 09.2019
Sr. Database Analyst
Nityo Internation Pte Ltd
03.2015 - 10.2018
Senior Technical Lead
Standard Chartered Bank
06.2008 - 01.2015
- We Support 100+ Oracle databases with Prod/Dev/SIT/UAT environments as onsite/offshore model
- Handling the database migration from legacy to the new servers
- Managing the database regular activities
- Database/Schema Refresh from Prod to Dev/UAT/SIT after each release
- Production Deployment for each Release
- Supporting/Resolving the issues within SLA
- Pro-active performance analysis, monitoring, troubleshooting and resolution of issues
- Resolving the backup failures and issues
- Handling the data guard issues with the 11g environment
- RMAN cloning for setup new Env for development Team for new Release
- Providing Solution for Query by running Sql tune Advisor
- Creation of multiple databases using DBCA and Manually by following OFA as per the requirement by the company/development team
- Create or clone the Oracle Instance and Databases on ASM
- Perform database cloning and re-location activities
- Managing table spaces, data files, redo logs, tables and its segments
- Maintaining data integrity also managing profiles, resources and password security
- Managing Users, Privileges and Roles
- Installation of Oracle software and patches
- Upgrading the 9i databases to 10g including data guard
- Upgrading the Database from lower version to higher version
- Tune SQL statement against database and its objects
- Write script to monitor the database with shell and PL/SQL code or SQL code such as procedure, function and package
- Writing shell scripts for sql loader to import the files received.
Education
Master of Computer Applications - Computer Science
SRI RAMAKRISHNA ENGINEERING
COIMBATORE06.2008
Skills
- Oracle 19c RDBMS
- Oracle Goldengate Classic and Microservices
- Linux Shell Scripting
- Oracle Performance Tunning
- Goldengate Veridata
- Backup and Recovery (RMAN)
Languages
Tamil
Intermediate (B1)
English
Upper intermediate (B2)
Hindi
Intermediate (B1)
Ms Sql
Installation, Configuration, Maintenance of MS SQL in Server 2012, Mirroring, Always On, Log Shipping, Creating the databases as per the client requests.
Education Certification
Anna University Chennai, Bharathiyar university Coimbatore
Technical Platforms Other Information
- HP-UX, AIX, Linux, Windows, Oracle (12c, 11g, 10g, 9i), MSSQL, SQL, PL/SQL, UNIX Shell Scripting, Oracle Enterprise Manager, SQL
- Plus, TOAD, Net Backup, RMAN, SQL, Unix Shell scripts, Oracle Golden gate, Oracle Data guard, Oracle Data Pump, Export/Import, Sql
- Loader, DBFS, ASM
Technical Trainings Certifications
- Oracle Certified Associate (OCA)
- Oracle Certified Professional (OCP) in Oracle 10g Database Administration
- Oracle Certified on Oracle Golden gate 12c
- Oracle 10g course certification from SQL Star International, Chennai
Personal Information
- Date of Birth: 10/02/1984
- Marital Status: Married
Timeline
Sr. Manager
LTIMINDTREE
10.2022 - Current
Sr. Technical Consultant
Infosys
09.2019 - 04.2022
Sr. Technical Consultant
Larsen & Turbo
10.2018 - 09.2019
Sr. Database Analyst
Nityo Internation Pte Ltd
03.2015 - 10.2018
Senior Technical Lead
Standard Chartered Bank
06.2008 - 01.2015
Master of Computer Applications - Computer Science
SRI RAMAKRISHNA ENGINEERING
Similar Profiles
Srestha BoseSrestha Bose
Specialist Senior Software Engineer at LTIMINDTREESpecialist Senior Software Engineer at LTIMINDTREE
Arivu PeriyasamyArivu Periyasamy
Network Specialist at LTIMindtreeNetwork Specialist at LTIMindtree
Vuppala Veeran Pranav GuptaVuppala Veeran Pranav Gupta
Leadership Recruiter at LTIMindtreeLeadership Recruiter at LTIMindtree