• Installation Oracle 12C Database software on test server
• Upgrading and verifying test databases
• Upgrading and verifying development databases
• Upgrading and verifying production databases

• Installation Oracle 12C Rac on test server
• Performing Oracle system tests
• Verifiying database types of company on Oracle 12c
• Verifiying administration scripts with Oracle12c
• Verifiying Standby Databases on Oracle 12c
• Verifying  test  databases

• Replicating databases to new storage by using logical standby database.
• Keeping master and standby database synchronized until performing switch-over.
• Performing re-organization on standby database by using data pump export import.
• Developing and implementing special scripts to perform imports faster.
• Preparing concept and technical guide about whole flow

• This project consist of two upgrade phase
• Upgrading databases to 10g and make the customer able to work current version of forms modules.
• Upgrading in-house operating systems from OEL4 to OEL5.
• Upgrading in-house databases from 9i to 10g
• Provide expertise and remote support to customer during to 10g upgrade.
• Upgrading databases to 11g after upgrade and test processes of current forms modules is completed.

• Creating a knowhow about installation and administration of Oracle 10g RAC in company.
• Investigating high availability and performance features of RAC to use with BC application

• Investigating features of different virtual machine solutions.
• Upgrading in-house databases from 9i and 8i to 10g.
• Migrating in-house and internal development databases from Unix to Oracle  Enterprise Linux (OEL).
• Moving internal test databases onto Oracle VM by migrating OEL

• Create Oracle10g Databases in company for development, test, and production
• Create designer repository.
• Provide steps which are necessary to upgrade database.
• Support test and developer teams during to test of application on Oracle 10g

• Create Oracle 9i Databases in company for development, test, and production
• Create designer repository.
• Provide steps which are necessary to setup the database.
• Create and configure test databsae on customer site.
• Support test and developer teams and also customer during to test of application

• Installation and configuration of Solaris 10 Containers for Oracle8i and Oracle9i
• Installation and configuration of HP Integrity Virtual Machines for Oracle8i and Oracle9i
• Installation and configuration of VmWare Virtual Machines for Oracle8i and Oracle9i
• Describing CPU, Memory and Disk configuration.
• Describing Dynamic Resource allocation methods of those technologies to provide easiness to management of Oracle test environments.
• Describing Backup, Recovery and cloning features and possibilities for Oracle databases in mentioned environment.

• Migration of Customer’s database ( HT-Mobile Croatia ) from Oracle8i to Oracle9i
• Migrate the production database to the new server cluster
  • Installation of Oracle9i on cluster nodes ( 2 nodes )
  • Creating and configuration of database
  • Define sizing of all file systems
  • Configuration for automatic failover mode and switch-over mode.
  • Define other requests necessary for a successful migration
  • Provide all necessary application-related and database-related information required for correct cluster package configuration to the hardware vendor
  • Define complete procedure for starting and stopping database in interaction with rating and mediation device in the cluster environment
  • Define the processes, which will be handled as database processes necessary for efficient use of dynamic resource allocation in case of one cluster node failure (in cooperation with hardware vendor)
  • Define the recovery procedure for the database in case when one node fails unsafely and define data sets, which have to be included in backup.
  • Performance monitoring
• Install the disaster recovery database server on secondary location
  • Installation of oracle9i on secondary location
  • Define Oracle initialization parameters for Oracle Data Guard.
  • Define configuration and procedures of Oracle Data Guard for disaster recovery and implement the respective changes to the Billing Components software to support these procedures.
• Install test database on secondary locatio
  • Installation of oracle9i on test server
  • Creating and Configuration od test database
  • Create procedures and documentation to show how to refresh test database.
  • migrate/clone all relevant data from the production database to the test database
• Define all relevant processes for the operation of the Billing Components software on the new hardware platforms
  • Define and document procedures to start, stop, oparate and recover the database.
  • All processes are defined for each
    • For the primary and the secondary  location
    • For the failover and disaster recovery scenarios in the cluster
• Installation and configuration of call details database .
• Internal tasks in house during to project
  • Build up know how and document failover situations
  • Backup and restore testing
  • Support test team during to Basic sanity tests of database
  • Provide entry to documentation team about clustering.
• Perform live migration on customer side
• Providing DBA support to customer on request (ongoing task)

• Migration Customer’s Database (ERONET – Bosnia) from Oracle7 to Oracle9i
• Create Oracle9i Databases in company for development, test,   production and designer repository.
• Create Oracle7 database from customer data
• Oracle9i Installation on Solaris in company to perform tests
• Creating Database and Application Schema in company to perform tests.
• Moving application data from Oracle7 to Oracle9i
• Provide Support to software team during to application migration.
• Perform same steps on Customer Side.
• Monitor and Report performance.
• Providing DBA support to customer on request (ongoing task)

• Oracle9i Installation on Solaris in company to perform tests
• Patching Oracle9i in company to perform tests
• Creating Database and Application Schema in company to perform tests.
• Moving application data from oracle7 to oracle9i
• Provide Support to software team during to application migration.
• Perform same steps on Customer Side (Batelco Telecom Comp. /Bahrain)
• Monitor and Report performance with Statspack and Spotlight.
• Providing DBA support to customer on request

• Oracle8i Installation on Solaris  in company to perform tests
• Patching Oracle8i  in company to perform tests
• Creating Database and Application Schema in company to perform tests.
• Moving application data onto new server
• Provide Support to software team during to application migration.
• Perform same steps on Customer Side ( HT  Telecom . / Zagrep - Croatia)
• Monitor and Report performance with Statspack and Spotlight

