Data Manager

Imran

Oracle Database Administrator

Boston, MA . 781-***-**** . addrz7@r.postjobfree.com

Summary

Database Administrator having hands on experience in database creation, administration, production support, performance troubleshooting, configuration and upgrades on Windows, HP-UX, and Linux.

Working with various Oracle 12c/11g/10g/9i/8i versions, Installation on Linux/Unix, Sun Solaris, IBM AIX, HP-UX, and Windows environment, Administration, Monitoring, Performance Tuning, Database Backup and Recovery.

Worked on Creating Oracle DB Instance in AWS RDS and EC2.

Experience working with AWS Oracle RDS, Data/Database encryption using Option groups, creating parameter groups using AWS Console or CLI.

Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability

Proficiency with Installation and maintenance of replication tool Golden Gate 11g and 12c Versions by creating extract process, extract pump, and replicate.

Implemented Golden Gate for data recovery and data migration for Oracle 11gR2 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.

Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.

Implemented GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.

Experience working with Exadata administration. Exadata Half Node configuration utilizing the Smart scan, Flash Cache, Storage Indexes and Exadata Storage server software and features.

Experience in using features like Data Replay, Log Miner, Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.

Implemented Backup & Recovery techniques using RMAN and conducted disaster recovery drills.

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

Implemented Oracle RAC with Data Guard implementation for disaster recovery.

Experience in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.

Experience in building Standby databases. Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Dataguard. Also, proficient with 11g features such as Active Dataguard and Snapshot standby database.

Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, data Migrations using export/import, benchmarking using load testing tools.

Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.

Experience in Tuning: Used Explain plan and TKPROF for SQL/PLSQL tuning; Used STATSPACK performance tuning i.e. tuning SGA, I/O distribution using STATSPACK.

Performance tuning expertise, specializing in OS tuning, SQL tuning, Database/Instance tuning.

Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR

(Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.

Extensively used advanced queuing to process the on line jobs.

Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.

Extensive experience on OEM, TOAD (Tools for Oracle Application Developers), SQL*Plus and SQL*Loader as well as traditional UNIX command that requires for Oracle DBA

Configured and Maintained Physical Data Guard for High Availability and offline reporting.

Designing and Building Relational Databases architecture in OLTP, OLAP, client/server.

Experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM

Installed, configured, and resolved issues with the Oracle Streams utility, and with the Oracle Change Data Capture utility (CDC).

Experience with installing, configuring and administering SQL server 2005/2008/2012/2014/2016 databases including migration from MS SQL server to oracle.

Good experience in MSSQL Server 2005/2008/2012/2014/2016, T- SQL with knowledge of Server Clustering, SQL Profiler, Execution plan, Log Shipping, and Database Mirroring. Skills

RDBMS: Oracle 12c/11g/10g

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.x, Linux RHEL 5.x,6.x,7.x MS SQL Server 2005/2008/2012/2014/2016

Languages: SQL, PL/SQL, Perl, Korn, UNIX Shell Scripting Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD,Sql developer, Sqlplus, Goldengate Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH Work Experience

Database Administrator January 2017 to Till Date

Massachusetts Bay Transportation Authority, Boston, MA

Working as a Core DBA/ Exadata DBA as migration specialist on Oracle 12cR2, 11gR2, Exadata X2, X3

& X6, OEM 13c, RAC, Data Guard, Linux.

Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack.

Migrating 50+ databases from Exadata X2 and X3 machines to Exadata x6 machines.

Managing database on 12c RAC and 11g R2 RAC.

Defining database migration execution plan and testing the migration strategy.

Database capacity planning, working with application team to understand their requirements and provide better solution for application high availability.

Working with UNIX, Network, NAS and DBA teams through the process, working on OEM, RAC, Golden Gate and Data Guard.

Created OEDA requirement document for Oracle to setup the new Exadata X6 machines.

Worked with network and linux teams to configure the network on the Exadata x6 machines so Oracle ACS can install Grid infrastructure 12cR2 and Databases 11g R2 and 12cR1.

Configured and modified Exadata x6 machines as per MBTA requirement and specifications after Oracle handed over the standard Exadata machines.

Installation of OJVM patch on 11gR2 databases on Exadata X2 and X3 environments before migrating it to Exadata X6 machines to match with Bundle patch version.

Worked with Storage team in configuring Netbackup and Datadomain on Exadata X6 machines.

Setup DataGuard between multiple datacenters for 12 production databases.

Planed and documented all migration steps and coordinated with different teams during the deployments.

Tested Switchover and failover between data centers before migration of production databases using Dataguard

Efficient in using Dataguard Broker for all DataGuard tasks.

Migrated multiple databases upto 10TB of size with minimal to no downtime using dataguard.

Migrated databases for applications like Peoplesoft, Automic UC4, GitHUB, Stibo STEP, Atlassian Jira, Arlassian Confluence, BuildForge, DataStage, Oracle WebCenter Sites and MBTA website.

Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.

Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.

Working on Installation of Oracle Enterprise Manager Cloud Control 13c.

Worked with linux team to setup VM’s for Oracle Management Repository database server and Oracle Management Service (OMS) web-based application server.

Working on setting up agents on Exadata x6 machines for monitoring.

Monitoring for 24x7 Production environment, resolution of severe performance and user access issues

Worked with tuning tools like DBArtisian, TOAD and Solarwinds Database Performance Analyzer.

Worked on building and rolling out new 12c databases for TEST/DEV/QA/PROD environments.

Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.

Interacting with the clients, gathering requirements, verifying that system meets performance criteria, designing new systems or enhancements to existing systems to support business needs.

Configure Goldengate and Upgrade on newly created environments.

Rebaseline Goldengate on already existing goldengate environment after refreshes.

Upgraded SQL Server databases 2012/2014 to 2016. Also implemented Goldengate from Oracle to SQL Server.

Perform day-to-day system support, design and implement data replication strategies, upgrading and new project planning and implementation.

Use Service Now for the non-production and for production to issue the tickets. Service Now tickets need to be cleared within SLA based on the severity of the ticket issued. Database Administrator August 2015 to December 2016 Harvard University, Cambridge, MA

Supported 80+ databases which includes RAC Production databases, Data warehouse databases and lot of Development and Test databases.

Worked on building and rolling out new 12c RAC, CRS databases using ASM for Test/Dev/QA environments.

Upgraded the transactional Oracle Databases from Oracle 11.2.0.4 to Oracle 12.1.0.2 in Production and lower environments and applied PSU’s (July 2015, October 2015, January 2016, April 2016, July 2016)

Coordinated with UNIX team on gathering the requirements to allocate new resources for building new hosts required as a part of migration.

Coordinated with the storage team to gather additional storage required on the servers and new mount points setup on the databases.

Implemented Oracle GoldenGate HA RAC environment to several downstream databases which are acting as offload databases by application teams.

Configured GoldenGate for DDL and DML replication in Production.

Migrated OLAP databases close to 8TB with minimal downtime using GoldenGate and verified data integrity using Goldengate Veridata tool for Linux 3 Node RAC.

GoldenGate 12.1.2.1 Upgrade from 11.2.1.0 version and handled FORMAT RELEASE changes for local and remote trail files in Extract and Pump processes.

Integrated all the databases with 12c OEM (Multi OMS configuration) to monitor databases and Goldengate effectively.

Converted Goldengate Classic Replicat to Co-ordinated Replicat to improve the throughput of golden gate apply.

Performed database management activities on Exadata X3-2, utilizing features of Exadata like smart scan, flash cache, storage indexes etc.

Worked on X3-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.

Performed role switchover in Exadata RAC environment with GoldenGate HA running on the servers.

Familiar with cellcli command line interface in Exadata environments

Troubleshooting Exadata smart scan/offloading issues and experience working with Exadata Storage Server software, managing cell disks, grid disks and ASM disks.

Configured RMAN backups in OEM and cron for development databases along with scheduling weekly full backups, Daily Incremental and Archivelog backups.

Cloned environments to create patch test, development and Stage environments

Created and monitored Virtual Private Database (VPD) policies for securing sensitive data in PI tables

Installed and configured Oracle Audit Vault and Database firewall in non-production environment as a proof of concept

Loading huge datasets into the database using SQL Loader during ETL operations

Testing the functionality of Key Vault in storing the TDE wallet keys from all the non-production databases as a proof of concept

Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.

Run SQL tuning advisor to compare execution plans and analyze them before enforcing the SQL profiles for optimizer to pick up best execution plan.

Troubleshooting resource intensive SQLs by enforcing optimal plans using SQL plan management.

Set up Active Dataguard Configurations for oracle database 11.2.0.4 for thirty databases whose size varies from 10TB to 15TB on a 3 node RAC.

Migrated some of the on premise database to AWS.

Was a Team Member to Migrate current infrastructure on-prem to AWS EC2.

Working with clients on an internal application to monitor the AWS accounts.

DDL replication with GoldenGate was provided for databases where heavy loads were run by BATCH jobs.

Worked on Implementing Oracle GoldenGate with Amazon RDS and EC2.

Working on JIRA tickets fulfilling developer, ETL and several team’s requests.

Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption) using RMAN and Oracle Flashback.

