We are looking for a Data Modeler for a long-term contract for a client of ours in RTP, NC. Skill Summary: Database Design Methods: Develop structural designs for Oracle databases based upon logical data models Develop and design Oracle databases as well as create data models to guide off-shore development of physical models Performed physical database design like table structures, join indexes, primary indexes, secondary indexes, PPI, collect stats and data skew Determine user requirements as well as sets up and tests Oracle databases Worked closely with system users to make sure that the database information system strategies meets with the program requirements Data Analysis: Extensive experience with database technology spanning relational, dimensional, and legacy technologies. Experience as a database designer, modeler, and/or analyst. This includes related experience with extraction transformation and load methods, data cleansing and validation, data integration, data flow modeling, and other complementary skills. Software Development: Full SDLC experience and demonstrated experience on the delivery of enterprise level Oracle databases, in support of application development teams. Good knowledge of database analysis and design, UML, and software development methodologies. Client/server, Web applications, and scientific / mathematical applications. Systems, Languages & Tools: Experience with Visual Modeling Tools: For example : ERWin, DBDesigner; Artisan Real Time, Poseidon, and other UML modeling tools. Programming Languages: SQL Database: MS Access, Oracle, ODBC, JDBC, ETL - OLTP (Online Transaction Processing) data modeling (logical / physical) - Communication / “team player” (needs to work with analysts, architects, DBA’s – some local, some remote) - Oracle Later on, this person may well need to design OLAP / reporting data models as well. The immediate need is for transactional system modeling – some later phases will likely get into reporting / analysis models as well. Keywords: Data Warehouse Architecture
Related projectsSearch for freelance jobs
can’t wait for more clients
and advertising. Thank you."