SQL Database Engineer

Synergy ECP • Annapolis Junction, MD

59d • $130,000 - $160,000

About The Position

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.

Requirements

• 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.
• 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.
• This position requires in-scope poly, within 7 years.
• TS/SCI w/ Polygraph
• U.S. Citizenship

Nice To Haves

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

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.

Benefits

• 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 it’s 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!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 101-250 employees