Oscar Armas

Experience

• 

  Nabi Biopharmaceuticals

  Sept 1994 - Oct 2002

  Responsible for implementing SAP R/3 Financial system on UNIX (HP-UX) using Hewlett Packard K-series servers. Administered 10 Hewlett Packard UNIX servers (K-210,K250,K260,K460 and K580). Duties included loading new operating system (OS), OS patch upgrades, product install and maintenance, user and file administration, system backups using openview omniback, high availability fail over using MC Service Guard and disaster recovery. Responsibilities also included monitoring disk space consumption on our EMC 3230 and planning for future growth.Responsible for administering 10 Sun MicroSystems servers (Sparc 10,Ultra 2,Ultra 250,Ultra 450,Ultra 3000). Duties included loading new operating system, applying recommended patch cluster, Solaris PROM upgrades, system backups using Veritas Netbackup and installing Oracle software on server. Implemented enterprise backup solution company wide using Veritas Netbackup product. Utilized Veritas VxVM volume manager to manage sun storage. Show less Responsible for implementing SAP R/3 Financial System on UNIX (HP-UX) using Oracle7 and Oracle8i and on Windows 2000 using Oracle8i. Duties included installing Oracle software on the server, designing the Oracle database physical layout, implementing the design and tuning Oracle database. Tuning included SQL Query optimization using explain plan, top sessions, utlbstat/utlestat, statspack and SAP Earlywatch. User OLTP response on the SAP R/3 financial system was 2 seconds.On the SAP R/3 system responsible for implementing backup and recovery strategy for a 300GB database, monitoring disk space consumption in the database and planning for future growth. Reorganized database objects when the number of extents exceeded 100 and created huge indexes (8GB) when necessary.Responsible for implementing ClinTrial and ClinTrace system on UNIX (Solaris) using Oracle7 and Oracle8i. Activities included installing the Oracle software on the server, creating the database, creating rollback segments, creating tablespaces, creating datafiles, creating redo log files, and mirroring redo log files across multiple disks. Managed database users, roles, synonyms and database links. Responsibilities also included implementing backup and recovery strategy for a 15GB database, automating backup of database using ksh scripts and job scheduling utilities (i.e. crontab) in UNIX. Show less

  • Senior Unix System Administrator

    Sept 1994 - Oct 2002

  • Senior Oracle Database Administrator

    Sept 1994 - Oct 2002
• 

  Sun-Sentinel

  Apr 2003 - Nov 2012

  Senior Oracle Database Administrator

  • Consolidated from 300 Oracle databases to 125 reducing costs and eliminating duplicate resources• Provided Oracle database administrator support to Oracle11g databases running on VMWare (VM) virtual machines and Linux CentOS 5.x ranging 100gb to 700gb, supporting multi-location databases• Provided Oracle database management including database design and creation, tablespace, user management, security, tuning, backup and recovery for enterprise applications• Created, installed and supported 60+ PostgreSQL instances for Tribune digital team by exporting and importing data into new Postgres instances; created and sync Postgres slave with master instance, conducting performance tuning and ensuring hot backup• Completed test database refresh from production using RMAN tool; constant database refresh including RMAN refreshes to Stage, QA, Test and Production databases• Created Oracle10g databases planning and managing tablespaces, managing database objects (tables, indexes, synonyms, procedures, functions, packages), managing database links, creating users and database roles, backup and recovery, creating database export files, tuning the database and providing 24x7 availability• Supported centralized enterprise databases using Oracle partitions on Oracle10g running on Sun Solaris duties included tablespace, user management, backup, recovery and performance tuning. • Performance tuning front-end SQL applications• Migrated TELESOFT Oracle10g database, Aveksa to Oracle11g running on Linux Red Hat• Performed Oracle database backup and restores for enterprise applications ranging from 300gb to 700gb with constant refresh of Test Oracle databases• Conducted performance tuning sessions with enterprise applications using Oracle explain plan/AWR/ASH/SQL reports to identify and tune underperforming SQL; also used Oracle Enterprise Manager SQL tuning wizard to implement improved SQL recommendations updating table statistics and creating indexes to improve SQL Show less

• 

  Tribune Technology

  Apr 2012 - Nov 2017

  Database Manager

  • Major accomplishments: led cost-reducing technology migrations leveraging cloud-based solutions including transitioning PeopleSoft HR Oracle10g database to Workday as well as in-house Turbine Oracle11g database to Amazon Web Services (AWS). Contributed to significant savings by driving outsourcing initiative of internal database support functions to Tata Consulting Services (TCS). • Established strategic direction leading team of 10 DBAs in daily operation of all Tribune databases (SQL Server, Oracle, MySQL, Postgres) including availability, stability, performance, change management, backups and monitoring across 600 SQL Server instances, 125 Oracle databases, 60 MySQL and 60 Postgres instances. • Developed database solutions by designing proposed system, defining database physical structure and functional capabilities, security, backup, and recovery specifications.• Recommended and implemented enhancements and process improvements enforcing peak database performance.• Enforced Sarbanes Oxley (SOX) and PCI standards by improving password security and encrypting customer financial data compliant with company policy as well as internal and external auditor demands. • Upheld Service Level Agreements (SLA) addressing ticket tracking and resolution for customer departments: PeopleSoft, Circulation, Editorial, Advertising, Digital.• Designed team goals and set metrics to measure departmental effectiveness and reviewed against performance monitoring team deliverables for quality, consistency and compliance. • Selected qualified staff; mentored and developed team members and evaluated staff performance. Show less