Database Administrator

Database Administrator

Job ID: 107063
Location: Oregon City, Oregon
Full/Part Time: Full Time
Regular/Temporary:Regular

CLACKAMAS COUNTY CORE VALUES



Clackamas County employees work to serve the public and enrich our community. In that spirit, we pledge to hold ourselves to these standards at all times in our interactions with customers and one another:

Service Professionalism Integrity Respect Individual accountability Trust

By incorporating these values into our daily routines, we can better serve our customers, ourselves and our projects. We're always looking to improve. That's the Clackamas County SPIRIT. Clackamas County Core Values

Clackamas County is committed to building a community where people thrive, have a sense of safety, connection, and belonging, so that everyone is honored and celebrated for the richness in diversity they bring. We encourage applicants of diverse backgrounds and lived experience to apply.



WHO MAY APPLY

Clackamas County does not offer visa sponsorships. Once a job applicant has accepted a position, they will be required to complete an I-9 and confirm authorization to work in the United States prior to their first day.


CLOSE DATE

This position will remain open until filled. The first application review will be Monday, July 10, 2023. We reserve the right to close this recruitment at any time on or after that date.


PAY AND BENEFITS

Annual Pay Range: $96,124.28 - $121,907.78

Hourly Pay Range: $46.213599 - $58.609515

The listed salary range reflects a 4.5% Cost of Living Adjustment (COLA) effective July 1, 2023. Salary offers will be made within the posted pay range and will be based on a candidate's experience (paid or unpaid) that is directly relevant to the position. This position is classified as an IT Administrator 2.

Clackamas County proudly offers an attractive compensation and benefits package, including competitive wages, cost-of-living adjustments, merit increases (for eligible employees), and a robust sick and vacation plan for regular status employees.

We encourage and support employee health and wellness by offering, health and wellness classes and events, and alternative care benefits, so you can customize your wellness needs to fit your lifestyle. Employee benefits become effective the first of the month following an employee's date of hire.

Attractive benefits package and incentives for employees in regular status positions are detailed below.

Generous paid time off package, including:

• 12 hours of vacation accrued per month
• 8 hours of sick accrued per month
• 10 paid holidays and 1 personal day per year

Other Benefits:

