Improver

Marina Sirota

Senior Oracle and Big data DBA

Israel

* Over 15 years of intensive hands-on experience in the IT industry as an Oracle DBA in UNIX and NT environments with expertise in performance tuning, crisis management and high availability.Oracle Certified Professional DBA since 2002.
* Experience with Oracle 11g/10g/9i/8i Installation, Administration, Monitoring, Performance Tuning.
* Maintenance, monitoring and 24/7 support of multi-terabyte databases in mission-critical production environments- OLTP and Data Warehouse.
* Installation and configuration of Oracle RAC and single node database on Solaris, HP-UX, Linux, IBM-AIX; implemented data files using ASM, file systems or raw devices.
* Expert in design, development, and deployment of backup and recovery solutions based on different strategies.
* Expert in design, development, and deployment of disaster recovery solutions through physical and logical standby databases.
* Implementation of monitoring systems: Quest Spotlight, Precise, CA Unicenter, Grid control.
* Database Security Architect: implementation of Oracle security techniques: FGA, VPDB, auditing, company strategy and more.
* Waste experience with implementation of Data Warehouse table-partitioned databases consisting of Star Schema Fact & Dimensions tables and reporting systems and ETL processes.
* Made heavy use of the ERWin/Erstudio design tools to produce logical and physical models.
* Expert with tuning and writing of SQL and PL/SQL code. In-depth understanding of cost-based optimization, execution plans analysis, tuning, and stabilization.
* Implementation of Oracle new features to achieve the maximum performance and availability.
* Shell scripting – Highly proficient in automation and optimization of database maintenance and monitoring procedures using shell scripts.
* Oracle replication: Oracle Streams, materialized views, familiar with Golden Gate and Shareplex tools.
* Performance monitoring via AWR snapshots, OEM grid console, Precise and Quest tools.

---

Experience:

• Senior Oracle Database Administrator (Playtech)
• Senior Oracle Database Administrator (Amdocs)
• Data Infrastructural Engineer (Check Point Software Technologies, Ltd.)
• Senior Oracle DBA (Tata Communications)
• Senior Oracle Database Administrator (Pelephone)

Skills:

• Microsoft SQL Server
• Oracle Database Administration
• Database Administration
• Database Design
• RMAN
• Data Guard
• Oracle
• SQL Tuning
• Oracle Enterprise Manager
• Unix
• Shell Scripting
• Oracle RAC
• ETL
• Solaris
• Performance Tuning
• SQL
• High Availability
• Databases
• Linux
• Replication
• Data Warehousing
• Unix Shell Scripting
• PL/SQL