Oracle Database Architect

• Jun 2023 - Present

Oracle Database Administrator

• Nov 2016 - Jun 2023

Finbet d.o.o is first-class IT services provider for online gaming and sports betting industry. Finbet is a company that specialized in software development, maintenance and support. As an Oracle Database Administrator, I deliver 24x7 production database and applications support for large OLTP and OLAP databases. I set up, install, configure, and patch Oracle databases, Oracle Grid Infrastructure. I also provide support, administration, and configuration of Oracle hardware engineered systems - Exadata and ODA. I implement Oracle Enterprise Manager (OEM) (11g), Grid Control (11g), Cloud control (12c and 13c), meeting business requirements. I also provide high-level in installing standby databases (Oracle Data Guard) for high availability and disaster recovery purpose. The following are the highlights of the value that I bring to the organisation; • Designed high availability and disaster recovery solutions to protect loss data during any critical failures. • Exceeded performance standards by utilising tools like EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM. • Authored PL/SQL stored procedures, UNIX Shell scripts, functions and triggers, optimizing performance. • Increased performance by partitioning large tables for better manageability and stability. • Troubleshooting general and specific performance issues. • Performed database upgrades to version 19c and database patching. • Performed database migrations to hardware engineered systems - Exadata and ODA. Show less

System and Database Administrator

• May 2012 - Oct 2016

A Database Administrator, DBA, I am responsible for overseeing the maintenance and security measures of company databases. I was monitoring and updating malware protection software to combat potential security breaches, creating account data for authorized individuals to access databases, and organizing databases so individuals can find important documents in an efficient manner. Furthermore, I installed, upgraded, and configured the Oracle environment by creating databases, storage structures, and objects. I created Oracle backup and recovery strategies using RMAN, flashback, point-in-time recovery/logical backups - Data Pump, export/import, and transportable Tablespaces. I created storage database structures with high-level security features. I altered storage structures to meet the evolving needs of the company. The following are the highlights of the value that I bring to the organization: • Participated in design reviews as required to ensure database design meets application requirements. • Designed, documented, and executed database utilities to provide information regarding database activity. • Reviewed and enforced adherence to the company's Architecture, as well as database design and usage standards. • Participated in creating, optimizing and documenting critical company's business/financial reports. • Implemented active database monitoring via Oracle Enterprise Manager and alert notifications. • Increased database performance significantly through SQL queries optimization and implementation of SQL plan. • Optimized data warehouse nightly jobs with Oracle partitioning. Show less

System and Database administrator

• Oct 2008 - Dec 2011

As a Network, System, and Database Administrator, I oversaw installation, configuration, and administration of MSSQL server databases. I designed backup/recovery strategies (point in time recovery). I created and implemented high availability strategies such as Database mirroring and log shipping. The following are the highlights of the value that I bring to the organization: • Delivered quality technical support and administration regarding MSSQL databases to 158 Serbian municipalities. • Conducted disaster data recovery of MSSQL databases and windows servers to protect data during a mishap • Troubleshot network issues and introduced best security practices for connecting 158 remote databases to the main headquarter database. • Supported network and system administration teams in advanced windows server troubleshooting. • Mentored system administration team in installing and configuring different types of windows servers (Exchange, Clustering, Firewall, and Certification Authority). • Participated in proof of concept for the usage of virtualization in the production environment. Additional Experience Advisor to the modernization, improvement of security, network infrastructure, and information system of the municipality of Zemun Show less