Architect (ATC)

ESSENTIAL DUTIES AND RESPONSIBILITIES Designing databases and ensuring their stability reliability and performance Design create and implement database systems based on the end user 39s requirements Develop test and maintain oracle database objects for PEARLCARE software Investigate and support new technology initiatives to improve or enhance current database capabilities Prepare documentations for database applications Maintain all programming in SourceSafe Learn new applicable programming techniques as needed Work with other database personnel front end programmers and customer support as needed Be available as needed should critical software issues arise Write documentation and sops for future use QUALIFICATIONS/REQUIREMENTS To perform this job successfully an individual must be able to perform each essential duty satisfactorily Requirements include B S in Information Technology Computer Science or equivalent skills work experience 5 years of hands-on Oracle Relational modeling and database development experience 3 years working in Oracle Database DDL DML and concepts table triggers views procedures functions packages PL SQL SQL languages with SQLplus SQLcli and or Experience with database version control through VSS or equivalent Demonstrated technical excellence working to support scientific user base to engage in problem solving and finding proactive solutions Proven track record of leading database transformation and development project through to successful implementation Significant Oracle database test development and performance tuning experience Proficiency in technical writing documenting solutions and communicating with clients and users JOB DESCRIPTION TEMPLATE SUCCESSFUL COMPETENCY FACTORS Use of the following skills problem solving analytical ability effective communication confidentiality Interpersonal skills necessary to work with staff senior management insurance companies government and private agencies Multi task in an efficient professional and calm manner SUPERVISORY RESPONSIBILITIES No supervisory responsibility BUDGETARY RESPONSIBILITIES No budgetary responsibility WORK ENVIRONMENT Minimal travel overnight travel may be required Noise level in the typical work environment is moderate due to the number of staff in business office area and staff patients equipment in patient care areas