Kazi Mehedi Oracle DBA

ad0fji@r.postjobfree.com 708-***-****

US Citizen

Education: Masters Asian University of Bangladesh 2004

Summary

Over 10 years of experience of Oracle Database Administrator including 10g/11g/12c/18c/19c databases.

Managed Databases on RHEL, OEL, Centos, AIX, HPUX, Solaris and Windows.

Proficient in 11g, 12c, 18c and 19c migration.

Hands on experience in database administration and production support.

Extensive work in database installation, configuration and upgrades.

Applied CPU and PSU patches on quarterly basis.

Worked on tuning SQL and instance for faster response time.

Extensive work experience in backup and recovery space management, cloning and migration.

Written shell scripting to automate procedures and jobs.

Expertise in various phases of System Development Life Cycle (SDLC) like analysis, design, Development, testing, implementation and Maintenance.

Excellent Experience as Production DBA with 24X7 support.

Expertise in Developing Recovery Manager (RMAN) scripts for database backup

Build 2-node and 4-node RAC clusters

Excellent Experience in installing and maintaining Oracle Data Guard in building Physical Standby

Extensive expertise in export import and data pump.

Maintenance and Expertise in using VERITAS Cluster Server (VCS).

Performed Installation of Oracle 11g ASM &10g RAC software with ASM & OCFS2 File systems.

Experience in Migration of databases from oracle 11g to 12c to 18c to 19c

Excellent experience of data migration, data archiving and data access techniques

Expertise in silent database installs

Build uni-directional Golden Gate replication.

Administered and managed Golden Gate.

Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)

Build and Managed 13c cloud control on OEM

Clone databases using RMAN restore/recovery methods and RMAN duplicated database methods

Experience in tuning Different components and identifying bottle necks in performance of databases

Hands on Experience in Performance tuning and optimization using DBMS_STATS, AWR and optimizer hint and tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF.

Analyze database performance using ASH, AWR and ADDM reports

Creating and Managing Users, Roles and Privileges with required security implementations

Expert in encryption for databases using Wallet Manager

Database replication using snapshot, materialized views and advance replication methods

Strong in writing shell scripts to setup cron jobs for checking Adaptive server's availability, backup of databases and crucial system tables, nightly batch jobs for data transfer between servers.

Assisted in integration of Exadata applications into current IT actionable events and solutions.

Migrating databases to Oracle Exadata Database Machine for different clients

Provides technical assistance for many platforms, during issues and/or outages. Areas include but are not limited to Oracle, Peoplesoft, homegrown monitoring applications, operating systems, hardware components and the network infrastructure.

Flexible and excellent team player. Ready to work in any time slot.

Excellent troubleshooting skills and quick learner.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g /12c/18c/19c (ASM, RAC & Data guard) 13c cloud control (OEM)

OS: Linux, RHEL, Windows, OEL, Solaris, AIX, HPUX, UNIX, CentOS

Tools: OEM, TOAD, SQL Developer, Smart FTP, Cute FTP, Putty, Cygwin, Spot Light, Erwin, DBCA, Data Guard, ASM, clusterware etc.

DB Utilities: SQL Plus, SQL Loader, Exp/Imp, Data pump Utilities, RMAN, tkprof

Language: SQL, PL/SQL for Oracle, Shell programming, C/C++.

Shell script: Shell Script (Bourne shell & Korn Shell)

PROFESSIONAL EXPERIENCE

First National Bank, Huston, TX February 2020 to Present

Oracle DBA

Build 4 node RAC.

Setup Data Guard.

Worked on Databases using ASM.

Worked on a 13c OEM migration project.

Installation/Creating new databases.

Cloned Databases using RMAN.

Installation, Configure, and setup of 4 node RAC cluster on Linux.

Supported database on Exadata X7.

Build new servers on AWS.

Applied patches on computer nodes, Exadata home, and storage cells.

Migrated standalone databases to Exadata.

Upgraded Databases from 11g to 12C to 18c and 19c.

Applied patches as per security needs and bug fixes.

Worked extensively on data center migrations on multiple database versions.

Designed, configured, and maintained backup and recovery policies using RMAN.

Build new databases on Amazon RDS.

Worked on a project to migrate databases to AWS instance.

Set up oracle instances on the AWS cloud

Recovered and cloned database using RMAN.

Worked on performance tuning.

12c OEM install/config Agents and deploying.

Used export-import and Data Pump.

Set up cron tabs to automated jobs as required.

Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, and data manipulation.

Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators, and Database developers

Collaborated with ETL, BI, and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.

Developed mapping spreadsheets for (ETL) team with a source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.

Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access, and Security and auditing

Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.

Involved in designing logical and physical data models using Erwin.

Created, documented, and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.

Good understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact, and Dimension tables.

Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.

Worked at conceptual/logical/physical data model level using Erwin according to requirements

Familiar with Oracle GoldenGate concepts and advanced replication techniques.

Written Shell scripts to automate purge.

Proficient in writing UNIX Shell scripts to automate business processes and daily backup.

Oracle Database capacity planning, Creating & Managing Database Structures, space management, storage allocation, and different types of storage structures (SAN/NAS)

Worked on OEM, DB console, Grid Control, and Cloud Control.

Build Database homes and databases using Cloud Plane.

Worked on Oracle Materialize Views, Oracle Golden Gate, and Oracle Active Data Guard.

Worked with Oracle Super Clusters and managed them with proficiency.

Proficient in using tools such as celcli and dcli in Exadata.

Build and managed RAC databases on Exadata.

Performed silent installation of databases on Exadata.

Configuration, troubleshooting Golden Gate issues.

Worked on Flash Recovery Area.

Performed DR switchover/failover practices using Data Broker.

