Mr. SINISA CVIJETINOVIC

Cell: 416-***-****

E-mail: ac59a4@r.postjobfree.com

LinkedIn: https://ca.linkedin.com/in/sinisa-cvijetinovic-4742b54

PROFESIONAL SUMMURY:

Twenty years of experience working as Sr. Database Administrator & Analyst for Oracle databases under UNIX and Window OS platforms, with notable success directing a broad range of IT initiatives while participating in planning, analysis and implementation of solutions in support of business objectives. Hands on experience leading and executing all stages of database systems including: Oracle database administration (Oracle 9i, 10g, 11g, 12c), database architecture, design, modeling, normalization and performance tuning.

AREAS OF EXPERTISE

* Database Administration and Security * Data integrity / Disaster recovery

* Backup and recovery strategy * Technical Specification Development

* Policy planning / Implementation * Cost benefits analysis

* Research and development * Team and Project Leadership

PROFESIONAL EXPERIENCE

Margos Inc., Mississauga February 2018-Present

Database Consultant

Provide strategic direction for database administration, information processing, system development and operations including logical and physical database design, troubleshooting, database backup solution and database performance improvement.

HP/DXC (CIBC account), Toronto May 2016–November 2017

Sr. Database Administrator/Analyst

Supported end-to-end projects including new database creation and old database decommissioning for RAC and NON-RAC Oracle 10g, 11g, 12c database environment under Unix/Linux and Oracle Exadata platform including database object management (create, delete, updates of tables, triggers, indexes, sequences, etc).

Monitor RAC database performance and troubleshoot bottleneck issues by Oracle Grid Control (OEM 12c)

Performed database migration from Oracle 10g, 11g to 12c to Exadata 12c using RMAN backup/restore solution as well as export/import techniques.

Executed database refresh from one to another environment using DataPump tool.

Responsible for Oracle space management under Oracle Automatic Storage Management (ASM) – adding, configuring and balancing new disk LUNs.

Implemented database changes and code promotion using Service Now change management tool

Granting access and establish end user access to SQL Server databases

Created and maintained database replication using DataGuard and Golden Gate tool as business solution for Disaster/Recovery. Also, conducted every 6 months mandatory DR testing with full database failover and failback scenario.

CPPIB (Canadian Pension Plan Investment Board), Toronto January 2014–February 2016

Sr. DBA/Analyst

Lead multiply end-to-end projects and DBA team to support RDBMS Oracle 11g, 12c RAC database systems under HP-UNIX and Solaris/Linux OS and Microsoft SQL Server 2008/2012/2014 database platforms under Windows OS.

Performed and supported Oracle 11g database administration including performance monitoring and tuning, identifying problems and implementing problem solutions, ensuring that databases are running at optimum speed and efficiency.

Supported and execute DR/BC project regarding Oracle database platform using DataGuard replication

Applied Oracle critical patches (CPU & PSU) and RDBMS release upgrades.

Strong experience with Oracle RAC Cluster and Automatic Storage Management (ASM) under x86-64.

Installation of SQL Server 2008 and 2012 clustered and standalone

Support, administer and managed the database environments running on SQL Server 2008/2012/2014.

Granting access and establish end user access to SQL Server 2008R2/2012

Troubleshooting SQL Server database performance including server configuration changes, indexes, stored procedure, query changes

Maintained and developed database backup/recovery strategy, test cases and recovery plans using RMAN backup tool and DataPump logical backup approach.

Performed data refresh from one environment to another using DataPump export/import tool.

Assumed responsibilities for full physical and logical database design, data model and documentation which included: software (database) installation, database physical and logical design, DB creation (database objects such as tables, views, triggers, roles, store procedure, indexes, etc), database sizing/storage, regular database maintenance, performance tuning and monitoring using Oracle OEM GRID repository and other applicable database tools (AWR, ADDM).

Established and documented database security policies, administration procedures and database best practices recommendations to ensure effective protection and integrity of data assets.

Setup and troubleshooting setup application connectivity configurations and issues regarding ODBC, JDBC

Evaluated and researched new database features (Oracle 12c, MySQL) and related software as directed. Prepared summary reports and recommendations and interacted with vendors as required.

Loyalty One (Air Miles), Toronto November 2008–January 2014

Sr. DBA/Database Analyst