• Installing oracle database servers on Sun Solaris and Windows 2000/NT.
• Upgrading Oracle Database Servers.
• Administration and maintenance of Oracle 8 and 8i Databases running on Sun  Solaris  and  Windows  2000/NT and Hp Unix ( MTS  configuration , Dedicated server configuration ,planning and organizing datafiles and tablespaces , checking alert logs , monitoring database usage etc )  .
• Establishing and Implementing Oracle Databases Backup Strategies. ( Export , Import , Cold Backup , Online Backup, Archived Log Configuration , Standby Oracle Server configuration , Closed Database Recovery , Opened Database  Recovery etc.)
• Logical and Physical planning databases.
• Improve performance of database servers.(Utlestat/Utlbstat, tkproff, performance manager, oracle expert, SQL Statement Tuning ) .
• Oracle Network Administration (Local Naming , Host Naming , Oracle Names )
• Develop stored codes on database (procedures, triggers, packages etc.)
• Providing support and expertise to each business units technical and development teams technical support about oracle and oracle tools ( Developer 2000 , Oracle Browser , SQL Statements etc )
• Unix Shell scripting
• User and Role management
• 7/24 on call support.

Projekte

Oracle 8i server  on Sun Solaris  2.6 ( E4000)

• Installing, upgrading, patching and configuring Oracle Server for an 
• OLTP system which is called “material control system”.
• Monitoring and reporting performance and activities on server.
• Configuring and managing Archived Logs and Backups.
• Managing updates and adding on application schema
• Providing consultancy to developers who are responsible of application which on this server

Oracle 8i server on Sun Solaris 2.6

• This server includes a third party application for HR management
• Upgrading and Patching Oracle Server.
• Managing Backups, Monitoring performance.
• Managing updates on application schema on request of software provider

Oracle 8i server on Windows 2000 (Dell 5400)

• Installing, upgrading, patching Oracle Server and configuring for following OLTP systems.
  • Order / Sales System
  • Vehicle Producing System
  • New Part Investment System
  • Current Account System
  • Hotline Support System
  • Purchasing System      
• Installing and managing a standby server which backs up this server.
• Configuring and managing archive log configuration and backups.
• Monitoring and reporting performance and activities on server.
• Managing updates and adding on application schema
• Providing consultancy to developers who are responsible of application which on this server

Oracle 8i server on Windows 2000

• Installing, upgrading, patching and configuring oracle server to provide development and test environment for developer team.
• Providing fresh data from production servers.
• Managing backups.
• Providing consultancy to developers who are responsible of application which on this server

Oracle 8 on Sun Solaris 2.6

• Installing, upgrading, patching and configuring oracle server for an OLTP system which is called Service / Warranty System
• Monitoring and reporting performance and activities on server.
• Configuring and managing Archived Logs and Backups.
• Managing updates and adding on application schema

Oracle 7.3.3 on HP Unix 11.20

• It includes a third party application for Spare Part System.
• Performing daily DBA tasks.
• Managing Backups, Monitoring and reporting performance

Oracle 7.3.2 on HP Unix 11.20

• It includes a Spate Part Datawarehause management system.
• Performing daily DBA tasks.
• Managing Backups , Monitoring  and reporting performance.
• Managing updates on application schema on request of software provider.

Sun  Solaris 2.6  for  FTP and automated scripts

• Installing UNIX server to use for ftp tasks which is performed to data  transfers and communication   between   Ford America Mainframe systems and our oracle systems
• Performing data transfers and communication between our  Mainframe systems ( unisys A6 system )  and our oracle systems via automated scripts.
• Developing about 100 unix shell scripts to perform transfer tasks

Performing maintanence on existing apllications.

Providing support to users and problem trouble shooting.

Programing with Oracle Developer and PL/SQL

Preparing reports to users with  Oracle Discoverer

Making analysis and developing and  adding new modules according to new requirements into existing systems.

Performing Database administration tasks in application schemas.

Monitoring and reporting performance and activities of oracle servers.

SQL Statement tuning

Performing database administration of Service and Warrianty Databse server and acting as primary DBA in absence of other dba

Projekte

Maintanence and updating existing sytems

• Making business analysis and adding new modules  according to new requirements in to systems  which are listed  below.
• Sales/Order System, Vehicle Producing System, New Part Investment System and Current Account System

Analysis and development Service/Warranty System

• Performing business analysis
•  Designing of application database
• Designing data feeding from other systems. ( from Sales/Order System , Spare Part System and Spare Part Datawarehouse system into Service/Warranty Systems)
• Designing data feeding to other systems (From Service/Warranty system into Sales/Order System and AutoPlus that is an application which runs on dealer and service sides. )
• Coding and developing with Oracle Developer Forms and Report.
• Providing support to Service/Warranty Department
• Adding new modules on request.
• Acting as DBA for application server.

Analysis Hotline Support System

• Performing business analysis
• Designing of application database
• Passing  design documents and  results to developer.

Upgrading Oracle Developer Forms/Reports Modules from R4.5 to R.6.

• Upgrade Oracle Developer Modules to provide year 2000 compatibility.
• Fixing Program Codes according to new version if it is necessary.
• Delivery of new modules on client sides.
• I have received an incentive present check from my manager because of my works. It is given to only one person each year at department.