SR. DATA MODELER
Location: Wilmington, Delaware
Description: The Judge Group is at present recruited SR. DATA MODELER right now, this job will be delegated in Delaware. More details about this job opportunity please read the description below. Our client is currently seeking a SR. DATA MODELER.
Required Skills:
- Minimum 7+ years’ experience modeling complex databases using 3rd party modeling tools such as ERWin 7.2
- Expe! rience designing and building large financial services data warehouses with very strong data analysis skills
- Have good knowledge of ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments.
- 5+ years of hands-on experience in data management, data warehousing, data transformation, metadata and reference data management and business intelligence tools.
- 5+ years of experience with advanced SQL query techniques using TOAD, SQL Navigator. Basic UNIX would be a Plus.
- Previous experience as a hands-on Oracle DBA of large database is a plus.
- Must have good understanding of leading 3rd party products in the relevant areas (e.g. Datastage, Business Objects, Microstrategy).
- Significant experience with System Development Life Cycle (SDLC)
- Strong communication (both written and verbal) and interpersonal skills are absolute requirements of ! this position.
- Maintains Database Naming Standards Do! cument
- Maintains all aspects of a physical model
- Generates DDL
- Adheres to company DDL software promotion procedures
- Creates indexes, partitions and other performance-oriented entities
- Ensures that physical modeling standards and naming conventions are followed
- Maintains company-wide data dictionary
- Capture business requirements and rules, design the associated Logical/Physical models, and create all required documentation to support, communicate, and validate the data model.
- Design, build and maintain the logical and physical data models to support the business requirements in a dynamic, expanding business environment.
- Map data elements of data sources into the domain data models.
- Maintain documentation of data models, including relationships, constraints and metadata.
- Publish and conduct model reviews with business and technical project! teams.
- Review database design changes with the team to determine the impact to the physical database and other systems.
- Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues.
- Participate in performance tuning activities including partitioning strategies, indexing strategies, and SQL optimization
- Architect with an eye toward high performance, scalability, and high availability.
- Understands physical design techniques
- Maintains good practical knowledge of Oracle and MS SQL Server features, data types, design performance implications
- Four year college degree with 3-5 years relevant experience.
- .
If you were eligible to this job, please give us your resume, with salary requirements and a resume to The Judge Group.
Interested on this job, just click on the Apply button, you will be redirected to the official website
This job starts available on: Wed, 03 Jul 2013 16:52:51 GMT