REZA TADAYON

*** ****** **** **. , *********,

Ontario N2P 2X5

519-***-****

x8315a@r.postjobfree.com

JOB OBJECTIVE: Oracle Database administrator / Developer

OVERVIEW

• Over 10+ years experience as Database programmer and Administrator focus on oracle

• Senior Oracle DBA with extensive Oracle database experience covering all DBA functions performance tuning, configuration, installation, upgrades and migrations from different database to oracle

• Expertise in using oracle utilities such as RMAN, expdp, impdp and sqlldr

• Expertise in software installation, configuration of DNS, DHCP ,networking utilities, TCP/IP

• Experience in setting up and configuring Apache and Tomcat Servers.

• Proven ability to maintain databases in 24x7 production environments

• Experience in database-centric web development

• Team player with good management, analytical, communication and interpersonal skills

COMPUTER SKILLS

Operating Systems: Windows 3.1, Windows 9x, NT4, 2000, 2003, XP, DOS, Linux,HP Unix

RDBMS (Databases): ORACLE 8, 8i, 9i, 10g,11g,MYSQL, SQLSERVER

RDBMS Tools: Recovery Manager (RMAN), SQL Navigator,TOAD,Report Builder,SQL Loader

Application Servers: Oracle application server 9i, 10g

Programming Languages: Java ,VB.NET,HTML, JSCRIPT, SQL, PL/SQL, Web development with PL/SQL server page (PSP),PORTAL Development ,XML

Ms Office: FrontPage, PowerPoint, Excel, Word

Tools: Oracle Apex, Oracle Designer, Oracle Discoverer,Sybase Power Designer,Crystal report

CERTIFICATIONS

Oracle 10g Database Administration II (OCP) 2009

Registration No: R9EDTT5246 Score: %78

Oracle 10g Database Administration I (OCA) 2008

Registration No: QD5DTT51DE Score: %84

Toronto College and Technology (Oracle 11g DBA course) 2011

Victoria College in Toronto (Oracle Advanced features (RAC , Data guard)) 2010

Database Design and SQL Programming (Conestoga College, Waterloo, Ontario) 2007

Microsoft VB .NET Programming basic to advanced (2 Certificate) 2008 Conestoga College, Waterloo, Ontario

Java Programming basic to advanced (4 Certificate) 2008

B.S. in Computer Engineering Software (Azad University of Iran) 1996

WORK EXPERIENCE

Database Administrator 29/06/2011-29/09/2011 (Contract)

Revera Inc, Cambridge ,Ontario ,Canada

• Responsible for two databases Oracle , SQLSERVER

• Monitoring databases in terms of data dictionary views and enterprise management tools

• Optimizing SQL queries regard to customer request

• Providing Backup /Recovery strategy in terms of cold and hot backup

• Providing SQLSERVER tasks for customers(High availability replication, log shipping )

• Configuration and installation Oracle 11g,10g disaster recovery on HP platform

• Monitoring Oracle performance by Quest Spotlight software

Database Administrator 30/08/2009 –29/06/2011

Descartes System Group, Waterloo,Ontario,Canada

• Responsible for three databases Oracle ,Mysql,Mssql

• Monitoring databases in terms of data dictionary views and enterprise management tools

• Optimizing SQL queries regard to customer request

• Providing Backup /Recovery strategy in terms of cold and hot backup

• One week per month on call

• Providing SQLSERVER tasks for customers

• Configuration and installation Oracle 11g clustering and RAC for evaluation on Linux

• Configuration and installation Oracle 10g DataGuard for evaluation on Windows platform

• Stress test Oracle application by DTM stress tools

Oracle Database Administrator (9i , 10g) 01/01 2006 – 23/07/2007

Tamin Co., Tehran, Iran (Insurance Company) www2.taminn.org

• Configuring Linux /windows server for oracle installation

• Performing Testing and verifications of systems, network connectivity and functionality prior to being released into production.

• Configuring and troubleshooting Apache

• Responsible for 24x7 support of 9i & 10g databases for mission critical online applications

• Migrate from different database (Foxpro,SQLserver)to Oracle10g and Managed data with more than 1,200,000,000 records and Tuned them

• Useing ADDR , SQL Access advisor, explain plan tools for tuning SQL Statements

• Utilized RMAN for backup and recovery strategy

• Established database backup/recovery strategy for databases

• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.

• Developed metadata method for dynamic applications

• Designed two layer application with minimum dependency by Collection Objects

• Distributed data in some physical storage for maximum performance by Partitioning tables

• Managed and troubleshoot some DBAs

• Developed some insurance systems with Oracle Apex tools

• Monitoring databases with oracle enterprise manager

Oracle10g Application Server Administrator 2005 - 2006

Computec Co., Tehran, Iran (Private Company)

• Developed portal site compatible to ECMS standard.

• Developed BILLING application using Oracle portal form developing tools and HTMLDB 2.2

• Created and managed Oracle application server, Firewall , Proxy server , Active directory, Web Cache

• Created content with PL/SQL server page(PSP)

Oracle 9i Administrator and Programmer 2004 - 2005

Avin System Co., Tehran, Iran (Private Company)

• Used PL/SQL and SQL languages in programming and creating of a M1 generator

• Managed the analysis and design of Relational and M1 (metadata model)

• Tuned database views and table design to better performance

Project Leader and Oracle 9i DBA 2002 - 2004

Baharan Co., Tehran, Iran (Private Company)

• Analyzed, designed and developed three of twelve sub-systems databases for a government organization that included: urban housing and development career development and placement; and, lodging accommodation

• Accountable for database administration and database tuning

• Designed and developed a community inspection system for head office

Contact this candidate