Kazi Anamul

Database Administrator

IPDC Finance • Fulltime

Mar 2024 - Present • 2 yrs 7 mos

•Managed 24x7 production Oracle database core banking (T24) with zero data loss and improved query performance by 70% performance improvement through SQL tuning and indexing. •Installed and configured enterprise databases (Oracle RAC & Single Instance, Clusterware, ASM, Data Guard, GoldenGate, PostgreSQL, MySQL, MSSQL) across AIX and Linux environments. •Delivered 24/7 production database administration with proactive monitoring, performance tuning, and issue resolution to ensure maximum system uptime and reliability. • Implemented high availability & disaster recovery using Oracle Physical & Logical Standby, ensuring business continuity with near-zero downtime. •Applied Oracle Database patching (PSU, CPU, RU/RUR) in mission-critical environments to address security vulnerabilities and maintain compliance. •Developed and optimized complex PL/SQL packages, procedures, and functions to automate banking operations and streamline high-volume data processing. •Designed Python automation scripts for bulk email notifications, database health checks, performance reports, and data correction, cutting manual effort and error rates significantly. •Integrated and supported Temenos T24 Core Banking System (CBS), including: 1.Data flow understanding across modules (Core, AA, Funds Transfer, Treasury, GL). 2.COB operations and month/quarter/year-end closures. 3.Data extraction & integration with downstream reporting and external systems. •Managed cross-platform database links (Oracle ↔ MSSQL/MySQL) to streamline data exchange between systems. •Utilized advanced Oracle tools (SQL Performance Analyzer, Tuning Advisor, Segment Advisor, SQL Baselines) to boost query performance and optimize workloads. •Executed database recovery for media failures, corruption, and accidental object drops, ensuring data integrity and minimal downtime. •Cloned environments via RMAN, Data Pump, Hot Backup for development, testing, and training needs.

Senior Product Engineer(Oracle DBA &PL/SQL Programmer)

Sonali Intellect Ltd. • Fulltime

Aug 2015 - Mar 2024 • 8 yrs 7 mos

• Oracle Database, Oracle Clusterware, Oracle ASM,RAC, Dataguard, Golden Gate, and Standalone database in AIX,Oracle Linux, Linux Environment. • Conducted performance tuning and analysis by evaluating the impact of adding or removing indexes, leading to improved query efficiency. • Used SQL hints to fine-tune query execution plans for optimal database performance. • Utilized Oracle tools such as Toad, PL/SQL Developer, and SQL*Plus for efficient development and troubleshooting. • Developed and maintained pipe functions for generating application-specific reports. • Led data migration and data cleaning efforts during the transition from branch banking systems to Core Banking System (CBS). • Conducted requirement analysis for enhancements and new system developments. • Wrote and optimized complex PL/SQL scripts using advanced techniques such as collections, BULK COLLECT, and FORALL. • Improved critical banking processes including End-of-Day (EOD), Month-End, June Closing, and Year-End operations. • Created, optimized, and maintained SQL queries, views, stored procedures, functions, packages, and triggers. • Performed database maintenance tasks such as: •Monitoring space and index usage •Identifying and resolving locks and wait events •Tracking top sessions and background processes • Gathering statistics and performing index rebuilds • Managed backup and recovery operations using RMAN and Data Pump, ensuring high availability and disaster recovery. • Resolved lock contention issues by identifying and modifying long-running queries holding locks. • Cloned production databases for development, testing, and demonstration environments. • Scheduled and monitored automated jobs for backups and data exports/imports. • Ensured consistent and reliable production database backups with smooth recovery processes. • Participated in the full development lifecycle: coding, testing, debugging, and documenting programs, as well as enhancing existing systems to m