Oracle Engineer
Resume:
***/***-**** (cell)
Email: ***.*****@*****.***
Chicago, IL 60606
R. Effee Temiz
SYNOPSIS Expert DBA with over twelve years of analysis, design,
architecture, implementation, and support of Enterprise
Database Solutions is seeking Enterprise Database
Administrator/Engineer/Architect opportunity.
EXPERIENCE [06/08-Present] Exelon Corporation
Chicago, IL
Lead DBA
Responsible with design, architecture, implementation,
and administration of over 1000 ORACLE, MS SQL Server,
and Sybase databases, the ERP Suite, and associated
DW/BI infrastructure in a multi-tier, highly available,
24/7, mission critical environment including ORACLE
eBusiness Suite, ORACLE Database Server, ORACLE
Application Server, MS SQL Server, Sybase, DB2,
PeopleSoft, Informatica, and Hyperion at this Fortune
500 company that is SOX IT compliant. Key
contributions:
Lead all aspects of ORACLE, MS SQL Server, MySQL, and
Sybase Database Administration including design,
installation, patching, cloning, upgrades, diagnostics,
backup/recovery, sizing, space management, load
balancing, Data Guard, Standby, performance & tuning on
SOLARIS, AIX, HP-UX, LINUX, WINDOWS
Design, implementation, and administration of highly
available enterprise ORACLE RAC database systems to
support energy generation, and delivery
Lead performance & tuning of the ORACLE RAC databases
on AIX with HACMP clusterware and GPFS with EMC SAN,
and RAC databases on HP-UX; root cause analysis,
resolving enterprise performance issues
Proficient in Veritas Cluster Services(VCS);
installation, configuration, and support of Highly
Available Active/Active and Active/Passive server
clusters for tier-1 ORACLE enterprise databases
Design, implementation, and administration of ORACLE
APPLICATIONS eBusiness Suite 11i/R12 with financials
Implementation and support of BI infrastructure and
Performance & Tuning of Hyperion reports
Supervise and drive Proof of Concept Study and later
implementation of virtualization using VMWare and
enterprise cloud computing in RDBMS, ERP, and BI realms
Lead the solution infrastructure design, architecture,
and implementation in accordance to Architecture, PMO,
and Governance policies; SDLC; support enterprise data
architecture
Manage projects; track record of on-time and on-budget
solution delivery
Collected system performance statistics and performed
trending analysis to satisfy the workload performance
and future work capacity, forecasted the new solutions
capacity to incorporate resource requirement and
capacity growth
Group Lead: Capacity & Demand Planning and Performance
Management: Provided a performance analysis framework
to optimize customer applications thus providing cost
benefits to the Business Team, presented a Business
Case, Project Charter, Proof of Concept and high level
implementation plan
Instill ITIL Change Management (CM) principles into
RDBMS, and BI realms
Lead a group of DBAs up to 5 at a time; planning,
training, budgeting; help with performance evaluation,
interviewing, forecasting
Establish and maintain good relationships with all
internal and external business and IT partners
[06/07-06/08] USG Corporation
Chicago, IL
Sr. Consultant, BI Architect
Responsible with the architecture, implementation, and
administration of ORACLE Technology Stack in a
multi-tier, highly available, 24/7, mission critical
environment including ORACLE e-Business Suite, ORACLE
Database Server, ORACLE Application Server, ORACLE
Concurrent Processing Server, ORACLE Reports Server,
ORACLE Forms Server, ORACLE Admin Server, ORACLE
Express Server, ORACLE Mobile Supply Chain Applications
Server, ORACLE Discoverer Server, ORACLE Data Warehouse
and Business Intelligence at this Fortune 500 company
that is SOX IT compliant. Key contributions:
Co-architected and implemented two full cycle DW/BI
projects. Responsibilities also included configuration
and support of the database, the application server,
OBIEE, Hyperion, OWB, Workflow components, migration of
OBIEE repository and the catalog, LDAP integration,
security, data modeling, design, administration of the
dashboard and answers, migration of the Data Warehouse,
writing automation scripts for ETL and mapping.
Performance & tuning of the ORACLE Applications and the
ORACLE databases, optimize concurrent managers and the
job queue, tune MSCA, tune RAC database instances, wait
events, tune SQL, trace and troubleshoot slow forms;
functioned as the principal DBA and SME to lead all
enterprise performance enhancement and capacity
planning efforts
ORACLE RAC performance & tuning; discovered and
resolved block loss in RAC inter-node communication
All aspects of ORACLE, Sybase, and SQL Server Database
Administration including design, installation,
patching, cloning, upgrades, diagnostics,
backup/recovery, sizing, space management, load
balancing, Data Guard, Standby, performance & tuning
All aspects of ORACLE APPS 11i administration,
including modules SCM, FIN, and HR, design,
installation, patching, cloning, diagnostics,
backup/recovery, load balancing, purging
Disaster Recovery using BCV, complete recovery of
ORACLE Technology Stack within SLA window of 8 hours
ORACLE Express Server and ORACLE Demand Planning
design, implementation, and administration. Have
consolidated Express Server running multiple engines
against one master,
Assisted with HP-UX 11.23 and VCS 4.1 upgrade,
conversant in Veritas Cluster Manager, and addressed
issues that were raised with Express 6.3.4 and HP-UX
11.23 compatibility
Manage a team of consultants, provide help with
interviewing, planning, managing off shore outsourced
resources including budgeting
[03/07-07/07] Elsevier
St. Louis, MO
ORACLE Solutions Architect (Consulting)
Responsible for gathering business and application
technology requirements to define the ideal solution
architecture. Responsibilities also included data
modeling, database design, capacity planning, database
installation, database administration, performance
tuning, RAC. The project was implemented on LINUX
platform with 10gR2 ORACLE and RAC; the Sybase
PowerDesigner was used as the design tool and the
Rational ClearCase for revision control using
AGILE/SCRUM process. Responsibilities also included 9i
to 10gR2 upgrade, upgrading 10g instances to ASM, and
tuning RAC.
[12/06-02/07] Teoma Systems
Flint, MI
ORACLE Systems Engineer(Consulting)
Responsible for the technical architecture of highly
available ORACLE environment. Responsibilities included
system design of Oracle Collaboration Suite clusters in
10gR2, design of ORACLE Real Application Clusters in
10gR2, capacity planning, data modeling and database
design in 10gR2, and integration of ORACLE instances
with 10g Grid Control. Responsibilities also included
enhancing existing ETL implementation and supporting
BI.
[06/06-12/06] Amdocs
Champaign, IL
Sr. ORACLE DBA (Consulting)
Responsible for design, implementation, and
administration of highly available, mission critical,
multi-terabyte ORACLE database system in a 24/7
environment where billing of 45 million cell phone
subscribers is processed. Designed and implemented high
availability through replication and RAC. Key
Contributions:
Managed 7TB of live data on HP-UX and LINUX to support
wireless customer billing; design, install, backup,
recovery, tuning, monitoring, troubleshooting,
configuration, cloning, refresh, and upgrade
ORACLE 9i RAC on LINUX: Solely designed and implemented
a complete two node ORACLE 9i Real Application
Clusters, install and configure ORACLE Cluster File
System, OCFS2, ORACLE Cluster Manager, ORACM, RAC,
design and create RAC databases, cluster tuning
Synchronous data replication with SharePlex
Asynchronous data replication with Business Continuance
Volumes (BCV)
TimesTen In-Memory Database administration
Backup and recovery with RMAN and with scripts
Create and manage db objects, develop shell scripts
Support of existing Data Warehouse and BI
Familiar with Fastcopy, Informatica, TOAD
[05/05-06/06] Archway Marketing
Services Romulus, MI
Sr. ORACLE DBA (Consulting)
Responsible for design, implementation, and
administration of three-tiered architecture with ORACLE
Database Systems, ORACLE Application Servers, and end
user applications including J2EE, ORACLE Forms/Reports
in a 24/7 environment. Responsibilities also included
design, engineering, and support of Linux Systems and
disaster recovery. Key Contributions:
All aspects of ORACLE Database Administration on HP-UX
and LINUX in DEV/TST/QA/PRD environments; design,
installation, backup, recovery, tuning, monitoring,
troubleshooting, configuration, cloning, refresh, and
upgrade
Use Oracle Enterprise Manager to monitor DB health,
optimize performance, monitor and recycle logs
Tuning with Statspack
Create DB objects: functions, views, synonyms, tables,
indexes
Disaster recovery on a remote site; complete recovery
of six db instances totaling 0.5TB of data from hot and
cold backups
Proficient ORACLE Application Server 10gAS
Administrator; install, backup, recovery, tuning,
monitoring, troubleshooting, and upgrade on LINUX and
HP-UX
Configure OPMN, HTTP, WEBCACHE, PORTAL, DCM, OID,
REPORTS, DISCOVERER, OC4J, SSO
Administer PORTAL, including OIP, and DISCOVERER
Administer J2EE applications; deployment with ORACLE
Application Server 10g, develop and debug Java code
Administer ORACLE Reports 9i, 10g
Engineer LINUX Server Systems to house middle tier and
integration into multi-tiered environment, administer
Linux Servers that host ORACLE Application Servers;
manage users, devices, volumes, file systems, kernel
configuration, patching, upgrade, performance, develop
shell scripts
Working knowledge of VERITAS, SAN, and Tivoli
[01/04-05/05] Hewlett-Packard Company
Dearborn, MI
UNIX Systems Administrator, ORACLE DBA (Consulting)
Assisted with administration of more than 400 UNIX
servers and 100 ORACLE databases in a highly available,
mission critical, and SLA-driven environment that
consists of several geographically disparate data
centers worldwide. Key Contributions:
Provide ORACLE DBA support (8i, 9i, 10g); monitoring,
troubleshooting, backup, configuration, install, tuning
Use RMAN for backup and recovery utilizing flashback
and ASM
24/7 System Administration of SOLARIS/HP/LINUX servers
Support SMTP, IMAP, POP3, HTTP, LDAP, BRIGHTMAIL,
AGGREPOP services on midtier hosts, including failover,
monitoring, tuning
Support mail and service proxies, including failover,
throttling, tuning
Support MC hosts with backend storage with EMC and
Veritas, including failover, monitoring, tuning
Develop shell scripts for system automation
Competence in HP OpenView Service Desk, incident
management
Spam filter development and deployment
[02/02-02/04] University of Michigan Ann Arbor, MI
ORACLE DBA
Responsible for design, implementation and
administration of three-tiered architecture with ORACLE
Database Systems, ORACLE Application Servers, and end
user applications including J2EE, ORACLE Forms/Reports.
Solely upgraded all client-server applications to and
deployed with ORACLE 9i Application Server. Key
Contributions:
Proficient ORACLE 9i Application Server (9iAS)
Administrator, install, backup, recovery, tuning,
monitoring, troubleshooting, and upgrade on SOLARIS
Configure OPMN, HTTP, WEBCACHE, PORTAL, DCM, OID,
FORMS, REPORTS, DISCOVERER, OC4J, SSO
Use Oracle Enterprise Manager to monitor server,
optimize performance, monitor and recycle logs, secure
the server and the applications deployed
Determine business needs to do architecture and
capacity planning for ORACLE DB Servers and ORACLE
Application Servers
Develop user applications with ORACLE Forms, Reports,
and develop shell scripts for system automation on
SOLARIS
Administer DB servers (8i, 9i) on SOLARIS, design,
install, backup, recovery, tuning, monitoring,
troubleshooting, configuration, and upgrade
Create DB objects, including PL/SQL stored procedures,
triggers, packages, functions, views, synonyms, tables,
indexes
Experience with opening, managing, and resolving ORACLE
TARs.
[03/98-04/04] University of Michigan
Ann Arbor, MI
Programmer (Consulting)
Assisted with several PL/SQL development projects. Key
Contributions:
Have designed the scanner interface to read forms and
convert them into data streams
Developed user applications with ORACLE Forms, and
ORACLE Reports
Installed, configured, and administered ORACLE 9iAS on
Windows platform and web-enabled existing client-server
forms and reports
Developed PL/SQL stored procedures, functions, and
triggers for data retrieval and validation
Installed and configured Microsoft Project and
Microsoft Project Central
[10/01-07/02] University of Michigan
Ann Arbor, MI
Database Manager (Consulting)
Responsible for modeling, design, implementation of
MySQL Databases and database-backed dynamic web
interface.
Manage a team of 3 developers, web designers, and
content developers including interviewing, budgeting,
training, planning, forecasting
MySQL database design, implementation, and
administration
Data/web user interface development with PHP,
JavaScript, and (D)HTML
Design of information architecture and of the usability
tests of the web interface
[05/01-09/02] University of Michigan Ann
Arbor, MI
Network Security Specialist
Responsible for assessing network security
vulnerabilities and implementing solutions.
Carried out security assessment of the hybrid LAN of
over 100 hosts with ORACLE RDBMS and Apache web servers
Experienced in firewalls, intrusion detection systems,
virtual private networks, and myriad of intrusion
detection and analysis tools, including ISS, Nessus
Carried out comprehensive intrusion tests designed for
both from within and outside the network
Familiarity with network topologies, and network
components
[02/98-05/02] Necessity and Chance, LLC
Ann Arbor, MI
Software Engineer
Assisted with streamlining data processing activities
for this Wall Street brokerage firm. Responsibilities
included modeling, design, implementation, and support
of several financial relational databases, creating
code to implement business logic for stocks, bonds, and
options.
Lead a group of 5 consultants including training,
performance evaluation, interviewing, planning
Have designed and developed a database-driven corporate
intranet web site using ColdFusion and MS ACCESS
Designed and implemented financial databases with MS
ACCESS, and MySQL
Created application software for office automation
using Visual BASIC, MS ACCESS, MySQL, and EXCEL
Carried out backup, restore, upgrade, install,
configuration, and migration procedures on WINDOWS
platform
Provided user support on database, web, and MS Office
software applications
[01/98-Present] Independent Contractor
Chicago, IL
IT Professional
Have worked on several Visual BASIC, Java, SQL,
JavaScript, ColdFusion, Perl, HTML, database design and
implementation projects, some of which are:
Socket programming with WinSock to implement Windows
User Interface in a Industrial Control Module for a Big
3 subsidiary
Windows User Interface using serial port for the
WORLSCAN industrial paint thickness analyzer
Applet and Servlet programming, including AWT and JDBC
Developed application software to implement a customer
reservation system
Designed and implemented dynamic, database-driven web
sites
Have carried out system level administration, analysis,
troubleshooting, and security analysis
Analysis, design, implementation, and deployment of
enterprise database systems
[1992-1994] Teletas, Inc.
Istanbul, Turkey
Electrical Engineer
Assisted with computer systems design and
implementation projects. Key Contributions:
Designed and implemented an 8-bit microprocessor: CPU,
Control Unit, and the Memory
Worked on Layout and Schematic design of Integrated
Circuits with MentorTools
Have developed Printed Circuit Board simulation
software in C in an attempt to reduce the Switching
Noise
Created testing and verification algorithms for digital
systems design
Carried out circuit simulation using C and Hspice, and
implemented verification algorithms in C
[1989-1991] Aselsan Ankara, Turkey
Research Staff Member
Have done research in Electromagnetics, Partial
Differential Equations, Advanced Mathematics, and
applications in Microwave Engineering.
Involved in a research project in Antennae Design and
Microwave Engineering
Participated in the design of Superbeam Antennae,
waveguides, and microwave amplifier circuits
CERTIFICATIO [23 Feb 2004] ITIL
N Dearborn, MI
Foundation Certificate in IT Service Management
by EXIN, Examination Institute for Information Science
in ITIL, Information Technology Information Library
EDUCATION [1994-1997] The University of Michigan
Ann Arbor, MI
MS/Ph.D Student, Electrical Engineering and Computer
Science. Graduate level course work and research
toward Ph.D. Courses in Computer systems design,
software engineering, database theory and design,
advanced mathematics, and physics.
[1992] METU
Ankara, Turkey
Bachelor of Science, Electrical Engineering.
SKILLS OS: UNIX, LINUX, WINDOWS, DOS, VMWare
Programming Languages: Java, Visual BASIC, C/C++, Perl,
SQL, PL/SQL, KSH/shell scripting, PHP, PowerShell
Development Tools: Visual BASIC, ColdFusion, JDK,
ORACLE Developer Suite, OWB, OBIEE, SQL Developer, SAP
Query Builder
DBMS/RDBMS: ORACLE, MS ACCESS, MySQL, Sybase, MS SQL
Server, TimesTen
ERP: ORACLE APPS 11i/R12, SAP R/3 ECC6
DW/BI: OBIEE, OWB, Hyperion, Informatica, SAP BW/BI
Web Development/Publishing: DHTML, JavaScript, CSS,
VBScript, PerlScript, HomeSite, ColdFusion Studio,
Macromedia Dreamweaver & Flash, Adobe Fireworks, Adobe
Photoshop & Acrobat, Siebel BI Publisher, Siebel
Analytics, SAP BI Portal, SharePoint
SERVERS: Apache HTTP Server, Microsoft IIS,
Jakarta-Tomcat, JRun, PWS, MOSS, ColdFusion Server,
Microsoft Project Central, Oracle Application Server,
Oracle APPS Server, Citrix, Hyperion Essbase, ORACLE BI
Server, SAP NetWeaver
PC S/W: Word, EXCEL, Microsoft Project, MS Power Point,
Visio, SSH/SCP clients,
Documentation/Source Control: SharePoint, Visual
SourceSafe(VSS), Quality Center, PVCS, RCS, Rational
ClearCase
AWARDS/ High Honor Listed METU
HONORS Ankara, Turkey, 1990, 1992
Six-year-long full coverage Government Scholarship to
pursue MS/Ph.D in the US, 1993
Graduated in 3rd place METU
Ankara, Turkey, 1992
REFERENCES
Donald Hostetler: Navistar, 4201 Winfield Road,
Warrenville, IL 60555. Ph: 773-***-**** (cell).
Email: ************@*****.***
Rajit Kohli: Elsevier, 11830 Westline Industrial Dr, St
Louis, MO 63146. Ph: 314-***-**** (desk), (636)
346-5311(cell). Email: *.*****@********.***,
******@*********.***
Tony Marion: AMDOCS, 2109 Fox Dr., Champaign, IL 61820.
Ph: 217-***-****. Email: ****.******@******.***
Diane Garza: Archway Marketing Services, 7525 Cogswell
Rd, Romulus, MI 48174-1308. Ph: 313-***-****. Email:
***********@*******.***
Jay Lanka: Archway Marketing Services, 7525 Cogswell
Rd, Romulus, MI 48174-1308. Ph: 734-***-**** (desk),
248-***-**** (cell). Email:
**************@*******.***, ******@*****.***
Gregory J. Paczas: IBM. Email: *******@***.***.
Woody Kellum: CAEN, University of Michigan, 2281
Bonisteel Blvd. Ann Arbor, MI 48109-2094. Ph: (734)
763-3247. Email: ***@*****.*****.***.
Larry Marek: Health Management Research Center,
University of Michigan, 1027 East Huron, Ann Arbor, MI
48104. Ph: 734-***-****. Email: ******@*****.***.
Dr. Reza Kamaly: Necessity and Chance, LLC, 3735 Tubbs
Rd., Ann Arbor, MI 48103. Ph: 734-***-****, (734)
996-5941. Email: *****@*******.***.
Khaled Mansour: Washtenaw Community College, Room: TI
118R, Ann Arbor, MI 48106. Ph: 734-***-****. Email:
********@******.***.
Jerry Schatzle: Health Management Research Center,
University of Michigan, 1027 East Huron, Ann Arbor, MI
48104. Ph: 734-***-****. Email: ********@*****.***.
TRAINING Oracle Performance Tuning by Hotsos Inc.
Oracle 10gR2 RAC Training by Oracle Corporation
ORACLE Business Intelligence Enterprise Edition Plus
(OBIEE) workshop by ORACLE Corporation
7 Habits of Highly Successful People by Exelon Corp.
Behavioral Interviewing Techniques by USG Corp.
ORACLE 10g DBA Workshop I and II by ORACLE Corporation
HP OpenView Service Desk, highly available systems by
Hewlett-Packard Company
IT Service Management by Examination Institute for
Information Science
AGILE/SCRUM Process Training
Registered to take Project Management training in March
2010
INTERESTS Wind surfing, skydiving, hiking, camping, skiing,
bridge, economics, politics
PERSONAL GC holder, friendly, positive, constructive,
self-motivated, self-confident, punctual, reliable,
easy to get along
Contact this candidate