Database Administrator

Database Administrator

Cayuse Civil Services, LLC is seeking a skilled Database Administrator for a hybrid role in Austin, TX. This full-time position offers a salary range of $91,520.00 - $131,040.00 annually. Employment is contingent upon the successful execution of the client contract.

The Work

The Database Administrator will perform advanced database administration and management functions for complex applications with sophisticated data models, multi-stage workflows, and extensive reporting requirements. This role involves providing expert leadership in the design, development, maintenance, optimization, and migration of integrated database systems, ensuring adherence to enterprise structural and security standards. This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity.

Responsibilities

• Enter codes and scripts to create and maintain production databases and associated objects.
• Select and configure utility programs to monitor database performance, such as record distribution, indexing efficiency, and memory utilization.
• Analyze, design, modify, and maintain logical and physical database structures for application and reporting needs.
• Design and implement procedures for database backup, retrieval, and recovery from failures.
• 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.
• Assist in the selection and evaluation of database management software and related tools.
• Provide assistance in planning, developing, implementing, and maintaining 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/implement efficiency improvements.
• Create test database environments for application and reporting teams.
• Assist in benchmarking and threshold testing for performance baselines and capacity planning.
• Perform logical and physical data modeling for transactional and analytical workloads.
• Design relational database models and create physical data models from logical models, aligning with data warehousing best practices.
• Evaluate user requests for new data elements, structures, and systems; incorporate approved changes into the shared data environment.
• Perform data modeling and prototyping to validate structure, performance, and usability of proposed solutions.
• Maintain and govern the data dictionary, ensuring uniformity of definitions and standards.
• Maintain security and integrity of critical infrastructure systems by preventing unauthorized access and ensuring compliance with national security and foreign ownership regulations.
• Establish and implement database security controls, including user roles, permissions, access levels, and encryption.
• Assist with determining, implementing, and enhancing database security standards.
• Execute security recovery procedures and support audit and compliance activities.
• Assist with monitoring and improving agency disaster recovery procedures and systems for databases and data warehouses.
• Coordinate data usage to ensure data integrity, control redundancy, and enforce standards.
• Apply working knowledge of Electronic and Information Resources (EIR) Accessibility standards to database administration tools and user interfaces.
• Ensure user interfaces for database administration and data input/output are compliant with accessibility standards.
• Provide support to users encountering EIR Accessibility issues and coordinate with developers to resolve them.
• Direct and coordinate with programmers, analysts, and other technical staff to implement database changes and enhancements.
• Review and correct database-related programs, scripts, and procedures for quality, performance, and compliance.
• Answer user questions and provide technical assistance regarding data, database structures, and access tools.
• Confer with coworkers and stakeholders to determine the impact of database changes and to plan implementation.
• Prepare and maintain database documentation, procedures, data definitions, and data dictionaries.
• Assist in developing and enforcing standards, guidelines, policies, and procedures for the database environment.
• Support project control, quality assurance, and cost estimating activities related to database and data warehouse implementations.
• Other duties as assigned.

Qualifications

This list is a general overview; additional qualifications may be requested by the client after contract award. Candidates should be flexible and adaptable.

• 4–7 years of experience in database administration, data warehousing, or a related information systems field.
• Familiarity with standard concepts, practices, and procedures in database and data warehouse management.
• Demonstrated ability to plan and accomplish goals with limited supervision using experience and judgment.
• Proven capacity for creativity, initiative, and independent judgment in solving complex technical problems.
• Ability to maintain security and integrity of critical infrastructure systems and ensure compliance with national security and foreign ownership regulations.
• Required (5+ Years):
• Strong knowledge of database management systems (DBMS), data warehouse management, and decision support tools.
• Extensive experience in developing, implementing, and maintaining data warehouses and data marts.
• Experience with business intelligence/analytics tools (e.g., Business Objects) and building/maintaining the data dictionary.
• Demonstrated ability to use database access tools for application delivery and reporting.
• Strong familiarity with analysis, planning, and management reporting functions.
• Well-developed oral and written communication skills.
• Strong teamwork and interpersonal skills for cross-functional collaboration.
• Extremely high level of analytical ability for complex technical problems.
• Understanding of benchmarking processes and techniques for database and data warehouse environments.
• Very high level of interpersonal skills for motivating teams and achieving high-quality output.
• Experience with data warehousing data population and data modeling techniques (Star Schemas, Snowflake Schemas, highly normalized data models).
• Hands-on experience with GUI-based ETL tools (e.g., Informatica, IBM WebSphere DataStage, or similar).
• Implementation experience with enterprise-class databases (e.g., Teradata, Oracle, Microsoft SQL Server, or similar).
• Implementation experience with analytical and reporting tools (e.g., Business Objects, Cognos, Hyperion, MicroStrategy, or similar).
• Experience with the complete data warehouse implementation process (requirements analysis, data modeling, database design, data sourcing, ETL, SQL development, end-user tools, performance tuning).
• Excellent analytical, problem-solving, team collaboration, and communication skills.
• Proven ability to work with technical and non-technical groups and manage multiple responsibilities.
• Experience in computer systems analysis or programming related to databases and data warehouses.
• Knowledge of programming principles, systems design, computer operations, database structures, current database technologies, and trends.
• Working knowledge of EIR Accessibility standards and assistive technologies.
• Ability to ensure database administration and data input/output user interfaces meet accessibility requirements.
• Experience providing support for EIR Accessibility issues, troubleshooting data access and reporting problems.
• Familiarity with security principles, controls, and compliance requirements for critical infrastructure and national security.
• Must be able to pass a background check; additional checks may be required.
• Minimum Skills:
• Exceptional interpersonal skills with clear, professional, and articulate communication.
• Exceptional verbal and written communication skills.
• Excellent organizational, analytical, and problem-solving skills with high attention to detail.
• Proven ability to multitask and prioritize in a fast-paced, changing environment; adaptable and a quick learner.
• Self-motivated with ability to work independently and on a multi-functional team.
• Ability to handle sensitive and confidential information appropriately.
• Proficient in MS Office Suite (Word, Outlook, PowerPoint, Excel).
• Ability to build trust and maintain relationships across technical and business teams.
• Preferred Qualifications:
• 5+ years of experience with Oracle Database administration and development.
• 5+ years of experience creating reports using SQL Server Reporting Services (SSRS).
• 1+ year of experience with M204 database environments.

Benefits

Cayuse offers a comprehensive benefits package:

• Medical, Dental, and Vision Insurance; Wellness Program
• Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
• Short-Term and Long-Term Disability options
• Basic Life and AD&D Insurance (Company Provided)
• Voluntary Life and AD&D options
• 401(k) Retirement Savings Plan with matching after one year
• Paid Time Off

Reports to: Program Manager

Working Conditions

This is a professional hybrid office environment in Austin, TX. The role requires the ability to perform duties for extended periods, use a computer and office tools efficiently, and establish a productive workspace. Candidates must be able to sit for long periods and may be asked to work flexible schedules, travel, or work outside normal business hours.

Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities.

Key skills/competency

• Database Administration
• Data Warehousing
• SQL
• ETL Tools
• Performance Tuning
• Data Modeling
• Database Security
• Reporting Tools
• System Analysis
• Technical Support