Offer summary

Qualifications:

Bachelor’s Degree in Computer Science, Information Systems, or related field., 5+ years of experience in database administration with Oracle and/or PostgreSQL., Proven experience migrating databases to AWS RDS or Aurora PostgreSQL., Strong understanding of data security practices in federal environments..

Key responsibilities:

Serve as the lead DBA for Oracle and PostgreSQL database environments.

Design and implement scalable and secure database structures.

Lead database migration efforts from on-premise Oracle to AWS RDS for PostgreSQL.

Optimize database performance and ensure high availability and data integrity.

Job description

Description

Title: Senior Database Administrator
Location: Remote (U.S. Citizenship Required)
Terms: Full-Time
Clearance Requirement: Must be a U.S. Citizen and able to obtain and maintain a Federal Security Clearance
Travel: 0–20%

RESULTS. INNOVATION. VALUES. ACCOUNTABILITY.
That’s RIVA. Our employee-first approach has cultivated a culture that attracts the best and brightest. By investing in people first and providing a flexible work environment, our employees experience higher morale, increased productivity, and lower turnover. At RIVA, people are our #1 priority.

RIVA is seeking a skilled and driven Senior Database Administrator to support the U.S. Patent and Trademark Office (USPTO) Patent Trial and Appeal Case Tracking System (P-TACTS). This position plays a critical role in modernizing the system’s data infrastructure as it transitions from a monolithic, on-premise Oracle environment to a cloud-optimized PostgreSQL solution hosted on AWS.

Key Responsibilities Include:

Database Architecture & Operations:

Serve as the lead DBA for mission-critical Oracle and PostgreSQL database environments.
Design and implement scalable, secure, and performant database structures to support both legacy and modernized application architectures.
Support application teams with schema design, data modeling, and integration best practices in a microservices-aware environment.

Cloud Migration & Infrastructure Modernization:

Lead database migration efforts from on-premise Oracle to AWS RDS for PostgreSQL.
Collaborate with DevOps to implement Infrastructure-as-Code (IaC) using Terraform and CI/CD pipelines.
Enable containerized deployment of microservices as the system transitions from a tightly coupled monolithic structure.

Performance, Availability & Security:

Optimize database performance through indexing, query tuning, partitioning, and resource management.
Ensure high availability, disaster recovery, and data integrity across staging and production environments.
Enforce data security policies aligned with FISMA and federal compliance standards, including encryption and access governance.

Automation & Support:

Automate backup, patching, and monitoring processes using scripting (e.g., Bash) and AWS-native tools.
Provide operational support for legacy Oracle databases during the transitional period to cloud-native systems.

Minimum Qualifications:

Bachelor’s Degree in Computer Science, Information Systems, or related field.
5+ years of experience in database administration with Oracle and/or PostgreSQL in enterprise or government environments.
Proven experience migrating databases to AWS RDS or Aurora PostgreSQL, including tuning and maintenance.
Proficiency with Terraform, shell scripting (e.g., Bash), and cloud-native tooling for infrastructure automation.
Familiarity with microservices architecture and how databases interface with applications built in Java 17, Spring Boot, and Angular.
Strong understanding of data security practices in federal environments, including encryption and access controls.
Demonstrated ability to collaborate cross-functionally with DevOps, application developers, and security teams.

Preferred Qualifications:

Experience with AWS CloudWatch, CloudFormation, or similar services.
Knowledge of P-TACTS or similar case tracking or content management systems.
Understanding of breaking down monolithic applications into microservices.
Previous support of federal clients or working in FISMA-moderate environments.

Salary Range: $100,000 – $130,000

RIVA Benefits:

Paid Time Off / Sick Leave
Health, Dental, and Vision Coverage
Life Insurance
401(k) with Company Matching
HSA/FSA Spending Accounts
Long- and Short-Term Disability
Pet Insurance
Wellness Program Initiatives
RIVA Flex
Additional Workplace Benefits

RIVA Solutions is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected class. If you need a reasonable accommodation to search for a job opening or to submit an online application, please email [email protected].

Required profile