SUMMARY:

• Seasoned software engineer with specialization in database design, implementation, and administration over the full system cycle. Proficient with database installation, configuration, upgrade, migration, backup and recovery, security, storage & capacity planning, performance monitoring & tuning, and troubleshooting.
• Advanced knowledge and extensive experience as ORACLE DBA with Oracle 12c, 11g, 10g, 9i and 8i (8.1.7.6) on Unix/Linux and MS Windows platforms. Hands - on experience administrating Microsoft SQL Server 2012-2016, Informix and Sybase databases.
• Proven record of successful administration and maintenance of enterprise database systems in banking, insurance and telecommunication. As well as planning and managing complex migration and integration projects. International consulting and hands-on experience in the entire SDLC.

TECHNICAL SKILLS:

Operation Systems: Windows x/NT, Novell 3/4.11, UNIX AIX 4.3.3., Sun Solaris

Languages: SQL, PL/SQL, Java 1.2, Pascal

Tools: Oracle OEM (Grid Control), Oracle Data Guard and RMAN , ORACLE RDB v. 7.3, v. 8.1.7, 9i,10g,11g,12c; Microsoft SQL Server 2012-2016, ORACLE Forms, ORACLE Reports, Report Smith, T.O.A.D., Tomcat Application Server, ErWin Data Modeler, Confidential - Info Sphere Data Architect, Confidential Clear Case

Hardware: PC compatibles / PC LANs/WAN / Confidential / Sun

EXPERIENCE:

Confidential

Sr. Database Administrator

Responsibilities:

• Managed all database systems with in a Bank, biggest and core are:
• Ensuring systems availability and performance.
• Leading expert on migration and integration projects.
• Supervised junior DBAs.
• Creating and implementing backup and recovery and disaster recovery stategy.

Confidential

Data Warehouse Architect

Responsibilities:

• Created multidimensional data models for Enterprise Data Warehouse and various Data Marts for Confidential information system.
• Collaborated with Technical Specialist Business Intelligence ( TSBI), ETL Developers, QA and Customers.

Confidential

ORACLE DB Administrator

Responsibilities:

• Provided s upport /L2 & L3 / to more than 50 Oracle DBs, some connected to systems of leading European Insurance and Financial entities .
• Executed v arious Oracle 10g, 11g DB c onfigurations, installations and monitoring including RAC (Real Application Cluster), Data Guards, and Distributed Database Systems on a various platforms - AIX, Sun Solaris, and Linux.

Confidential

ORACLE DB Administrator PL SQL Developer

Responsibilities:

• Advised clients and managed Database performance and tuning; backup and recovery; Change Technology - strategy development and implementation; Planning and supporting “next release” changes and implementation

ORACLE DB Administrator

Confidential

Responsibilities:

• Managed Oracle database on Sun Solaris with 8 CPUs, assuring 24/7 availability web applications, constant performance tuning through changes to database parameters, planning and implementing tables partitioning, designed and executed master to master asynchronous replication.

Confidential

DBA / DB developer

Responsibilities:

• Performance tuning of TB OLTP system, servicing motor vehicle insurance, running on Oracle 8.1.7 Enterprise Edition; Confidential f-80 UNIX AIX 4.3.3.
• Optimized access path, memory allocation, I/O and physical structure. database maintenance, backup and recovery procedures.
• Designed and developed “Distribution management” and “Cu sto mer partner“modules of GIOS (Global Insurance Open Solution).

Confidential

DBA / DB developer

Responsibilities:

• Administered an Internet system for tracking programs on satellite channels for Italy, running on Oracle 8.1.5 Enterprise Edition and Tomcat Application Server with connection pool.
• Oracle server is configured in Dedicated Server Option, because of middle layer connection pool.
• Designed and developed the logical and physical database structure, stored procedures and packages implementing behavior of the game actors.

Confidential

Programmer/Analyst

Responsibilities:

• Designed and developed logical and physical Oracle database structure; defined replication objects, groups and sites organizing schema objects, including triggers, stored procedures and packages fulfilling business requirements.
• Created procedures for snapshot replication, database consistency support and front-end forms & reports

Confidential

Responsibilities:

• Analyzed, designed and created an Oracle database; module for importing data into Oracle database from dbf files; developed UI; trained end users.
• Created ETL tool for transferring data from unspecified dbf, txt or db files in to Oracle database keeping the integrity of the database .
• Created few system m odule for (a) importing data, measurements of the water of Danube characteristics, organized as dbf files, into ORACLE DB; (b) generating reports; (b) generating a file from the database, an input for the central database in Hungary.
• Designed and developed an Information System for Dental Practice
• The calculation takes into consideration type of manipulation, quantity and price of the used materials, qualification degree of the dentist and all legislation rules; Inventory - quantities and prices of the available materials; Schedule - reserved appointments; and Reports.