Previous Job
Previous
Database Administrator III
Ref No.: 17-25511
Location: Salem, Oregon
Direct Client Req  Direct Client Req  Database Administrator III
Location : 355 Capitol Street NE Salem Oregon    97301
Duration : 7+ months
Client : State of Oregon
Dept: ODOT
job code id : 730-29073W174-17
Shift 1 8:00 AM -5:00 PM
Interview Type: Phone + Skype for non locals
 
Years of Experience : 15-20 years experience
 
NOTE KEY TO THE ROLE :
Ideal Candidate is IBM DB2 Developer & Administrator  with Mainframe ZOS  environment
With Strong MS SQL Skills
Minimal Oracle Relational Database Experience from previous
Who will work in .net Environment
 
Description :
Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the company database. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues. May require a bachelor's degree in a related area and at least 6 years or equivalent experience in the field or in a related area. Familiar with advanced concepts, practices, and procedures within a particular field. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. A certain degree of creativity and latitude is required.
 The purpose of this request is to procure a Database Administrator for ODOT Information Systems(Enterprise Data Management Area). The general tasks the contractor will perform are as follows:  
 Software (Operations)
  • Coordinate, for the supported ODOT business area, the installation of vendor-developed and ODOT built software, which may be new to ODOT. In some cases, new installation of software may impact systems external to ODOT.
  • Support distributed systems within multiple sites/branches.
  • Ensure version compatibility between new releases of supported business application data and current operating environments.
  • Contact multiple vendors regarding data-related problems and resolve or escalates problems as needed; coordinate with vendors, external agencies, customers and IS to schedule resources to implement solutions.
  • Analyze and identity corrupt or problematic data issues for mission critical system; evaluate and execute actions to resolve errors as needed.
Assess compatibility issues and recommends options for system upgrades.
 Software (Customer Assistance)
  • Respond to system crashes that are critical to the agency and/or other State agencies. These systems maybe time critical, support reporting of regulatory requirement, and/or public safety. Solving the problem usually requires a high level of coordination with other IS staff, vendors and involves situations requiring conflict resolutions and/or negotiating the resolution process.
Provide technical assistance and/or develop and deliver formal training to customers, developers, project managers and system analysts.
 Software (Construction)
  • Perform business analysis and requirements-gathering that will automate current, new or changing/re-engineered business processes. This may include conducting joint application development sessions with other section personnel and user representatives.
  • Responsible for overall development, performance and maintenance of physical models of relational databases
Consider system features, configuration, and compatibility and performance issues to recommend business operation changes to effectively use system data resources.
 Data (Operations)
  • Develop and manage relational databases, as well as VSAM files. They may be multiple, distributed databases.
  • Maintain relational integrity of Agency databases. This includes, but is not limited to the constraints, linked tables and consistency.
  •  
  • Make recommendations on performance tuning, considering the cost, specifications, and organizational policies on expansion.
Establishes and enforces data security policy definition and administration.
·       Strong technical background in Database Administration fundamentals (Mandatory)
·       Strong technical background in Mainframe ZOS IBM DB2 (Mandatory)
·       Strong technical background in Microsoft Sql Server (desireable)
·       Some awareness of Oracle Database administration
·       Ability to communicate clearly verbally and in writing. (Mandatory)
·       Demonstrated capability to interact with customers, clearly understand customer needs and document those needs. (Mandatory)
·       Ability to work in a close knit Database team environment
·       Strong customer service ethic