Description
Job Id: 66495
Database Administrator
As part of the Office of Information Services (OIS), Technology Platform – Data Resources Management Team (DRM) is searching for an experienced senior DB2 database administrator to assist with the administration of the enterprise DB2 environment. This position will focus on providing expert consultation to management, DRM staff, technical, and business stakeholders.
The Key Person will participate in the Mainframe Modernization project by applying their skills and experience to manage both IBM DB2 databases for Unix and Mainframe operating systems.
The Key Person will perform data refreshes in development, test, and UAT environments, assist in the deprecation of legacy DB2 databases, and troubleshoot and resolve DB2 job and database issues. They will plan and implement DB2 upgrades and patches, support the export and load of production data, and provide support for batch jobs on zOS, including job scheduling, monitoring, and troubleshooting. The Key Person will also offer DBA support for applications running on AIX, zOS, and Linux platforms, support Java-based applications using JDBC and SQLJ, and create and manage JCL jobs to automate database and system tasks.
Additionally, the Key Person will design, create, implement, maintain, tune, and support DB2/UDB databases on AIX and z/OS platforms. They will manage tables and indexes, promote changes to various subsystems including production, and provide on-call coverage for OLTP applications on the zOS platform. The Key Person will develop and maintain UNIX shell scripts to monitor table space usage and buffer pool usage, work with ETL tools to extract DB2 data from zOS to staging tables on distributed platforms and develop ETL routines using DB2 load/unload utilities, DB2 Connect, and other data warehousing tools.
Finally, the Key Person will provide ongoing technical assistance and education to application developers and business analysts for DB2, COBOL, JCL, and SQL. They will conduct performance analysis and identify tuning opportunities to enhance database performance, implement and manage recovery strategies using RMAN, and provide schema development and system configuration support for application developers. The Key Person will also work with developers to diagnose and resolve database-related application issues, supporting schema maintenance and data distribution.
This is a remote position.
Database Administrator Responsibilities
Data Operations:
Diagnoses and resolves complex problems for critical state systems, often requiring high-level coordination with IS staff and multiple vendors, including conflict resolution.
Provides expertise to other IS staff, assisting with major system crashes and establishing procedures for problem diagnosis and resolution.
Communicates effectively with customers in both oral and written forms, and coordinates training for assigned infrastructure functions within a diverse and dynamic system environment.
Data Construction:
Ensures daily operations run smoothly by managing tasks such as installation, performance monitoring, access, security, back-ups, scheduling, inventory management, and order processing, within a diverse environment with multiple vendors and sites.
Plans and schedules installations of new or significantly updated products, analyzes system performance, resolves resource competition issues, and recommends system configurations based on costs, specifications, and organizational policies.
Communicates effectively with IT counterparts, addressing performance problems and maintaining relational database integrity while considering constraints, linked tables, consistency, and data-level security.
Planning:
Oversees high-level strategic planning, addressing resource utilization, acquisition planning, new technologies, disaster planning, overall system performance, and security. Assesses and integrates new technologies, establishes standards, and recommends operational changes to optimize resource use.
Manages data-related decisions, including data sharing, location, usage, security, integrity, flexibility, and resource allocation. Establishes and enforces metadata standards, reviews and approves logical data models, and conducts training in data modeling and design.
Navigates a diverse and dynamic planning environment with multiple remote locations and varied standards, integrating multiple systems from public and private organizations.
Database Administrator Qualifications
Theories, principles and practices of Information Systems Technology.
Project administration methods, principles, techniques and practices.
Information systems architecture.
Methods and procedures for designing, developing, monitoring and maintaining databases.
Tools for constructing database structures.
Automation products that support a variety of data management environments.
General Knowledge:
Business systems and organizational structures.
Trends, technological changes and developments in IS.
Operations and business of the organization.
Skills:
Administering and managing comprehensive, multi-system projects including directing and motivating internal staff, contractors and other participants.
Identifying the scope and complexity of a project and assigning segments of that project to others.
Assigning and reviewing the work of others to determine accuracy and adequacy of identified conditions, criteria, recommendations and supporting materials.
Developing long and short-range plans to meet established goals.
Developing policies and procedures.
Analyzing organizational needs and implementing cost-effective solutions.
Determining efficient design of data structures and software applications.
Assessing new technology developments.
Specific DBMS Skills:
Extensive knowledge of DB2 on z/OS and AIX.
Knowledge of SQL construction and optimization.
Understanding of data base connectivity to DB2 z/OS from SQL-Server, WebSphere, Cold fusion, Business objects, LUW, MS-Access, Toad, Oracle, etc.
Extensive knowledge of z/OS, OMVS, CICS basics, utilities, RACF and dataset and Access Control.
AIX security, scripting and monitoring experience.
Compensation: $65-$75/hr. (DOE)
Benefits
Benefits are available to eligible VanderHouwen contractors and include coverage for medical, dental, vision, life insurance, short and long term disability, and matching 401k.
About VanderHouwen
VanderHouwen is an award-winning, Women-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen has been successfully placing experienced professionals throughout the Pacific Northwest and nationwide. Our recruitment teams are highly specialized in either Technology and IT, Engineering, or Accounting and Finance career markets. Our recruiters value building meaningful, professional relationships with each candidate as well as developing honed knowledge of companies' staffing needs and workplaces. Partner with us to land your next exciting career.
VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state or federal civil rights laws.
#LI-Remote
- Auditor (Risk Adjustment)
08/13/2024 - SQL Software Engineer
07/15/2024 - Certified Medical Assistant
08/05/2024 - Registered Nurse
06/28/2024 - Data Engineer
08/01/2024 - Human Systems Integration Engineer
07/22/2024 - Risk Adjustment Auditor
08/09/2024 - Senior Structural Engineer
07/26/2024 - Acute Care RN – Medical Surgical ICU
07/08/2024 - Senior Principal Analog Mixed – Signal Design Engineer
05/28/2024
Apply Now
Thank you for your interest in applying for this position! Please fill out the fields below. Your profile will be reviewed with the rest of the applicants.