Database Analyst VDuration:
3 months (04/06/2015 - 07/31/2015)Location:
Salem, Oregon. Job Desc:
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.
| ||Type|| || Qualification Experience|| || || || || || || || |
| ||Skills|| ||C# ??|| || || || || || || || |
| ||Skills|| ||Data Analysis ??|| || || || || || || || |
| ||Skills|| ||Data Modeling ??|| || || || || || || || |
| ||Skills|| ||Microsoft SQL Server ??|| || || || || || || || |
| ||Skills|| ||Microsoft Visual Studio .NET ??|| || || || || || || || |
| ||Skills|| ||SQL ??|| || || || || || || || |
| ||Skills|| ||Sybase PowerBuilder ??|| || || || || || || || |
Alex Watson,Sr. IT Recruiter | Talent Acquisition Team
Direct Number: 302-356-1423 | E-mail: firstname.lastname@example.org
19 C Trolley Square, Wilmington, DE – 19806
Office: (302) 357-9017 | www.conq-tech.com Disclaimer:
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the organization. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error