Data Architect - Columbia, SC + Remote

Peer Solutions Group, Inc.

We are currently hiring a Data Architect who will 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 &/or provide directions for others Generate anomaly reports for others to act upon 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; scheduled migration update Assist other DB staff with similar duties Document tasks and provide up-to-date status through the project collaboration tools Assist and develop SQL views for forms and reports Location : Columbia and Remote (Must be in commutable distance to the office for attending meetings) Duration : 5 months with possibility of extn. Employment type: W2 only. Corp-to-Corp and/or 1099 is not allowed REQUIRED SKILLS Accounting & Financial knowledge & experience in connection with DB and application development Database experience (5 years min.) of at least two (2) databases Postgres MySQL Sybase Other Database tools, at least one of the following (1-year min.) ER/Studio MySQL Workbench TOAD or equivalent Experience implementing up-to-date industry standard procedures and schemas for the majority of the following: Naming conventions Revising DB schemas for consistent use of terminology, naming, etc. Update history Logging HIPAA compliance Security and access control Data exchange protocols Cross platform integration Strong knowledge and use of SQL; multi table JOINS, functions, procedures, triggers, etc. Experience creating SQL views for the foundation of reports and forms; Rollback/Commit; anticipate needs of coders/programmers 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 available PREFERRED SKILLS : Additional Database tools experience; e.g. Datanamic tool Suite ER/Studio, Erwin, etc. Experience with Data Governance and related documentation requirements Database experience Sybase PostgreSQL MS Access; MS SQL Server MongoDB (document DB, nice bonus) Neo4j (Graph DB, nice bonus) Experience with Platforms as a Service (PaaS) and Software as a Service (SaaS) Data transfers, APIs, etc. Data integration across systems Knowledge of container technology Survey application DB schema with update history capacity Open Source development experience; e.g., Python, PHP, JavaScript, & other Web coding Experience with disconnected (store & forward) database applications REQUIRED EDUCATION : Bachelor of Science; BA may be considered REQUIRED CERTIFICATIONS: NONE About Peer Solutions Group, Inc. Peer Solutions Group, a full-service, Minority Certified (MBE) IT Services company founded by professionals with hands on experience in Staffing, Recruiting, Project Management, Technology and Consulting. Since the past 10+ years, we have helped our customers strengthen their competitive advantage, reduce operational costs, and improve efficiency by providing our P ersonalized E ffective E fficient R eliable services with integrity, intellectual growth, quality, respect and positive thinking. Our core capabilities include but are not limited to: Robotic Process Automation (RPA) Business Process Analysis, Re-engineering and Automation Cyber Security Consulting Project Management Consulting Custom Application Development/Programming IT Staffing - Contract & Permanent Peer Solutions Group is an Equal Opportunity Employer and is committed to providing the right opportunities for the right people. We have a culture of entrepreneurship and innovation where our employees can make a difference. We are looking for like-minded, dynamic individuals to come and join our rapidly expanding team. - provided by Dice

Data Architect, RDBMS, SQL, Postgres, MySQL, ER Studio, MySQL Workbench, TOAD

View this job on