Mid-Level SQL Database Engineer

Founded in 2007 and headquartered in Columbia, Maryland, Synergy ECP is a leading provider of cybersecurity, software and systems engineering and IT services to the U.S. intelligence and defense communities. The company leverages its expertise in data transport solutions, software and systems engineering, and other solutions to deliver critical and innovative capabilities to high-level decision makers that enhance our nation’s security.

In an ultra-competitive environment, Synergy ECP has thrived by adhering to our name, making sure excellence is displayed by our employees, to our customers and by Improving Performance (ECP). It’s what sets us apart, enabling us to be an autonomous yet agile business that delivers huge results—showing we’re ready to meet our customers’ evolving demands. Synergy ECP has earned a client list that includes numerous Fortune 100 companies, in addition to multiple branches of the US government and military services.

The candidate must have experience with Postgre

SQL and PostGIS.

• Design and optimize Postgre
  
  SQL 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.

• Strong SQL skills and experience with performance tuning and query optimization.
• Proficiency in Linux/Unix environments and CLI tools like psql.
• Experience with logical and physical replication, partitioning, and backup strategies.
• Familiarity with monitoring tools (e.g., _statements, Prometheus, Grafana).
• Knowledge of scripting languages for automation and tooling.

Provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational and/or Object-Oriented databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Responsible for developing 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.

The DBE works primarily at the front end of the lifecycle-requirements through system acceptance testing and Initial Operational Capability (IOC). Develops requirements from a project’s inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts.

Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies.

Five (5) years’ experience as a DBE in programs and contracts of similar scope, type, and complexity is required. Bachelor’s degree in a technical discipline from an accredited college or university is required. Five (5) years of DBE experience may be substituted for a bachelor’s degree.

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