Catalis Work Values

Daily Duties at Catalis:

• As the company’s first Oracle DBA, I lead the company’s transition to Oracle versions 9i and 10g running on Linux. I established the development, test and production environments. This effort included: server and client software installations, software upgrades, developer and end-user training, backup and recovery procedures, instance and application tuning, database security, and migration scripts. • Using Oracle Designer running on Windows, I reverse engineered the existing data model in order to document the current system and to lay the foundation for new features. Working with the domain experts and Java application programmers, I developed both routine and unique additions to the data model. The company has received patents for the unique parts of the data model that I created. • Using Oracle Forms running on Windows, I developed several applications to create, edit and review the content data which drives the company’s products. These tools are used daily and provide a robust and efficient work environment for the content editors to do their job. I received a special performance bonus for this work. • Using PL/SQL, database packages, SQL*Loader and Linux shell scripts, I developed data validation software to insure correctness and consistency of content data. The software initially discovered over 30,000 content errors which were subsequently corrected using the tools that I developed. This software greatly streamlined the development and QA processes and insured data correctness. • Worked on several special R&D type projects to provide functionality outside of the core development effort. Example projects include the development of a Controlled Medical Vocabulary, and a Payer Rules System for Medicare/Medicaid patients. • Investigated Oracle RAC and Data Guard technologies in order to develop a road map for scaling our products from small to large groups of users. Developed a statistical model to predict the hardware and software needed to satisfy performance, high availability, and disaster recovery requirements for a 24x7 ASP. • Using Oracle 10g, I created proof of concept and development Oracle RAC installations. These installations were used as a platform to scale our product to large groups of users. • Using Oracle 11g, I installed Oracle RAC in a production environment in order to support deployment our product via a SaaS model. • Using PL/SQL, database packages and Linux shell scripts, I developed a reusable software infrastructure for the deployment of content updates and database patches to our clients. This software automates the monthly update of client sites with minimal manual involvement. It is orders of magnitude more efficient than the previous system.

What they like about Catalis:

You highly value a work environment built on a formal structure, rules, and regulations. You do not enjoy the unpredictability of shifting priorities and deadlines that upset your routine. You require and enjoy direction, input and accountability as part of your work environment. You have a strong need to participate in making key decisions and feel left out if your superiors or co-workers do not seek your input when making decisions. You thrive on providing good customer service to both internal or external customers, and doing so makes you feel good.

Tags

Oracle, DBA

Skills

These are some of the questions we asked our climbers about their experiences with Catalis: