Syed Ibrahim

Contact: 872-***-****

E-mail ID: adbtni@r.postjobfree.com

SUMMARY

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

Performed build and installation of RAC.

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

Monitor database instances using 13c Cloud control (OEM)

Actively monitor CPU usage, memory, disk and I/O, make sure there are no performance bottlenecks.

Good understanding of Amazon Cloud (AWS).

Migrated databases to EC2 instances on AWS.

Good understanding of database statistics and its impact on optimizer,

Monitor logs generation, tablespace and FRA usage.

Build Physical Standby and Active Data Guard.

Monitor Data Guard instances, gaps, and data integrity and parameter checks.

Written custom shell scripts to automate tasks.

Create tickets related to testing data using service now.

Managed databases on Exadata X7.

Migrated standalone database on cluster on RAC.

Perform backup/restore using RMAN.

Used ASH, AWR and ADDM reports to tune database performance related issues.

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

Expertise in silent database installs

Clone databases using RMAN

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

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

Worked on Auditing and FGA

Good understanding of Oracle Goldengate replication.

Refresh database, schemas and tables using traditional export/import tool and Data Pump.

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

Proficient in database migration projects.

Applied CPU and PSU patches on quarterly basis.

Upgrade databases from 12c to 18c.

Good understanding of SQL Server Database Management

Worked closed with Oracle engineers from oracle support.

Extensive work in database installation, configuration and upgrades.

Worked on tuning SQL and instance for faster response time.

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

Excellent Experience as Production DBA with 24X7 support.

Flexible and excellent team player

Excellent troubleshooting skills and quick learner.

TECHNICAL KEYWORDS

Exadata

RAC

ASM

AWS

Migration

Data Guard

ASH

EC2 instances

Upgrade

Active Data Guard

AWR

Patching

Troubleshooting

Partitioning

ADDM

Cloning

Performance

Dictionary Views

Backups

RMAN

13c Cloud Control

Statistics

Export Import

Data Pump

PROFESSIONAL EXPERIENCE

Great Western Bank, Sioux Falls, SD

February 2016 to Present

Oracle DBA

Responsibilities:

Provide day to day operations support in managing 11g, 12c and 18c databases.

Setup and managed Oracle 12c Physical Standby databases.

Installed, configured, and maintained Oracle 12c and 18c on OEL.

Performed the migration of databases during hardware refresh.

Build Physical Standby databases

Setup Active Data Guard

Resolved Gaps in primary/standby configuration.

Work closely with application and developers on performance of databases, indexing, space etc.

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 24/7 environments

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 12c/18c RAC databases on Linux.

Upgraded the Oracle 12c database to 18c version and also applied patch set and interim patches whenever required to make the database software up to date.

Worked with storage team on getting LUNs for ASM.

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.

Used ADDM, ASH and 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 database from 13c cloud control

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

Deloitte, Tulsa, OK

June 2012 to January 2016

Oracle DBA

Responsibilities:

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).

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 10g RAC infrastructure to Oracle 11g Grid infrastructure. Built Oracle 11g 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 11g 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.

Education:

Bachelor of Science

Osmania University

Contact this candidate