Khaja Pattan
Database Manager
bangkok,rama3, Phone :: +66831424023
Summary
12 years of hands-on experience in administration of Oracle Database (19c,12c,11g,10g) And Oracle Applications 12.2.3, 12.2.5 and 11i/R12.1. And Exadata and Super Cluster and Exalogic on Unix (Solaries Sparc, Linux, Aix, Windows) and Oracle Application Server 10g, Fusion Middleware 11g with WebLogic environments and Mongodb. Currently working for Commercial Bank of Ethiopia to fine tune there performances issues related to PAYLOAD, GL, IRAC jobs. successfully resolved major performance issues for Manappuram Finance Ltd (inda) and Onsite L3 support at data center for BOB Bank customer as a Principal Advanced Support Engineer from ORACLE ACS. Implemented MAA+ Pilot (FULL HA) for Telkomcel customer. Experience onsite production DBA support as a RE for KBZBANK. Good experience in administering and troubleshooting Oracle databases 12c, 11g and 10g for mission critical OLTP and OLAP Systems with Flexcube Core banking application. Improved the daily EOD by fine tuning the batch jobs (ICEOD, ACCREVAL,etc) from 3+ hours to less than one hour. Improved EOM and EOY (CLBATCH, ACHTHAND) timings by finetune the batches. L3 Performance support for Finacle Core banking application to bob. Hands on experience in 12.x, 11i Clones from multi - multi node, multi - single node. Experience in R12.2 patching in WebLogic environments. Implemented various multi lingual languages like (Czech, Polish, and Lithuanian) on Oracle e-business suite. Good knowledge in installations of Oracle Applications R12.2,11i & R12.1,Oracle Database 10g,11g&12c,Weblogic server. Prepared the clear SOP for patching activity from analysis to apply end to end for cpu, psu, delta patches in database and applications and got good VOC from client. Applied ADOP patches in phase model (prepare, finalize, apply, cutover, cleanup) and using downtime mode for GE customer. Configuring RMAN catalog, Performing Cold & Hot Backups & restoring from backups using ZDLRA. Performed green zone maintenance activity on production while server patching. Hands on experience on production standby data guard. Excellent analytical, problem-solving and learning skills and understand new technologies as well as a keen interest in the emerging technologies. Hands on experience on ASM administration. Proficient in tools like – sql developer /plsql developer Toad and OEM. Scheduling tools like Appworx, IFLOW, Gateway, Apex, PPM(kintana))
Overview
11
11
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
Work History
Database Manager
ATA IT Limited
02.2024 - Current
- Led the migration of legacy databases to EXADATA X9 platform, minimizing downtime and preserving critical business data during the transition process.
- Increased system uptime by proactively monitoring database health and addressing potential issues before they escalated post go-live.
- Maximized resource utilization through capacity planning initiatives that identified opportunities for consolidation while maintaining service quality standards and fine tuning the critical queries.
- Perform EOD tuning and reporting queries tuning.
- Collaborated with cross-functional teams to develop customized database solutions for specific business needs.
- Supporting Flexcube, Exadata, ZDLRA, Dataguard, RAC.
- Leading handon with Kafa CDC for digital banking for few modules.
Senior Oracle Database Administrator
ORACLE INDIA
12.2021 - 02.2024
- Prepare and insisting customer to implement Performance review reports and security assessment reports in ORACLE ACS Standard.
- Show customer benefit with implementing assessment report before and after comparison.
- Worked in Datacenter hosted with 150+ databases on various flavors of UNIX environment and windows with various service level agreements comprising of production and non-production systems
- Database Upgrade support from lower database version to 11.x,12.x to 19.x which include RAC, Standalone, primary and standby databases.
- SCAN implementation roadmap for BOB CORE Banking.
- Successful implementation of RMAN fast incremental backup for 100+ databases and suggested customer to use ZDLRA and provided SOP for implementation.
- NDR Implementation for LIVE and DR.
- Resolved Post UPGRADE performance issues for UTRS and Other databases.
- UPI database proactive tuning by creating HASH portioning and required SEQUENCE and creating necessary INDEXES also creating profiles and baselines.
- Resolved major issues with library cache and mutex contention waits on internet banking.
- Proactive query recommendations on CBS and UPI,NEFT, MOBILE Banking,IMPS,CARDS,FEBA,ATM,CSIS ,TRADE Finance, greenpin,etc
- Resolved branch overload issues by identifying the root cause.
Extensively worked on Partitioning and created script to automatically identify & delete the expired daily/ weekly / monthly partitions. - OEM configuration including alerts and performance monitoring using metric extensions for all databases.
Reduce average active sessions by fine tune heavy PIO/ LIO transaction queries. - Actively involved in tuning SQL and PL/SQL scripts to improve performance.
- Performance tuning for optimized results using tools like AWR, ADDM, ASH and STATSPACK Reports and OEM and ORACHK and OSWatcher.
- Quick troubleshooting with various RAC and DB issues.
- Quick finding of bugs and fast track patch implantation process by contacting MOS.
- Experience in Identifying performance bottlenecks on high volume transaction systems.
- Analyze SQL statements reorganize database objects and design indexes to improve response of queries.
- Proposed database changes to ease monitoring and administrative effort.
- Provided resources and skill sets to support DBA functions for applications.
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Conducted tests to identify issues and make necessary modifications
- Adhered to set schedules to test databases for flaws and reduce downtime
- Demonstrated strong organizational and time management skills while managing multiple projects
- Delivered services to customer locations within specific timeframes
- Demonstrated leadership skills in managing projects from concept to completion
Residential Engineer From ORACLE ACS
ORACLE Corporation Ltd (MPS)
11.2020 - 11.2021
- Implementing MAA+ Pilot Full HA (DB + APPLICATION) on exadata and exalogic environments.
- Implement FSFO for automatic failover using Dataguard broker.
- Load profile of databases.
- Capacity planning for future.
- Load balancing of databases.
- Instance caging, IORM.
- Fine tune the oracle databases.
- Perform root cause analysis on failures. Resolve performance related issues and queries prepare RCA for issues.
END – END ppt representation for every stream and explain to customer. - Generated AWR/ASH/ADDM/SQLT reports from Oracle 11g/12c database and analyzed reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
- Involved in SQL Query tuning and provided tuning recommendations.
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Provided resources and skill sets to support DBA functions for applications.
- Proposed database changes to ease monitoring and administrative effort.
- Reviewed database design to recommend enhancements or improvements.
- Responded promptly to user requests for permission changes, new storage and expansion questions.
- Tested and deployed scalable and highly available software products.
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
- Created proofs of concept for innovative new solutions.
- Tuned systems to boost performance.
Residential Engineer From ORACLE ACS
ORACLE Corporation Ltd (Crown Global Solutions)
06.2018 - 09.2020
- Experienced in performance and tuning on SUPER CLUSTER and EXADATA machines with OLTP and OLAP environments.
- Patch 30133696: QUARTERLY FULL STACK DOWNLOAD PATCH FOR EXADATA (OCT2019 - 19.5)
- Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
- Oracle Enterprise Manager (OEM) 13C,12C & Grid Control (11g) for database monitoring/performance/diagnostics.
- For 12c In-Memory configuration and recommendation for highly used objects to give better performance for OLAP reporting database.
- Resolved replication issues in Golden Gate EXTRACT and REPLICATE.
- Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, SQLT AWR and ADDM.
- Running EXACHK reports on super cluster M7 and exadata X7/X6/X5/X4 machines.
- Conducted Performance Review of Oracle Database for business-critical applications with Senior Leadership team
- Hands on experience on active-active golden gate in multi master replication environment with robust reporting environment.
- Generated AWR/ASH/ADDM/SQLT reports from Oracle 11g/12c database and analyzed reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
- Involved in SQL Query tuning and provided tuning recommendations to scheduled jobs, time/CPU consuming queries.
- Administration of RAC environment using various command line interfaces such as CRSCTL, SRVCTL, OCRCONFIG, OCRDUMP, OIFCFG, OLSNODES, ASMCMD and ADRCI.
- Used Explain Plan, Oracle hints and creation of new indexes to improve performance of SQL statements.
- Completed minimized space related errors in Oracle Databases by conducting month review with Senior Management and addresses space issues proactively
- Provided tuning recommendations and future memory requirements to Primary DBA team to make changes in Database like table reorg, add enough spaces to database
- Set up new database instance with Prod and Test Environment and provided database related support
- Created purge script and few monitoring scripts on Sparc and Linux machines and scheduled cronjobs.
- Scheduled regular RMAN backup and DATAPUMP schema level backups process and involved in backup activities.
- Configured backup plans on ZDLRA.
- Implemented RMAN backups for oracle using block change tracking file for incremental Level 1 backups.
- Performed oracle home PATCHING actives including OJVM whenever required.
- Good experience RAC Cluster ware administration, Configuration and Patching.
- Working experience on DATAGUARD and ASM.
- Experience in OEM 11g & 12c, 13c. Discovering of EBS targets. Setting up metrics etc.
- Automating tasks using cron .
- Replicated to disaster recovery site for increased server manageability and availability.
- Executed processes for evaluation of system space, database allocation and storage metrics.
- Tuned GG to handle large volumes of data for high transaction tables
- Monitored real-time bidirectional data movement
- Supported 11g agent decommissioning - moved to 12c grid control
- Consolidated tables and enabled GG replication by application segregation
- Used Oracle 11gR2 to resolve complexity of configuring conflict detection and resolution
- Automated Timestamp resolution - most common conflict handling in a active-active scenario
- Setting up Before and After Image captures for Conflict Detection and Resolution
- Active monitoring of Conflict Detection and Stats verified after hourly run
Lead Consultant DBA Worked as Offshore Lead for GE
Genpact
10.2012 - 05.2018
- Team Size : 36 (pooling model)
- GE is world’s Digital Industrial Company, transforming industry with software-defined machines and solutions that are connected, responsive and predictive
- Administering production databases as large as 5 TB on 4 node RAC installation, with 4 node PCP configuration exclusively for Concurrent Processing, Load balancing form services and apache through F5 setup on 2 web servers
- Perform, prioritize and coordinate with all DBA related activities
- Experience on EBS R12.2.5 application patching using adop and cloning with dualfs
- Experience on application upgrade from 11.5.10.2 to 12.1.3
- Worked on Database upgrade from 10.2.0.4 to 11.2.0.2 and 11.2.0.3 to 12.1.0.2
- Worked on 12.2.6 upgrade from 12.2.5 EBS r12.2
- Involved on 11gR2 RAC implementation project
- Experience on weblogic installation, node managers, domains, managed servers etc
- Involved on weblogic application deployment, datasource etc
- Hands on experience DMZ (Reverse proxy) configuration
- Perform, prioritize and coordinate with all DBA related activities
- Involved in tasks like performing Pre Patch Analysis for requested Patches, preparing Mass Patching Plan Document for patching activity and successfully executing mass patching activity
- Extensive experience in patching using adop, adpatch and Opatch as well as Discoverer and WebLogic Patching
- Cloned production system to multiple test/stage/development target instances
- Performed greenzone maintenance activity on production while Unix patching and theoretical reboots
- Troubleshooting SSO issue ,Apache issues and Forms related issues Concurrent Mangers, Programs, and Requests
- Excellent Knowledge on AD Utilities and their usage
- As part of Performance Tuning, monitored long running form sessions and killed them by developing shell script and placed it in cron, which kills idle/long forms sessions which are idle/long for more than 120mins
- Starting and shutting down of workflow components through OAM
- User account management – creating users, disabling users, responsibility management
- Patch log files for application related issues
- Managing concurrent managers –ensure system is running smooth, monitoring throughput, watch for long runners
- Code migration activities using starteam,kintana tool
- Performed configuration changes and bounced servers as and when required
- Troubleshooting the Application System, this includes troubleshooting login problems, troubleshooting and regenerating application components and file system (forms, reports, menus, java classes, libraries and jar files), relinking executables, troubleshooting database problems.
- Had good knowledge on backup, Restore and Recovery at different scenario
- Working experience on RAC and ASM
- Creating technical documentation & Troubleshooting issues
- Creating Service Requests as and when required and contacted Oracle Support
- Participating in customer calls and ensuring all requirements are documented
- Extensive working experience in setting up multiple domains, including Administration Servers, Managed Servers, Machines, Node managers in different cluster environments
- Work collaboratively with teams like Development and QA to resolve production support issues
- Worked on Onsite – Offshore project model
- Monitoring the OEM grid(12c & 13c)
- Developed program schedules and monitored milestones, managing production flow to guide production orders to correct and timely completion.
- Identified business issues through careful collaboration with key stakeholders.
- Performed gap analysis and provided plans based off of identified recommendations.
Education
Master of Technology - Computer Science Engineering
SNBTM (ANU)
ANDHRA,INDIA 03.2006 - 03.2010
Skills
Database : Oracle 10g & 11g, 12c,19c,SingleStore, MangoDB
undefinedCertification
Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
Timeline
Database Manager
ATA IT Limited
02.2024 - Current
Oracle Cloud Infrastructure 2023 Certified Multicloud Architect Associate
10-2023
Oracle Cloud Data Management 2023 Certified Foundations Associate
10-2023
Oracle Cloud Infrastructure 2023 Certified Foundations Associate
10-2023
Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
09-2023
Senior Oracle Database Administrator
ORACLE INDIA
12.2021 - 02.2024
Residential Engineer From ORACLE ACS
ORACLE Corporation Ltd (MPS)
11.2020 - 11.2021
Residential Engineer From ORACLE ACS
ORACLE Corporation Ltd (Crown Global Solutions)
06.2018 - 09.2020
Lead Consultant DBA Worked as Offshore Lead for GE
Genpact
10.2012 - 05.2018
Master of Technology - Computer Science Engineering
SNBTM (ANU)
03.2006 - 03.2010
Similar Profiles
Rachel TaisRachel Tais
Door Greeter at ATA ServicesDoor Greeter at ATA Services
Cody McMullenCody McMullen
Electrical Field Service Technician at ATA Security SystemsElectrical Field Service Technician at ATA Security Systems
Cristian Gabriel NeamtuCristian Gabriel Neamtu
Delivery Driver at Ata LogisticsDelivery Driver at Ata Logistics