Database Administrator 2

Database Administrator 2 Secret Level Security Clearance Required

About the Role

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 written a 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 them 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.

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 commercial off‑the‑shelf 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 commercial off‑the‑shelf software.
• Develop and maintain shell scripts to automate monitoring, maintenance, and operational tasks.
• Apply strong SQL expertise, including query writing, optimization, indexing, and normalization.

Qualifications

• 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.

Work Environment

Remote with limited travel.

Compensation and Benefits

• Competitive salary based on experience.
• Performance bonus eligibility.
• 401k with company match.
• Medical, dental, and vision coverage.
• Life and disability insurance.
• Health Savings Account.
• Professional development programs.
• Employee referral bonus program.

Equal Opportunity Employer Trilogy Innovations, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Apply tot his job Apply To this Job