MIS Database Analyst, (B255520-1), 210, Mainframe

This position is responsible for overseeing, managing, and maintaining the database systems used by the IST MIS division for the City of Laredo. This includes monitoring and tracking incoming requests for MIS data integration, open records, and all associated application support. It also requires the entry of daily requisitions, the processing of invoices, responding to all business-related requests, and providing management with weekly activity reports. ESSENTIAL DUTIES & RESPONSIBILITIES

The intent of this job description is to provide a representative summary of the major duties and responsibilities performed by employees in this job. Employees may be requested to perform job-related tasks other than those specifically presented in this description.
 

• Responsible for managing and maintaining the integrity of IBM Power Systems Platform data, including all upgrades and implementations for all business application modules and operating systems data, as well as its associated applications.
• Develops, coordinates, and implements development solutions for any City of Laredo department.
• Maintains communication with City of Laredo departments and vendors regarding the status of data projects or implementations, resolution of issues, and projected completion dates.
• Responsible for the management and maintenance of IBM system database security, application security, custom programming, design and development of custom reports, technical support, training, and general assistance.
• Responsible for leading the MIS team in the management of database systems the interface with government business applications. 
• Responsible for database administration and operations, database and associated application upgrades, and system compatibility with multiple database models or structures.
• Responsible for managing IBM Database Platform systems and associated application interfaces. 
• Responsibilities include IBM database importation and export operations, implementation or new data platforms across multiple OS platforms, and migrating legacy data models to current standards.
• Develops, processes, and reviews data content supplied and received from different payment and operational systems.
• Provides senior level database support to all City departments, and MIS staff (MIS Applications Analysts I and II, and computer operators).
• Will be required to drive a City vehicle for City business use.
• Performs related work as required.

COMPETENCIES FOR SUCCESSFUL PERFORMANCE OF JOB DUTIES

Knowledge of:

•  Knowledge of database management.
• Knowledge of business concepts.
• Knowledge of programming.
• Knowledge of query.
• Knowledge of project management.
• Knowledge of operational workflows.

Skills and Abilities:

• Ability to build and maintain effective working relationships with others.
• Ability to communicate clearly and effectively both orally and in writing.
• Ability to maintain good planning and organizational skills.
• Ability to take and follow directions from supervisor.
• Ability to give directions to and gain compliance from assigned staff.
• Ability to perform strenuous work and routine work.
• Ability to maintain a valid Texas Driver License and a good driving record.
• Ability to project a positive and professional image of the City of Laredo.
• Ability to effectively communicate both orally and in writing in the English language and orally in the Spanish language.
• Ability to comply with all City of Laredo's policies and procedures.
• Ability to maintain good health and physical condition sufficient to permit the full performance of the duties of this position.

WORK ENVIRONMENT/CONDITIONS AND PHYSICAL DEMANDS

Physical Effort Requirements
 Position will have the following exposures

• Office or similar indoor environment, relatively free from unpleasant environmental conditions or hazards.
• Exerting up to 10 pounds of force occasionally, a negligible amount of force frequently, and/or constantly having to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

Work Environment Locations 
Position will require the employee to work in the following types of work environments
 
 Seldom

• Outdoor environment
• Street environment (near moving traffic)
• Construction site
• Confined space 
• Warehouse environment

 Frequently

• Vehicles

 Often

• Office or similar indoor environment

Exposures 
Position will require the employee to be exposed to the following environmental elements
 
Never

• Individuals with known violent backgrounds
• Moving mechanical parts
• Fumes or airborne particles
• Toxic or caustic chemicals or substances
• Loud noises (85 decibels such as heavy trucks, jack hammers, construction)

Seldom

• Individuals who are hostile or irate
• Extreme cold (below 32 degrees)
• Extreme heat (above 100 degrees)
• Communicable diseases

 Travel
 Position will require the employee to travel
 
Never

• International travel

Seldom

• National travel

Sometimes

• Regional travel

Frequently

• Local travel

Required Education and Experience

• Bachelor's Degree from and accredited* college or university in Information Technology, Business Administration or related degree 
• At least five (5) years of progressively responsible experience in IBM Systems/Windows OS Database Administration or programming and business application support  

        *Council of Higher Education Accreditation (C.H.E.A.)Required Licenses or Certifications 

• Valid Texas Driver License. If applicant holds an out-of-state license, a State of Texas Driver License must be obtained within 6 months of employment.

 

As part of the minimum requirements for all positions with the City of Laredo, a thorough background check and certified school transcripts will be required from all applicants who are offered employment.
 

Effective February 24, 1997, all selected applicants are required to undergo a drug and alcohol test prior to employment.
 

Effective January 7, 2008, all persons in safety-sensitive functions/positions, as per City of Laredo Drug and Alcohol Policy definition, shall be subject to random drug and alcohol testing.
 

A person with a disability who needs a reasonable accommodation related to a selection process is requested to contact the Human Resources Department at (956) 791-7480, two days prior to the scheduled interview and/or test if applicable.    
 


City of Laredo is an Equal Opportunity/Affirmative Action/Pro Disabled and Veteran Employer. We welcome differences in the form of gender, race, ethnicity, disability, geography, socioeconomic status, age, politics, religion, philosophy, sexual orientation, or gender identity. All applicants who share this goal are encouraged to apply. Must be able to function in a principle-based organization that has a culture built on character and core values.

Salary : $60,840 - $76,066