DPS - IT - Database Administrator IV IT Job Austin area,Texas USA,IT/Tech

Position: DPS - IT - Database Administrator IV IT - 0214

GENERAL DESCRIPTION

GENERAL DESCRIPTION: Perform advanced (senior level) database administration work. Provide direction and guidance in strategic operations and planning; provide for the effective and efficient storage, retrieval, customization, and archiving of data ensuring integrated database systems; plan, develop, and implement database policies and procedures; and maintain and verify data integrity. May assign and/or supervise the work of others. Work under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

Applicants must fully complete the summary of experience to determine if minimum qualifications are met. The following Military Occupational Specialty codes are generally applicable to this position.

Essentials and qualifications details are described below.

ESSENTIAL DUTIES / RESPONSIBILITIES

Oversee the design and maintenance of database structures and develop policies and procedures designed to ensure the integrity of the database environment(s) on premises or in the cloud.

Oversee the evaluation of database software packages for potential acquisition.

Develop and review policies and procedures to guide in the use and acquisition of database software and resources.

Oversee logical and physical data modeling, evaluate relational database models, and review physical data models created from logical data models.

Coordinate and oversee migration to new data management system software levels and ensure that appropriate testing and validation are completed.

Design, recommend, and implement procedures necessary to save and recover databases from hardware and software failures.

Evaluate and review database performance monitoring, implement efficiency improvements, and modify existing databases and database management systems.

Recommend and implement necessary database security standards and controls.

Assess future information requirements and develop goals and objectives for the improvement and use of an efficient and cost-effective database system.

Develop budgets for database management systems.

May assign and/or supervise the work of others.

Attend work regularly and observes approved work hours in accordance with agency leave and attendance policies.

Perform other duties as assigned.

GENERAL QUALIFICATIONS and REQUIREMENTS

Education – Graduation from an accredited four-year college or university with a major in Computer Science, Information Technology, or a related field is required.

Experience – Minimum of four (4) years’ progressively responsible experience in Extract Transform Load development is required. Minimum of four (4) years’ experience in Data Modeling is required. Minimum of eight (8) years’ experience in relational databases. Experience in DB2 is required. Experience in MySQL, SQL Server and Postgre

SQL is preferred. Have hands-on experience in a multitude of domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud database infrastructure design and management, security, business continuity, disaster recovery, big data, data warehousing, business intelligence, predictive analytics, database design, database tuning, application optimization, application design, resource provisioning, virtual computing and storage, enterprise data storage and backup, incident tracking, change management, and general database administration.

Substitution

Note:

Additional work experience of the type described or other related education may be substituted for one another on a year-for-year basis.

Licensure and/or Certification – If driving is required, must possess a valid driver license from state of residence.

Critical Organizational Infrastructure requirements – This job may be responsible for conducting research on, working on, or having the ability to access critical organizational infrastructure; must be able to maintain the security and integrity of the infrastructure related to this role. Additionally, and more specifically, must not be employed by nor have any connection or continuous connections to any governmental entity or political apparatus of a country listed in 15 C.F.R. §791.4.

Regulatory Knowledge – Working knowledge of, or the…


Increase/decrease your Search Radius (miles)



Job Posting Language