Managed, maintained and administered Oracle 10g,11g, 12c as well as SQL Server 2008 in 24x7 OLTP environment under Sun Solaris and Windows OS platform using Oracle RAC database environment

Created, configured and administrated Oracle 11g standalone database under Windows 2012 platform

Administrating, Maintaining and building SQL Server 2008R2

Developed and maintained PL/SQL scripts, created user tables, indexes, views using native SQL or software tool and introduced testing/release procedures using SQL*Loader control cards.

Responsible for complete database administration functions including: installation, physical and logical design, DB creation, database sizing/storage, regular database maintenance, tuning and monitoring using Oracle GRID repository.

Participated in Database Migration / Refresh / Re-Build, and Database Replication on Oracle Sun Solaris/Linux platform using DataGuard tool.

Executed database changes using Change Management software ATLAS, per Change Request, Incident and Problem tickets

Managed multiple PROD/UAT/TNVDEV database environments using Oracle 10g, 11g RAC and standalone databases hosting different applications including www.airmiles.ca

Prepared and applied Oracle 11g database upgrade from 10g to 11gR2 version including Oracle binaries, CRS, ASM and agent components.

Guided the developers to trace program execution and fine tune the developed objects. Actively supported technical architects, data modeler and developers throughout the development, test and implementation phases of the project.

CIBC Bank (VISA - Card Products Technology), Toronto June 2007–October 2008

Sr. Oracle DBA

Analyzed business requirements for Data Simplification Project regarding better performance on database and application side.

Prepared database design strategy for improving tablespace/partitions creation process which resulted in a significant storage saving.

Wrote shell and SQL scripts to automate monthly process of creation of tablespaces/partitions and monthly processes for archive purge and drop tables. Performed live manual database reorg for 4 years of historical data based on new tablespace/partitions creation process and provide 15% (more then 700 GB) physical space back to OS level.

Proposed new database backup strategy for production databases using RMAN repository catalog and FAST Incremental backup (Oracle 10g feature) with READ ONLY option on historical tables, which reduced a backup window from 20 hours to 3 hours for database size of 6 TB.

Created variety of development Oracle databases including all database structures with partitions and provided support during full development cycle including user, QA and accepting testing levels.

Rogers Communications Inc., Toronto July 2006 – June 2007

Database & Backup Analyst

Hydro One / Inergi LP, Toronto November 2004 – July 2006

Sr. Oracle DBA / Consultant

CIBC Bank (Amicus Division), Toronto January 2004 – November 2004

Sr. Oracle DBA / Database Analyst (CIBC Amicus)

New Horizon - OPG (Infrastructure), Toronto January 2001 – September 2003

Sr. Oracle DBA & Database architect

Group Telecom (Operation), Toronto February 2000 – January 2001

Sr. ORACLE DBA / Team Leader

EDUCATION PROFESIONAL DEVELOPMENT (COURSES)

University of Novi Sad, 1982 * SQL and PL/SQL * Database Administration

Business Administration Diploma * Performance Tuning * Network Administration

Major in Applied Computer Science * Backup & Recovery * 11g RAC Administration

* Object-Oriented Designs * Data Base design

* Project Planning and Manag. * Project Estimating

TECHICAL PROFICIENCIES

PROGRAM. LANGUAGES: SQL, PL/SQL, COBOL, JCL, C++, Pascal,Basic, PERL

HARDWARE: Sun Solaris (420, 4500, 6500, 4800), HP 9000, IBM-370,HN/Bull (DPS9000), x86/64

OPERATING SYSTEMS: UNIX (Sun Solaris), Linux, HP, Windows NT/XP, TSO/MVS, AIX

TOOLS: Grid Control 12c, Golden Gate, Actifio, Oracle Forms, Visio, BMC, JIRA, Sharepoint,Visual Basic, Visual C++, MS Project

ADMINISTRATION TOOLS: Quest Software (SharePlex, TOAD, Space Manager, SpotLight), Solarwind, Computer Associate (ASO, BrightStor), SQL*Plus, Server Manager, SQL*Loader, OEM, RMAN, Import/Export, data pump, Oracle Designer, ERWIN, Veritas NetBackup

CERTIFICATINS: - Oracle RAC Administration

- Oracle OEM Grid Control

- Managing Multiple Projects

Contact this candidate