Database Analyst - (SQL Developer) - Capleo Global
Salem, OR
About the Job
Job Title: Database Analyst - (SQL Developer)
Location: Remote
Duration: 6 Months
Description:
Maintains data storage and access by evaluating, designing and implementing company database[s].
Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
Writes codes for database access, modifications and constructions. Relies on established guidelines and instructions to perform daily job functions.
Works under immediate supervision and usually reports to a manager. May require a bachelor s degree in a related area and 0 2 years of relevant experience.
Required skills and experience:
Microsoft Azure Development Operations
Microsoft SQL Server/Reporting Services/Business Intelligence (7-9 years of experience)
Microsoft Visual Studio (10+ years of experience)
Microsoft .NET framework (4-5 years of experience)
HTML Customer (7-9 years of experience)
Windows 9x/2000/XP/NT/Vista/7 (7-9 years of experience)
Design patterns (7-9 years of experience)
Transact-SQL (10+ years of experience)
Data Analysis (10+ years of experience)
JSON (10+ years of experience)
SQL (10+ years of experience)
MVC (4-6 years of experience)
XML (4-6 years of experience)
C# (4-6 years of experience)
HTML (4-6 years of experience)
JavaScript (4-6 years of experience)
TCP/IP (4-6 years of experience)
Communication skills both verbal and written (4-6 years of experience)
Microsoft Office (4-6 years of experience)
In addition, the ideal candidate will have skills and experience in:
Software development life cycle especially related to the impact from requirement changes.
Agile Software Development Process
Requirements elicitation and specification in collaboration with non-technical Business Analysts and non-technical CW business program staff.
Modernization initiatives targeting specific technology changes or generational changes in Federal program regulations.
Working to deliver technical solutions in a County, State or Federal Human Services context.
Managing the impact of database changes on external data exchanges or date warehouses
Apache (1-3 years of experience)
SOAP (1-3 years of experience)
Angular (1-3 years of experience)
Erwin (1-3 years of experience)
ASP (4-6 years of experience)
Service oriented architecture (SOA) (4-6 years of experience)
XMLDOM (4-6 years of experience)
XMLSchema (4-6 years of experience)
ADO.NET (4-6 years of experience)
AJAX (4-6 years of experience)
DHTML (4-6 years of experience)
CSS (4-6 years of experience)
Microsoft Exchange Server (4-6 years of experience)
WSDL (4-6 years of experience)
PL/SQL (4-6 years of experience)
ASP. NET (4-6 years of experience)
VBScript (4-6 years of experience)
XHTML (4-6 years of experience)
XSL (4-6 years of experience)
XSLT (4-6 years of experience)
Shell (4-6 years of experience)
Backup and recovery (4-6 years of experience)
Active Directory (4-6 years of experience)
IIS (4-6 years of experience)
Microsoft Internet Information Server (IIS) (4-6 years of experience)
IBM WebSphere (4-6 years of experience)
Microsoft Visual Studio .NET (4-6 years of experience)
Location: Remote
Duration: 6 Months
Description:
Maintains data storage and access by evaluating, designing and implementing company database[s].
Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
Writes codes for database access, modifications and constructions. Relies on established guidelines and instructions to perform daily job functions.
Works under immediate supervision and usually reports to a manager. May require a bachelor s degree in a related area and 0 2 years of relevant experience.
Required skills and experience:
Microsoft Azure Development Operations
Microsoft SQL Server/Reporting Services/Business Intelligence (7-9 years of experience)
Microsoft Visual Studio (10+ years of experience)
Microsoft .NET framework (4-5 years of experience)
HTML Customer (7-9 years of experience)
Windows 9x/2000/XP/NT/Vista/7 (7-9 years of experience)
Design patterns (7-9 years of experience)
Transact-SQL (10+ years of experience)
Data Analysis (10+ years of experience)
JSON (10+ years of experience)
SQL (10+ years of experience)
MVC (4-6 years of experience)
XML (4-6 years of experience)
C# (4-6 years of experience)
HTML (4-6 years of experience)
JavaScript (4-6 years of experience)
TCP/IP (4-6 years of experience)
Communication skills both verbal and written (4-6 years of experience)
Microsoft Office (4-6 years of experience)
In addition, the ideal candidate will have skills and experience in:
Software development life cycle especially related to the impact from requirement changes.
Agile Software Development Process
Requirements elicitation and specification in collaboration with non-technical Business Analysts and non-technical CW business program staff.
Modernization initiatives targeting specific technology changes or generational changes in Federal program regulations.
Working to deliver technical solutions in a County, State or Federal Human Services context.
Managing the impact of database changes on external data exchanges or date warehouses
Apache (1-3 years of experience)
SOAP (1-3 years of experience)
Angular (1-3 years of experience)
Erwin (1-3 years of experience)
ASP (4-6 years of experience)
Service oriented architecture (SOA) (4-6 years of experience)
XMLDOM (4-6 years of experience)
XMLSchema (4-6 years of experience)
ADO.NET (4-6 years of experience)
AJAX (4-6 years of experience)
DHTML (4-6 years of experience)
CSS (4-6 years of experience)
Microsoft Exchange Server (4-6 years of experience)
WSDL (4-6 years of experience)
PL/SQL (4-6 years of experience)
ASP. NET (4-6 years of experience)
VBScript (4-6 years of experience)
XHTML (4-6 years of experience)
XSL (4-6 years of experience)
XSLT (4-6 years of experience)
Shell (4-6 years of experience)
Backup and recovery (4-6 years of experience)
Active Directory (4-6 years of experience)
IIS (4-6 years of experience)
Microsoft Internet Information Server (IIS) (4-6 years of experience)
IBM WebSphere (4-6 years of experience)
Microsoft Visual Studio .NET (4-6 years of experience)
Source : Capleo Global