EMPLOYES' RETIREMENT SYSTEM SENIOR DATABASE ADMINISTRATOR

Located on the western shore of Lake Michigan, Milwaukee is an urban hub bursting with energy. Milwaukee provides a casual sophistication – big city appeal without the big city hassles. We are accessible and affordable, and our residents are welcoming. Milwaukee has evolved through the years, bringing together its unsurpassed old world charm with a breathtaking Art Museum, top-flight arts and cultural attractions, professional sports, lakefront festivals, recreational opportunities, and great restaurants.

The Employes’ Retirement System (ERS) Senior Database Administrator supports the business and technology processes necessary to manage the MERITS pension system database and all Structured Query Language (SQL) database applications at the ERS. This position designs solutions to optimize the productivity and efficiency of the ERS and its internal and external databases. 

• Perform in-depth business and systems analyses of the ERS pension system and operating environment. Make recommendations for improvement for its databases.
• Perform structured query language (SQL) backups, reporting backups, transaction log backups, and others to ensure no loss of data in the event of a disaster.
• Perform complex database administrator tasks including data migrations, replication and performance optimization.
• Troubleshoot problems with MERITS database and subsystems and work with the infrastructure team troubleshooting problems with network equipment, servers, VmWare and the wide area network as needed.
• Provide SQL Server expertise within the development team and propose design recommendations.
• Provide relevant documentation on current environment and standards relating to ERS databases.
• Manage and participate in the development and implementation of SQL-based projects.
• Determine potential database administrator solutions and testing for both technical and business compatibility.
• Work with the applications team, quality assurance (QA) and end users to ensure technical compatibility and user satisfaction.
• As part of the infrastructure team, lead the Database support and Database Maintenance (patching, updates, upgrades, etc.).
• Develop solutions that increase process efficiency following accepted systems development life cycle (SDLC) methodology (design, code, test, document, train, and rollout).
• Perform functions related to system development, maintenance and support.
• Identify single points of failure and recommend improvements to eliminate failures.
• Provide high availability design and architecture for ERS databases.
• Document changes to processes (whether implemented through the application of technology or otherwise).
• Prepare reports for ERS management, the Board or its subcommittees.

Reasonable accommodations requested by qualified individuals with disabilities will be made in accordance with the Americans with Disabilities Act (ADA) of 1990, as amended by the Americans with Disabilities Act Amendments Act (ADAAA) of 2008.

1. Bachelor’s degree from an accredited college or university in business, computer science, management information systems or a closely related field.
2. Five years of professional, full-time database development, support and maintenance experience.
3. Valid driver’s license at time of appointment and throughout employment.

Equivalent combinations of education and experience may also be considered.

IMPORTANT NOTE: College transcripts are required and must be received by the application period closing date. Transcripts should be attached to your online application. Applications without transcripts attached will be considered incomplete and will be rejected. Student/unofficial copies are acceptable; however, your transcript must be legible and include your college/university name, your name, the degree completed (if applicable) and the date completed.

• IT Certifications.

• Knowledge and experience with enterprise technologies such as Storage Area Networks (SANs) and VmWare.
• Knowledge of Local Area Network (LAN)/Wide Area Network (WAN) and networking concepts for the disaster recovery service level agreement (SLA).
• Knowledge of application programming concepts and languages.
• Experience in the analysis, documentation and design of database systems.
• Experience maintaining database security, integrity, and availability.
• Experience with Database Administration for Microsoft SQL Server technologies.
• Experience in applying desktop and server based office automation technologies to administrative and business operations practices and systems.
• Experience in MS Windows Server and Desktop environments and the MS Office Suite.
• Skill in analyzing and troubleshooting complex application and database problems.
• Ability to analyze software issues to ensure consistent functionality.
• Ability to work cooperatively and effectively with ERS management, staff, support personnel, vendors and consultants.
• Ability to read and interpret technical documents and policies.
• Ability to clearly communicate technical information in an understandable way for both technical and non-technical staff.
• Written communication and documentation skills, including the ability to write reports, correspondence and technical documentation.
• Ability to work independently and in a team oriented, collaborative environment.
• Ability to maintain confidentiality of restricted information.
• Highly motivated, self-directed and well organized.
• Initiative, honesty and integrity.

The current salary range (Pay Range 2LX) for City of Milwaukee resident is $70,827-$99,154 annually, and the non-resident salary range is $69,089-96,722. Appointment above the minimum is possible based upon level of experience and other qualifications.

The City of Milwaukee provides a comprehensive benefit program that includes the following:

• Defined Benefit Pension Plan
• 457 Deferred Compensation Plan
• Health and Dental Insurance
• Comprehensive Wellness Program
• Onsite Clinic Services Onsite Employee Assistance Program
• Alternative Work Schedules
• Long Term Disability Insurance
• Group Life Insurance
• Tuition Benefits
• Paid Vacation
• 11 Paid Holidays
• Paid Sick Leave and other paid leaves
• Flexible Spending Arrangement
• Commuter Value Pass

For full details of the benefits offered by the City of Milwaukee, please visit http://city.milwaukee.gov/Benefits2017.

 

THE SELECTION PROCESS will be job related and will consist of one or more of the following: education and experience evaluation; written, oral, or performance tests, or other assessment methods. The Department of Employee Relations and the Employes’ Retirement System (ERS) reserve the right to call only the most qualified candidates to oral and performance examinations. Oral examinations may include written exercises. Selection process component weights will be determined by further analysis of the job.

INITIAL FILING DATE - The examination will be held as soon as practical after Wednesday, December 13, 2017. Receipt of applications may be discontinued at any time after this date without prior notice. However, recruitment may continue until the needs of the City have been met. Qualified applicants will be notified of the date, time, and place of the examination. Unless otherwise required by law, the City of Milwaukee will not provide alternative test administration. The applicant is responsible for attending all phases of the job selection process at the time and place designated by the City of Milwaukee.

• APPLICATIONS and further information may be accessed by visiting, http://city.milwaukee.gov/jobs.
• If you would like assistance completing an application, please contact the Department of Employee Relations at (414) 286-3751 or staffinginfo@milwaukee.gov.
• The Department of Employee Relations is located at City Hall, 200 E. Wells St., Room 706, Milwaukee, WI 53202

EEO 102

The City of Milwaukee values and encourages diversity and is an equal opportunity employer.