Database Administrator

Overview

JOB TITLE:

Database Administrator

CAYUSE COMPANY:

Cayuse Civil Services, LLC

LOCATION

Hybrid in Austin, TX

SALARY:

$91,520.00-$

EMPLOYEE TYPE:

Full-Time Salary Exempt

TRAVEL

No

RELOCATION

No

Employment in this role is conditional upon successful execution of the contract by the client.

The Work

The Database Administrator will perform advanced database administration and management functions in support of highly complex applications characterized by sophisticated data models, multi-stage workflows, and extensive reporting requirements. This position will provide expert leadership in the design, development, maintenance, optimization, and migration of integrated database systems, ensuring that applications conform to enterprise structural and security standards.

This position aligns with Cayuse's core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables.

Responsibilities

• Enter codes and scripts to create and maintain production databases and associated objects.
• Select and configure utility programs and jobs to monitor database performance, such as record distribution, indexing efficiency, and available memory utilization.
• Analyze, design, modify, and maintain logical and physical database structures in support of application and reporting requirements.
• Design and implement procedures necessary to save, retrieve, and recover databases from hardware and software failures in accordance with established recovery objectives.
• Execute backup, restore, and recovery procedures to ensure database availability, reliability, and data integrity.
• Support installation, configuration, and upgrades of database software and migrations to new data management system levels; test and validate migrations to ensure functionality and data reliability.
• Assist in the selection and evaluation of database management software and related tools.
• Provide assistance in the planning, development, implementation, and maintenance of data warehouses, data marts, and decision support environments.
• Perform performance tuning and optimization of database and data warehouse environments, including query optimization, indexing strategies, and resource utilization improvements.
• Monitor database and data warehouse performance, identify bottlenecks, and recommend and implement efficiency improvements.
• Create test database environments for application and reporting teams, including creation of necessary libraries, schemas, and procedures to support development and QA activities.
• Assist in benchmarking and threshold testing to establish performance baselines and capacity planning targets.
• Perform logical and physical data modeling to support transactional and analytical workloads.
• Design relational database models and create physical data models from logical data models aligned with data warehousing best practices (e.g., star schemas, snowflake schemas, normalized structures).
• Evaluate users' requests for new data elements, structures, and systems; incorporate approved changes into the existing shared data environment.
• Perform data modeling and prototyping to validate structure, performance, and usability of proposed database and data warehouse solutions.
• Maintain and govern the data dictionary, ensuring uniformity of definitions and establishing standards for its use across the organization.
• Maintain the security and integrity of critical infrastructure systems by preventing unauthorized access and ensuring compliance with laws and regulations related to national security and foreign ownership restrictions.
• Establish and implement database security controls, including user roles, permissions, access levels, and encryption as appropriate.
• Assist with determining, implementing, and enhancing standards on database security in accordance with organizational and regulatory requirements.
• Execute security recovery procedures and support audit and compliance activities for database environments.
• Assist with monitoring and improving agency disaster recovery procedures and systems related to databases and data warehouses.
• Coordinate the use of data to ensure data integrity, control redundancy, and enforce standards across applications and reporting environments.
• Apply working knowledge of Electronic and Information Resources (EIR) Accessibility standards and assistive technologies to database administration tools and user interfaces.
• Ensure that user interfaces for database administration and for inputting, viewing, and outputting data (including reports) are compliant with accessibility standards.
• Provide support to users in obtaining data/information when EIR Accessibility issues arise, and coordinate with application/report developers to resolve issues.
• Direct and coordinate with programmers, analysts, and other technical staff to implement database changes and enhancements to the database management system.
• Review and correct database-related programs,…