Glen Bernas

Glen Bernas

Work History

Work History
Dec 2007 - Mar 2009

Sr. Oracle Database Administrator

Sungard Financial
  • Mentor Junior Oracle DBAsSupport by developing ways to solve business needs with the new features in Oracle 11G
  • Provide 24/7 support to mission critical database
  • Product installations and maintenance of 10 productions databases and 15 development databases
  • Monitor, tune and enhance the performance of development, QA and production database environment
  • Identify and resolve ‘root cause’ problems related to application/database performance
  • Provide full-lifecycle DBA support from physical database design, development, user acceptance and production deployment
  • Identify, test, and approve hardware and software solutions
  • Document of problems and solutions and platform handbooks
  • Assist to diagnose, resolve, and prevent problems associated with MS SQL and Oracle environment
  • Procure or design, implement, and support a forecasting and capacity management reporting methodology to provide enterprise growth and cost of operations' metrics for MS SQL and Oracle

Oracle Version: 11g, 10g, 9i, 8i

Platform: HP, Solaris, Window

Database Features: RMAN, Data Guard, OEM, RAC

Software: Quest Spotlight, Quest Benchmark Factor, Quest Toad

Jul 2006 - Dec 2007

Oracle Database Administrator

http://www.mtm.com
  • Day-to-day database management for production and test environment including Oracle (8-10) on 24x7 schedule with on-call rotation
  • Implemented RMAN Oracle backup and recovery
  • Developed and implemented set of daily database maintenance jobs
  • Configured monitoring tools such Oracle 10G Grid
  • Promoted weekly development changes in production environment
  • Participated in regular disaster recovery exercises
  • Maintained all service delivery operations and service levels for applications, services and systems in the production environment
  • Maintained proactive health check operation, service monitoring alerts, and comprehensive configuration documentation for all environments.

Oracle Version: 10g, 9i, 8i

Platform: HP, Solaris, Windows

Database Features: RMAN, Data Guard, OEM

Software: Quest Spotlight, Quest Benchmark Factor, Quest Toad

Jan 2001 - Jul 2006

Oracle Database Administrator

EMC
  • Procure or design, implement, and support a forecasting and capacity management reporting methodology to provide enterprise growth and cost of operations' metrics for MS SQL and Oracle
  • Analyzed user requirements, procedures and problems to automate processing and improving existing EMC systems
  • Established the processes and procedures to evaluate and ensure the accuracy of data and reports
  • Determined database object storage requirements for optimum performance and scalability by reviewing computer system capacities, workflow and scheduling limitations to determine if request programs or program changes are possible within EMC's current database systems
  • Analyzed existing information process systems to evaluate effectiveness and developed new system to improve the workflow
  • Designed schema for inventory tracking system, and ticketing system
  • Development DBA, and Production DBA for software engineering division.
  • Installed, configured and managed Oracle 9i databases for development and QA
  • Involved in 24x7 supports for the production 500+ GB databases (Sybase, Oracle, DB2, SQL Server)
  • Installed and configured database software
  • Performed database tuning (Sybase, MS SQL, Oracle, DB2)
  • Established Database Backup/Restore/Recovery Processes and Procedures
  • Troubleshoot and resolved various production problems
  • Monitored and analysed daily load of the production database and identified most heavy used database elements
  • Executed various database management tasks (reindexing, update statistics, dump and load backups, synchronization of primary and standby databases)
  • Set-up Replication Server for high availability and reporting
  • Createddata model and technical design specifications for newer applications

Oracle Version: 10g, 9i, 8i

Platform: HP, AIX, Solaris, Windows

Database Features: RMAN, Data Guard, OEM, RAC

Software: Quest Spotlight, Quest Benchmark Factor, Quest Toad

Storage Array: Clariion, Symetrix

Education

Education

Skills

Skills

Quest Benchmark Factory

Quest Foglight

DB2

Sybase

MS Sql

Oracle Administration

Certifications

Certifications

Oracle Certified Professional

OCP