Sonya Chbeeb

Current

• Oracle Database Administrator at Intergraph Corporation

Past

• Oracle Database Administrator/Data Processing Analyst IV at Westar Corp
• Oracle Database Administrator at TransUnion SSI
• Oracle Database Administrator at Borders Group, Inc

• Oracle Database/UNIX/NetBackup Administrator at Siemens
• Oracle Database Administrator at Cadbury Schwepps

see less...

2 more...

Education

• Mary Baldwin College

Connections

21 connections

Industry

Computer Software

Sonya Chbeeb’s Summary

Experience:
9 Years of experience in an IT related Field with strong expertise in Database Analysis and Design,
Performance Tuning, Backup and Recovery including RMAN and other backup methods.
Oracle DBA experience of 3 years and data analysis for 6 years
Experience in Oracle 9i,10g and 11g.
Planning and execution of migration of over 60 databases from Oracle 8i to Oracle 9i/10g/11g.
Excellent analytical abilities, strong work ethic, demonstrated teamwork, willing to make a long-term
commitment to projects.
Excellent in SQL and PL/SQL programming such as Functions, Stored Procedures, and Packages
Comprehensive and in depth experience using the System Development Life Cycle(SDLC)

Sonya Chbeeb’s Experience

• Oracle Database Administrator

  Intergraph Corporation

  (Computer Software industry)

  November 2008 — Present (1 year 1 month)

  Database back-up and recovery
  Applied Oracle patch updates as needed for routine maintenance
  Upgraded oracle as new versions were released
  Maintained 6+ internal servers and 15+ laptops for training, development and backup purposes to make
  sure software was up to date and database was at the current version.
  Baselined the 6 external databases weekly to search for anomalies
  Monitored users on all databases to ensure no unauthorized users have been created.
  Performed capacity planning when upgrading and installing new databases on new servers or laptops
  Automated DBA tasks
  Created and tested Backup Integrity
  Verified data integrity
  In charge of creating and maintaining autoloader templates as requested by the government
  Verified Security documentation according to DoD requirements
  Provided helpdesk support on the Web Based Application we maintain in-house
  Tested and verified different modules on our in-house web based application prior to release dates
  Worked closely with 5+ developers/ 3+ tech writers to run scripts and change user permissions for
  testing/development purposes
  Granted roles/privileges to users according to specific government guidelines
  Defined and/or implemented access controls to the data availability
  Ensured maximum uptime performance and maintenance
  Helped programmers and engineers to efficiently utilize the database
  Proactively identified and mitigated project risks
  
  Description: This project involved installations, applied patches, wrote and performed test plans as well as Implemented standard backup and recovery methods. along with standard DBA tasks. Also maintained helpdesk support for clients about our web based application.
  Environment: Windows 2003/XP, Oracle 10.2.0.4, TOAD, SQL Developer

• Oracle Database Administrator/Data Processing Analyst IV

  Westar Corp

  (Computer Software industry)

  June 2008 — August 2008 (3 months)

  Managed data processing for multiple datasets
  Worked with .rdf, .xml, and .csv files
  Compiled documentation and preformed updates accordingly
  Reorganized data to make it more manageable
  Installed multiple third party tools and created documentation for them
  Worked with multiple managers on requests as needed
  Import/Export data into the Oracle databases as needed for updates
  Created/Disabled users
  Worked together with the lead DBA to create documentation and manage databases
  Imported data from a SQL Server environment to Oracle using Oracle Migration Workbench
  Monitor processes that run and keep track of all details in a spreadsheet.
  Daily and monthly processes documented and completed on time
  Worked in a team environment that consisted of 5 people
  
  Description: This project was to help with data processing, documentation and organization of data before the end of their fiscal year. Environment: Linux x86_64, Windows 2000/2003, SQL Server, Oracle 10.2.0.3, OEM, Oracle Migration Work Bench(OMWB), TOAD, SQL Developer

• Oracle Database Administrator

  TransUnion SSI

  (Computer Software industry)

  February 2008 — May 2008 (4 months)

  Performed weekly database updates
  Maintained development databases
  Performed weekly backups
  Weekly statistics were ran and analyzed
  Response Time Reports were created on a weekly basis
  Applied patches, maintained, supported and monitored all the databases on location
  Performed database migrations from Oracle 10.2.0.3 to 11.1.0 on Windows 2003 and Unbreakable Linux
  Worked with Oracle support to resolve issues.
  24/7 on Call support
  Resolved connectivity/network issues as needed
  Collected weekly statistics from the database updated information for analysis.
  Created testing databases
  Worked closely with the systems administrator to resolve and improve performance
  
  Description: This project involved maintenance and migrations of databases for both production and test. Environment: Oracle 10.2.0.3 to 11.1.0 on Windows 2003 and Unbreakable Linux, OEM, RMAN 10g, TOAD, SQL Developer, OUI, etc..

