Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Data Architecture Expertise Implementation Analyst
(Jobs in Columbia, SC)
 
Requirement id 58965
Job title Analyst
Job location in Columbia, SC
Skills required MS SQL, MySQL Experience, Financial Systems, Data Architecture Expertise Implementati
Open Date 30-Jan-2017
Close Date
Job type Not specified
Duration 3 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Analyst: MS SQL, MySQL Experience, Financial Systems, Data Architecture Expertise Implementati

Start Date : 02/13/2017
Submission Deadline : 02/08/2017
Client Info : Lieutenant Governors Office
Description :

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
• 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
• 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

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):

• Accounting & Financial knowledge & experience in connection with DB and application development
• Database experience (5 years min.) of at least two (2) databases
o MySQL
o MS SQL Server
o Other
• Database tools, at least one of the following (1-year min.)
o MySQL Workbench
o TOAD
o or equivalent
• Experience implementing up-to-date industry standard procedures and schemas for the majority of the following:
o Naming conventions
o Revising DB schemas for consistent use of terminology, naming, etc.
o Update history
o Logging
o HIPAA compliance
o Security and access control
o Data exchange protocols
o 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

• 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 (RANK IN ORDER OF IMPORTANCE):

• Additional Database tools experience; e.g.
o Datanamic tool Suite
o ErWin
• 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
• Database experience
o Sybase
o MS Access
• Experience with Platforms as a Service (PaaS) and Software as a Service (SaaS)
o Data transfers
o Data integration across systems
• Experience with Data Governance and related documentation requirements

REQUIRED EDUCATION/CERTIFICATIONS:
Bachelor of Science; BA may be considered

PREFERRED EDUCATION/CERTIFICATIONS:
Master of Science or PhD
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 58965 while calling.
 
Other jobs in SC: Beaufort (1), Blythewod (2), Blythewood (3), Charleston (17), Columbia (37), Greenville (4), Hartsville (2), North Charleston (2), Overland Park (1), San Francisco (1), SENECA (4), South Carolina (1), Spartanburg (3), Unknown (2),
MS SQL job openings in Columbia, SC
Jobs List

WEB/INTERNET ENGINEER-CONSULTANT - 11412-1
Create date: 15-Oct-2024
No of Submissions :

Start date : 11/2/2024

Submission deadline : 10/22/2024

Client Info : (EXP 6.30.2024) Health & Environmental Control Department (DHEC)

Note :

Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

A) An interview panel will cond.... (This job is for - Workflow Jobs in SC COLUMBIA Consultant - (in Columbia, SC))

DATABASE DEVELOPER (SQL) - ADVANCED - 11345-1
Create date: 21-Aug-2024
No of Submissions : 2

Start date : 9/23/24

Submission deadline : 8/28/2024

Client Info : Department of Transportation

Note:

Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)?

A) PHONE

Q) INTERVIEW AVAILABILITY: How soon can you schedule an in.... (This job is for - Tuning Jobs in SC COLUMBIA Developer - (in Columbia, SC))

SYSTEMS SOFTWARE PROGRAMMER - ADVANCED - 11326-1
Create date: 06-Aug-2024
No of Submissions : 2

Start date : 9/2/2024

Submission deadline : 8/15/2024

Client Info : Department of Juvenile Justice

Note:

Q) INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)?

A) INTERVIEWS WILL BE CONDUCTED IN PERSON WITH AN INTERVIEW PANEL O.... (This job is for - job Jobs in SC Columbia Consultant - (in Columbia, SC))

DATABASE DEVELOPER (SQL) - ADVANCED - 11297-1
Create date: 18-Jul-2024
No of Submissions : 2

Start date : 8/05/2024

Submission deadline : 7/27/2024

Client Info : Department of Transportation

Note:

Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)?

A) PHONE

Q) INTERVIEW AVAILABILITY: How soon can you schedule an i.... (This job is for - SQL Jobs in SC COLUMBIA Developer - (in Columbia, SC))

DATA/INFORMATION ARCHITECT-INTERMEDIATE-11290-1
Create date: 10-Jul-2024
No of Submissions : 2

Start date : 07/29/2024

Submission deadline : 7/19/2024

Client Info : Department of Employment and Workforce

Note:

Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

A) Phone Interviews

Q) SCHEDULE INTERVIEW: Ho.... (This job is for - job Jobs in SC COLUMBIA Architect - (in Columbia, SC))
 
 MS SQL job openings in other states
Jobs List

