City of Laredo, TX
MIS Database Analyst, 210, Mainframe
City of Laredo, TX, Laredo, Texas, United States, 78045
Salary :
$60,840.00 - $76,065.60 Annually
Location :
Laredo, TX
Job Type:
Full-time
Job Number:
B255520-1
Department:
Info. Svcs. & Telecomm.
Division:
Mainframe
Opening Date:
10/11/2024
Closing Date:
Continuous
Job Description
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 Functions/ Job Competencies/ Physical Requirements
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 RequirementsPosition 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 LocationsPosition will require the employee to work in the following types of work environments
Seldom
Outdoor environmentStreet environment (near moving traffic)Construction siteConfined spaceWarehouse environmentFrequentlyVehiclesOftenOffice or similar indoor environmentExposuresPosition will require the employee to be exposed to the following environmental elements
Never
Individuals with known violent backgroundsMoving mechanical partsFumes or airborne particlesToxic or caustic chemicals or substancesLoud noises (85+ decibels such as heavy trucks, jack hammers, construction)SeldomIndividuals who are hostile or irateExtreme cold (below 32 degrees)Extreme heat (above 100 degrees)Communicable diseasesTravelPosition will require the employee to travel
Never
International travelSeldomNational travelSometimesRegional travelFrequentlyLocal travelMinimum Qualifications
Required Education and Experience
Bachelor's Degree from and accredited* college or university in Information Technology, Business Administration or related degreeAt 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.)Valid Licenses and Certifications
Required Licenses or Certifications
None
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.
The City of Laredo provides a benefit compensation package that includes the following for all Full-time regular employees:
10 days of paid vacation per year6 1/2 days sick leave per yearPension plan16 paid HolidaysPaid health *Dental plan *Life insurance **30 day waiting period
For a full description of our benefits, please visit our website at: under Employee Benefits
01
Are you a current regular full-time or part-time City of Laredo employee?
I am a full-time City of Laredo employeeI am a part-time City of LaredoI am not a full-time or part-time City of Laredo employee
02
What is your highest level of education?
03
If you hold an Associate's, Bachelor's, Master's PhD, Juris Doctor, or Post Graduate Degree, please provide your major/minor:
04
Do you have at least four (5) years of experience in IBM Systems/Windows OS Database Administration or programming and business application support?
YesNo
05
From the experience you provided on your application, list the name of the agencies you performed these duties with: Note: Do not answer this question with "See Resume" or "See Application". Doing so will automatically disqualify your application from the process. )
06
I understand that failure to complete
ALL sections
of my application, including the "Driver License" (if appicable), "Education", "Work Experience", "Certifications and Licenses" (if applicable), "Agency-Wide Questions", and "Job Specific Supplemental Questions" will result in my application
not
being processed.
I have read and understood the above information.I have read and do not understand the above information. I will contact the Human Resources Department for further explanation.
Required Question
$60,840.00 - $76,065.60 Annually
Location :
Laredo, TX
Job Type:
Full-time
Job Number:
B255520-1
Department:
Info. Svcs. & Telecomm.
Division:
Mainframe
Opening Date:
10/11/2024
Closing Date:
Continuous
Job Description
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 Functions/ Job Competencies/ Physical Requirements
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 RequirementsPosition 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 LocationsPosition will require the employee to work in the following types of work environments
Seldom
Outdoor environmentStreet environment (near moving traffic)Construction siteConfined spaceWarehouse environmentFrequentlyVehiclesOftenOffice or similar indoor environmentExposuresPosition will require the employee to be exposed to the following environmental elements
Never
Individuals with known violent backgroundsMoving mechanical partsFumes or airborne particlesToxic or caustic chemicals or substancesLoud noises (85+ decibels such as heavy trucks, jack hammers, construction)SeldomIndividuals who are hostile or irateExtreme cold (below 32 degrees)Extreme heat (above 100 degrees)Communicable diseasesTravelPosition will require the employee to travel
Never
International travelSeldomNational travelSometimesRegional travelFrequentlyLocal travelMinimum Qualifications
Required Education and Experience
Bachelor's Degree from and accredited* college or university in Information Technology, Business Administration or related degreeAt 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.)Valid Licenses and Certifications
Required Licenses or Certifications
None
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.
The City of Laredo provides a benefit compensation package that includes the following for all Full-time regular employees:
10 days of paid vacation per year6 1/2 days sick leave per yearPension plan16 paid HolidaysPaid health *Dental plan *Life insurance **30 day waiting period
For a full description of our benefits, please visit our website at: under Employee Benefits
01
Are you a current regular full-time or part-time City of Laredo employee?
I am a full-time City of Laredo employeeI am a part-time City of LaredoI am not a full-time or part-time City of Laredo employee
02
What is your highest level of education?
03
If you hold an Associate's, Bachelor's, Master's PhD, Juris Doctor, or Post Graduate Degree, please provide your major/minor:
04
Do you have at least four (5) years of experience in IBM Systems/Windows OS Database Administration or programming and business application support?
YesNo
05
From the experience you provided on your application, list the name of the agencies you performed these duties with: Note: Do not answer this question with "See Resume" or "See Application". Doing so will automatically disqualify your application from the process. )
06
I understand that failure to complete
ALL sections
of my application, including the "Driver License" (if appicable), "Education", "Work Experience", "Certifications and Licenses" (if applicable), "Agency-Wide Questions", and "Job Specific Supplemental Questions" will result in my application
not
being processed.
I have read and understood the above information.I have read and do not understand the above information. I will contact the Human Resources Department for further explanation.
Required Question