Data Engineer/DBA - Hybrid

* Hybrid; webcam interview; need 3 references  Long term

Job Description:

• Supports the installation of database software and migrations to new data management system software levels, and tests the migrations to ensure data reliability and functionality.

• Analyzes, designs, modifies, and maintains database structures.

• Designs and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures.

• Establishes and implements database security controls and user access levels.

• Evaluates and recommends database software packages for potential acquisition.

• Prepares and develops database documentation, procedures, and definitions for data

• dictionaries.

• Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models.

• Performs database performance monitoring and implements efficiency improvements.

• Assists in modifying existing databases and database management systems.

• Assists in developing standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment

Skills/Requirements

• Strong knowledge of database management systems, as well as data warehouse management and decision support tools Required 5 Years
• Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired Required 5  Years
• Experience in business objects and in building the data dictionary Required 5  Years
• Ability to use data base access tools for application delivery Required 5  Years
• Strong familiarity with analysis, planning and management reporting functions Required 5   Years
• Well-developed oral and written communications skills Required 5  Years
• Strong teamwork and interpersonal skills Required 5  Years
• Extremely high level of analytical ability where problems are very unusual and extremely difficult Required 5  Years
• Understanding of benchmarking processes and techniques Required 5  Years
• Very high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output Required 5  Years
• Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models Required 5  Years
• GUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools. Required 5  Years
• Implementation experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies. Required 5  Years
• Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools. Required 5  Years
• Experience with data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, Structured Query Language (SQL), end-user tools, database and SQL. Required 5  Years
• Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools. Required 5  Years
• Excellent analytical; problem-solving; team playing; and oral and written communication skills. Required 5  Years
• Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities. Required 5  Years
• Oracle Database experience Preferred 5  Years
• SSRS report creation Preferred 5  Years
• M204 database experience Preferred 1  Years