Working on daily tickets which involved password resets, account unlocks, users creation and tickets reported by developers having issues with any database.

Actively participated on war room bridges during major releases and escalated to dba management as needed.

Upgraded and Migrated SQL Server databases 2008R2/2012/2014 as a supporting DBA.

24 x7 databases support for the customer-facing and servicing environments as a part of Goldengate migration project to make sure that no performance issues are impacting the applications in this critical environments.

Operational DBA support for all environments on daily shift basis and On Call rotation to support production systems.

Database Administrator August 2014 to August 2015

Wells Fargo, Des Moines Iowa

Worked on Installation and maintenance of Oracle 11g, 12C RAC databases including Golden gate, ASM and CRS.

Responsible for installation of Oracle Clusterware (CRS) also referred as Grid Infrastructure from 11g and creating the RAC databases.

Upgraded the RAC and standalone databases from 11g (11.2.0.2 and 11.2.0.3 and 11.2.0.4) as part of performance improvement by utilizing the new features.

Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export

/Import), Database backup (Hot & cold).

Worked on Features: Data Pump, ASM and RMAN, Data Base Recovery (complete & Incomplete).

Installed Oracle 12c database on Linux in a test environment.

Performed Initial load, Extract, Replicat, trial files and exporting data onto Repository Database using Golden Gate tool.

Worked on Debugging and trouble-shooting replication issues in Golden Gate 11gR2.

Handled large volume transaction loads in various replication scenarios and fast resolution of issues.

Worked on Golden Gate patching, upgrade and solutions for compressed and encrypted tables and table spaces.

Worked on Troubleshooting Complex Golden Gate production issues including latency optimization and conflict resolution.

Worked on Database Wallet and TDE (Transparent Data Encryption) for encrypting the Sensitive data using column encryption and tablespace encryption.

Applied the Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches

(for Bug resolution) using opatch.

Proficient in managing Oracle Instance, database storage structure, schema objects.

Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.

Worked on installing the Rollover PSU patches for RAC databases (Jan 2015 & April 2015).

Experience in Planning Database, Sizing table space, create database, scripts, monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.

Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp.

Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.

Implemented archive and Purge strategy for archiving the inactive data and purging the archived data from the primary/OLTP database as a part of performance improvisation with minimal downtime using online redefinition.

Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.

Masked sensitive data columns in a table to import data from production to Test environments using Oracle Data Masking

Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as clients and understanding requirements

Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables. Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN.

Monitored Goldengate using 12c Goldengate Plugin and also Goldengate Director and shell scripts for alerting GG process down alerts.

Worked on scheduling the automated jobs via OEM grid control, cron and autosys (using jil file).

Responsible for optimizing sql queries and tuning the long running queries as a part of performance improvisation.

Providing the Go-live and Post –go live Support for the database performance related issues and ensure that all the work is documented for future reference.

Generating Stats pack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.

Experience in supporting SQL Server databases 2008R2/2012 as a supporting DBA.

Working with Server Admin to resolve the server level issues. Oracle DBA August 2013 - August 2014

Cisco, San Jose, CA

Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 2(11.2.0.2,11.2.0.3) install and upgrade on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11gR2 upgrades.

Checking Backup and Restore validity periodically on databases about 12TB in size, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups

