Senior Creative Manager - Branding at Unique Industries @ Greater Philadelphia
Senior Oracle and Big data DBA
* 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.