Summary
Overview
Work History
Education
Skills
Accomplishments
Certifications Training
Certification
Languages
Timeline
Generic

Farhan Syed Khundmir

Chicago,IL

Summary

Information Technology professional with 11+ years of experience as an Oracle Database Administrator, providing 24x7 production support of both development and production 21C 19C /13c/ 12c / 11g / 10g / 9i / 8i databases on different Platforms.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Sr Oracle Application DBA

Roger Telecommunication
08.2020 - Current
  • Supported the development and Test teams with data refresh using exp/imp, Data Pump and scripts execution
  • Worked on Oracle application upgrade from R12.1.3 to R12.2.0 and R12.2.0 to 12.2.3
  • Worked on Oracle Database upgrade from 11g to 12c using DBUA and Manual upgrade
  • Perform Oracle E-Business Suite (EBS) apps DBA duties as assigned including code migrations, patching, cloning, backup and recovery
  • Troubleshoot and tune Oracle E-Business and Non-ERP Oracle Databases
  • Contribute to technical performance analysis and enhancement
  • Perform daily system health checks and monthly performance metrics to publish reports
  • Monitoring setup using Oracle Enterprise Manger (OEM)
  • Assist in planning and performing Oracle EBS and database upgrades and migrations
  • Responsible for Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications
  • Installed and supported OEM 10g on Windows and Linux
  • Created table spaces, tables, and users for custom applications
  • Performed Schema/Tables/Databases export using Data Pump, Export and Import utilities
  • Upgraded to 19C 18C 12c Grid Infrastructure from 12C

Sr Oracle DBA

Ingersoll Rand/Trane
06.2019 - 08.2020
  • Upgraded 10g to 11g, 11g to 12c and applied latest PSU every quarter
  • Supported more than 650 databases for more than 250 production servers for 24/7 support
  • Configured the databases with suitable block size, multiple pools and storage parameters for best performance
  • Upgraded different versions of Oracle databases
  • Refreshed data on windows databases using the Data Pump method and kept the integrity of the existing data
  • Created new users, tables/objects, permissions and added data on demand
  • Created, maintained and supported Oracle 11g/12c database instances
  • Automated database administration tasks with Oracle Enterprise Manager 11g/12c
  • Managed ASM instances and added multiple disk groups
  • Worked with Oracle Support to fix any bug issues
  • Analyzed long running queries and provided the required suggestions based on the Explain plan and AWR reports
  • Created DB Links to access data from Oracle to SQL Server using Oracle Gateway.

Sr Oracle DBA

Colorado Access
10.2018 - 04.2019
  • Supported the development and Test teams with data refresh using exp/imp, Data Pump and scripts execution
  • Configured the databases with suitable block size, multiple pools and storage parameters for best performance
  • Upgraded different versions of Oracle databases
  • Refreshed data on bi-weekly basis using the Data Pump method and kept the integrity of the existing data
  • Created new users, tables/objects, permissions and added data on demand
  • Created, maintained and supported Oracle 11g/12c database instances
  • Worked with System Admins to allocate the space and resources for different servers
  • Automated database administration tasks with Oracle Enterprise Manager 11g/12c
  • Managed ASM instances and added multiple disk groups
  • Worked with Oracle Support to fix any bug issues
  • Analyzed long running queries and provided the required suggestions based on the Explain plan and AWR reports
  • Trained new DBAs on the systems and participated in Yearly Oracle Audit
  • Created DB Links to access data from Oracle to SQL Server using Oracle Gateway.

Oracle DBA

Federal Reserve
01.2018 - 08.2018
  • Analyzed customer data for data integrity and Normal Form standardization
  • Installed, created and upgraded oracle databases
  • Created physical standby and Active data guard
  • Restored and recovered databases using different backup strategies
  • Developed matching methods to enrich customer data
  • Analyzed long data processes and streamlined for time efficiency
  • Applied quarterly patches and upgraded numerous Oracle databases
  • Setup, configuration and maintenance of Standby Databases for disaster recovery, high availability and data protection
  • Monitoring of tablespaces, indexes, memory and logfiles
  • Monitoring of Listener and TNS Names files and storage space for better performance Data Refresh in Test and Integration Databases using Transportable Table spaces
  • Worked on Data Replication using Materialized views, Snapshot, Streams
  • Worked on import/export, export Data Pump/import Data Pump and SQL Loader
  • Installed and Implemented Backup & Recovery procedures
  • Implemented Hot, Cold and Logical backup plans
  • Setup backup and recovery procedures using RMAN
  • Migrated from non-ASM instance to ASM instance
  • Configured Streams to capture propagate; apply changes in multiple databases
  • Performed Database and SQL tuning by using various Tools like Stats pack, TKPROF, Explain plan, AWR and ADDR.

Oracle Database Administrator

Health Net
08.2016 - 11.2017
  • Planned and designed logical Storage Structure
  • Configured the databases with suitable block size, multiple pools and storage parameters for best performance
  • Upgraded from Oracle 10g to 11g and 11g to 12c
  • Worked as lead DBA to implement/maintain Oracle Spatial to store and retrieve stored/location information
  • Creating materialized views and partitioning large tables (using Range-Hash, Range-List, Range-Range, List-Range, List-Hash) for performance improvement
  • Created, maintained and supported Oracle 11g databases and instances
  • Automated database administration tasks with Oracle Enterprise Manager 11g Database Control RAC installation and troubleshooting experience
  • Worked with RMAN and Data Pump to backup databases and refresh the data
  • Installed and configured Data guard set up including logical and active Data Guard
  • Managed change management system and kept track of the tickets.

