Manager Oracle
Resume:
Harunur Rashid
************@*****.***
Professional Summary:
More than 9 years of in-depth experience in Database Administration including Oracle 12c, 11g, 10g, 9i and 8i on platforms UNIX(HP-UX, IBM-AIX), Sun Solaris, Linux, and windows and SQL Server 2005, 2008, 2010, 2012 & 2014.
Configure, Manage and troubleshoot Oracle 10g, 11g, 12c RAC on multiple nodes clusters.
Hands on Experience in Performance tuning & optimization using DBMS_STATS, optimizer HINT and tools like Explain Plan, STATSPACK, and Index re-organization, Table Partitioning, SQL Trace, SQL Profiles, and TKPROF. Analyzed ASH, AWR & ADDM reports.
Worked on setting up Physical and Logical standby Data Guard Environments.
Installed and applied CPU& PSU patches to oracle RDBMS.
Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non-traditional way (Transportable tablespaces and RMAN)
Experience in GoldenGate 10g, 11g & 12c implementation, Upgradation, Performance tuning GoldenGate extract and Replicates processes for real time database replication.
Experience in Transportable Tablespaces, Materialized Views& Partitioning.
Experience to implement and configuration Oracle Advanced Security Option, Database Vault, Audit Vault, Database Firewall
Experience in Oracle Enterprise Manager (OEM) Grid & Cloud Control 10g, 11g, 12c & 13c
Hands on experience in Backup, Recovery & Cloning of databases using RMAN.
Data movement (import/export, data pump, SQL*Loader).
Experience to write Optimal SQL Query, T-SQL & PL/SQL (Package, Procedure, Function, Trigger, View) Scripting.
Worked on creating and Managing Users, Roles, Privilege and Virtual Private Database (VPD).
Experience with very large database (VLDB).
ETL, Data Warehousing Dimensional Modeling. Cube, Rollup Query.
UNIX/LINUX installation and shell scripting.
Implement and Maintain SQL Server 2005/2008 and HA (Replication, Log Shipping, Mirroring & Cluster).
Worked on 24/7 high availability environment. Flexible and excellent team player. Ready to work in any time slot.
Excellent troubleshooting skills and quick learner. Troubleshoot Networking issues.
Worked With Oracle Global Customer Support Service Request (SR) Analyst
Technical Skills:
Database (RDBMS): Oracle Database 12c, 11g, 10g, 9i, 8i, MS SQL Server 2000, 2008, 2010, 2012, 2014, DB2, MySQL and MS Access and Oracle on an Exadata Database Platform
High Availability: Oracle Database 10g, 11g and 12c Real Application Cluster, MS SQL Server 2008, 2012 and 2014 Clustering and on an Exadata Database Machine.
Replication: Oracle Streams, Materialized View, Golden Gate (Veridata, Director and Golden Gate Studio), and Oracle DataGuard.
Operating System: UNIX - Sun Solaris, IBM-AIX, HP-UX, Red Hat Enterprise Linux 4.0, 4.5, 5.0, 6.0, 7.0, Oracle Linux 5.4, 6.0, 6.4, 6.6 and 7.0, Microsoft Windows Server 2000, 2003, 2008, 2012 and 2014/NT Environment, CentOS, Ubuntu and Debian.
Operating System Cluster: IBM-AIX and Microsoft Windows Server.
Database security: Database Vault, Audit Vault, Key Vault, Database Firewall, TDE
Tuning Tool: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM
Programming Language: C, C++, VB, Oracle 9i, 10g and 11g Forms & Reports Developer, JavaScript, Java and UNIX Shell Scripting, Ksh, bash, Perl.
Professional Experience:
EMGENEX, LLC April 2013 - Present
LEAD Database Administrator
EMGENEX provides high-quality services to enhance medical business operations, builds highly integrated clinical networks for collaborative care and develops healthcare industry-specific software applications for comprehensive business management.
Maintenance and Administration of 10g/11g/12c databases on Windows Server 2012 & Unix( 2 Node Cluster) with database sizes ranging from 30GB to 10TB and managed these databases in different Data Centers and Reporting databases.
Installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues for both RAC and non RAC system. Golden Gate updates, upgrade from 10g to 11g by using GG in real time
Checked database synchronization using Veridata and Monitor Golden Gate using Golden Gate Monitor, Director and Golden Gate Studio
Administration and management of the entire development, QA and production environment.
Installed and configured MySQL on Linux and Windows environments. Managing, Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1)
Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
Provided Centralized management of information about users and groups using Oracle Collaboration Suite which uses Oracle Internet Directory (LDAP) to store and resolve database services.
Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware. Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
Worked with the engineering team to implement new design systems of databases used by the company.
Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
Expertise in T-SQL writing stored procedures, triggers and functions.
Administering SQL Server High Availability and Disaster Recovery strategies.
Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
Worked on logical and physical data base modeling with UML and ERWIN tools.
Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
Experience in Disaster Recovery Planning and Security Management operations.
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Having hands on experience in DR processes including Log shipping and Database Mirroring.
Worked on configuring SQL Server with minimum privileged access.
Effectively configured MySQL Replication.
Designed databases for referential integrity and involved in logical design plan. Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
Implemented Golden Gate Replication in non-prod & prod servers (unidirectional, bidirectional & Peer to peer configuration).
Involvement in the timely Database and Application releases for application. Interacting with the Development team, Application Team, System Administrators and Release teams.
Working On performance tuning the database using utilities likeAWR, ADDM & SQL TUNNING ADVISOR.
Migration of database servers from Non-RAC (non-ASM) environment on 64 bit UNIX to RAC (with ASM) environment.
Adding DISKS to ASM Disk groups and resizing the data files.
Maintenance and Administration of 4 node High availability RAC 11g databases with ASM shared storage, failover and Disaster Recovery procedures using a Physical Standby.
Experience implementing Restore and Recovery strategies using RMAN cold/Hot backups and cloning databases using RMAN duplicate and scheduling the backups using Crontab.
Refreshed Application schemas from Production to Test using Datapump and Export/Import.
Setup and Maintenance of Oracle Advanced features like Oracle FLASHBACK and Flash Recovery Area, Data Guard (Physical Standby) and Failover procedures.
Renamed database with DBNEWID Utility.
Applied latest PSU patch updates from MOS to GRID and RDBMS on 11.2.0.4.
Installation and configuration of Oracle Client on Application servers.
Created and troubleshoot of DB Link issues in Oracle for communicating with external databases.
Analysis and management of Oracle problems/defects using SRs and/or MOS with Oracle Corporation and installation of patches.
Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility, integrity and security of all databases by following policies and procedures and documentation of every step.
Managed crontab file, rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).
Responsible for Change Management, Incident Management, Problem Management, Security Management, Backup Management etc.
Recovered the database from block corruption in the data file.
Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Environments: Oracle 12c,11g, 10g, 9i,MS SQL Server 2008, 2010, 2012, 2014, MySQL, SQL*Plus, PL/SQL, Oracle RAC and Replication, UNIX - Solaris, HP-UX, AIX, RedHat Enterprise Linux, Oracle Linux,Windows Server 2000to 2014, Oracle Golden Gate, Oracle Golden Gate Monitor, Oracle Veridata and Oracle Golden Gate Director, Toad Data Modeler, SQL Developer Data Modeler, Oracle Enterprise Manager(OEM), Enterprise Manager Grid Control, OEM Cloud Control 12c, ToadPercona Toolkit, Common Schema, mysqldump, hot backup (the official Oracle MySQL Enterprise Backup or Percona'sXtrabackup) and storage snapshots.
National Bank Limited December 2010 - April 2013
Senior Oracle DBA
National Bank Limited is one of the largest private bank by market capitalization with more than 280 branches in seven different countries, including USA. As a team lead, I was responsible for managing more than 20+ databases. Was also involved in several major projects including security implementation by using Database Vault, RAC implementation and Data guard setup for major databases. Have also worked on several critical migrations of large databases of 10TB+ Responsible for migrating several oracle 10g databases to oracle 11g and implemented Database vault.
Installation and Maintenance of Oracle 9i, 10g, 11gR2 and 12c RAC on IBM-AIX, LINUX, HP-UX, Solaris, Windows Server and Oracle 11g RAC on an Exadata Database Platform
Implemented the Oracle 11gR2, Physical Data Guardand Oracle 11g on an ExadataDatabasePlatform
Installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues for both RAC and non RAC system. Golden Gate updates, upgrade from 10g to 11g by using GG in real time
Checked database synchronization using Veridata and Monitor Goldengate using Golden Gate Monitor, Director and Golden Gate Studio
Responsible for supporting and administrating both Data warehousing and OLTP databasesof size 10TB on RAC.
Upgradation of databases applying patches, patch sets, critical patch updates and PSUs.
Provided Centralized management of information about users and groups using Oracle Collaboration Suite which uses Oracle Internet Directory (LDAP) to store and resolve database services.
Performed oracle database refreshes usingexpdp/impdpfrom production to test database.
Worked with very large scale Database environment and mission critical OLTP and OLAP systems ranging from 1TB to 4TB.
Upgraded the database from 9.2.0.8 to 11.2.0.2
Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
24x7 remote support and on call support for Production databases.
Performed cloning of database using RMAN.
Performance tuning of database by using the reports AWR, ADDM, TKPROF, STATSPACK, EXPLAIN PLAN.
Performed policies on data confidentiality, integrity, availability, and audit ability, Based on Access Controls for Access to Data at the database level.
Worked on creation of users, granting roles and privileges to users, table space management.
Planning the backups Hot & COLD backup, Incremental Level 0 and Level 1 Back and scheduling.
Taken backups using RMAN, logical (import/export, impdp/expdp), hot and cold backup.
Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
Implemented Security user management, privileges, roles, profiling, auditing, authenticationsetc.
Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Environments: Exadata Database Machine, Oracle 12c 11g, 10g &9i, MS SQL Server 2008, 2010, 2012, 2014, MySQL, SQL*Plus, PL/SQL,Oracle & MS SQL Server Cluster and Replication, Java, Oracle Forms & Report 11g, Tomcat, Oracle WebLogic Server, UNIX - Solaris, HP-UX, AIX, RedHat Enterprise Linux, Oracle Linux, Window Server 2000 to 2010, Windows NT, Oracle Golden Gate, Oracle Golden Gate Monitor, Oracle Veridata and Oracle Golden Gate Director, Toad Data Modeler and SQL Developer Data Modeler, Oracle Enterprise Manager(OEM), Enterprise Manager Grid Control, OEM Cloud Control 12c, Toad Percona Toolkit, Common Schema, mysqldump, hot backup (the official Oracle MySQL Enterprise Backup or Percona'sXtrabackup) and storage snapshots.
Computer Systems Network Limited September 2007 - December 2010
Oracle DBA
Computer Network Systems (CNS) is accredited with SEI CMMi Level 3 standards for its Development & Maintenance. I was part of the team responsible for providing Software Development and Maintenance for CNS clients. Served as a Database Administrator. My main responsibility was to work with mission critical database for an online Fees collection & Registration System of Bangladesh Road Transport Authority, Online Ticketing System of Bangladesh Railway and Toll Collection of Bangladesh Bridge Authority. I have worked with Oracle advanced queuing and PL/SQL development during this tenure. Also designed a cascaded standby system to facilitate DR operations and offload reporting.
Supported Oracle 11gR2 RAC databases
Responsible for supporting and administrating both Data warehousing and OLTP databases of size 12TB on RAC.
Installed and upgraded from 9.2.0.8 to 11.2.0.4 RAC database on Linux 6.4
Cloned 11grR2 RAC Production databases (size of 5TB) for UAT
Provided Centralized management of information about users and groups using Oracle Collaboration Suite which uses Oracle Internet Directory (LDAP) to store and resolve database services.
Installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICAT issues for both RAC and non RAC system
Cloned Productions databases for Test environments using RMAN
Created the partition table concepts like rang, list etc.
Configured RMAN Hot and Cold backups
Analyzing the AWR report for the performance issue
Performing the DR switchover activity on periodical basis
Implemented Security user management, privileges, roles, profiling, auditing, authentications etc.
Refreshed schemas from production to lower environments with re-mapping table spaces for partitioned objects.
Worked on both ASM and file systems for managing data in SAN.
Documented the issues/resolutions/process details with maintaining them up to date.
Created and troubleshoot DB Links issues in Oracle for communicating with external databases.
Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
Managed crontab file, rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).
Generated weekly performance reports to identify and solve the problems with performance.
Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
Monitoring and resolving tickets in different environments
Export and Import of database objects to copy from one database to another database between different environments
Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
Applied PSU patches to Oracle Databases and Oracle Applications.
Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Involved in team management, team building exercises for the DBA team.
Environments: Oracle 11g, 10g &9i, MS SQL Server 2008, 2010, 2012 MySQL, SQl*Plus, PL/SQL, Oracle, Java, Tomcat, Oracle WebLogic Server, UNIX - Solaris, HP-UX, AIX, RedHat Enterprise Linux, Oracle Linux, Window Server, Windows NT, Oracle Golden Gate, Oracle Golden Gate Monitor, and Oracle Golden Gate Director, Toad Data Modeler and SQL Developer Data Modeler, Oracle Enterprise Manager(OEM), Enterprise Manager Grid Control, Enterprise Manager Cloud Control, Toad Percona Toolkit, Common Schema, mysqldump, hot backup (the official Oracle MySQL Enterprise Backup or Percona'sXtrabackup) and storage snapshots.
Education:
Dhaka University of Engineering & Technology 2007
B Sc in Computer Science & Engineering
Certifications:
Oracle Certified Professional (OCP - Oracle 10g, 11g& 12c DBA).
Oracle Certified Expert, Oracle Real Application Clusters 11g R2 and Grid Infrastructure Administrator.
Oracle Database 11g R2 Performance Tuning Certified Expert (OCE).
Oracle 9i Developer Certified Professional (OCP).
Red Hat Certified Engineer (RHCE).
ITIL V3 Certified (Foundation Certificate in IT Service Management).
Oracle Certified Professional, Java SE 6 Programmer.
Contact this candidate