Programmer Analyst 5 -134955
Create date: 13-Sep-2024
Bid Limit Per Vendor : 1

Start date : 10/14/2024

End Date : 09/30/2025

Submission deadline : 9/20/2024 at 10am EST.

Client Info : DOC

Note :

* Interview Process: Virtual Interview via MS Teams video. There is potential for a 2nd round interview which may be held in-person.
T SQLDatabase Admin Jobs in MI Lansing Analyst - (in Lansing, MI))

VDH T-SQL Programmer Analyst (742187)
Create date: 17-Jul-2024
No of Submissions :2

Start date :7/22/2024

End Date :06/30/2025

Submission deadline :7/22/2024

Client Info :VDH

Note:
* Hybrid
* Agency Interview Type:Web Cam Interview Only

Description :

*local candidates strongly preferred
*remote work is available now bu.... (This job is for - T SQL Jobs in VA Richmond Analyst - (in Richmond, VA))

SharePoint Administrator - SME - 130055
Create date: 06-May-2024
No of Submissions : 1

Start date : 5/20/2024

End date : 9/30/2024

Submission deadline : 5/8/2024 3:00:00 PM

Client info : MDEK12

Note :

* Onsite

Description :

The SharePoint Administrator will be responsible for .... (This job is for - job Jobs in MS Jackson Administrator - (in Jackson, MS))

Programmer/Analyst 3 - 62109
Create date: 19-Jan-2024
Start date :02/01/2024

End Date : 01/31/2025

Submission deadline : 01/23/2024

Client Info :TN AG

Position Location : Hybrid

Description :
------------------------------------------------------
75523 Job Code 75523 Analyzes functional business requirements and design specifications .... (This job is for - UX Jobs in TN Nashville Analyst - (in Nashville, TN))

COM-Programmer 5 / PR5 (724595)
Create date: 13-Nov-2023
Start date :12/04/2023

End date :06/30/2024

Submission deadline :11/15/2023

Client info :COM

Description :

Requirement Description: The candidate will be supporting The Ohio Department of Commerces Liquor Permitting Modernization project. The .... (This job is for - job Jobs in OH Columbus Consultant - (in Columbus, OH))
 
 MS SQL job openings in SC
Jobs List

Security Architect - 11168-1
Create date: 25-Mar-2024
Start date : 5/2/2024

Submission deadline : 4/1/2024

Client Info : Department of Motor Vehicles

Note :

Q) Interview Process (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

A) • Eric Crane, Security Team Manager
• In-person preferred but will be willing to accommoda.... (This job is for - job Jobs in SC Blythewood Architect - (in Blythewood, SC))

DATA ARCHITECT CONSULTANT -10996-1
Create date: 31-Oct-2023
Start date : 11/16/2023

Submission deadline : 11/2/2023

Client Info : Department of Administration

Note :

Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)?

A) Hiring manager will conduct panel interviews in person, via video conference or via phone.

Des.... (This job is for - job Jobs in SC COLA Consultant - (in COLA, SC))

PROGRAMMER - INTERMEDIATE - 10890-1
Create date: 20-Jul-2023
start date : 16 AUG 2023

End date : 12 MONTHS from the start date.

submission deadline : 7/27/2023

client info : Department of Motor Vehicles

Note :

* INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

- Teams video interviews will be used. In p.... (This job is for - job Jobs in SC BLYTHEWOOD Consultant - (in Blythewood, SC))

DATA ARCHITECT-10839-1
Create date: 25-May-2023
Start date :07/13/2023

Submission deadline :6/1/2023

Client Info :Department of Transportation

Note :

Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)?

A) TELEPHONE INTERVIEWS TO BE CONDUCTED BY James Green and/or Ani Vanadore.

1 – 2 ROUNDS OF .... (This job is for - NET FRAMEWORK Jobs in SC HQ Architect - (in HQ, SC))

PROGRAMMER-ADVANCED - 10823-1
Create date: 11-May-2023
start date : 6.8.2023

submission deadline : 5/18/2023

client info : Horry County Schools District

Note :

* INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)?

- PHONE INTERVIEW

* SCHEDULE INTERVIEW: HOW SOON CAN YOU SCHEDULE AN INTERVIEW (DATE /.... (This job is for - job Jobs in SC CONWAY Consultant - (in CONWAY, SC))
(Analyst: MS SQL, MySQL Experience, Financial Systems, Data Architecture Expertise Implementati in Columbia, SC)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us