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.

• 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, scripts, and procedures for quality, performance, and compliance with standards.
• 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 on other systems, operations, and staff cost, and to plan and schedule implementation.
• Prepare and maintain database documentation, procedures, data definitions, and data dictionaries to ensure accurate, up-to-date reference materials.
• Assist in developing and enforcing standards, guidelines, policies, and procedures designed to ensure the integrity, security, and performance of the database environment.
• Support project control, quality assurance, and cost estimating activities related to database and data warehouse implementations.
• Other duties as assigned.

Here’s What You Need

The qualifications and skills listed below are intended to provide a general overview of the requirements for this position. However, due to the anticipated nature of the contract and the absence of a finalized task order from the client, this list should not be considered all-encompassing. Additional qualifications, certifications, skills, or experience specific to the client’s requirements may be identified and requested upon award of the task order. Candidates should demonstrate flexibility and a willingness to adapt to evolving responsibilities as outlined by the client.

• 4–7 years of experience in the database administration, data warehousing, or a closely related information systems field.
• Familiarity with standard concepts, practices, and procedures within the database and data warehouse management discipline.
• Demonstrated ability to rely on experience and judgment to plan and accomplish goals with limited supervision.
• Proven capacity to exercise creativity, initiative, and independent judgment in solving complex technical problems and optimizing database environments.
• Ability to maintain 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.
• Required (5+ Years):
• Strong knowledge of database management systems (DBMS), as well as data warehouse management and decision support tools.
• Extensive experience in the development, implementation, and maintenance of data warehouses and data marts.
• Experience with business intelligence/analytics tools (e.g., Business Objects) and building and maintaining the data dictionary.
• Demonstrated ability to use database access tools to support application delivery and reporting.
• Strong familiarity with analysis, planning, and management reporting functions.
• Well-developed oral and written communications skills.
• Strong teamwork and interpersonal skills to collaborate effectively across technical and non-technical teams.
• Extremely high level of analytical ability to address very unusual and extremely difficult technical problems.
• Understanding of benchmarking processes and techniques for database and data warehouse environments.
• Very high level of interpersonal skills to work effectively with others, motivate teams, and elicit high-quality work output.
• Experience with data warehousing data population and data modeling techniques for target structures such as:
  • Star Schemas
  • Snowflake Schemas
  • Highly normalized data models
  • Hands-on experience with GUI-based ETL tools such as:
  • Informatica
  • IBM WebSphere DataStage
  • Or similar enterprise ETL tools
  • Implementation experience with enterprise-class databases, such as:
  • Teradata
  • Oracle
  • Microsoft SQL Server
  • Or similar technologies
  • Implementation experience with analytical and reporting tools, such as:
  • Business Objects
  • Cognos
  • Hyperion
  • MicroStrategy
  • Or similar tools
  • Experience with the complete data warehouse implementation process, including:
  • Business requirements analysis
  • Logical data modeling
  • Physical database design
  • Data sourcing and data transformation
  • Data loading and ETL processes
  • Structured Query Language (SQL) development and optimization
  • End-user tools and reporting/analytics
  • Database and SQL performance tuning
• Excellent analytical, problem-solving, team collaboration, and oral and written communication skills.
• Proven ability to work successfully with both technical and non-technical groups and to manage multiple responsibilities and priorities simultaneously.
• Experience in computer systems analysis or computer programming work related to databases and data warehouses.
• Knowledge of:
  • Principles, practices, and techniques of computer programming and systems design
  • Computer operations, systems, and procedures
  • Project control and cost estimating techniques
  • Computer programming languages commonly used with databases and data warehouses
  • Data processing flowcharting techniques
  • Database structures and theories
  • Current database technologies and trends
• Working knowledge of EIR Accessibility standards and assistive technologies.
• Ability to ensure that database administration and data input/output user interfaces meet accessibility requirements.
• Experience providing support to users when EIR Accessibility issues arise, including troubleshooting data access and reporting accessibility problems.
• Familiarity with security principles, controls, and compliance requirements relevant to critical infrastructure and national security.
• Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.

Minimum Skills:

• Exceptional interpersonal skills with the ability to communicate in a clear, professional, and articulate manner.
• Exceptional verbal and written communication skills.
• Excellent organizational, analytical, and problem-solving skills with high-level attention to detail.
• Proven ability to multitask and prioritize in a fast past environment with changing priorities; adaptable to change and a quick learner.
• Must be self-motivated and able to work well independently as well as on a multi-functional team.
• Ability to handle sensitive and confidential information appropriately
• Proficient in MS Office, Word, Outlook, PowerPoint, and 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.

Our Commitment to you / overview of benefits

• 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

• Professional hybrid office environment.
• Must be physically and mentally able to perform duties extended periods of time.
• Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.
• Must be able to establish a productive and professional workspace.
• Must be able to sit for long periods of time looking at computer screen.

• May be asked to work a flexible schedule which may include holidays.
• May be asked to travel for business or professional development purposes.
• May be asked to work hours outside of normal business hours.

Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job.  Duties, responsibilities, and activities may change at any time with or without notice.

Cayuse is an Equal Opportunity Employer.  All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.