Post Date: 05/31/2019
Close Date: 06/20/2019
Salem / Labor & Industries Building - DCBS
Initial Posting Date:
Department of Consumer & Business Services
$5,293 - $7,644
Application Database Administrator/Architect (Information Systems Specialist 7)
To protect and serve Oregon's consumers and workers while supporting a positive business climate.
The Department of Consumer and Business Services (DCBS) is a progressive business regulatory state agency dedicated to the mission of protecting and serving Oregon's consumers and workers while supporting a positive business climate. The department administers state laws and rules governing workers' compensation, occupational safety and health, financial institutions, insurance companies and building codes. The department has consumer protection and education programs, offices, and ombudsmen to help consumers, injured workers, and businesses.
This position is with the Information Technology and Research (IT&R) Section of the Central Services Division. IT&R provides a broad range of specialized technical services in the areas of information systems, data analysis/dissemination, and computer/telecommunication services for a large, diverse agency. The staff support the collection, processing, analysis, and dissemination of statewide and regional data about workers' compensation, accident prevention, insurance, financial institutions, corporate securities, building codes, and senior health insurance benefits. The section supports a number of critical systems to meet the regulatory requirements for each program and interact with other state and federal agencies.
This position is represented by the Service Employees International Union (SEIU).
What’s in it for you:
Rewarding work in a collaborative and stable environment
Colleagues who are passionate about public service
Work/life balance, 10 paid holidays a year, and a competitive benefits package
Here’s what you will do:
The successful candidate will serve as the agency’s Application Database Administrator and Database Architect. Unlike other DBA roles, DCBS has a System DBA who takes care of all the physical elements of database management. This is not a 24/7 support role; there is occasional off-hours work to support system upgrades or maintenance.
Provide technical expertise and support in the use of database technology for applications that are critical to DCBS
Own, track, and resolve database related incidents and requests
Design and implement new databases or make changes to existing databases
Coordinate and facilitate integration of applications with existing databases
Train, review, and mentor IT&R staff on database modeling, design, and PL/SQL & SQL programming
Initiate, plan, and execute IT projects of small and medium size and complexity under the guidance and direction of manager, PMO manager, or project manager
Here’s what you need to qualify:
Six (6) years of information systems experience providing technical expertise and support in the use of database technology for applications;
An Associate's degree in Computer Science, Information Technology, or related field, OR completion of a two (2) year accredited vocational training program in information technology or related field; AND four (4) years of information systems experience providing technical expertise and support in the use of database technology for applications;
A Bachelor's degree in Information Technology, Computer Science, or related field AND two (2) years of information systems experience providing technical expertise and support in the use of database technology for applications;
A Master's degree in Information Technology, Computer Science, or related field.
Knowledge of relational database theory
Knowledge of project management principles
Experience in information systems analysis and design
Experience in relational database design
Experience using Oracle RDBMS
Experience programming in SQL and PL/SQL
Excellent verbal and written communication skills
You must clearly demonstrate in your application and application materials that you meet the qualifications listed. Failure to provide this information may result in not being considered further.
How To Apply:
To apply for this position, click on the "Apply" button to fill out the online application and complete the questionnaire.
A resume and cover letter are required for this position. Please attach both documents to the “My Experience” section under Resume/CV in the application.
Only complete applications received by the posted application deadline date will be considered.
After you apply:
Log in to your Workday account before the job announcement closes to see if you have any pending tasks or actions. These can be found under the “My Applications” section.
Make sure to complete these tasks or actions before the job announcement closes.
Be sure to check both your email and Workday account for updates regarding this recruitment.
As part of the application selection process, you may be asked to complete a skills assessment or submit a writing sample.
Employment will be contingent upon passing a criminal background check.
Eligible veterans who meet the qualifications will be given veterans' preference. For further information, please see the following website: Veterans Resources. You may also call the Oregon Department of Veterans' Affairs at 1-800-692-9666. NOTE: If claiming veteran’s preference please be sure to check your Workday account for pending tasks or actions under your “My Applications” section.
The Department of Consumer and Business Services does not offer VISA sponsorships. Within three days of hire, you will be required to complete the US Department of Homeland Security's I-9 form confirming authorization to work in the United States.
Helpful Links And Contact Information:
Learn more about DCBS
Understanding the State Application Process
Help & Support webpage
Learn more about Oregon
For additional information you may contact us by e-mail at DCBS.Recruiting@oregon.gov or by phone at 503-378-3200.
DCBS is an equal opportunity, affirmative action employer committed to workforce diversity.
Oregon state government is a large organization by nearly any standard. With over 40,000 employees working all over the state, in small communities and large, we are proving that government can be innovative.
We work as a team, challenging ourselves to be better, faster and more efficient with taxpayer dollars.
After all, when every day we are responsible for caring for the needs of a diverse population and thriving business community, we simply must have the best and brightest workforce. If you take responsibility for your actions, are passionate about helping others succeed, and have a reputation for excellence and honesty, why not make Oregon state government your next career move?
Joining our team means you open the door to many possibilities. From entry level to executive, outdoor work to policy setting, we have a role for nearly every calling, expertise and background.
If you’re looking at us from across the country (or beyond!), know that Oregon is one of the most beautiful places on earth. Made up of seven diverse regions, Oregon has the ocean, mountains, valleys, high desert, cities, small towns, and almost everything in between.
Oregon “flies with her own wings.”
Complete details: https://oregon.wd5.myworkdayjobs.com/en-US/SOR_External_Career_Site/job/Salem--Labor--Industries-Building---DCBS/Application-Database-Administrator-Architect--Information-Systems-Specialist-7-_REQ-11567?fbclid=IwAR22upvNuYJ8PgTm_wXC6hdHO4MLuARfmJvDeH