Job Details
Position: | Database Analyst (Ref: 17406) |
---|---|
Location: | Salem, OR 97302 USA |
Duration: | 1 Years 1 Months 22 Days - Contract |
Openings: | 1 |
Deadline: | 05/14/2025 |
Pay Rate: | Login |
Description:
***Local Candidates***Hybrid
We are seeking an experienced Database Analyst with expertise in designing and developing Microsoft SQL Server data structures, optimizing interactions with and within the database (SQL, stored procedures, ETL, etc.), in accordance with business, data security and regulatory requirements as well as legislative mandates and court findings.
This work will continue fulfilling planned items from previous years and continue to support the Transformation strategies including data quality initiatives and the emerging transition to data-oriented decision making.
The candidate will also work with various program areas and business teams to deliver strategic roadmap components to execute data modernization efforts, fulfill legislative mandates and comply with court findings.
The candidate will participate in executing the strategic direction for use of data to support programmatic and administrative functions. The candidate will provide expertise in the planning efforts to identify and modernize the agency’s data assets and to develop the future state technical environment.
Tasks:
• Develop database structure and process changes based on specifications established during weekly Sprint planning sessions and following data standards based on existing datatype standards where available and appropriate; address standards published by the United States Postal Service as an example.
• Comply with data security and access models.
• Comply with Federal regulations for design, development, deployment and maintenance.
• Follow a data (or database) change request process with the developer and Data Resource Management teams.
• Microsoft SQL Server/Reporting Services/Business Intelligence
• HTML DOM
• Windows 9x/2000/XP/NT/Vista/7
• Transact-SQL (10+ years of experience)
• Microsoft Visual Studio
• Microsoft .NET framework
• Microsoft Azure Development Operations
• MVC (4-6 years of experience)
• Data Analysis
• JSON
• SQL
• MVC
• XML
• C#
• HTML
• JavaScript
• TCP/IP
• Communication skills both verbal and written
• Microsoft Office
• 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 business program staff.
• Modernization initiatives targeting specific technology changes or generational changes in Federal program regulations.
• Managing the impact of database changes on external data exchanges or date warehouses
Required / Desired Skills
- Microsoft .NET Framework (Required 4 Years)
- MVC (Required 4 Years)
- Service oriented architecture (SOA) (Required 4 Years)
- SOAP (Required 1 Years)
- XMLDOM (Required 4 Years)
- XMLSchema (Required 4 Years)
- ADO.NET (Required 4 Years)
- Data Analysis (Required 4 Years)
- Microsoft SQL Server (Required 10 Years)
- Transact-SQL (Required 4 Years)
- AJAX (Required 4 Years)
- CSS (Required 7 Years)
- HTML DOM (Required 4 Years)
- Microsoft Exchange Server (Required 4 Years)
- C# (Required 4 Years)
- HTML (Required 4 Years)
- JavaScript (Required 10 Years)
- JSON (Required 4 Years)
- PL/SQL (Required 10 Years)
- SQL (Required 4 Years)
- VBScript (Required 4 Years)
- WSDL (Required 4 Years)
- XHTML (Required 4 Years)
- XML (Required 4 Years)
- XSL (Required 4 Years)
- XSLT (Required 4 Years)
- TCP/IP (Required 4 Years)
- Windows 9x/2000/XP/NT/Vista/7 (Required 7 Years)
- Shell (Required 4 Years)
- ERwin (Required 1 Years)
- Angular (Required 1 Years)
- Apache (Required 1 Years)
- ASP (Required 4 Years)
- ASP.NET (Required 4 Years)
- Backup & Recovery (Required 4 Years)
- Communication skills both verbal and written (Required 4 Years)
- Active Directory (Required 4 Years)
- IBM WebSphere (Required 4 Years)
- IIS (Required 4 Years)
- Microsoft Internet Information Server (IIS) (Required 4 Years)
- Design patterns (Required 7 Years)
- Microsoft Visual Studio .NET (Required 4 Years)
- MicrosoftOffice (Required 4 Years)
- Visual Studio (Required 10 Years)
copyright @ www.ProfessionalTechIntegration.com.2011 All rights reserved