Hi

Please let me know your interest for this position

Reply back with expected hourly rate

 

Interview Mode-Phone/Skype

 

Location: Columbia, SC

Duration: 3+ months

Rate: Open

 

Job Description

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) 

·         Clean and validate data 

·         Generate anomaly reports for others to act upon 

·         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:

Master of Science or PhD

 

Thanks
Archit
 
Archit Jain
Software People Inc.
 <mailto:[email protected]> [email protected]
Ph: 631-739-8782 © Fax: 631-574-3122
Gtalk: ajain0102

Certifications: NY MWBE, VA SWaM, DE OMWBE, MA MWBE

 

 

-- 
You received this message because you are subscribed to the Google Groups "SAP 
ABAP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sap-abap.
For more options, visit https://groups.google.com/d/optout.

Reply via email to