Logo
ClearanceJobs

Database Engineer Level 2

ClearanceJobs, Fort George Meade, Maryland, United States

Save Job

Database Engineer

MissionEdge Technologies is seeking a qualified candidate that 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. Essential Job Functions: 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. Minimum Required Qualifications: Due to the nature of this position and the information that employees will be required to access; U.S. Citizenship is required. Active TS/SCI w/ polygraph 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. 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. Desired/Preferred Skills: 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. Working Conditions: Work is typically based in a busy office environment and subject to frequent interruptions. Business work hours are normally set from Monday through Friday 8:00am to 5:00pm, however some extended or weekend hours may be required. Additional details on the precise hours will be informed to the candidate from the Program Manager/Hiring Manager. Physical Requirements: May be required to lift and carry items weighing up to 25 lbs. Requires intermittent standing, walking, sitting, squatting, stretching and bending throughout the workday. Background Screening/Check/Investigation: Successful Completion of a Background Screening/Check/Investigation will be required as a condition of hire. Benefits: MissionEdge Technologies offers competitive compensation, a flexible benefits package, career development opportunities that reflect its commitment to creating a diverse and supportive workplace. Benefits include, not all inclusive - Medical, Vision & Dental Insurance, Paid Time-Off & Company Paid Holidays, Personal Development & Learning Opportunities. Other: This employer participates in employment verification and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. MissionEdge Technologies is an Equal Opportunity/Affirmative Action Employer that does not unlawfully discriminate in any of its programs or activities on the basis of race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other basis prohibited by applicable law. We strive to create a diverse, inclusive and respectful work culture that values all.