JR. Oracle Database Administrator

Boeing Company
02.2012 - 09.2016
  • Supported more than 1500 databases for more than 289 production servers for 24/7 support
  • Upgraded 10g to 11g, 11g to 12c and applied latest PSU every quarter
  • Installed and configured new Quarterly ORACLE HOMES for the 10g and 11g versioned servers
  • Installed and configured Oracle RDBMS 11g on Red Hat Linux release 5 for the creation of a new Oracle Spatial database instance Primary DBA for all databases in DEV/TEST/PRODUCTION on 11g and 12c (Agents and Databases monitoring)
  • Handled individual project for ASM (Automatic Storage Management) migration every 2 months for Linux servers
  • Handled as a Primary DBA on Quarterly Patches for Linux, HP-UX and AIX operating systems, assigning schedules and delivering the results to end client
  • Application on-boarded process handled as a primary DBA, new applications requirement gathering from application team and then updating in a SharePoint
  • Supported the upgrade of RHEL and Hard work are diagnostics on various servers
  • Worked in all shifts and 5 days SNAP (production maintenance) at the maximum handovers
  • Documented all the incidents and presented in a form of report
  • Conducting meetings as a host on various occasions, preparing RCA (root cause analysis) as shift coordinator for several months
  • Installation, configuration and administrating Oracle Golden Gate replication between Oracle databases
  • Supported the agent patching for 12c server transformations
  • Regular work on 12c OEM for Monitoring the system databases and applications for availability and maintenance
  • Conducting shift weekly team meetings and involved in giving sessions on topics to the new folks, trained new team members in the team including 12c upgrade and monitoring support in OEM cloud control
  • Experience in ITIL with Incident tracker maintenance and SLA agreement following
  • Making sure the backups and file system usage is up to date
  • ASM is enabled and auto rebalancing is on
  • Supported the quarterly reboots for multiple servers and involved in Data guard home relinking as well as RAC Relinking
  • Prepared the document for applying quarterly UNIX patch over several databases
  • Tablespace management including, adding/resize data files, all ted quotas to user and managed disk space
  • Help developers write database triggers, packages, procedures, functions, utilities for application development
  • Export and Import of User, Tables and Database using exp/imp and Data Pump
  • Installed Patch for 11.2.0.4 and moved ASM to newer homes
  • Installed fresh homes for 11.2.0.4 on Linux servers
  • Supported SAN Migration and ASM migration, allotted new candidate disks.

JR. Database Administrator

Andhra Bank
12.2010 - 01.2012
  • Creation/cloning of database instances for development and testing purposes Design, develop, and maintain optimized databases for testing, production, and training
  • Provide ongoing consultation and documentation on the design, accessibility, and maintenance of database systems
  • Monitor and optimize the performance of the databases
  • Develop and implement the technical procedures, standards and security for databases
  • Database backup/restore activities
  • Production database support and issue resolution

Education

Bachelor of Science - Computer Science

Osmania University
Hyderabad, India
05.2010

Skills

  • Microsoft Visio, JIRA, Azure DevOps
  • SQL, PL/SQL
  • Snowflake, Redshift, Teradata, Oracle DB
  • Oracle 12c/11g/10g, RAC, Red hat Linux 4X, DB2, Solaris 10, Toad, PL/SQL, SQL
  • Plus, Oracle 9i/10g, LINUX, HP-UX, Solaris 9, SQL Server 2005, Windows 2000 SQL
  • Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM Grid Control
  • Verbal Communication
  • Remote Office Availability
  • Self-Directed
  • Active Listening

Accomplishments

  • Resolved product issue through consumer testing.
  • Documented and resolved [Issue] which led to [Results].
  • Achieved [Result] by introducing [Software] for [Type] tasks.
  • Used Microsoft Excel to develop inventory tracking spreadsheets.

Certifications Training

OCA Certified Oracle certified Associate (https://www.credly.com/badges/0d911961-94c9-462b-98dd-196548f77a6c/linked_in_profile)

Certification

  • [Area of certification] Training - [Timeframe]
  • Licensed [Job Title] - [Timeframe]
  • [Area of expertise] License - [Timeframe]
  • Certified [Job Title], [Company Name] - [Timeframe]
  • [Area of certification], [Company Name] - [Timeframe]

Languages

English
Full Professional
Hindi
Professional Working
Urdu
Native or Bilingual

Timeline

Sr Oracle Application DBA

Roger Telecommunication
08.2020 - Current

Sr Oracle DBA

Ingersoll Rand/Trane
06.2019 - 08.2020

Sr Oracle DBA

Colorado Access
10.2018 - 04.2019

Oracle DBA

Federal Reserve
01.2018 - 08.2018

Oracle Database Administrator

Health Net
08.2016 - 11.2017

JR. Oracle Database Administrator

Boeing Company
02.2012 - 09.2016

JR. Database Administrator

Andhra Bank
12.2010 - 01.2012

Bachelor of Science - Computer Science

Osmania University

Similar Profiles

CREATE PROFILE
Farhan Syed Khundmir