A bachelor's degree in Computer Science or a scientific/quantitative field.
Strong SQL programming skills, particularly for Oracle, Microsoft SQL Server, and IBM DB2 platforms.
Understanding of source and target data structures, ETL processes, and ETL products.
Knowledge of 3GL/4GL programming languages and ETL products including SAP Data Services.
Strong problem-solving and metadata skills.
Extensive knowledge of Oracle 11g relational database availability, performance, and security principles, concepts, and tools.
Expert knowledge and skill with SQL, including data definition language and data manipulation language.
Hands-on experience writing complex PL/SQL and Unix shell scripts.
Demonstrable experience managing high-performance, high-capacity databases in a critical production environment.
Proficiency with database performance monitoring tools such as Oracle Enterprise Manager.
Expert knowledge of database scripting and automation technology.
Familiarity with ETL and data warehouse concepts.
Understanding of and experience implementing ETL principles and best practices, including error handling, logging and alerting, scheduling, and job control.
Knowledge of reporting processes, including Crystal development and Business Objects InfoView.
Demonstrated proficiency with business intelligence tools and best practices.
Responsibilities
Perform scheduled Clarity ETL batch operations from the Epic Chronicles hierarchical data store to the Epic Clarity relational data store.
Perform additional ETL procedures to extract data from Epic and other data sources, clean and conform the data, and deliver the data.
Desired Qualifications
Oracle Database 11g Administrator preferred.
Job Description
The applications DBA performs scheduled Clarity ETL batch operations from the Epic Chronicles hierarchical data store to the Epic Clarity relational data store. The individual performs additional ETL procedures to extract data from both Epic and other data sources, to clean the data, to conform the data, and to deliver the data.
Qualifications
Bachelor's degree in Computer Science or scientific/quantitative field.
Oracle Database 11g Administrator preferred.
Strong SQL programming skills, particularly for the Oracle, Microsoft SQL Server, and IBM DB2 platforms.
Understanding of source and target data structures, ETL processes, and products.
Knowledge of 3GL/4GL programming languages and ETL products including SAP Data Services.
Strong problem-solving and metadata skills.
Extensive knowledge of relational database Oracle 11g availability, performance, and security principles, concepts, and tools.
Expert knowledge and skill with SQL; both DDL (data definition) and DML (data manipulation).
Hands-on with writing complex PL/SQL and Unix shell scripts.
Demonstrable experience of managing high-performance, high-capacity databases in a critical production environment.
Proficiency with DB performance monitoring tools like Oracle Enterprise Manager.
Expert knowledge of database scripting and automation technology.
Familiar with ETL and Data warehouse concepts.
Understanding of and experience implementing, ETL principles and best practices, including error handling, logging & alerting, scheduling and job control.
Knowledge of reporting processes (Crystal development, Business Objects InfoView).
Demonstrated proficiency with Business Intelligence (BI) tools and best practices.