Oracle Data
Resume:
Manouchehr Ghayedikarimi
Cell: 416-***-****
**********@*****.***
Oracle Database (Administration /Data Warehousing/ Support)
Highlights:
Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and OLAP.
Experience as a University Instructor teaching advanced computer programming
Experience in Oracle DBA, MS SQL Server, C, Visual Basic, Java, FoxPro, Oracle Database design and programming and Oracle and SQL Server Data Warehousing
Excellent problem solving, communication skills, team work spirit, quick learner, self-motivated and
results-oriented
Extensive experience in application development, support and maintenance
Education and Training
B. Sc. Degree in Computer Science from Sharif University of Technology
Oracle Certified Associate (OCA) for Oracle 10g
Oracle Certified Professional (OCP) for Oracle 10g
PL/SQL, Java, ASP, HTML, XML, MS SQL Server
Technical Skills
Languages: PL/SQL, T-SQL, C, C#, Java, ASP, ASP.net, VB, VB.Net, Pascal, Foxpro,
Databases Management: Oracle10g/11g/12c, SQL Server Integration Services (ETL)
Performed installation and configuration of Oracle database and data migration
Experience building, supporting and troubleshooting Oracle RAC and Exadata
Created user accounts, schemas, database objects
Wrote triggers, procedures, views and PL/SQL programming
Analyzed database performance and implemented solutions for performance tuning
Implemented database backup/recovery solutions and supported using RMAN.
Developed and implemented database security features (roles, privileges, authentication, and encryption)
Created physical databases/schemas from logical design
Troubleshoot and diagnostic activities.
Managed database physical storage and structures, control system resources
Experience with the full project lifecycle from conception to implementation and support
Deep understanding of RDBMS structures and how they interact: tables, indices, triggers, procedures, etc.
Application: Financial, HR System, Banking, Logistics
Professional Experiences
Oracle Database Administrator (DBA)
Rogers, Toronto, Canada [Feb 2018 – Apr 2018]
Provide Oracle DBA support for multiple large databases in production, development and test environments. Databases were Oracle 9i/10g/11and 12C. Following are some of the typical tasks carried out as part of database administration.
Provided 24x7 on call production support
Responsibilities included: upgrades, monitoring, troubleshooting Oracle DB (Backup/Recovery, Flashback, moving data using Data Pump and application performance tuning, managing schema objects, managing storage, automating tasks and replication)
Operated as an Oracle DBA supporting the in a technical support team for many separate Oracle environments and applications.
Moved database Schema changes to stage or production
Professional Experiences
Oracle Database Administrator (DBA)
CIBC, Toronto, Canada [Mar 2009 – Mar 2017]
Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP, Data warehouse and Exadata. Databases were Oracle 9i/10g/11and 12C. Following are some of the typical tasks carried out as part of database administration.
Responsibilities included: upgrades, monitoring, troubleshooting Oracle DB (Backup/Recovery, Flashback, moving data using Data Pump and SQL*Loader, and application performance tuning, managing schema objects, managing storage, automating tasks and replication)
Operated as an Oracle DBA supporting the in a technical support team for many separate Oracle environments and applications.
Designed and maintained Oracle databases, stored procedures, triggers, queries, PL/SQL programming, relational views and database diagrams
Install and working with Oracle Real Application Cluster (RAC), ASM and Oracle Data Guard.
Proactive to find problem in the Oracle environment and solve them
Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software Legato troubleshoot and backup testing.
Moved database Schema changes to stage or production
Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
Developed some Unix Shell scripts to automate database operation and database monitoring
Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
Trained a new DBA in our environment
Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
Provided 24x7 on call production support
Took care of the database design and implementation
Work with team of UNIX, Internet and Network
Developed UNIX shell and SQL scripts for database backups.
Refreshing development/test database from production using Export/Import. This was done so that the latest data is available in the development/test database.
Analyze Oracle AWR/ADDM/ASH reports (proactive troubleshooting) on a daily basis and review SQL execution plans on critical application queries and build SQL profiles if needed.
Working on migrating databases from one platform to another with Target being Oracle.
Experience with installation and configuration Oracle Goldengate.
Experience in replication using Goldengate.
Support and maintenance SQL Server databases.
Support and maintenance DB2 databases.
Oracle Database Administrator (DBA)
Leasex Inc, Toronto, Canada [June 2007 – July 2008]
Provide Oracle DBA support for multiple large databases in production, development and test environments for various types of databases - OLTP and Data warehouse. Databases were Oracle 9i/10g and running on UNIX and NT. Following are some of the typical tasks carried out as part of database administration.
Worked with Oracle 10g (Backup/Recovery, Flashback, moving data using Data Pump and SQL*Loader, performance tuning, managing schema objects, managing storage, automating tasks and replication)
Designed and maintained Oracle databases, stored procedures, triggers, queries, PL/SQL programming, relational views and database diagrams
Install and working with Oracle Real Application Cluster (RAC) and, ASM and Oracle Data Guard.
Proactive to find problem in the Oracle environment and solve them
Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software Legato troubleshoot and backup testing.
Moved database Schema changes to stage or production
Developed some Unix Shell scripts to automate database operation and database monitoring
Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
Trained a new DBA in our environment
Responsible for Oracle9i/10g logical and physical databases design, implementation and maintenance on UNIX and NT.
Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
Provided 24x7 on call production support
Took care of the database design and implementation
Work with team of UNIX, Internet and Network
Developed UNIX shell and SQL scripts for database backups.
Performed database tuning. Migration of databases.
Refreshing development/test database from production using Export/Import. This was done so that the latest data is available in the development/test database.
Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
DBA / Developer
Manco Technologies Inc, Toronto, Canada [Sep 2002 – June 2006]
Leader in localization and globalization of design, development and maintenance of special applications/tools
Designed and maintained Oracle databases, stored procedures, triggers, queries, PL/SQL programming, relational views and database diagrams
Worked with Data Transformation Services, SQL Agent job scheduling, backup/restoring data, index tuning and other database performance issues
Worked with Backup/Recovery, Flashback, moving data using Data Pump and SQL*Loader, performance tuning, managing schema objects, managing storage, automating tasks and replication
Proactive to find problem in the Oracle environment and solve them.
Designed, developed and maintained Service Management System for automating all tasks that were needed as a localization project manager and production manager which included preparing localizable media, assigning and controlling the tasks of different members of the team. Also used Visual Basic and SQL Server
Designed, developed and maintained Localization Media Processing System (MPS). This was an application for parsing, processing and publishing, which is used by service providers such as translators as a tool to simplify their work in different stages of media such as web pages/emails/text documents/web applications, MS Word and MS Excel. Used technologies like VB and SQL Server
Designed, developed and maintained special applications/tools written by ASP, ASP.net pages
Researched solutions for extracting the items such as text and graphics from different types of media including HTML pages, Text/ MS Word documents, Excel, XML, Lotus Notes, databases, email text and then preparing them to be localized
Took care of the database design (data modeling) and implementation
Working with SQL DTS and SSIS packages
System analyst / DBA / Developer
Education Research and Renovation Industries Inc. [Sep 1991 - Apr 2002]
Company Affiliated to the Ministry of Education and Training, which developed a Management Information System for establish management method on the basis of data through automation of executive operations.
Analyzed, designed and implemented a variety of systems including planning and control of education process, human resources allocation, payroll, retirement and data warehousing
Designed and maintained databases, stored procedures, triggers, queries, database programming, relational views and database diagrams
Prepared technical and user documentation to explain applications of the system
Made presentations of applications to personnel in charge of operations of the system
Taught proper use and operation of the system to distributors and end users
Assisted customer in solving problems and provided support
Took in consideration feedback and recommendations of customers for enhancement of the system (completed and reviewed required system specification)
DBA /Developer
Behvar Design and Engineering Company [May 2000 – Mar 2002]
Analyzed, designed, implemented Retirement Information System
Performed tuning, database backup, restore and recovery
Implemented database security
Managed database installations, storage, data and concurrency
Created and maintained schemas, profiles, tables and users
Designed and maintained databases, stored procedures and triggers.
Data Transformation Services, job scheduling, index tuning and other database performance issues
Prepared technical documentation to explain use and applications of the system
Took in consideration feedback and recommendations of customers for enhancement of the system
I was the main contributor to the analysis, design and development of the information system with around 1,000,000 employee records. The system included establishment, recovery and payment of pension and loan for employees and their survivors. The database has been replicated over 29 updating servers all around the country. The business rules were defined in a dynamic and parametric manner. All data modifications were fully logged as well as data creations, indicating modified field, modifier user, time of modification with old and new values
System Analyst Programmer
Yazd Foulad Manufacturing Company [May 1994 – Aug 1995]
Analyzed, designed, implemented Accounting System
Analyzed, designed, implemented Inventory Control System
Instructor
Shamsipour Technical University [Sep 1992 – May 1994]
Taught advanced computer programming at Bachelor Level
Database Programming
Yazd Foulad Manufacturing Company [Apr 1990 – Aug 1992]
Programmed, implemented and tested payroll system
Contact this candidate