Highlights:

Skills:Oracle DBA, Oracle Developer, PL/SQL, Pl/SQL Programmer, Oracle RAC

Associate Consultant (Oracle DBA & PL/SQL Programmer) 03/2014 - current
SonaliPolaris FT Limited., Dhaka, Bangladesh
Industry: Software
Oracle database11g r2, Dataguard , IBM AIX , J2EE, J-boss, Java applications, Linux, Toad for Oracle, Sql Developer, PL/SQL Developer & RMAN.
• Performing Managing Production Databases, Database Performance tuning, SQL & PL/SQL Optimization, Migrating Data from current application data model to new data model with complex PLSQL scripting. • Involved in installing, configuring and managing 11gR2 version of databases with Oracle DATAGAURD & RMAN. • Involved in writing and optimizing SQL queries, views, PL/SQL stored procedures, functions, Packages and triggers. • Involved in analyzing index, table partitioning, defragmenter, shrink table space and gathering statics, explain plan and outlining, Hints and using wait events. • Making sure Production Database is backed up regularly and recoverable without any issue. • Making sure production Databases maximum Performance for internal and external user. • Regularly performance monitoring/tuning the databases with ADDM, ASH, AWR, STATSPACK, v$ dynamic performance views. • Setup and monitoring Schedule jobs to handle RMAN backup as well as export / Import Backup using data pump. • Providing 24*7 On Call support for any kind of issues on Production and other environments. • Cloning database for development and testing and demo environment using RMAN, Hot Backup. • Scheduling the RMAN jobs for backing up Data files and Archive logs. • Resolved lock contention by detecting and modifying long running queries holding locks and applications explicitly locking objects.--
Assistant Programmer (Oracle DBA & Developer) 05/2011 - 02/2014
ERA InfoTech Limited., Dhaka, Bangladesh
Industry: Software
Oracle Database 9i/10g/11g, Oracle Developer 6i/9i/10g/11g, Oracle 10g Application Server, Oracle 11g Weblogic Server, Oracle Linux, SQL, PL/SQL, Shell Script, Oracle RMAN, Materialized view, Oracle Enterprise Manager (EM), Oracle APEX, Windows Server 2003/2008, Red Hat Linux 5.5/6.2, Toad for Oracle, Sql Developer, PL/SQL Developer & RMAN.
• Performing Managing Production Databases, Database & Application Developer, SQL & PL/SQL Writing, Oracle Forms & Report Design. • Involved in installing, configuring and managing Oracle 9i, 10g and 11gR2 versions of databases with Oracle DATAGAURD & RMAN. • Involved in Oracle Forms & Report Design for multiple banking project. • Involved in design GUI using Oracle Application Express (APEX). • Working with to processes MICR Scanner Output (.csv & .tiff) using Oracle PL/SQL. • Involved in writing SQL queries, views, PL/SQL stored procedures, functions, Packages and triggers. • Involved in generation and extraction XML and .img file using Oracle PL/SQL & Java Programming within Oracle Database. • Involved in Installation, Administration & Maintenance Oracle 11g Weblogic server. • Involved in Manage, Create, and Delete domain in Oracle Weblogic Server. • Involved in Installation, Administration & Maintenance Oracle 10g Application Server. • Involved in Configuring & using Webutil in oracle 10g/11g database within Windows and Linux server. • Install & configure Oracle Enterprise Manager to monitor Oracle 11g and 10g database. • Handling transactional data in more than three database using database link. • Involved in Developing MICR Interface for handshaking MICR Software and Core Banking Software. • Involved in Developing BEFTN Interface for handshaking BEFTN Software and Core Banking Software. • Cloning database for development and testing and demo environment using RMAN, Hot Backup. • Scheduling the RMAN jobs for backing up Data files and Archive logs. • Involved in analyzing index, table partitioning, defragmenter, shrink table space and gathering statics, explain plan and outlining, Hints and using wait events. • Making sure Production Database is backed up regularly and recoverable without any issue. • Making sure production Databases maximum Performance for internal and external user. • Regularly performance monitoring/tuning the databases with ADDM, ASH, AWR, STATSPACK, v$ dynamic performance views. • Setup and monitoring Schedule jobs to handle RMAN backup as well as export / Import Backup using data pump. • Providing 24*7 On Call support for any kind of issues on Production and other environments. • Cloning database for development and testing and demo environment using RMAN, Hot Backup. • Scheduling the RMAN jobs for backing up Data files and Archive logs.--
Junior Support Specialist.(Oracle DBA) 09/2010 - 04/2011
Data Edge Limited., Dhaka, Bangladesh
Industry: Software
Oracle Database Administrator
• Performing Managing Production Databases, Installation & Configuration Oracle 10g Database in Red Hat Linux. • Making sure Production Database is backed up regularly. • Providing 24*7 On Call support for any kind of issues on Production and other environments. • Cloning database for development and testing using oracle data pump.--

Daffodil International University 01/2011 - 05/2014
Dhaka, , Bangladesh
Degree: Bachelor's Degree
Major:Computer Science & Engineering
Bachelor of science in Computer Science & Engineering

Mohammad Rajib Pradhan