Innovations technological

Location: Woonsocket, RI
Duration: 12+ months
Role :- Application Data Architect

Mandatory Technical / Functional Skills

- 8+ years with at least 2 years as Data Architect
- 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.
- Experience in RAC/ASM implementation for multi node architecture.
- Knowledge of database tuning including table/index partitioning concepts.
- 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)
- ETL (Data Extract/ Transform and Load) and  Batch Data Processing knowledge.
- Exposure to UML objects modeling concepts.
- Work experience in presentation tools like excel,ppt,visio,mpp.

Roles and responsibility

1. Will be involved in all aspects of the project life cycle, from the requirements analysis, design, and implementation and testing.
2. Design and development of separate modules based on object oriented paradigm.
3. Refactoring of existing module to make an extensible system.
4. Be the focal point for all data model related changes.
5. Perform SQL certification wherein and SQL change needs to be certified.
6. Being part of all production issues and providing inputs wherever applicable.
7. Perform Data model creation from scratch for newer projects.(From conceptual to physical structure)
8. Responsible to perform half-yearly or quarterly sanity check of production environment from db object and PSQL code perspective.
9. Maintaining a regular check on data replication performance issues in production.
10. Need to work closely with offshore  team to guide them through the low level design
11. Need to provide consultation wherever required during development and also need to validate the code.

Desirable Technical / Functional Skills

Work with different teams – Business, Solutions – BI, team of Architects, provide solutions with complete considerations on Infrastructure capability, performance, supportability to achieve end user business results, 1. Exposure to multiple, diverse technical configurations, technologies, and processing environments, Excellent planning and organizational skills, Understands the business, business drivers, and business strategy, 5. Understands system analysis and synthesis, modeling, conceptualization, Proactive – Identifies problem areas and opportunities and makes recommendations, Exceptional interpersonal skills, team player and team builder, Strong facilitation and negotiation skills , Persuades & communicates effectively.

Thanks and Regards

Prateek Jain

Email:prateek@sysmind.com

Phone:609 897 9670 Extn 2183

Fax: 302-269-7171

Address: 38 Washington Road, Princeton Junction, NJ 08850

Gtalk :- prateekjain.ramy

Yahoo Id :- prateekjain_ramyinfo