Data Modeler/Database Administrator
Excel Management Systems, Inc. - Columbus, OH

This job posting is no longer available on Excel Management Systems, Inc.. Find similar jobs: Data Modeler Database Administrator jobs - Excel Management Systems jobs

Job Title: Data Modeler/DBA Job Purpose: The Agency is seeking a Data Modeler/DBA to help complete the PACTS Update Project that includes rewriting the current PACTS ASP Classic web application in .NET and enhancing. Attention: ODE is specifically looking for a resource that is strong in Erwin , data modeling , Business analyst skills (i.e. working with the customer to determine what requirements they need) excellent interpersonal skills, ability to work independently or with supervision. DBA skills are 50 % of the necessary skill set.

Duties: The Database Administrator is responsible for data analysis and database management. Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Database Administrators have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team. • Highly skilled at database design, installations, conversions: • Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.

  • Is involved in the gathering of requirements • Reviews the project documentation • Conducts reviews of the data model to support the application • Understands and identifies data that exists in other systems/data stores • Attends all status meetings during which data, data models, reports, Extraction Transformation Loads (ETLs), and data exchanges will be discussed. • Experience designing and developing Oracle relational data models and generating related Database schemas. • Experience as a data analyst/modeler • Experience designing relational data models including (but not limited to): • Interviewing business stakeholders and system users to identify important business data • Creating transactional data models to support on-line web application • Documenting data lineage (source-to-target mappings), dependencies, and calculations that can lead to an ETL design and implementation • Identifying and designing views and/or materialized views as necessary • Experience with designing databases schemas on Oracle 11g • Experience creating logical and physical data models using ERwin 7.3 • Demonstrated prior experience in similar engagements. • Experience writing complex SQL queries and performing data analysis.
  • Experience with Oracle Version 11g • Experience using Microsoft SharePoint. • Experience using SCRUM Agile development methodologies (or SCRUM Master certification as equivalent). • Experience with Microsoft Team Foundation Server. • Goals-oriented proactive team player with the ability to multi-task and prioritize technical tasks in a fast-paced, professional environment.
  • Bachelor ’s degree or higher in Computer Science or related field. Partial credit will be awarded for BS degree or higher in any field. • Excellent verbal communication skills (to be rated at onsite interview) Please note – no “telephone interviews ” will be considered for this engagement opportunity Only onsite, “in-person ” interviews will be conducted at the ODE headquarters in downtown Columbus, Ohio for candidates who score highest in the initial evaluation. Skills and Requirements: Experience designing and developing Oracle relational data models and generating related Database schemas – Required 5 Years Experience with Logical and Physical Modeling within the last two years using ERwin 7.3 – Required 5 Years Experience with Modelmart Repository, Naming Standards File " Domain Class name applications – Required 5 Years Experience designing relational data models – Required 5 Years Experience with designing databases schemas on Oracle 11g – Required 1 Years Experience using Microsoft Office – Required 3 Years 2 years ’ experience writing complex SQL queries and performing data analysis - Highly desired At least 2 years ’ experience with Oracle Version 11g - Highly desired 1 year experience using Microsoft SharePoint - Highly desired 1 year experience using SCRUM Agile development methodologies - Highly desired 1 year experience with Microsoft Team Foundation Server - Highly desired Excellent verbal communication skills (to be rated at onsite interview - Highly desired Goals-oriented proactive team player with the ability to multi-task and prioritize technical tasks in a fast-paced, professional environment.
  • Highly desired Bachelor ’s degree or higher in Computer Science or related field - Highly desired

Excel Management Systems, Inc. - 17 months ago - save job - block
About this company
EFITS delivers a variety of field-based IT services using EXCEL's 4-R Service Delivery System. This provides clients with the Reach, Range,...