Under direction,
functions as a technical team leader for the design, implementation, and
management of database systems and new database technologies, and performs
related duties as required.

ESSENTIAL DUTIES

Installs, configures Postgres databases and applies
security patches and upgrade existing installations

Supports PostgreSQL database in both locally hosted
servers and on AWS, including exposure to setting up AWS RDS instances

Works with teammates to migrate Oracle databases to
the Postgres platform

Designs and creates database schema

Designs and ensures backup and recovery techniques
to prevent data loss

Designs and implements High Availability
architecture that includes replication for Disaster Recovery

Creates security architectures to prevent
unauthorized access

Resolves any performance or scaling issues

NOTE: The list of essential duties is not
intended to be inclusive; there may be other duties that are essential to
particular positions within the class.

Location:
DePaul Center

Address:
333 South State
Street

Days:
Monday – Friday

Hours:
8:30 AM – 4:30 PM

THIS POSITION IS EXEMPT FROM THE CAREER
SERVICE

Qualifications

Graduation from an accredited college or university
with a Bachelor’s Degree in Computer Science, Information
Technology/Systems, or a directly related field, plus two years of
experience in maintaining and designing integrated database systems,
or an equivalent combination of education, training, and experience

Disclaimer –
“Accredited” means any nationally or regionally accredited college,
university, or law school where the applicant is enrolled in or has
completed an Associates, Bachelors, Masters, or Juris Doctorate degree
program.

NOTE: To be considered for this position, you
must provide information about your educational background and your work
experience. You must include job titles, dates of employment, and
specific job duties. (If you are a current City employee, Acting Up
cannot be considered). If you fail to provide this information at the time
you submit your application, it will be incomplete and you will not be
considered for this position. There are three ways to provide the
information: 1) you may attach a resume; 2) you may paste a resume; or 3)
you can complete the online resume fields.

Education &
Employment Verification – Please be advised that if you are selected to be hired you
must provide, upon request, adequate information regarding your educational
and employment history as it relates to the qualifications of the position
for which you are applying. If you received your degree internationally,
all international transcripts/diploma must be accompanied by a Foreign
Credential Evaluation. If the City of Chicago cannot verify this
information, any offer extended to you will be withdrawn and you will not
be hired.

SELECTION
REQUIREMENTS

This position
requires applicants to successfully complete an interview. The interviewed
candidate(s) possessing the qualifications best suited to fulfill the
responsibilities of the position will be selected.

Preference will be
given to candidates possessing the following:

Previous experience working with Postgres on a
Linux/UNIX system

Previous experience setting up and configuring
Amazon Web Services (AWS) Relational Database Services (RDS)

Previous experience setting up and managing
Postgres on AWS

Previous experience administering an Oracle
database

Previous experience migrating an Oracle database to
Postgres

Previous experience administering or consuming data
from a MongoDB

VETERANS PREFERENCE
NOTE: The City of Chicago
offers Veterans Preference to both current, active military personnel AND
military personnel who have served in the Armed Forces of the
United States and have received an honorable or general discharge. Eligible
candidates must have at least six months of active duty documented. In
order to receive the veterans preference, candidates need to indicate whether
or not they are a veteran by answering “yes” or “no” to the question on the
online application that asks, “Are you currently serving on active duty for
at least six months in the Armed Forces of the United States OR have
you served in the Armed Forces of the United States on active duty for at
least six months and received an honorable or general discharge?” In
addition, you must attach documentation to verify your military service.
For veterans, you must attach a copy of your DD214 (Member Copy-4) to your
online application which includes character of service status OR a
letter from the United States Veterans Administration on official
stationary stating dates of service and character of service. For active
military personnel, you must attach a letter from your Commanding Office on
official stationary verifying your active duty, length of service, and
character of service in the Armed Forces of the United States AND a
copy of your military ID to your online application. Failure to answer
the question and attach the required documentation will result in you not
being considered for the Veterans Preference.

Evaluation: Your initial evaluation will be based on
information provided on the application form and documents submitted with
the application. Applications must be submitted by the individual
applicant. No second party applicants will be accepted.

Residency
Requirement: All employees of the
City must be actual residents of the City as outlined in 2-152-050 of the
City of Chicago Municipal Code. Proof of residency will be required.

If you would like to
request a reasonable accommodation due to disability or pregnancy in order
to participate in the application process, please contact the City of
Chicago, Department of Human Resources, at (312) 744-4976 (voice) or (312)
744-5035 (TTY). Please be prepared to provide information in support of
your reasonable accommodation request.

ALL REFERENCES TO
POLITICAL SPONSORSHIP OR RECOMMENDATION MUST BE OMITTED FROM ANY AND ALL
APPLICATION MATERIALS SUBMITTED FOR CITY EMPLOYMENT.

The City of Chicago
is an Equal Employment Opportunity and Military Friendly Employer.

City of
Chicago
Department of Human Resources

Rahm Emanuel, Mayor

Soo Choi, Commissioner

Posting Date: May 24, 2017 |

Closing Date (Period
for Applying) - External

: Jun
24, 2017

BU: 00 | Salary: Up
To $100,656.00 Pay Basis:Yearly

PRINCIPAL
DATABASE ANALYST [POSTGRES]

Read Full Job Description

Principal Database Analyst

Similar Jobs