• Membership in the Public Employees Retirement System (PERS)/Oregon Public Service Retirement Plan (OPSRP):
  • Employer paid 6% PERS retirement contribution (The county currently pays the employee's share of the retirement contribution.)
  • OPSRP members get vested after five years of contributions or when they reach age 65
• A Choice of Medical Plans that include chiropractic coverage, alternative care, vision, and prescription drug coverage
• A Choice of Dental Plans
• Robust EAP and wellness programs, including gym discounts and wellness education classes
• Longevity pay
• Other retirement Savings Options that allow for additional retirement funds savings, including an option to contribute a portion of employee earnings on a pre or post-tax basis to a 457b Deferred Compensation Plan
• A variety of additional optional benefits (see links below for additional information)

This is a full time County position represented by the Employees' Association.

Employees' Association (EA) Full Time Benefits

Learn More About Benefits


JOB DETAILS AND QUALIFICATIONS

The Clackamas County Department of Technology Services is seeking an experienced IT professional to join our team as a Database Administrator.

This position is primarily responsible for the administration of county Microsoft SQL Server databases which includes security, configuration, installation, HA/DR, monitoring, troubleshooting and performance tuning. The incumbent will support on-premise and cloud based county databases in multiple DEV/Test/Prod environments. The position is also responsible for primary and backup level application support which includes, installation, configuration/customization, upgrade, integration and reporting.

Required Minimum Qualifications/ Transferrable Skills:*

• At least six (6) years of relevant experience that would provide the required knowledge and skills to perform the duties of the role. Relevant experience must have included working with:
  • Administration, development and monitoring of Microsoft SQL Server databases (on-premise and Azure)
  • TSQL Coding
  • .Net applications
  • Data integration and reporting
  • Working closely with software vendors in support of their applications, both on premise and hosted
  • Software installation, configuration, permissions
  • Customer service emphasis
  • Ability to work independently and as part of technical and non-technical teams
  • Leading small projects and initiatives
  • Ability to learn and apply new IT tools, methods and technologies
• Must pass a criminal history check which may include national or state fingerprint records check
• Must pass a post-offer physical assessment; accommodation requests will be reviewed on an individual basis in compliance with State and Federal legislation
• Driving may be necessary for County business. For position(s) with occasional/incidental driving, incumbents must possess a valid driver's license. Accommodation requests for an acceptable alternative method of transportation will be reviewed on an individual basis in compliance with State and Federal legislation. For position(s) with regular driving, incumbent(s) must also possess and maintain an acceptable driving record throughout the course of employment. Learn more about the County's driving policy

Preferred Special Qualifications/ Transferrable Skills:*

• Experience with any of the following:
  • Auditing for compliance requirements
  • IT automation
  • Systems monitoring and alerting
  • IT Project management
  • Application life cycle, SDLC
  • Business analysis
  • Testing and Quality Assurance
  • Data analytics

*For Veterans qualified for Veteran's Preference: If you believe you have skills that would transfer well to this position and/or special qualifications that relate to this position, please list those skills and/or qualifications in the open-ended question at the end of the application and explain how those skills and/or qualifications relate to this position.


TYPICAL TASKS

Duties may include but are not limited to the following:

• Administration of County Microsoft SQL Server Databases (on-premise and cloud) Includes Security, Configuration, Installation, HA/DR, Monitoring, Troubleshooting, Performance Tuning and Data Warehousing.
• Enterprise application support (install, configure, upgrade, troubleshoot, document).
• Database integration and development (SSIS, Azure Logic Apps, TSQL programming, new databases and database objects, modify existing databases, migrate from Dev to Production).
• Report maintenance and development (SSRS, Crystal Reports, Power BI).
• Database upgrades, coordinating, patching, planning, migration.
• Application programming and maintenance, other enterprise software installation and configuration (TSQL, VB/C#.Net, Powershell).

REQUIRED KNOWLEDGE AND SKILLS

Thorough Knowledge of: Current technology associated with a specific discipline, including its application, design, installation, maintenance, performance optimization, troubleshooting and security as described below. At this level, incumbents should be experienced in their discipline, able to think through issues, analyze problems, propose solutions, make technical recommendations and provide training to others.

Skill to: communicate effectively, both orally and in writing, including communicating technical information to non-technical users; translate user needs into productive systems; administer and control the distribution of funds according to budget proposals; organize, coordinate and facilitate diverse groups; develop, justify and ensure completion of project within budget, time and legal guidelines; perform advanced technical analysis and design in support of county wide technical structures; compile and analyze data and develop recommendations; prepare and deliver oral presentations; train, coordinate and review the work of assigned staff; establish and maintain cooperative working relationships with users, staff, and vendors.


WORKING CONDITIONS

Incumbents typically work in a variety of settings and locations. Work requires the ability to bend, crawl, climb, stoop and be available at sites to provide client support in the installation, repair and maintenance of hardware and software. Incumbent must be able to lift or move personal computers, terminals and peripheral equipment which may weigh up to fifty pounds. Frequently works early and late hours to meet timelines, provide off-hour upgrade and maintenance, and respond to emergencies.


WORK SCHEDULE

This position is included in the County's alternate workweek program, working 40 hours during a standard workweek of Monday through Thursday (Fridays off). Specific hours of work will be discussed with the candidate selected for this position at the time an offer of employment is extended. This position is eligible for hybrid on-site/telework subject to the Clackamas County Teleworking Policy and based on the Department's business needs. The exact amount of on-site/telework and schedule will be discussed with the hiring manager during time of offer. Telework locations cannot be located outside of Oregon or Washington. Washington residents must perform 50% of their time on-site at Clackamas County.


EXPLORE CLACKAMAS COUNTY

Clackamas County is in a prime location in the Portland, Oregon metropolitan area and is recognized nationally as one of the most livable areas in the United States. Located on the southern edge of the City of Portland and extending to the top of Mt. Hood, Clackamas County is part of a thriving region in the Northwest. It has a population of about 420,000 residents.

• Explore Clackamas County
• Working for Clackamas County
• Recreation, Arts & Heritage
• Equity, Diversity and Inclusion

ABOUT THE DEPARTMENT

The Technology Services Department provides computing services to County departments and other public and private agencies. The Department offers technical services and support in the following areas:

• Applications, including enterprise systems
• Geographical Information Systems
• Web
• Document Imaging
• Desktop Support
• Data Center Operations
• Network, including the Clackamas Broadband Express
• Telecom
• Systems Administration
• Technical Call Center
• Technical Learning Center

The mission of the Technology Services Department is to provide high quality, cost-effective technology for, citizens, county departments, and county commissioners.

Learn more about Clackamas County Technology Services


APPLICATION PROCESS

Clackamas County only accepts online applications.

Help With Your Application:

• Application Process
• Help with the Application

If you have any questions or issues you may contact the Department of Human Resources at 503-655-8459 or e-mail us. Our office hours are Monday - Thursday 7:00 a.m. - 6:00 p.m. Pacific Time (closed on Fridays).

HOW TO CLAIM VETERAN'S PREFERENCE

• Request Veterans' Preference
• Learn more about the County's Veterans' Preference

VISA SPONSORSHIP

Clackamas County does not offer visa sponsorships. Once a job applicant has accepted a position, they will be required to complete an I-9 and confirm authorization to work in the United States prior to their first day.

EQUAL EMPLOYMENT OPPORTUNITY

Clackamas County is an Equal Opportunity Employer. We value diversity, equity, and inclusion as essential elements that create and foster a welcoming workplace. All qualified persons will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, political affiliation, disability or any other factor unrelated to the essential functions of the job.

If you wish to identify yourself as a qualified person with a disability under the Americans with Disabilities Act and would like to request an accommodation, please address the request to the Department of Human Resources prior to the recruitment close date. You may request an accommodation during the online application process.


RECRUITING QUESTIONS?

James Callahan, Recruiter
JCallahan@clackamas.us


To apply, visit https://hrapp.clackamas.us/psc/recruit/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FL&Action=U&JobOpeningId=107063&PostingSeq=1&SiteId=1&languageCd=ENG&FOCUS=Applicant



jeid-4f075b6ea4cd304cba5338bb1502efd3