Jishi Jacob K.J
Kochi,Kerala
Summary
Resourceful hands on with 12 years of experience with the database from designing, developing, implementing, networking, monitoring and managing of users, performance tuning of applications and the databases also a solid background in data modeling and database design, Excellent analytical and problem-solving skills, ability to isolate and resolve problems in timely manner. Experience in supporting and administrating large 24x7 production databases in Oracle 10g, 11g, 12C and 19C RAC, ASM, 1 node RAC with passive node and Data Guard environments.
Database professional with depth in data management and team leadership. Known for optimizing database performance, ensuring data integrity, and delivering robust solutions. Strong focus on team collaboration, achieving results, and adapting to changing project needs. Skilled in SQL, data modeling, performance tuning, and problem-solving. Reliable, flexible, and driven to achieve impactful outcomes.
Overview
12
12
years of professional experience
Work History
Assistant Consultant
TCS
04.2019 - Current
- Leading Offshore DBA team of 22 resources who manages Oracle, MS SQL & DB2 resources.
- Provided 24x7 on call DBA support for over 150 Oracle 11g/12c/19C production, QA, DEV databases on RHEL, HP-UX AIX
- Excellent hands-on experience migrates ASM storage on diskgroup by adding new disks and dropping new old disks with rebalance operations
- Hands on experienced configuring oracle database backup using RMAN.
- Performed installation, configuration of multi node Oracle 12c/19c RAC with ASM and single instances using customized scripts, DBCA.
- Excellent hands-on experience migrating and configuring Commvault database rman backup on crontab job scheduler
- Upgraded production, Development and UAT databases from Oracle 11g/12c RAC using both out-of-place, in-place and dbua to 19c version
- Hands on experience with oracle database PSU/CPU/One-off patches on different version (10g, 11g, 12c and 19c) across multiple technology like RAC, Dataguard, Rac 1 node, Single instance
- Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing
- Handled all daily DBA activities and excellent experience with SQL scripting, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules
- Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Stats pack), ADDM, ASH, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters
- Create and Monitor SR to track the root cause/fix of any database issue with Oracle Support
- Migrated Schema data from Old Dev database (create new database of same version, datapump expdp/impdp was used to move the data)
- Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat, etc
- Troubleshoot database slow query performance using explain plan, tkprof, tunning advisor to maintain query plan
Consultant
Capgemini
12.2017 - 03.2019
- Performing all related database activity like space management in database, user and roles administration, schema management of all the databases
- Administration of ASM instance, managing the DISK GROUPS and DISK Operations
- Unix scripting, database performance tuning and administration and system administration of various platforms of Unix systems
- Creating database users and by setting the default & temporary table spaces, assigning quotas, roles, Privileges and Profiles to users
- Administration of Oracle 11gR2, 12c RAC.
- Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations
- Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN
- Restoration and recovery from backup as timely manner to support application development team for testing
- Monitoring the table growth, database growth, current users, and system resource usage
- Verify success of database backup (Maintaining RMAN and LOGICAL backups)
- Implemented and maintained Oracle 10g/11g/12c Data Guard/standby databases for fail-over purposes.
- Managing both data replication using oracle Goldengate
- Cleaning the ORACLE_HOME file system by cleaning the log files, alert log file and listener.log files
- Implemented and maintained Oracle 10g/11g/12c Data Guard/standby databases for fail-over purposes
- Perform RMAN operations (Incremental Backups)
- Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC
- Performed SQL Tuning by using explain plan and TKPROOF
- Analyzed and helped speeding up long running queries
- Creating and managing the database objects such as tables, indexes and views
- Managed the flashback space and performed recovery of dropped tables and data using flashback recovery
- Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along With AWR & ADDM reports
- Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc
Senior Analyst
HCL Technologies Ltd
02.2013 - 11.2017
- Managed user accounts and support systems within complex Oracle databases.
- Created program backups and information recovery systems.
- Created and altered database storage structures to meet user needs.
- Updated and inspected database security features and protocols.
- Hands on experienced using dbms_sqltune, dbms_xplan, dbms_spm, to load/add/remove/drop query plan from cursor, awr to provide plan stability
- Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc
- Work hand in hand with the developer to apply releases or production database.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Maintained working knowledge of programming languages and technical documentation.
- Analyzed workflows and established priorities for daily operations.
- Developed and implemented security initiatives to protect important company data.
- Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
Education
B.E - Electronics and Communication
Tamilnadu College of Engineering
Coimbatore04-2012
Higher Secondary -
S.D.P.Y.B.H.S.S
03-2008
High School -
T.D.H.S
03-2006
Skills
- Database Administration: Oracle 10g/11g/12c/19c, SQL server 2003-2019
- Platforms: UNIX, Solaris, Linux, Windows 2003-2019, HP-UX, AIX, Exadata
- Disaster Recovery, User Support,Data Backup,Performance Tuning and upgrading
- High-Availability: Real Application Clusters (RAC) 11g-19c, Data Guard, RMAN, AIX Cluster
- Dataguard
- Enterprise Database Tools: Oracle Designer, OEM/EM Grid Control (Enterprise Manager)
- Capacity planning, Performance tuning, Database security, Database migration
- Replication strategies
Languages
Malayalam
Native language
English
Upper intermediate
B2
Tamil
Intermediate
B1
Hindi
Elementary
A2
Timeline
Assistant Consultant
TCS
04.2019 - Current
Consultant
Capgemini
12.2017 - 03.2019
Senior Analyst
HCL Technologies Ltd
02.2013 - 11.2017
B.E - Electronics and Communication
Tamilnadu College of Engineering
Higher Secondary -
S.D.P.Y.B.H.S.S
High School -
T.D.H.S
Similar Profiles
PRASHANT GUPTAPRASHANT GUPTA
Payment Operations Specialist at TCSPayment Operations Specialist at TCS
Kuntal SugandhiKuntal Sugandhi
Associate Consultant at TCSAssociate Consultant at TCS
Chirag KhuranaChirag Khurana
Data Science Intern at TCSData Science Intern at TCS