Database Administrator 2

Trilogy Innovations•Bridgeport, WV

2d•Remote

About The Position

At Trilogy Innovations, we are committed to driving meaningful change for our customers and communities through smart, innovative technology that solves real problems. As a growing systems and software engineering company, we partner across public and private sectors to modernize enterprise systems, strengthen security, and deliver high value solutions. We are scaling with purpose, investing in our people, processes, and platforms as we expand. We work hard, think creatively, and value every perspective as we push boundaries and build systems that matter. You are the kind of Database Administrator who enjoys digging into problems and making systems run faster, cleaner, and smarter. You know your way around Oracle and PostgreSQL, and you are just as comfortable in a Linux environment as you are navigating cloud platforms like AWS. You have a solid handle on the fundamentals, backups, performance tuning, and database optimization are not new concepts to you. You have likely written your fair share of SQL and scripts, and you take pride in making things more efficient than you found them. You are naturally curious. When something breaks, you want to understand why, not just fix it and move on. When something works, you look for ways to make it even better. You are proactive, detail-oriented, and not afraid to take ownership. You work well with others, explain technical concepts without making it complicated, and keep a cool head when things get busy. Most importantly, you care about the impact of your work, because behind every database is a mission that depends on it running right. This position will require being on call once every 2 months.

Requirements

Bachelor's Degree required or related field or equivalent experience
3+ years' experience in Database Administration
Secret Level Security Clearance
Hands-on experience administering Oracle (19c/21c) and PostgreSQL databases in production environments
Strong understanding of database performance tuning, optimization, and troubleshooting
Experience with backup and recovery strategies, including RMAN and PostgreSQL tools such as pg_dump and PITR
Solid SQL skills, including writing, optimizing, and analyzing complex queries
Experience working across Linux, RHEL, and Windows operating systems
Familiarity with AWS services such as EC2, CloudWatch, CloudTrail, and RDS (Oracle, PostgreSQL, Aurora)
Experience with database patching, upgrades, and overall system maintenance
Scripting experience using shell, PL/SQL, or PL/pgSQL to automate tasks and improve efficiency
Understanding of database security, user roles, access control, and data integrity best practices
Ability to support database integrations and work across multiple systems and applications
Strong problem-solving skills with a proactive, solution-oriented mindset
Clear communication skills and the ability to work effectively with technical and cross-functional teams

Responsibilities

Administer, support, configure, upgrade, and maintain Oracle (19c/21c) and PostgreSQL databases across Linux, RHEL, and Windows environments.
Manage database high availability and recovery solutions, including Oracle Data Guard, RMAN, and PostgreSQL backup and recovery methods such as pg_dump, pg_basebackup, and point-in-time recovery (PITR).
Perform database performance tuning and troubleshooting using tools such as AWR, ASH, ADDM, and PostgreSQL explain plans and monitoring utilities.
Execute database patching, upgrades, and maintenance across all COTS database platforms.
Develop and maintain database scripts using PL/SQL and PL/pgSQL, including loops, conditions, and variables.
Design and manage database storage, schemas, user roles, access controls, and security models.
Support database interfaces, integrations with external applications, and cross-system data interactions.
Utilize AWS cloud services, including CloudWatch, CloudTrail, EC2, and RDS (Oracle, PostgreSQL, Aurora).
Perform system-level performance tuning, hardware replacements, firmware upgrades, and patching across operating systems and COTS software.
Develop and maintain shell scripts to automate monitoring, maintenance, and operational tasks.
Apply strong SQL expertise, including query writing, optimization, indexing, and normalization.