Database Administrator

Print (https://www.governmentjobs.com/careers/gilbert/jobs/newprint/4500496)

Apply



Database Administrator

Salary

$90,762.52 - $136,143.78 Annually

Location

Gilbert, AZ

Job Type

Full Time

Remote Employment

Flexible/Hybrid

Job Number

24-063

Department

INFORMATION TECHNOLOGY

Opening Date

05/08/2024

Closing Date

5/22/2024 11:59 PM Arizona

• Description

• Benefits

• Questions

We Are Seeking

Gilbert is on a mission to be the City of the Future. We choose to “Anticipate. Create. Help people.” With over 100 years of history and growth, our focus is on keeping the thriving community that Gilbert is today well into the future. Gilbert has been named the Most Prosperous City in the Country, Best Place to Live, Work and Play, Arizona’s Most Admired Companies to Work For, and more . (https://www.gilbertaz.gov/about-us/team-gilbert/awards-accolades)

We hire people who share our aspiration to be driven, kind, bold, and humble. Join Team Gilbert, and help us shape a new tomorrow, today: https://youtu.be/ftB0lKDltvc

About You

Team Gilbert has an exciting opportunity for a highly motivated professional to fill the Database Administrator position .

The Database Administrator role is to serve as a subject matter expert and perform tasks that contribute to the organization's use of data-driven decisions. Daily activities include the design and maintenance of the Town of Gilbert’s Data environments that support and align with the organization’s data governance efforts, to promote data quality, security, and accessibility, as well as DBA best practices and strategies. The role will serve as a liaison to the Data Analytics team and be responsible for maintaining and improving the data infrastructure used for reporting within the Town.

Key responsibilities include:

Designing, implementing, and optimizing database schemas and queries.

Collaborating with other team members to define data standards, identify gaps and map new reporting data sets.

Mapping new data sets and sources into predefined data models or developing new data models as needed while ensuring data integrity.

Building and validating pipelines to administer internal and external datasets into the Town’s data lake.

Providing up-to-date documentation, descriptions, and workflow diagrams for the Town’s data lake.

Developing and implementing data management policies, procedures, and standards to ensure data quality, security, and compliance.

Define and document standards, frameworks and reference architectures.

Work closely with other teams to deliver new environments and resolve problems related to existing infrastructure.

Determine database structural requirements by analyzing client operations, applications, and programming; review objectives with clients; evaluate current systems.

Develop database solutions by designing proposed system; define database physical structure and functional capabilities, security, back-up, and recovery specifications.

Manage systems for reporting and data acquisition.

Provide insight into the changing database storage and utilization requirements for the company and offer suggestions for solutions.

Analyze database implementation methods to make sure they are in line with company policies and any external regulations that may apply.

Ability to work independently with minimal supervision, using initiative to anticipate needs in areas of responsibility.

Ability to work with business and development teams to convey the value of enterprise data modeling, data quality and data governance practices.

Additional responsibilities include analyzing system requirements, designing data models, and assisting in the Town’s data migration, to ensure that it aligns with enterprise best practices. Experience in using Matillion for data transformation and ELT processes to include end-to-end data ingestion into a data lake environment such as Snowflake is a plus.

MINIMUM QUALIFICATIONS & SPECIAL REQUIREMENTS:

BA/BS degree in Computer Science, Engineering, Math, or other technically relevant area

5-7 years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies.

Experience with enterprise data management technologies, including database platforms, ETL tools, and SQL.

Understanding of API's

Knowledge of Project Management/Agile development methodology and concepts.

Proven experience in data architecture and analytics management roles, with specific development experience in Azure Blob, Snowflake, Matillion, Purview, and Power BI.

Demonstrated ability in managing data lifecycle processes and implementing data governance policies.

Extensive experience with data modeling, ELT design, and data integration techniques.

Familiarity with BI tools and data management software.

We're looking for someone with excellent written and verbal communication skills and the ability to interact professionally with a diverse group of executives, managers, and subject matter experts. The ideal candidate has skills in evaluating and finding data sources and presenting the data. This position requires someone who is able to work independently with minimal supervision, using initiative to anticipate needs in areas of responsibility and take on other duties as assigned.

We Are Team Gilbert

This position will define and document standards, frameworks, and reference architectures that will lead to developing database solutions by designing proposed systems; defining database physical structures and functional capabilities including security, backup, and recovery specifications. This position will analyze database implementation methods to make sure they are in line with company policies and any external regulations that may apply and be able to work with business and development teams to convey the value of enterprise data modeling, data quality, and data governance practices. Other duties include working closely with other teams to deliver new environments and resolve problems related to existing infrastructure and providing insight into the changing database storage and utilization requirements for the company and offering suggestions for solutions. At Team Gilbert, we hire outcome-oriented problem-solvers who love what they do!

This position is an At-Will and is FLSA Exempt – ineligible for overtime compensation.

This department is working in a hybrid environment, with remote work. Modified work privileges are approved at the sole discretion of the department director; as such, the department reserves the right to modify or discontinue modified work arrangements at any point. Work location Onsite & Remote (Hybrid) Town of Gilbert employees are required to reside in the state of Arizona by hire date.

Up For the Challenge

In addition to a competitive salary, Gilbert offers a comprehensive benefit package that includes self-funded medical and dental plans, life insurance, disability, pension, tuition reimbursement and more.

Join Team Gilbert and make an income while making an impact! If you are looking for an opportunity to make a visible contribution to our community, and get excited about doing interesting work that matters, then why not click that “Apply” button at the top there? We can’t think of a better place to put your talents to work.

Let’s get this adventure started!

Gilbert provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Town of Gilbert offers a comprehensive benefits package for qualifying positions that includes self-funded medical and dental plans, life insurance, disability, pension, tuition reimbursement, parental leave, babies at work, and more! Click Here (https://www.gilbertaz.gov/home/showdocument?id=42978&t=637793142009536761) to see a list of our benefit offerings at-a-glance.

01

In the questions that follow, you will be asked for information about your work history, to include things such as dates of employment, names of employers and specific details of the work you did. In answer to questions asking you to describe your work experience, if you do not have that type of experience, enter "N/A". Answers provided in this supplemental questionnaire must be substantiated and verifiable in the employment history section of your application. Be aware that submitting a resume in lieu of completing the employment history section of the application and failing to provide all of the information requested in these supplemental questions will disqualify you from further consideration, so be thorough in answering the questions. Please indicate whether or not you accept these terms by checking the appropriate response below.

• Yes

• No

  02

  Do you have a bachelor's degree in computer science, engineering, math, or other technically relevant area?

• Yes

• No

  03

  3. If you indicated in the previous question that you do not have a bachelor's degree, please describe your equivalent work experience. If this does not apply to you, please enter N/A.

  04

  Do you have at least five years of experience in Information Technology programs and services?

• Yes

• No

  05

  If you indicated in the previous question that you do have five years of experience with Information Technology programs and services, please indicate what programs and services you've used and the years of experience. If you do not have this experience, please enter N/A.

  06

  How many years have you administered Database environments?

• No experience in this area

• Less than one year

• More than one year, less than four years

• More than four years, less than eight years

• More than eight years

  07

  Please select all Databases you have experience with.

• Microsoft SQL Server

• Microsoft Azure

• Oracle

• Other

  08

  If you indicated in the previous question that you have "other" type of experience, please describe it in the space below. If not, please enter N/A.

  09

  Please select all ETL tools you have experience with.

• DeNoDo

• Talend

• Matallian

• Microsoft SSIS

  10

  If you indicated in the previous question that you have experience with the listed ETL tools, please describe what projects you have used the tools for. If not, please enter N/A.

  11

  How many years of experience do you have with a municipal Open Data system?

• No experience in this area

• Less than one year

• More than one year, less than four years

• More than four years, less than eight years

• More than eight years

  12

  How many years have you worked with or in a municipal or state level of government?

• No experience in this area

• Less than one yea

• More than one year, less than four years

• More than four years, less than eight years

• More than eight years

  13

  How many years have you worked with MS Azure?

• No experience in this area

• Less than one year

• More than one year, less than four years

• More than four years, less than eight years

• More than eight years

  14

  Do you have any certifications for MS Azure of Amazon Web Services?

• Yes

• No

  15

  If you indicated in the previous question that you have certifications for Microsoft Azure or Amazon Web Services, please list the certifications and when they were obtained. If not, please enter N/A.

  16

  How many years of experience do you have with AI/ML?

• No experience in this area

• Less than one year

• More than one year, less than four years

• More than four years, less than eight years

• More than eight years

  17

  Please describe what type of experience you have with data lakes. If you do not have this experience, please enter N/A.

  18

  Please describe what type of experience you have with API's. If you do not have this experience, please enter N/A.

  19

  The following question is strictly confidential and will not be made part of your application for employment. Preference Status per Arizona Revised Statute 38-492 (select all that apply):

• Veteran

• Disabled Veteran

• Veteran's Spouse / Surviving Spouse

• Disabled Person

  Required Question

Agency

Town of Gilbert

Address

50 E. Civic Center Drive Gilbert, Arizona, 85296

Website

https://gilbertaz.gov/jobs

Apply

Please verify your email address Verify Email