Role Description Security-cleared Professional: A DOD Secret Clearance or a Top Secret Clearance is required to be considered for this position. You have a Bachelor's Degree in a related field with 3+ years of experience as a Database Engineer using PostgresSQL. Can accept experience in lieu of degree. Additional requirements for the Mid-Level Database Developer position include: - Database experience of working in different OS platforms like Linux and/or RHEL. - Database performance tuning, upgrades, and patching to all COTS database products. - Database script writing (PL/SQL & PL/pgSQL) experience to manage ETL procedures. - 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 (Aurora & Postgres RDS) (Cloud Watch, Cloud Trail, EC2). - Strong understanding of postgres schema, user roles, access control, and security model. - Postgres script writing (PL/pgSQL) with loops, conditions, and variables. - Experience with Oracle development and administration is desired but not required. What you'll do: - Administer and maintain PostgreSQL databases across Linux 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 (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. Qualifications - Bachelor's Degree in a related field. - 3+ years of experience as a Database Engineer using PostgresSQL. Requirements - DOD Secret Clearance or Top Secret Clearance. - Experience with different OS platforms like Linux and/or RHEL. - Database performance tuning and upgrades. - Experience with PL/SQL & PL/pgSQL. - Experience in shell scripting. - Working experience of AWS Cloud Services. - Strong understanding of postgres schema and security model. 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.