• Oracle Database Administrator

  Borders Group, Inc

  (Computer Software industry)

  December 2007 — February 2008 (3 months)

  Design, create, maintain, support, monitor and tune physical databases
  Processed code for the developers in QA and production environments.
  Created daily tablespace reports and deployed on dev, QA, and Prod.
  Monitored tablespaces daily.
  Updated database information for documentation
  Worked with requests for SOX Audit reports
  Created universal TNSnames.ora
  Troubleshoot and resolve database related issues
  Worked with a variety of database environments such as Oracle, DB2 and MS SQL Server.
  Manage Database Binary Installations, Upgrades and Patch maintenance
  Translate logical data models into physical models
  
  Description: This project included maintenance, code drops and special requests. Environment: AIX 5.3/5.2, Windows 2000/2003, Oracle 8.1.7./9.2.0.5/10.1.0.1/10.2.0.2/10.2.0.3, OEM, RMAN 8i/9i/10g

• Oracle Database/UNIX/NetBackup Administrator

  Siemens

  (Privately Held; 10,001 or more employees; Information Technology and Services industry)

  September 2007 — November 2007 (3 months)

  Installation of Agile, Oracle and WebLogic
  Installation of Oracle and Agile client software on both and Unix and Windows environments.
  Support role as Oracle DBA for production applications: Agile, SAP, WebLogic
  Unix Administrator working on client hardware/server relocation project: Sun Sparc Servers
  Administrator for monitoring Veritas NetBackup tasks including, daily and monthly offsite.
  NetBackup daily tape monitoring and troubleshooting robot inventory.
  Created daily backups using Veritas
  Assisting project management to create planning and estimation documents for datacenter relocation.
  Evaluation of the SLA of an outsourced vender by providing technical expertise.
  
  Description: This project was the relocation of the datacenter. Environment: Sun Solaris 10/8, Windows 2000/2003, Oracle 8.1.7, OEM, Veritas NetBackup 4.5/6.0

• Oracle Database Administrator

  Cadbury Schwepps

  (Computer Software industry)

  May 2007 — August 2007 (4 months)

  Primary Database Administrator for 24x7 Oracle Production Database and Additional
  management/monitoring several databases.
  Handled Oracle trace events while upgrading the databases
  Managed the file systems on the OS level by resizing the tablespaces
  Documented the upgrade procedure for other team members
  Performed database tuning & performance, storage management, plan growth and changes,
  database monitoring, security management, and tuning SQL batch queries.
  Developed PL/SQL stored procedures, packages, functions & database triggers
  Troubleshoot issues raised in the instillation and upgrade process
  Managed the tnsnames and listener to point to the new oracle home
  Migration of Oracle 8.1.7.x to Oracle 9.2.0.x
  Migration of Oracle 9.2.0.x to Oracle 10.2.0.x
  Applied interim patches using the OPatch utility
  Experience with staging, development, and production databases
  Used Toad and OEM to evaluate performance issues
  Import/Export schemas, users, data, and indexes
  Migration of databases from Sun Solaris 8 server to an AIX 5L server
  Experience using the RMAN utility to backup a database as well as point in time recovery
  Performed the RMAN configuration after upgrading
  Scheduled nightly jobs using the crontab
  Coordinated with the managers to distribute the tasks among the team
  Created tablespaces, datafiles, and extended space where needed
  
  Description: This project was to upgrade 60+ databases for Data Center Outsourcing (DCO) Environment: AIX 5L, Oracle 8.1.7/9.2.0/10.2.0.2, Sun Solaris 8, TOAD, OEM, RMAN

Sonya Chbeeb’s Education

• Mary Baldwin College

  Bachelor of Science , Computer Information System; Pre-Med

Additional Information

Sonya Chbeeb’s Groups:

•    Oracle Jobs

Sonya Chbeeb’s Contact Settings

Interested In:

• consulting offers
• new ventures
• job inquiries
• expertise requests
• business deals
• reference requests
• getting back in touch