Database Administrator

Job Title: Database Administrator

Descriptions, Qualification Requirements, and Required Positions:

Proven ability to take project requirements and the logical data model and create the following:

• A physical data model optimized for DB2/zOS environment
• A document representing details how the implementation will conform to required agency standards
• In response to changes to the Java, .net and SQL-based applications, the DBA will collaborate with the Java, .net and SQL development teams and be responsible for detailed DB design, implementation, testing, and deployment ensuring the technical integrity of the project.
• Provide SQL performance tuning on both OLTP and Data warehouse environments. Optimize DB2 resource utilization by tuning queries (static and dynamic), recommending indexes, and configuring database parameters
• Engage in data mining activities needed to support management requests for information, assist in analysis of application errors, and define and execute queries needed to repair data in support of problem resolution. Provide trend analysis to management team to enable them to make informed decisions regarding resource management
• Responsibilities will span all aspects of DB design, maintenance, performance optimization, monitoring, and operational support. This includes DB disaster recovery and development of backup and archiving solutions.
• Provide on-call rotational 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel

Qualifications:

• Technical expertise in MVS-zOS environment
• Technical expertise in DB2 V8 and above
• Detailed knowledge of logical and physical DB design, performance monitoring and tuning, definition of alert thresholds
• Detailed knowledge of stored procedures (COBOL and NATIVE), triggers and UDFs, RMF and use of SMF data.
• Strong experience with DB2 Utilities, SPUFI, QMF, OSC, BMC-DB2Mon, and PowerDesigner
• Preferred experience with J2EE environments and UDB on LUW

Candidate Qualifications and R sum s/Curriculum Vitea:

• Experience with supporting and maintaining complex information technology applications;
• Experience with enhancing complex technology applications;
• Experience with financial and insurance technology applications; and
• Experience with government entities and maintaining government technology systems