Thursday, January 27, 2011

Teksystems - Production Database Migration

New hardware. New operating system. New software versions. Trigger based replication. Nightmare. Run. Fast. Run away. Faster.

For a hospital automation application that "impacts peoples’ lives", 99.9% uptime is surprisingly low. That is nearly 9 hours per year. Looks like their Oracle account manager sold them a solution that will fix everything wrong with their current system. Prepare for an expensive fail.




Opportunity
This is an opportunity to work for an industry leading company in one of the fastest growing verticals in the country. Combine that with implementing enterprise level applications using new technology, and ultimately deploying something that impacts peoples’ lives.

Qualified candidates must have the following:
1. Cloning, Backup, and Recovery of enterprise level databases
2. PL/SQL Database Development Skills
3. Application and Database deployment experience with RAC/ASM experience

Job Description:
Performs Production Database migration to new RAC hardware/new OS, Production Database conversion to new customer software versions, perform trigger based replication from production to new RAC databases, maintain production 24x7 Oracle Databases with 99.9% uptime for hospital automation of live
patient encounters, surgeries, medications etc.. They will also perform flashback of database to allow customer to evaluate conversion of production database before committing to final steps and cutover to production. Complete RMAN cloning of production databases to local/remote hosts, then debug and edit PL/SQL to allow conversion process to continue. Additionally they will be responsible for database/SQL performance tuning and application troubleshooting, also perform Korn Shell scripting and debugging for minor upgrades and conversions, and finally create and remove RAC clustered databases. They will also trouble shoot truncated data, wrong data types, duplicate data, index constraints, and primary key constraints.

Additional Job Info:
This is a customer facing role, so our resources must be able to have in depth technical conversations with customers during both planning and go live scenarios.

Contact Information:
If interested in hearing more information about this position and applying, please email Ashley Reasner at areasner@teksystems.com or call directly at 303.412.2757. Thank you!