Database Developer

Fusion Technology•Washington, DC

1d•Remote

About The Position

Fusion Technology is seeking a Security-cleared Professional with a DOD Secret Clearance or a Top Secret Clearance for a Mid-Level Database Developer position. The role involves administering and maintaining PostgreSQL databases across Linux environments, performing installations, configurations, upgrades, and routine maintenance. The developer will also write, optimize, and troubleshoot SQL queries, execute backup and recovery processes, analyze and improve database performance, and support AWS-based infrastructure and database services. Additionally, the role includes managing PostgreSQL schemas, roles, and access controls, developing and maintaining PL/pgSQL scripts, performing system and software maintenance, and creating/enhancing shell scripts for automation.

Requirements

DOD Secret Clearance or a Top Secret Clearance required.
Bachelor's Degree in a related field with 3+ years of experience as a Database Engineer using PostgresSQL (experience can be accepted in lieu of degree).
Database experience of working in different OS platform like Linux and/or RHEL.
Database performance tuning, database upgrades, and database patching to all COTS database products.
Database script writing (PL/SQL & PL/pgSQL) experience to manage ETL procedures.
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 (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.

Nice To Haves

Experience with Oracle development and administration is desired but not required.

Responsibilities

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.