Resume

Sign in

Oracle DBA

Location:
Fairfax, VA
Posted:
April 18, 2016

Contact this candidate

Resume:

Aashiqul

Oracle DBA

Fairfax, VA *****

Profile Summary:

Over 8 years of experience as an Oracle DBA in Performance Testing, Production, Development environments, and transforming business strategies of various Fortune 500 and MNC organizations into efficient and integrated global business solutions. Proficient in an assortment of technologies, including Oracle 9i/10g/11g/12C, MS SQL Server 2008/2012/2014, JDBC, Visio,VB.NET C#, Windows, Solaris Linux and Unix Environment.

DBA skills include:

Oracle 12c/11g/10g/9i Database Administration.

Performance Tuning & Capacity Planning.

RMAN, Data Security, Backup & Recovery.

Core Competency Details:

Oracle RAC & ASM Admin/Installation.

Oracle Forms and Reports Development.

Database-Backed Web Solutions, OEM.

Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.

Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.

Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES.

Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.

Experience in implementing real application cluster Oracle 12c/11g/10g RAC.

Involved in installation, administration and troubleshooting Oracle Golden Gate.

Applied various processes in Oracle Golden gate.

Experience working in various events in Exadata.

Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners PL/SQL,UNIX Shell Programming.

Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.

Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)

Experience in using Tools like OEM, TOAD, E-Business suite, Data Migrations & export/import.

Excellent experience in Performance tuning of oracle databases using Oracle Grid Control,AWR, ADDM, TKPROF,STATSPACK, and tuning of SQL scripts using SQL Trace, Explain Plan, and Hints.

Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

Excellent experience in applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.

Designing the ETL processes and Experience designing the DW model USING TABLEAU.

Technical Skills:

Operating Systems

HP-UX 10.x,11.x,Sun Solaris 2.5,2.6,8,9,10, AIX 5.1,5.2, RED HAT LINUX 5.X, 6.X, 7.X and WINDOWS 2007/2008/2010, WINDOWS SERVER 2008/2008R2/2012.

RDBMS

Oracle 12c/11g/10g/9i/,Real Application Cluster (RAC); Golden Gate, Streams

Tools &Utilities

RMAN, OEM, TOAD, Oracle Management Server, SQL*Loader, Erwin, Export/Import, Data pump, OLTP, OLAP, Query builder, NetBackup, VB, Crystal Report, MS Access, Data Guard, Data Stage, Performance tuning,

Languages

C, C++, C#, SQL, PL/SQL, VB.NET, UNIX/NT Shell Scripting, awk Scripting, Perl

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK

Others

NetApp, Veritas Net Backup, EMC, TSM,HP Data Protector

Education: Master of Science from Chittagong University

Experience Summary

Client: United Bank, Fairfax, VA Feb 2015 – Present

Role: Sr. Oracle DBA

Trade completion system was involved in enriching the trade information which was received from the “Trade order management system.” The system was responsible for calculating the various costs and brokerages involved with the processing and execution of the trades, interactions with various ECN (Electronic learning system) and trade settlement systems. It implements the business logic for post trade processing, allocation, clearing and settlement.

Responsibilities:

Responsible for administration and supporting Oracle 12c, 11g, & 10g databases in DEV, QA, UAT and Prod environments.

Installation and Setting up of 11g RAC in AIX environment and 11g ASM on RAC databases.

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA.

Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 12C.

Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.

Scheduled and attended day to day meetings as part of Agile methodology.

Tuned OBIEE, ODI queries on date-ware house environments.

Built two 4 node 11gR2 RAC clusters on AIX 6.1 and RHEL servers and many two node RAC clusters on RHEL and AIX servers

Applied various PL/SQL scripts in Oracle database projects.

Proactive database monitoring using 11g grid monitoring tool.

Monitored Oracle Golden Gate replication and used log dump utility to read tracefiles.

Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas

Applied patches to Oracle Databases and Oracle Applications.

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM.

Conducted integrated capture and logical change record in Oracle Golden Gate.

Worked on Automatic Storage Management (ASM) for managing data in SAN.

Monitoring and resolving tickets in different environments.

Participated in Exadata database migration.

Deployed and supported Exadata.

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.

Checked parallelism instance parameter in Exadata.

Created UNIX shell scripts to automate batch jobs through Cron.

Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Environment: IBM-AIX, Sun Solaris, Oracle 12C,11g,Oracle RAC (11g), Exadata, Oracle Enterprise Manager Grid Control, RDBMS, RMAN, Agile, RHEL, Import/Export, Golden gate, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL

Client: Hyundai Capital, Irvine, CA Sep 2013- Jan 2015

Role: Oracle DBA

Hyundai Capital is South Korea’s No. 1 provider of consumer financial products, including auto financing, auto leasing services, personal loans, and home mortgages. The project involves maintenance and configuration of database for various transactional, OLAP and reporting databases with huge data volumes and to provide the applications support to the development teams and also the user community.

Responsibilities:

Installed myriad number of 11gR2 RAC databases on physical servers as well as VM’s.

Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments.

RAC to RAC physical standby configuration of dataguard for Disaster recovery requirement.

Built physical standby using RMAN Active duplication method as well for Disaster recovery site.

Achieved load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.

Database administration experience using DB2 UDB Version 9 or 10 on Linux.

Installation of 12c OEM and customize it to our needs.

Installed Oracle Golden Gate on RHEL and setup table level replication as well as DDL replication too.

Set up Golden Gate replication in Uni-directional and Bi-directional ways for couple of databases.

Migration of databases from Physical servers to VM’s on ESX clusters.

Expertise in managing very large database with 30TB in size on a 8 node RAC cluster.

Knowledge on EMC replication technologies like SRDF at database level.

Schedule quarterly maintenance activity for my primary databases as required and communicate with the app teams as needed

Applied Smart Scan, Flash Cache, Hybrid Columnar Compression IORM in exadata.

Knowledge about various events in Exadata.

Expertise in Performance tuning of RAC and standalone databases, configuring initialization parameters, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/Logical IO and Memory Usage.

Setting up Data guard to ensure the application is highly available, protecting from disaster recovery and for data protection.

Scheduled and attended day to day meetings as part of Agile methodology

Experience in installation, and maintenance of Oracle Exadata machines.

Storage management i.e adding of disks and removing of disks from disk groups and rebalancing of disk groups and analyzing disk stats as well using ASM

Performed migration activities like Dev to Test and Test to Production for large databases.

Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.

Used Oracle Exadata for DBA activities and advanced queuing while replication.

Designing and implementing of backup strategy for database like when to perform a full backup, incremental / cumulative and deciding upon timings that doesn’t affect normal processing.

Used shell scripts for monitoring jobs, for startup and shutdown, health check of databases, analyzing stats at different levels, rebuilding indexes and for purging as well.

Optimizing ETL procedures and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL trace

Additionally, part of on-call rotation to support databases 24X7

Environment: Oracle RAC 12c, 11gR2 11.2.0.3,11.2.0.1,10.2.0.4, RHEL 6.0,RHEL 5.x, AIX 6.1, Agile, Exadata, Solaris, TOAD, DBArtisan, ASM, OLTP, Hybrid environment, OEM

Client: State Street Corporation, Boston, MA Sep 2011 – Aug 2013 Role: Oracle DBA

State Street is the world’s leading provider of financial services to institutional investors. Their broad and integrated range of services spans the entire investment spectrum, including research, investment management, trading services and investment servicing. Their offices are located in twenty five countries worldwide.

Responsibilities:

Providing 24x7 supports for designated production databases. Ensuring data availability as per the service level agreement. Oracle’s Enterprise Manager (OEM), Statspack Reports, Explain Plan, SQL Trace and TKPROF. Complex queries prepared and ETL processes build and executed. Involved in physical model. Data is normalized as per performance and integrity data.

Tons of experience in installation, configuration, troubleshooting and analyzing of RAC environments

