Previous Job
Previous
Data Architect V
Ref No.: 15-00302
Location: Salem, Oregon
Oregon State Treasury (OST)
5+ Months

Oregon State Treasury (OST) is seeking a database administrator/analyst to act as the agency's primary data resource while we recruit a long-term candidate for the position.
 
The Oregon State Treasury fulfills the functions of commercial and investment banks for State agencies and local governments.  Treasury seeks to provide the highest value to taxpayers by protecting public funds and earning strong investment returns – and by being an efficient, transparent, and accountable organization.


The person in this position will review existing documentation, databases, and related activities to gain an understanding of the current database environment.  They will use this understanding to provide database administration support to production operations and ongoing projects.  


This position will also provide data analysis services to create data models, dictionaries, catalog data interfaces, and provide related information to aid in decision-making for production support and project direction.


Sample related tasks include:

 
  • Work with stakeholders to ensure data integrity, accessibility and security of Treasury data.
  • Resolve database-related issues in production and development environments.
  • Plan and implement measures to ensure database capacity and performance to ensure service delivery expectations are met.
  • Design, install, configure, support and optimize databases and associated environments.
  • Review current processes and update as needed to ensure reliable database backup and recovery.
  • Create and maintain documentation of database configurations and monitor other technical staff as needed to assure adherence to policies.
  • Advise application development staff and other stakeholders on database-related matters.
  • Participate in the resolution of critical and complex data-related design and implementation issues across projects.
  • Review and modify or develop scripts for routine administrative function to eliminate manual intervention.
  • Implement new database software, modifications, patches and full scale upgrades in an optimal manner without adverse effects on current production and development activities.
  • Conduct and document data analysis to identify data source, transformation, and destination.Create data models, dictionaries, and other representations to aid in decision-making.
  • Recommend improvements in data-related standards and practices.Aid in the implementation of recommended improvements.


 


Treasury's database platform is Microsoft SQL Server in a Windows environment.  Applications are written in C#.Net and Powerbuilder.      


This position will work alongside application developers, network and other technical staff to ensure the reliable operation of OST financial services, conduct data analysis activities, and complete projects.  The position may also work directly with business users, software or other vendors, and other stakeholders as needed. 
 
Qualifications
  Type   Qualification   Description   Competency   Experience   Required  
  Skills   C#               No  
  Skills   Data Analysis       Advanced       No  
  Skills   Data Modeling       Advanced       Yes  
  Skills   Microsoft SQL Server       Expert       Yes  
  Skills   Microsoft Visual Studio .NET       Advanced       No  
  Skills   SQL       Expert       Yes  
  Skills   Sybase PowerBuilder