Senior Oracle Database Administrator
Downers Grove, Il
Oracle Database Administrator (8i, 9i, 10g)Oracle Senior Database Administrator (10g)Recruited from IT Operations to perform as an Ingres DBA, was trained and learned relational database administration and supported various Financial, Patient, Client and Reporting mission critical databases. This included; the object design and implementation, authoring rules and procedures, process monitoring and tuning, database performance monitoring and tuning, writing documentation and… Show more Oracle Database Administrator (8i, 9i, 10g)Oracle Senior Database Administrator (10g)Recruited from IT Operations to perform as an Ingres DBA, was trained and learned relational database administration and supported various Financial, Patient, Client and Reporting mission critical databases. This included; the object design and implementation, authoring rules and procedures, process monitoring and tuning, database performance monitoring and tuning, writing documentation and troubleshooting in the development, testing, training and live production environments.As Oracle was introduced as a new platform, I transitioned to become an Oracle DBA and my primary responsibilities included developing standards and providing full service database administration and support for various mission critical application databases including the companies first claims data warehouse. I was trained and quickly learned relational database design methodologies to create, design and implement Oracle databases to meet the growing business needs.I created and maintained logical and physical database design models including writing macros to generate and support object triggers, procedures, privileges and sequences. I participated in troubleshooting, performance tuning, backup, recovery and supporting production as well as development and testing environments.I wrote processes and documentation that conformed to the current corporate standards for; creating new databases, enhancing performance, change management, pro-active monitoring and coordinating maintenance. I utilized PL/SQL, SQL, TOAD and the UNIX “vi” editor to perform efficient database queries. Show less