Developed skills and gathered thorough experience in accounting such as Profit & Loss, Balance Sheet, and Cash Flow Statements. Implemented RMAN backups (Full, Incremental and Cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.

Built myriad RAC clusters for UAT and Development environments as well. Oracle 11g, 10g, 9i installation and Configuration. Build 11g OEM on Linux. Monitored production databases via OEM 11g.

Supported Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems, for applications with data warehouse and OLTP components.

Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches

Configuration of RAC environments to suit business requirements to achieve maximum resource utilization

Oracle Exadata Management was efficiently used in the project

Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM. Setting up Data guard to ensure the application is highly available, protecting from disaster recovery and for data protection. Meeting users’ requests.

Analyzed log transport services and log apply services in physical/logical databases using data guard.

Involved in Performance Planning and Tuning by using baselines for AWR and proactive monitoring, bottleneck elimination and the wait event interface to identify issues with respect to performance.

Very good at analyzing execution plans for queries and making necessary changes to the queries by adding necessary hints to them as suggested to deliver optimum performance.

Practical application of Oracle 11g new features like Database replay, Transaction management with log miner and Flashback data archive, RMAN’s new features as well.

Very comfortable in using ASM for creating disk groups, adding additional storage (DISKS) and troubleshooting ASM issues.

Environment: Oracle RAC 11gR2 11.2.0.2, 11gr2, AIX 6.1, Oracle 9i,10g/11g,RHEL 5.5, Red Hat Linux 5, Solaris, SQL, PL/SQL, ETL, TOAD, DBArtisan, ASM, OLTP, Hybrid environment, OEM

Client: MassMutual, Springfield, MA July 2009 – Aug 2011

Role: Oracle DBA

Massachusetts Mutual Life Insurance Company (MassMutual) is a leading mutual life insurance company with 1800 offices and 13 million clients worldwide. Mass Mutual is one of the largest Life Insurance companies globally and is currently ranked 93rd in the Fortune 500 list. The Company has revenues of about $25 Billion with Assets under Management at $448 Billion..

Responsibilities:

Responsible for administration and supporting Oracle 11g, 10g and 9i databases in DEV, QA, UAT and Prod environments

Installation and Setting up of 11g RAC in AIX environment and 11g ASM on RAC databases

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA

Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g

Configured Oracle Streams for stand alone and RAC environments as well.

Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.

Tuned OBIEE, ODI queries on date-ware house environments.

Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas

Applied patches to Oracle Databases and Oracle Applications.

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM

Worked on Automatic Storage Management (ASM) for managing data in SAN

Monitoring and resolving tickets in different environments

Export and Import of database objects to copy from one database to another database between different environments

Extensively used Oracle Exadata throughout the project

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

Created UNIX shell scripts to automate batch jobs through Cron

Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc

Environment: IBM-AIX, Sun Solaris, Oracle 11g, 10g, and 9i, Oracle RAC (11g), Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL

Fannie Mae, Pittsburgh, PA Feb 2008- June 2009

Oracle Database Administrator

Fannie Mae is a government-sponsored financial firm (GSE) chartered by Congress with a mission to provide liquidity, stability and affordability to the U.S. housing and mortgage markets. The Project deals with the internal implementation between the bankers and Fannie Mae, where the bankers provides the details of customers to FM, and here the Employees will process Loans depending up on the customer’s credit records.

Responsibilities:

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.

Installation, Maintenance and administration of Oracle 10g on Red hat Linux.

Implemented Data guard and administered the production database.

Installed Oracle 10g RAC database on RHEL and applied all current patches

Scheduled several backups through RMAN.

Database Restore using RMAN, Cold Backup and Export/Import.

Experience in working with data warehouse products

Used Flashback table to restore tables which is a new feature of Oracle 10g.

Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

Extensive application tuning through STATSPACK, explain plan, SQL*Trace.

Worked on decommission of database and services which are no more required

Monitored the Oracle Streams topology and performance.

Identified the long running transaction through V$session_longops and also for Rollback monitoring which is an enhanced feature of Oracle 10g.

Used EM on Oracle 10g for diagnostic summary, host CPU utilization, finding wait events, alerts Log errors etc.

Re-engineered system to J2EE using Oracle 10g backend database.

Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.

Performed the SGA tuning, monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Tablespaces and Segment fragmentation. Performed trouble-shooting activities, created new users and assigned privileges and roles to users.

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g/, PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.



Contact this candidate