Responsibilities

• Under general direction, provides highly technical expertise and guidance in the architecture, design, implementation, support, operation and maintenance of database management systems (DBMS) such as lnformix, DB2, MySQL, and SQL Server.
• Performs data movement, troubleshoots issues, and writes scripts to perform common database tasks.
• Maintains complex databases with respect to JCL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
• Performs installs, configuration, migrations, restores, and monitors the security and performance of the systems are not compromised. Provides Tier 2 and Tier 3 support. Prepares and delivers presentations on DBMS concepts.

Qualifications

• Bachelor's with 2-5 years (or commensurate experience)
• Full knowledge of the job. Moderate understanding of the general aspects of the job and its application.
• Provides solutions to a variety of technical problems of moderate scope and complexity.
• Works under general supervision.
• Follows established procedures. Work is reviewed for soundness and overall accuracy.
• Contributes to the completion of milestones associated with specific projects.
• Failure to achieve results may cause delays in program schedules and may result in the allocation of additional resources.
• Strong Informix analytical and decision making skills
• Demonstrated Informix configuration and administration experience
• Demonstrated Informix performance tuning experience
• Demonstrated Informix backup and data recovery experience
• Basic scripting skills

• Clearance Required: Ability to acquire and maintain Public Trust