Patched Oracle databases using OPatch utility.

Worked on monitoring Database health, Bottlenecks, session information, table privileges, and permissions.

Monitored scheduled jobs for backups, gathering statistics, AWR reports, and data guard status reports, disk space utilization reports.

Generated triggers for data integrity, and created views to resolve complex queries.

Used RMAN duplicated database to clone.

Used export-import and Data pump to refresh schemas.

Identifying the poorly performing queries using Explain Plan, TKPROF, and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.

ENVOY American Airline, Irving, TX February 2017 to Jan 2020

Oracle DBA

Responsibilities:

Oracle 11g/12c/18c and 19c with Physical Stand by Data Guard.

Handling the code deployments developed by Developers on Dev, Test and Production.

Managing users, profiles, roles and table space according to the requirement. Created custom script to create large number of users automatically.

Database user backup using Export /Import Utility. And database backup using data pump.

Production refresh to PRR environment and conversion environment when required.

Done partitions on tables and indexes to get better performance on large tables.

Monitoring Backup report, Database sync report (Verifying Production & Standby Database Synchronization), AWR report and wait events reports using OEM and Custom scripts.

Configured OEM for the performance monitoring and database administration.

Monitored indexes and analyzed their status for performance tuning and query optimization (Done lot of SQL tuning).

Configuration, troubleshooting Golden Gate issues

Setup Uni-directional GoldenGate setup.

Setup and managed replication using Oracle GoldenGate

Used SQL Trace, TKPROF, STATSPACK, perfstat, Explain Plan, AWR and ADDM for database performance monitoring and tuning. Ensure availability of databases and all related services such as RAC, ASM, Oracle streams and Data Guard.

Setup new database infrastructure. Install Grid Infrastructure /Real Application Clusterware (RAC), database server software and related products. Setup, configure standby databases, replication using Oracle Streams/Golden Gate, ASM for data storage and RMAN for backup and recovery. Apply Oracle patch set/PSU.

Successfully upgraded and migrated databases for critical OLTP application from Oracle 12c RAC infrastructure to Oracle 18c and 19c Grid infrastructure. Built Oracle 18c Grid infrastructure for all the region from Dev to Prod. Worked in collaboration with AIX, Storage team in setting up Oracle 11g Grid infrastructure, Development team in performing application testing and Load Runner team in performing Capacity testing.

Upgraded Oracle 10g and lower Non-RAC databases to Oracle 12c including data warehouse databases.

Migrated Oracle Non-RAC databases to Oracle RAC databases.

Migrated Oracle database from file system to ASM.

Define database backup/restore procedures using RMAN and TSM. Manage database backups and perform recovery. Participate in DR exercise twice a year to validate recovery procedures.

Prepare documentation and baselines. Analyze gap assessment and create road maps to overcome those gaps using Oracle best practices.

Perform database tuning and performance monitoring at the OS level, DB level and SQL level. Analyze data and make recommendations relating to performance and efficiency of data storage. Perform capacity testing before implementing new major application release to production environment. Provide advice and solution to Application Development Team to have effective use of indexes, how to reduce waits or other advices from OEM Grid control.

Work with the system administrator and storage administrator to perform software installations, and to configure hardware and software so that it functions optimally with the Oracle infrastructure.

Monitor and maintain database security. Co-ordinate with Security administrator in adding, maintaining and removing users account, administering quotas, auditing, and checking for security issues.

Interface with Oracle Corporation for technical support, solution to problems by utilizing Oracle support.

Provide after hours and weekend on-call support on a rotation basis.

Environment: Oracle 10g(10.2.0.1), Oracle 11g, 12c,18c and 19c RMAN, SQL*Plus, SQL*Loader, RMAN, AWR, ADR, ADDM, Scheduler, Data Pump, OEM, SQL Developer, Oracle Enterprise Manager(OEM) Grid, DBCA, DBUA, SQLTRACE, TKPROF, EXPLAIN PLAN, Golden Gate, Exadata, AWS

ABC, Bensalem, PA Oct 2013 to January 2017

Oracle DBA

Responsibilities:

Installed, configured, and maintained Oracle 10g and 11g and 12c on Linux and also Upgraded from Oracle 10g to 11g to 12c.

Performed the migration from Tandem to Oracle 11g and 12c

Expertise in designing the table structure using Visio by creating ER diagram and normalized all the tables from the scratch according to the specifications provided.

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Performed Database Refresh from Production to Development databases.

. Used PL/SQL (stored Procedures, triggers, packages), SQL* PLUS, SQL* LOADER of oracle database.

Supported different Databases like Testing, Staging and Training.

Performed installation and configuration of Oracle 10g/11g RAC databases on Linux.

Upgraded the Oracle 10g database to 11gR2 version and also applied patch set and interim patches whenever required to make the database software up to date.

Installed RAC on Oracle 10g and worked on ASM feature of Oracle.

Worked closely with developers during release and used oracle advanced features to achieve minimum downtime.

Good experience in Performance tuning of large databases.

Data Guard administration and maintenance.

Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.

Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.

Taking the RMAN incremental and cumulative backups.

Scheduling the databases backup using Cron tab and VERITAS net backup.

Perform Logical backup using full/partial export/import and data pump.

Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through Roles.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.

Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

Creation of Users and granting them the required Roles and Privileges accordingly.

Involvement in space management, managed quotas.

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Configuration of Listener and Net Service names using NETCA and NETMGR.

Cloned schemas, objects and data on new server using Data pump.

Managing databases on multiple servers.

Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 12c 11g/10g, UNIX RHEL 5.x, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Business Objects, Toad, Awr, Addm, Sql*Loader, VERITAS Net Backup, Visio.

Contact this candidate