Apply on Employer Site

Synergy ECP · 2 months ago

Mid-Level SQL Database Engineer

Annapolis Junction, MD

Full-time

Onsite

Mid, Senior Level

$130K/yr - $160K/yr

5+ years exp

Synergy ECP is a leading provider of cybersecurity, software and systems engineering, and IT services to the U.S. intelligence and defense communities. The Mid-Level SQL Database Engineer will be responsible for designing and optimizing PostgreSQL database schemas, monitoring database performance, and collaborating with developers to refine complex queries. This role also involves supporting database administration and development activities and ensuring the database structure fits into the overall architecture of the system.

Cyber SecurityProcurementProject Management

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

Design and optimize PostgreSQL database schemas, indexes, and queries for performance and scalability

Monitor and tune database performance using native tools and custom scripts

Implement and maintain high availability (HA) and replication strategies

Collaborate with developers to refine complex queries and stored procedures

Automate routine tasks using scripting languages (e.g., Bash, Python)

Document database architecture, processes, and best practices

Support the database design, development, implementation, information storage and retrieval, data flow and analysis activities

Support the development of long and short-term requirements for database administration and design

Support the analysis and evaluation of system improvements, optimization, development and/or maintenance efforts

Translate a set of requirements and data into a usable database schema by creating or recreating ad hoc queries, scripts and macros, updates existing queries, creates new ones to manipulate data into a master file

Assist in developing databases, database parser software, and database loading software

Assist in developing database structures that fit into the overall architecture of the system under development

Lead development of databases, database parser software, and database loading software

Lead development of database structures that fit into the overall architecture of the system under development

Develop requirement recommendations from a project’s inception to its conclusion for a particular Business and IT subject matter area (i.e. simple to complex systems)

Develop a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls