Oracle Manager
Resume:
Amer Safdar
Morton Grove, Il *****
***********@*****.***
Executive Summary:
I have been in the industry for over 20+ years, and have a Master’s degree in Computer Science and Bachelors in Business Administration. I have managed multiple teams, including DBA’s and DEVOPS. I leverage my team members and consider myself to be an enabler. Over the course of my career, I have designed & implemented various database solutions for Financial, Pharmaceutical and Utility companies, focusing on the following areas:
* Cloud migration strategy (private and public cloud)
* Virtualization (OVM, VMware)
* Hardware and software procurement process
* Vendor management
* Data Center Migrations
* HR management including onshore and offshore teams
* Project Management
* Data Warehouses and OLTP systems
* Oracle Engineered Systems
* Manage Incident & Change Control processes including Release Management
PROFESSIONAL EXPERIENCE
Senior Principal Consultant, Forsythe Technology
Implemented multiple Oracle Engineered Systems, which included X6's and ODA's. Assisted the clients in pre-implementation and post-implementation phases.
Planned and migrated databases from traditional platforms to EXADATA, Private Cloud Appliance (PCA) and ODA's.
Planned and executed storage migrations from HP 3PAR to VMAX Clarion, at enterprise level.
Performed Infrastructure assessment, architected/migrated DB’s to cloud, which included Hybrid strategy and on premise cloud, focus on security and networking, using Oracle and AWS cloud solutions.
Implemented RMAN backups to ZFS appliances, implemented compression, fine tuned backups and brought down the time significantly. Performed several migrations, using heterogeneous data guard from non-exadata to exadata environment. Used RMAN duplicate to create data guard environments.
Implemented TDE for a large utility company, to protect PII data. Also implemented role based security, along with Oracle masking, to protect sensitive data.
Manager, Accenture INC, June 2013 – June 2016
Clients: APSP (Accenture Public Service Platform)
Praxair, Inc. Chemical company (Old name: Union Carbide)
Ohio, Iowa and Kansas Eligibility and Enforcement System (Affordable Care Act)
Portland General Electric (PGE)
Architected and implemented 12c CDB environment on a RAC platform, for a large regulated industry client. Responsible for entire database landscape.
Managed global teams including Oracle, SQL DBA’s and infrastructure teams. Responsibilities included incident management, RCA and escalations.
Responsible for annual performance reviews, merit raises, bonus allocation, training and laddering. Also had to discipline employees, if the situation demanded it.
Conducted collaborative sessions for the team members, to present ideas, learn and share, all aspects of technology. Provided a congenial learning and work environment. Used mentor/mentee program to develop junior resources.
Involved in hardware/software procurement, providing short term/long term roadmaps. Part of budget forecasting and allocations.
Planned and managed Oracle upgrades from version 11.1.0 to 11.2.0 and introduction of 12c on RAC.
Conducting a POC for Big data solutions based upon Hadoop.
Adopted Liquibase framework to streamline the database change deployment process.
Providing support for the development/production environments, both RAC and single instance.
Implemented Goldengate replication between Oracle 11.2 and DB2 on mainframe, including the monitoring piece, Goldengate director.
Hospira, Database Architect Consultant, Chicago, IL May 2012 – June 2013.
Architected database environments, which conform to FDA standards, for pharmaceutical industry.
Involved in a EXADATA X3-2 implementation. Involved in the migration strategy from a non RAC environment to EXA environment.
Designed, executed, documented and trained the in-house DBA staff on customized procedures for upgrading Oracle databases to 11gR2 using clone method to maximize efficiency.
Utilize Oracle Automatic Storage Management (ASM), Oracle Managed Files (OMF) and Recovery Manager (RMAN) to reduce administration overhead and provide a comprehensive backup and recovery strategy.
Setup Goldengate between the production environment and a reporting database.
Newedge INC, DBA Chicago, IL October 2009 to May 2012.
Negotiated licenses for strategic platforms including Oracle and SQL Server. Excellent people management and motivational skills. Responsible for staffing resources and merit raises.
Setup training/mentoring and collaborative sessions for developers and junior resources.
Involved in the physical design and implementation of enterprise wide data warehouse on three node RAC cluster (11.2.3).
RAC technology stack supporting both OLTP and DSS (data mart/data warehouse) databases.
Support RAC environment (11.1.0.7), configured and setup a six node OLTP environment. Involved in tuning and troubleshooting, as these applications serve as a backend to online trading application.
Implementing high availability solutions including RAC and Data Guard (11.1.0.7).
Implemented Goldengate (10.x and 11.x) replication between SQL Server and Oracle environments.
UBS, Database Management Specialist/Lead Associate, Chicago, IL June 2006 to October, 2009
Developed methodology for upgrading older versions of Oracle RDBMS, along with the whole technology stack, conforming to the latest support matrix.
Implemented enterprise wide disaster recovery, using SQLBACKTRACK and RMAN. Performed disaster recoveries, tested various failure scenarios.
Implemented reorg strategies, for better performance and reclaiming space Tuning SQL code and database environments.
Moving non ASM instances to ASM.
Configure and support clustered Linux servers (RHEL and OEL) to host Oracle 10g
Heavy interaction with clients regarding requirements gathering and any special needs to application design.
Upgrades to 10g, OEM setups and general troubleshooting
Documented and setup multi way replication using Golden Gate.
Developed a set of standards for architecting file systems layouts for OLTP and data warehouse environments, based upon SAN storage, raid level configurations based upon the usage of underlying file systems, on Solaris 8 and Solaris 10.
Technology: Korn Shell, Linux, Sun OS, Oracle (version 10g, 11g), PL/SQL, SQLSERVER,
RMAN, ASM, DataGuard, RAC 10g, GoldenGate.
Tek Systems, Database Administrator, Clients U.S. Cellular, Abbott Labs, January 2006 to
June 2006
Production support DBA.
Synching up dev environments with prod.
New hardware setup for prod. Environments.
Making sure all database environments conformed to FDA standards.
Technology: Korn Shell, HP9000, Sun OS, Oracle (version 8i, 9i, 10g), Oracle 8i/9i, PL/SQL, Windows 2000 and NT, SQLSERVER.
DBS Communications, Lead Database Administrator, IL October 2004 to December 2005
Implemented and supported a 9.2.0.6 Oracle RAC two node cluster (1.5 terabyte) on a Solaris 5.8, using Veritas Cluster Software
Implemented 10G and migrated from 8.1.7.4 to 10G
Implemented role based security and used resource manager to limit the resource utilization
Implemented logon triggers to audit users
Applied Oracle patches, for stability reasons
Helped tune the application as it had extensive bugs. Bugs caused locking and shared pool
fragmentation and number of other issues. Had to troubleshoot and provide solutions
Responsible for all backups and restores. Cloned databases for developers
Involved in the logical and physical design of Data warehouse and Operational Data Store.
Also involved in the tool selection and sizing the environment
Maintained vendor relationships, ordered hardware and involved in tool selection
Helped the developers in SQL and application tuning
Technology: Korn Shell, Linux, Sun OS, Oracle 8i/9i, PL/SQL, SQLSERVER, RMAN, DataGuard, RAC 9i.
ARC, Senior Database Administrator, IL October 2001 to September 2004
Performed migrations/upgrades from Oracle 8.0.4.4 to 8.1.7, 8.1.7 to 9.2.0.4 and patched to Version 8.1.7.3.
Setup and supported a two node 9i RAC cluster.
Defining preproduction architecture and process methodologies as it relates to PeopleSoft,
including startup and shutdown procedures for database, application server and other backend processes.
Tuning assignments include database, SQL, Application Engine, Application Server, Process Scheduler, People Code and web related activities.
Set up RMAN catalog for backups and recovery.
Cloned production databases.
Implemented new 8i and 9i features and also tuned SQL for the new and existing environment. Installed OEM and Statspack and used these tools for performance and tuning.
Implemented role based security and used resource manager to limit the resource utilization.
Implemented logon triggers to audit users.
Identified and worked with the developers in tuning SQL and PeopleSoft applications, including HR and financials modules.
Setup standby databases in 8i.
Configured a primary and secondary names servers.
Architected and implemented an Operational Data Store (ODS).
Heavily involved in OS/Oracle tuning to support ODS environment.
Reversed engineered schemas from Erwin.
Assisted the efforts of the development team, by tuning SQL code.
Supported applications on SQLServer 2000. Responsible for backups, restores and performance and tuning.
Technology: Korn Shell, HP9000, Sun OS, Oracle (version 8i, 9i), Oracle 8i/9i, PL/SQL,
SQL*Plus, Windows 2000 and NT, RMAN, PeopleSoft
Moore NA, Lead Database Administrator, Libertyville, IL January 1999 to August 2001
Implemented and designed the physical layout of a data warehouse, using Oracle 8.1.6., on a
Sun platform.
Migrated databases from Oracle 8.0.4 to 8.1.7.
Supported a distributed CRM application (Oracle 7.3.4) and OLTP applications.
Responsibilities include scheduled maintenance, performance and tuning, monitoring,
designing the physical layout of hardware.
Working on disaster recovery scenarios. Responsible for enterprise level backups and restores
using Veritas NetBackup.
Cloned production databases for test and development environments.
Backup and refresh of SYBASE environments from production.
Worked as a part of the UNIX team, performing admin duties. Maintained and developed
scripts in Korn shell and Perl.
Technology: Korn Shell, HP (Vclass and K class boxes),Oracle 8.0.4/8i, SYBASE, PL/SQL,
SQL*Plus, Windows 2000 and NT, RMAN, Veritas Netbackup 2.5, Acta, Business Objects, SAP,
Sun E10k
CCCIS, Informix Database Administrator, Chicago, IL July 1999 to December 2000
Responsible for setting the standards for developers and configuration of the development,
test and production environments.
Supported the ETL process from Oracle and loaded into the Redbrick warehouse.
Set up partitioning in Redbrick datawarehouse.
Implemented version control in the Unix environment using RCS.
Technology: Perl, HP (V Class), Redbrick 3.4, SQL
Tenneco, Operations Database Administrator, Lake Forest, IL May 1997 to July 1999
Part of a design team, responsible for designing an operational data store.
Designed and implemented error checking for the daily feeds coming from SAP. Maintained
daily feeds and all the tasks associated with it.
Capacity planning to accommodate the growing amount of data.
Setup database instances, applied patches and version upgrades.
Responsible for SQL and performance tuning.
Wrote shell scripts such as to dynamically generate sol and analyze tables, to check if all the
interfaces ran properly and report, status, etc.
Responsible for solving problems that users and developers encounter during day to day.
Provide mentoring to junior developers, training others and facilitating.
Technology: Korn Shell, HP (Vclass and K class boxes), Oracle 8.0.4, PL/SQL, SQL*Plus,
Windows NT, Cognos, Autosys
UOP, Applications Database Administrator, Des Plaines, IL September 1996 to May 1998
Designed and physically implemented two major reporting databases.
Monitored the performance of databases and maintained metrics for future use.
Setup database loads, synched up databases.
Developed stored procedures, packages and functions in PL/SQL.
Developed GUI's using power builder version 4&5.
Part of a team responsible for data mapping and data conversion for SAP.
Technology: Korn Shell, HPUX11, Oracle 7.3.4, Powerbuilder 4/5, PL/SQL, SQL*Plus,
Windows NT, Cognos, Powerplay
EDUCATION
Master of Computer Science, 1992
Illinois Institute of Technology, IIT, Chicago, Illinois
Bachelor of Business Administration 1987
Certification
•Oracle Exadata Database Machine & Cloud Service 2017 Certified Implementation Specialist
•Oracle Database 12c Administrator Certified Professional
•Oracle Exadata 11g Certified Implementation Specialist
•Oracle Database 10g Administrator Certified Professional
•Oracle Database 10g Administrator Certified Associate
•Oracle Database 12c Essentials
•Upgrade to Oracle Database 12c
•Oracle Exadata 11g Essentials
•Oracle Database 10g Hands-On Course Requirement
•Oracle Database 10g: Administration II
•Oracle Database 10g OCA Exception to SQL Requirement
•Introduction to Oracle: SQL and PL/SQL
TRAINING
Oracle 8i, 9i, 10g, 11g trainings attended at Oracle Corporation
Veritas Netbackup, and Sys Admin training by Sun
Java Programming Language Sun Microsystems 2000
SAP ABAP, SAP Script, Basis training conducted by SAP 1997
TECHNICAL SKILLS
Operating Sys: UNIX Solaris 8 & 10, HPUX11, Win NT/2000, Linux (4 &5), and VMS.
Hardware: Sun (E4800, 1280, 10K), HP9000, Windows NT/2000, IBM370, DEC
Languages: SQL, PL/SQL, Korn shell, Perl
RDBMS: Oracle version 11g(11.1.0.7, 11.2.0.2), 9i, 8i, 8.0.4, 7.3, 7.2 (UNIX &
NT), REDBRICK (UNIX), SQL Server (2000), SYBASE, FOXPRO
(DOS), INGRESS, (VMS), UNIFY, Ultrix
Development Tools: DBArtisan, DESKTOP DBA, ENTERPRISE MANAGER, SQL DBA,
SERVER MANAGER, EZSQL, Business Objects, COGNOS, TOAD
Applications: Oracle Apps(11.5.10), Autosys, BMC Patrol, PVCS, Object cycle,
SQLLAB, Veritas Netbackup, Websphere, Golden Gate Replication
Functional Areas: Communication, Health care, Retail, Hotel, Supply Chain Management,
Manufacturing
REFERENCES Available on request
Contact this candidate