Senior Oracle Database Administrator (Senior Information Technology Systems Specialist)

ABOUT THIS POSITION

With more than 14,000 employees working across 41 departments, the City of Phoenix offers opportunity for career growth and advancement. Whether you're an experienced professional or just starting your career, working in public service offers many rewards! Be a part of building the Phoenix of tomorrow.

The Information Technology Department has a vacancy for a Senior Oracle Database Administrator (DBA). In this role you will be responsible for providing technical support for the Oracle database environments. You will configure and maintain the databases to ensure accuracy, availability, consistency, and acceptable response times.

Additional responsibilities include:

• Collaboration with application and management teams to ensure project work complies with standards, expectations, and timely delivery.

• Update and maintain documentation to ensure database manageability.

• Participate in an active on-call rotation and provide after-hours support when needed to ensure database availability during normal business hours.

• Other responsibilities as requested by leadership.

Depending on assignment, this position may be eligible for a telework schedule at the discretion of the Chief Information Officer. You will be required to come into the office for meetings in the Phoenix metro area or to work on-site when assigned. Telework is subject to department need and could change in the future.

IDEAL CANDIDATE

• Knowledge and understanding of disaster recovery procedures and database backup/recovery utilities including Recovery Manager (RMAN), Data Pump, Flashback technologies, and media management integration.

• Knowledge and understanding of database security management practices and advanced technologies including Transparent Data Encryption (TDE), Lightweight Directory Access Protocol (LDAP) authentication, and data masking.

• Skilled in scripting languages such as Shell, Perl, or Python.

• Self-motivated with attention to detail.

SALARY

Pay Range: $93,121.60 to $131,040.00/annually.

Hiring Range: $93,121.60 to $118,872.00/annually.

Pay Range Explanation:

• Pay range is the entire compensation range for the position classification.

• Hiring range is an estimate of where you can receive an offer. The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience, education, licenses, training, and internal equity.

BENEFITS

A comprehensive benefits package is offered which includes:

• Traditional pension with employer and employee contributions, click here for more details: Pension Information

• 401(a) and 457 plans with employer contributions

• Choice of generous medical HMO, PPO, or HSA/HDHP plans

• Medical enrollment includes a monthly $150 City contribution to a Post-Employment Health Plan

• Wellness incentive of up to $720 annually

• Dental, vision, and life insurance options

• Employer paid long-term disability

• Free Bus/light rail pass

• Tuition reimbursement program up to $6,500 per year

• Paid time off includes 13.5 paid holidays, 12 vacation days, and 15 sick days and personal leave days

• Paid Parental Leave for eligible employees up to 480 hours (12 weeks) of paid leave for the birth, adoption, or foster care placement of a child during a 12-month period

• Federal Student Loan Forgiveness offered through Savi

For more details, visit: Unit 007 Benefits

MINIMUM QUALIFICATIONS

• Two years of experience as an Information Technology Systems Specialist involving database management and on-line telecommunications.

• Bachelor's degree in computer science, math, or a related field.

• Other combinations of experience and education that meet the minimum requirements may be substituted.

• The City job description can be found here.

• All finalists for positions are subject to a criminal background check applicable to the department or position.

• This position is subject to Criminal Justice Information Systems (CJIS) background standards. Candidates who receive a conditional offer of employment must be fingerprinted and will have their fingerprints used to check the Criminal History Records of the State of Arizona Department of Public Safety and the Federal Bureau of Investigation. Any records returned will be reviewed to determine the candidate's suitability for the job.

• For information regarding pre-screening and driving positions, click here.

PREFERRED QUALIFICATIONS

The minimum qualifications listed above, plus:

• Five years of experience supporting Oracle Relational Database Management Systems (RDBMS).

• Five years of experience with Oracle Real Application Clusters (RAC), Grid Infrastructure, and Automated Storage Manager (ASM).

• Two years of experience administering Exadata/ExaCC environments including upgrade, patching, and system administration.

• Two years of experience with advanced database replication solutions including Materialized Views, DataGuard, and GoldenGate.

• Experience programming in SQL and PL/SQL.

RECRUITMENT DATES

Recruitment closes May 1, 2024. All materials must be received by 11:59 p.m. on this date.

This is a position-based recruitment and will not result in any ongoing eligibility list. This recruitment and any selection processes resulting from this recruitment may be used to fill other related vacancies within the organization now or in the near future.

HOW TO APPLY

Apply online by completing the required information and attaching, as one document, your cover letter and resume. Please include your experience as it relates to the qualifications stated above. Only the highest qualified may be posted to the eligible to hire list. The results of the resume screening process will be sent to your primary email address.

During the online application process, you will provide responses to questions regarding your experience and qualifications. Information you provide in these questions should align to the information in your resume. Information not consistent with your resume may not be considered when determining your education and/or experience level.

WE ARE HERE TO HELP

• Job interviews may be held by video or audio conference.

• If you are in need of computer resources, click here for free options.

• Arizona at Work has frequent classes to help with resume writing, interviewing skills, and general career guidance. Click here for more information.

• Explore other Employment Opportunities with the City of Phoenix.

• Subscribe to receive e-mail notifications about new employment opportunities.

• If you need assistance applying for this job, please contact our HR Connection Center at (602) 495-5700.

REFERENCE

Senior Info Tech Systems Spec, JC:09570, ID# 54125, 4/16/2024, USM, KA, Benefits:007.

Building the Phoenix of tomorrow.

#DoWorkThatMakesPhoenixWork

City of Phoenix is an equal opportunity employer. AmeriCorps, Peace Corps, and other national service alumni who meet the required qualifications are encouraged to apply.