Oracle Database Administration and Development
The Oracle Relational Database Management System (RDBMS) is one of the most technologically-advanced database systems on the market. Oracle is the choice for many businesses, both big and small, to hold their precious data. However, experience with Oracle is required to take advantage of the advanced features of Oracle, convert databases running on older versions of Oracle or on other database systems to later Oracle versions, or design and implement a fast, reliable database solution.
 |
|
Certified Professional |
Foundation Software Technology’s Principle Consultant, Christopher Johnson, has been administering and developing Oracle databases and applications since 1992, starting with Oracle Version 6. Christopher is an Oracle Certified Professional Database Administrator for Oracle 7.3, 8.0, 8i, 9i and 10g. He has worked with databases used in Online Transaction Processing (OLTP) and Data Warehousing applications, including in 7x24 factory production operations and FDA 21 CFR Part 11 validated pharmaceutical environments.
To design, implement and administer Oracle databases, Christopher is fluent in SQL, and PL/SQL. He has used Erwin to design, implement, and maintain database schemas. He has also written numerous DBA utilities in SQL, Unix Shell, and Perl.
Christopher has experience administering Oracle on several platforms, including:
- Linux
- Microsoft Windows
- HP-UX
- IBM AIX
- Sun Solaris
In many cases, Christopher has served as the System Administrator for the above platforms, as well as the DBA.
Christopher has written database applications and utilities that take advantage of many of the features of Oracle, such as:
- Tables, views, indexes, constraints, synonyms, and database links.
- PL/SQL Packages, Procedures and Functions, and Triggers
- SQL*Loader for bulk loading data files
- Import/Export for logical backups and restores
- RMAN for backups, restores, cloning and standby database creation
- Oracle DataGuard Standby Databases
- Autonomous Transactions for logging and auditing
- Oracle Temporary Tables
- Oracle Data Cartridge Interface (ODCI) applications for creating domain indexes
- Oracle Text indexes for Google-like searches
Applications have also included external programs written in Java, Perl, Visual Basic, and Unix Shell.
Please contact us to find out how Foundation Software Technology can fill your Oracle DBA and Development needs.