Hi Partners,
Greetings,
Hope you are doing Well!!!!!!!!!!!!!!!
Please forward a profiles to shankar@techconsultinc.com
Here are the requirement details
SCOPE OF THE PROJECT:
This work is part of the start-up phase of overlapping information system projects.• Identify and map existing data / information systems
• Create data schema of existing databases in Database Design software; e.g., Toad, CA, etc.
• Develop new DB Schema and physical DB for new Information System
DAILY DUTIES / RESPONSIBILITIES:
Responsible for the overall design of the enterprisewide data/information architecture, which maps to the enterprise architecture and balances the need for access against security and performance requirements. Knowledgeable in most aspects of designing and constructing data architectures, operational data stores, and data marts. Focuses on enterprisewide data modeling and database design. Defines data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and applies accepted data content standards to technology projects. Facilitates consistent business analysis, data acquisition and access analysis and design, Database Management Systems optimization, archiving and recovery strategy, load strategy design and implementation, security and change management at the enterprise level. May require an associate's degree in a related area and 0-1 years of experience in the field or in a related area.
SCOPE OF THE PROJECT:
This work is part of the start-up phase of overlapping information system projects.
• Identify and map existing data / information systems
• Create data schema of existing databases in Database Design software; e.g., Toad, CA, etc.
• Develop new DB Schema and physical DB for new Information System
DAILY DUTIES / RESPONSIBILITIES:
Work with team to
• Document existing Database(s)
• Document, cull, and generate schema from current database(s) using SQL and DB tool(s)
o Clean and validate data
o Generate anomaly reports for others to act upon
o Combine, consolidate, and redistribute DBs to provide a consistent data source to currently disconnected (identical) DBs
• Analyze, design and document updated DB schema with industry standard features and create a map from current to new DB
• Design, implement and test migration from current DB to the new DB
• Document tasks and provide up-to-date status through the project collaboration tools
• Assist and develop SQL views for forms and reports
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Database experience (2 years min.) with databases; with special interest in
o MySQL
o MS Access
• Database tools experience; e.g.
o MySQL Workbench
o TOAD
o or equivalent
• Experience implementing up-to-date industry standard procedures and schemas for at least some of the following:
o Naming conventions
o Revising DB schemas for consistent use of terminology, naming, etc.
o Update history
o Logging
• Good knowledge and use of SQL; multi table JOINS, functions, procedures, triggers, etc.
• Experience creating SQL views for the foundation of reports and forms
• Excellent listening and communication (written & verbal) skills; ability to discuss and present information logically and concisely
• Ability to work individually and as part of a team. Willing to share knowledge & experience with others
• Flexible problem solver; use of previous knowledge & experience, yet open to alternative methods when made
PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Additional Database tools experience; e.g.
o Datanamic tool Suite
o ErWin, etc.
• Experience implementing up-to-date industry standard procedures and schemas for the following:
o HIPAA compliance
o Security and access control
o Data exchange protocols
o Cross platform integration
• Survey application DB schema with update history capacity
• Open Source development experience; e.g., PHP and/or JavaScript coding
• Experience with disconnected (store & forward) database applications
• Experience with Data Governance and related documentation
REQUIRED EDUCATION/CERTIFICATIONS:
Bachelor of Science; BA may be considered
PREFERRED EDUCATION/CERTIFICATIONS
Looking forward to hearing from you at the earliest!!!
Regards
Shankar
Professional Recruiter
33505 State Street, Suite # 200 Farmington, MI 48335
V (248)-522-6879
F (248)-579-4454
Linkedin: www.linkedin.com/in/shkrajan
Email : Shankar@techconsultinc.com
Messanger: shankarraj001@yahoo.com
Minority Certified and Woman Owned Enterprise
TCI- Technology Consultants inc
Note: It is not a solicitation attempt!!!
You received this message because you are subscribed to the Google Groups "ASP._NET_jobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to asp_net_jobs+unsubscribe@googlegroups.com.
To post to this group, send email to asp_net_jobs@googlegroups.com.
Visit this group at https://groups.google.com/group/asp_net_jobs.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment