Guard Jobs

About The Position

Requirements

• DOD Secret Clearance or a Top Secret Clearance is required.
• Bachelor's Degree in a related field with 3+ years of experience as a Database Administrator (experience can be accepted in lieu of degree).
• Database experience of working in different OS platforms like Linux, RHEL and Windows.
• Experience in Oracle 19C/21C database administration, support, implantation, configuration and upgrade.
• Experience in Oracle Data Guard, RMAN (Backup & Recovery), Cloning, Resource Management, OEM Grid administration and Implementation for version 19C/21C databases.
• Experience in Oracle database performance tuning using AWR/ASH/ADDM reports for troubleshooting performance issues.
• Working experience of AWS Cloud Services (Cloud Watch Cloud Trail, EC2) and Databases (ORACLE & Postgres RDS).
• Database performance tuning, database upgrades, and database patching to all COTS database products.
• Database script writing (PL/SQL), database storage management, database interfaces, external application database interfaces, and other systems database interfacing.
• Performance tuning, hardware replacement, firmware upgrades, and patching to all COTS software products, including operating systems.
• Experience in shell scripting to enhance and update daily monitoring tasks.
• Working experience of AWS Cloud Services (Cloud Watch Cloud Trail, EC2) and Databases (Oracle, Aurora & Postgres RDS).
• Strong understanding of postgres schema, user roles, access control and security model.
• Postgres script writing (PL/pgSQL) with loops, conditions and variables.

Responsibilities

• Administer and maintain Oracle and PostgreSQL databases across Linux, RHEL, and Windows environments, ensuring reliability and availability.
• Perform database installations, configurations, upgrades, and routine maintenance activities with minimal supervision.
• Write, optimize, and troubleshoot SQL queries, applying best practices in normalization and indexing to support application performance.
• Execute and monitor backup and recovery processes, including pg_dump, pg_basebackup, and point-in-time recovery (PITR).
• Analyze and improve database performance using explain plans and monitoring tools, resolving performance issues as they arise.
• Support AWS-based infrastructure and database services, including EC2, CloudWatch, CloudTrail, and RDS (Oracle, Aurora, PostgreSQL).
• Manage PostgreSQL schemas, roles, and access controls, ensuring adherence to security and compliance standards.
• Develop and maintain PL/pgSQL scripts to support database functionality and automation needs.
• Perform system and software maintenance, including patching, upgrades, and coordination of hardware-related changes when required.
• Create and enhance shell scripts to automate monitoring, alerting, and routine operational tasks.

Benefits

• Best-in-class matching 401K program
• Comprehensive healthcare plan through Cigna
• Competitive employer contribution to a health savings account
• Vision and dental plans
• Life insurance
• Short- and long-term disability
• Personal leave
• Paid certifications and training