Data Architect

Data Architect

Job Code: 1161
Job Location: Woonsocket, Rhode Island
Zip Code: 02895
Job Category/Title: Architect
Employment Category: Contract - Corp-to-Corp, Contract - Independent, Contract - W2
Position Type: Mid Level
Travel Required: No
Interview Type: In-person
Education: Associate Degree
Experience: 3-5 year(s)
Job Description: Mandatory Technical / Functional Skills :

• Strong RDBMS concepts
• Good knowledge of application layers, modeling techniques
• Hands-on experience with designing object-oriented components
• Understanding of database concepts
• Experience with Oracle database/Architecture (10g, 11g)
• Data modeling experience with knowledge of normalization/de-normalization (preferably with CA Erwin )
• Expert in creation of conceptual/logical/physical data models.
• Exposure to UML objects modeling concepts.
• Work experience in presentation tools like excel,ppt,visio,mpp.

Roles and responsibility:

• Will be involved in all aspects of the project life cycle, from the requirements analysis, design, and implementation and testing.
• Design and development of separate modules based on object oriented paradigm.
• Refactoring of existing module to make an extensible system.
• Be the focal point for all data model related changes.
• Perform SQL certification wherein and SQL change needs to be certified.
• Being part of all production issues and providing inputs wherever applicable.
• Perform Data model creation from scratch for newer projects.(From conceptual to physical structure)
• Responsible to perform half-yearly or quarterly sanity check of production environment from db object and PSQL code perspective.
• Maintaining a regular check on data replication performance issues in production.
• Need to work closely with offshore team to guide them through the low level design
• Need to provide consultation wherever required during development and also need to validate the code.
• Sound knowledge of replication methodologies provided by Oracle like MV, Data guard, Streams, Golden Gate, CDC etc.
• Sound knowledge of PLSQL concepts mainly from query tuning perspective. (Usage of hints, best practices etc)
• Good Communication skills, interpersonal skills and analytical skills.
• Work closely with Development team and DBAs.
Duration: 6 Month(s)
No. of Posts: 1
Job Expiry Date: March 11, 2016
Telecommute: No
Contact Information Login To View