SQL Database Administrator I/II

Print (https://www.governmentjobs.com/careers/adacounty/jobs/newprint/4794870)

Apply



SQL Database Administrator I/II

Salary

$62,637.00 - $105,404.00 Annually

Location

Boise, ID

Job Type

Full-Time with Benefits

Job Number

02474

Department

Information Technology

Opening Date

01/16/2025

Closing Date

1/29/2025 11:59 PM Mountain

• Description

• Benefits

General Summary

Ada County is a great place to work! We have more than 2000 employees dedicated to enhancing our community’s quality of life. Our Information Technology team is growing, and this is an excellent opportunity to be a part of taking this team to the next level. We offer a competitive benefits package which includes excellent medical, dental and vision insurance; generous vacation and sick leave accrual beginning as soon as you start; 11 paid holidays a year; participation in one of the Nation's best state retirement systems which includes 11.96% employer contribution; various savings plans including a deferred compensation 457(b) plan with up to 3% county match; 401K plan; paid parental leave; life insurance; wellness programs; ongoing training opportunities and career pathing. This generous Ada County Total Rewards package increases the base salary by approximately 40 percent. The Ada County Information Technology Department (AC-IT) supports the largest county in the State of Idaho. The department is divided into functional areas of Administration, Customer Support, Infrastructure, Project Management and Development for Client/Server/Web/GIS.AC-IT provides computing and communications infrastructure, services, and innovation to the departments and elected officials charged with providing the services to the citizens of Ada County.

Learn more about Ada County Information Technology by visiting their website. Ada County Information Technology (https://adacounty.id.gov/informationtechnology/)

REQUIRED: Submit updated resume and cover letter with your application.

POSITION GENERAL SUMMARY:

The SQL DBA develops, supports, and maintains the database platforms for Ada County. The SQL DBA assists in building and maintaining documentation including policies, standards, data classification and guidelines to cost effectively develop and manage all databases, regardless of its connectivity to various applications and platforms. The incumbent ensures best performance of the databases, including proper backups and restores, administer necessary upgrades and enhancements, and follow guidelines and procedures for maintaining server confidentiality, security, integrity and availability of the data assets. The SQL DBA acts as a technical project leader on assigned projects and provide assistance to project teams with technical issues in the initiation, planning, and testing phases, and roll-out of infrastructure projects. The SQL DBA provides oversight, training, and guidance to Systems Administrators and Data Analysts focused on delivering the above.

DISTINGUISHING FEATURES OF THE CLASS:

The SQL DBA I assignments are well defined and of limited scope and technical complexity, using standard procedures and techniques. Guidance is readily available from other team members or management. Schedules, milestones, and priorities are usually provided by management.

The SQL DBA II assignments are less well defined and of moderate scope and technical complexity, where technical supervision provides an outline of the tasks to be performed and suggestions as to methods of approach and procedure to be followed. Guidance is readily available from other team members or management. Consults with team leader and/or management to develop schedules, milestones, and priorities.

Essential Functions

SQL DBA I

• Develop database architectures and designs to enhance existing operational database environments, new projects and initiatives;

• Monitor database activity and system usage, ensuring necessary resources are present to ensure databases function properly;

• Refine physical design of databases to meet storage requirements, or makes recommendations for upgrading storage based on projected DB growth;

• Analyze and determine informational needs, data relationships, proposed manipulation, data flow, and data output for complex databases;

• Develop complex data retrieval queries and optimizing data queries within programs for performance and maintainability;

• Monitor SQL, DB2 and Oracle Server security and managing both front end and back-end access to all databases;

• Determine tests to use and collecting appropriate data;

• Provide coding guidance, review and optimization of SQL Server SSIS packages, and related application programming interfaces;

• Provide full support of SQL Server SSRS;

• Provide support of maintenance plans (including DBCC), backup, recovery, and refresh of development SQL Server databases;

• Plan/advise/validate all database installations, patches and upgrades;

• Design indexes for existing applications, choosing when to add or remove indexes;

• Configure SQL Server monitoring utilities to minimize false alarms;

• As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies;

• Install and configure new SQL Servers;

• Provide extended hours of support for application development of database systems when required.

  SQL DBA II

• In addition to the above;

• Research various hardware and software products; recommend solutions and implement approved products;

• Work closely with management to develop the County's database security plan;

• Document the company's database environment;

• Perform complex technical, analytical and professional services involving program/member services, evaluation, database-driven Web sites, office operations;

• Maintain and administer web server and middleware tools;

• Audit, modify, and amend data in systems using SQL commands, hand-editing, and bulk import;

• Troubleshoot and correct issues as they arise;

• Add new users to the system as needed;

• Enhance or build database designs;

• Ensure database security, optimum performance of databases, backup & recovery, and disaster recovery;

• May require supervision of SQL DBA I;

• Understand and implement Business Intelligence (BI) features of SQL Server.

  ADDITIONAL FUNCTIONS:

• Performs related duties as required.

Job Requirements

SQL DBA I

• Bachelor's degree from an accredited university in Computer Science or related field or equivalent combination of education and experience;

• A minimum of one to two years of experience in SQL database administration planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, and security management required; and related certifications;

• Experience building and maintaining a clustered, high availability MS SQL and DB2 environment required;

• Experience level T-SQL Development and Tuning skills;

• Ability to program in SQL;

• Experience with computational thinking and some database principles;

• Excellent organizational and project management skills including ability to organize time and work on multiple tasks and follow through to completion of tasks or projects;

• Ability to create and write clear, complete documentation of systems and procedures;

• Excellent analytical and problem-solving skills including high degree of attention to detail and accuracy;

• Knowledge of Replication Technologies (transactional, merge) in a production environment;

• Experience with dimensional and relational modeling;

• Working knowledge of SAN concepts and physical array design;

• Applied knowledge of Microsoft Security/Authentication Concepts (Active Directory, IIS, Windows OS);

• Knowledge of industry best practices;

• Flexibility to participate in on-call rotation;

• Ability to work with cross-functional project teams across multiple locations;

• Ability to work independently.

SQL DBA II

• In addition to the above;

• A minimum of five years of experience in SQL database administration planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, and security management required; and related certifications;

• Experience with MOF and MSF process frameworks a plus;

• Experience with Performance Point Server or ProClarity tools a plus;

• Established understanding of Infrastructure and relative technologies;

• Established understanding of network connectivity and protocols;

• Experience with Windows Server operating systems or Linux/UNIX operating systems is required;

• Thorough understanding of database structures, theories, principles, and practices;

• Exposure to other database platforms such as DB2, Sybase, MySQL, postgreSQL, SQL server.

OTHER REQUIREMENTS:

• Must possess and maintain a valid driver's license;

• Must pass a criminal background investigation;

• Must treat coworkers, users and the public with the utmost respect and regard for good public relations;

• Working hours are generally from 8:00 a.m. to 5:00 p.m., Monday through Friday, but may vary with the needs of the County and may include evening or weekend work in the event of serious systems problems.

Work Environment & Physical Demands

• Work is performed primarily in an office environment and the employee in this class is subject to inside environmental conditions;

• Requires sufficient personal mobility and physical reflexes, which permits the employee to function in a general office environment to accomplish tasks.

DISCLAIMER:

To perform this job successfully, an individual must be able to perform the essential functions satisfactorily with or without reasonable accommodation. The above statements are intended to describe the general nature and level of work being assigned to this job. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of individuals in the job. This job description is not an employment agreement and/or an expressed or implied employment contract. Management has the exclusive right to alter this job description at any time without notice. Ada County provides Veteran's Preference for all County jobs except for those deemed "key positions" in accordance with Title 65, Chapter 5 of Idaho Code.

Ada County recognizes that employees are our most valuable asset. We are proud to offer a comprehensive benefits package to benefit-eligible employees designed to support the health, wellness and long-term financial stability of our employees and their families.

Healthcare:

• Low-cost medical, dental, vision premiums and deductibles

• Post-employment health savings account

Retirement and Investments Plans:

• PERSI retirement benefits

• 457(b) post or pre-tax investments options with up to 3% employer match

• 401(k)

Wellbeing Program:

• Employee Assistance Program for short-term counseling on work, family, finances, and personal concerns.

• Free ACHD Commuter ride vanpool program

• Free bus pass

Paid-leave:

• 11 paid holidays per year

• 8 weeks paid Parental Leave

• Approximately 96 hours of vacation accrual for full-time employee

• Approximately 96 hours of sick accrual for full-time employee

• 5 days paid bereavement leave

Life & Short-Term Disability Insurance

• Basic Life Insurance employer paid if benefit eligible

• Short Term Disability employer paid if benefit eligible

Optional Benefits:

• Pre-tax Flexible Spending Account and Dependent Care Account

• NCPERS Decreasing Term Life Insurance

• Supplemental Employee, Spouse, Child Life Insurance

• Supplemental Long-Term Disability Insurance

• AFLAC

Visit us at adacounty.id.gov/Human-Resources/Employee-Benefits to view details regarding our benefits package, including: paid leave, healthcare benefits, retirement benefits, and more!

Agency

Ada County

Department

Information Technology

Address

200 W. Front St. Suite #3269 Boise, Idaho, 83702

Website

www.adacounty.id.gov

Apply

Please verify your email address Verify Email