Responsible for installing, supporting the oracle stand alone, RAC(2node) and RAC(2node) with databases of the version 11g, 10g and 9i on AIX 6.1/5.3/5.2, Sun Solaris 10, and Windows 2008.

Used Veritas Cluster File System (VCFS), ASM file system and SCAN LISTENER in installing Oracle 11g RAC and also installed oracle grid agents on standalone and RAC databases.

Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.

Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN. Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2.

Worked on installing the data guard on RAC databases for disaster recovery and setup the broker.

Tested the switchover on the RAC databases manually and also using broker.

Worked on resolving the gap between primary and standby databases in by registering the missing archive logs in the standby database of about 8TB

Worked on setting up the flashback and restore point on the databases and also flashbacked the databases to restore point when required.

Worked with different utilities like broker (DGMGRL), SRVCTL, CRSCTL and CLUVFY.

Configured OEM 12c Grid control to monitor database performance, SQL query tuning, create monitor block, and deployed plugins.

Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node.

Performed Initial load, extract, replica, trial files and exporting data onto Repository Database using Golden Gate tool.

Experience with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.

Database Maintenance, Data warehousing, and Data Modeling using Erwin.

Prepared test environments for backup/recovery using RMAN and Recovering Databases when there is any physical or Logical Corruption.

Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities.

Kept tracking the database performance using oracle enterprise manager and checking the user’s sessions consuming more CPU and taken the necessary steps to reduce the CPU usage.

Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp.

Refreshed the databases from PROD to lower environments using RMAN.

Performance tuning of oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor.

Worked on DR tests using Dataguard and VVR, resolved the issues during switch over and switch back.

Migrated the databases from 9i and 10g to 11g from SunOS to AIX.

Upgraded the databases from 9i and 10g to 11g and resolving the issues during upgrade.

Worked on RMAN backup and recovery. Recovered the databases (full recovery) during database upgrade and point in time recovery as per the user request using RMAN.

Created the dblinks (private and public), synonyms (private and public) and views. Validated the views and compiled the views which are invalid.

Have used different tools like DB Artisan (8.7.2), EXPLAIN PLAN, TKprof, STATSPACK to solve the performance issues.

Helped developer in installing Oracle Client, troubleshoot and establish the connection to Oracle database through JDBC.

Responsible for monitoring the daily jobs and resolving and finding reasons for failed jobs.

Responsible for creating the sizing documents for databases as per storage provided by application team. Documented all the necessary work for future reference

Installed and administered SQL server 2000/2005/2008/2012 databases including migration from MS SQL server to oracle, MS SQL Server 2005, 2008 to 2012. Jr Oracle DBA December 2011 - December 2012

E Plus Projects Pvt Ltd., India

Involved in the installation of Oracle products (10g) on Windows NT and Linux.

Performed day-to-day DBA jobs for managing Development databases

Cloning the databases for different environments.

Creating primary database storage structures (table spaces, rollback segments, etc).

Applied patches, keeping applications software bug free, and improving data integrity.

Execute Hot, Cold and RMAN backups and recoveries.

Tuning the Database and Analyzing the Database.

Participated in Disaster Recovery Drills, documented database and application validation steps

Applied High priority, security patches downloaded from Metalink.

Coding PL/SQL & Shell Scripts, Design/Code reviews.

Installation of the Databases, Environment Building to OFA compliancy.

Recovery Manager (RMAN) Implementation and strategies, Various Database Recovery scenarios verification in advance.

Database Maintenance, Data warehousing. Data Modeling using Erwin.

Software design of medium/large business applications, Design methodologies.

Database (SQL) design, E-R Modeling, Design and Development Of database design.

Jobs Scheduling, Exports/ Imports, Space Management.

Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.

SGA, I/O, OTIMIZATION, SQL- tuning, Security Management.

Managing the network and service changes on the network of the databases.

Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.

STANDBY Database implementation and Automation of the process (KSH, LOADER, PL-SQL scripting combination) of ftp download of files to proper load and update on tables.

Writing shell scripts, Loading data into the database from the flat files with SQL*Loader.

Installation, configuration and upgrading of Oracle server software and related products.

Responsible for setting and managing user accounts, Granting required privileges to users. Education:

Bachelor of Engineering August 2007 - June 2011

Contact this candidate