Mid-Level SQL Database Engineer

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 nations security.

In an ultra-competitive environment, Synergy ECP has thrived by adhering to our name, making sure excellence is displayed by our E mployees, to our C ustomers and by Improving P erformance (ECP). Its what sets us apart, enabling us to be an autonomous yet agile business that delivers huge resultsshowing were 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 PostgreSQL and PostGIS.

Key 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.

Required Qualifications :

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., pg_stat_statements, Prometheus, Grafana).

Knowledge of scripting languages for automation and tooling.

Description :

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 projects 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. Bachelors degree in a technical discipline from an accredited college or university is required. Five (5) years of DBE experience may be substituted for a bachelors 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 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 projects 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.

Preferred Qualifications :

Experience with containerized environments (Docker, Kubernetes).

Familiarity with cloud platforms (AWS RDS, GCP Cloud SQL, or Azure Database for PostgreSQL).

Understanding of CI / CD pipelines and infrastructure as code (Terraform, Ansible).

Exposure to other RDBMS (e.g., Oracle, MySQL) or NoSQL systems is a plus.

This position requires in-scope poly, within 7 years.

CLEARANCE REQUIRED :

TS / SCI w / Polygraph

Other Requirements : U.S. Citizenship

Compensation Spotlight :

For this role, our typical salary range starts at $130,000 and stretches up to $160,000. But here's the deal we're not about capping your potential. We're committed to snapping up the best and brightest, and we're ready to put our money where our mouth is. So, if you're one of the rare exceptions to the status quo with the education, experience, and that extra something special, we're not afraid to go above and beyond to secure your talent. Because for us, it's not just about a salary. It's about the complete rewards package, the culture, and the opportunity to make a real impact.

Taking Care of the People Who Take Care of The Nation

Compensation : We offer highly competitive compensation that is consistently recognized by our employees as being generous!

Health & Retirement : We offer a comprehensive Health Benefits package and 401K Retirement plan so you can take care of yourself and your family... both now and in the future. Other health-related benefits include an employee Gym wellness benefit, People Partners who will help you navigate both personal and professional worlds, as well as strong wellness related resources offered through our healthcare provider.

Education : Individual growth is a priority at Synergy ECP. Employees are encouraged to take advantage of our company-sponsored continuing education program so they can get their degree or that next certification needed to propel them towards the next level. Not sure what's best for your career plans, we'll help you navigate it all!

Work / Life Balance : A healthy work / life balance is essential for building and executing your work effectively at Synergy ECP, but its also necessary to allow you the room to pursue everything you want to develop in your personal life. We offer a generous Paid Time Off benefit and 11 paid holidays a year. Synergy ECP also provides flexible work options that work with your schedule and lifestyle.

Philanthropy : With the help of our amazing employees, Synergy ECP participates annually in building awareness, volunteering and contributing to dozens of organizations. We believe that giving back creates a sense of purpose, engagement, and fulfillment. Have a cause you are passionate about? We bet you'll find others here that care about it just as much!

Great Corporate Facilities : Come by our corporate office and enjoy a weekly happy hour, take a drive to nearby restaurants, grab a snack or coffee in our caf, or utilize our collaborative office space and conference rooms.

SkillBridge : Our SkillBridge Program takes the incredible experience our servicemembers already have and shows them how to apply it within corporate environments. We are fanatical about helping our Military!

Synergy ECP is committed to providing equal employment opportunities to all qualified individuals. Employment decisions are based on merit, qualifications, and business needs. We do not discriminate on the basis of race, color, sex, national origin, religion, age, disability, or any other status protected by applicable law.

We welcome candidates from all backgrounds and are dedicated to maintaining a professional and respectful workplace where every employee can succeed.

PI799835da96c0-30511-38924477