Database Developer Engineer

AMERICAN SYSTEMS is an employee-owned federal government contractor supporting national priority programs through our strategic solutions in the areas of Information Technology, Test & Evaluation, Program Mission Support, Engineering & Analysis, and Training.

Responsibilities

As a Database Developer Engineer, you will design, build, and manage robust database architecture using technologies like Databricks and MS Access. Key responsibilities include developing secure data pipelines, performing complex data transformations, and ensuring database performance and integrity. You will write code in languages such as Python, R, and VBA to create data-driven applications and collaborate with interagency teams to protect the nation's research and engineering data.

As a Database Developer Engineer, you will:

• Database Architecture and Development: Design, develop, and implement robust database architectures, incorporating advanced analytics and data processing, to meet organizational requirements for data storage, retrieval, and analysis. This includes schema design, performance optimization, and ensuring scalability across various platforms, including MS Access.
• Databricks Development and Integration: Leverage Databricks to build and deploy data pipelines, perform complex data transformations, and develop data-driven applications. This includes working with Databricks notebooks, clusters, and related infrastructure.
• Database Administration and Management: Implement, deploy, and maintain databases on various platforms, including MS Access, ensuring performance, security, availability, and data integrity. This includes tasks such as backup, recovery, migration, and upgrade.
• MS Access Development and Maintenance: Develop and maintain MS Access databases and applications, including VBA scripting and automation, to support specific business needs and integrate with other systems.
• Data Management and Governance: Implement and adhere to company data management practices and policies, ensuring data quality, security, and compliance across all database platforms.
• Secure Development Practices: Develop and maintain secure database solutions, adhering to best practices and security protocols to protect sensitive research and engineering (R&E) data.
• Collaboration and Cross-Functional Teamwork: Collaborate with multiple interagency teams to contribute to protecting the nation's R&E technology ecosystem. This includes cross walking adversary technology status with our nation's current research cadence and progress.
• Code Development: Write code to interact with databases, develop database applications, integrate with Databricks, and potentially develop scripts and automation for MS Access using VBA and other relevant languages .

Qualifications

• BS or higher Degree required in a STEM field.
• Five years of experience in database architecture, design, and implementation is desired, including two years utilizing Databricks and demonstrated proficiency in MS Access development and maintenance, specifically VBA scripting.
• Current and active Secret Clearance Required and must be TS/SCI Clearance eligible.
• U.S. Citizenship Required for the purposes of obtaining/holding a U.S. security clearance.
• Proficiency in programming languages such as R, Python and SQL. Experience with VBA for MS Access automation is essential. Experience with other languages like Java, Scala, PL/SQL, C++, C#, and HTML is a plus.
• Strong understanding of database design principles, including data modeling, schema design, and database normalization.
• Experience with database management systems (e.g., PostgreSQL, MySQL, SQL Server, MS Access).
• Experience with cloud-based databases and data warehousing solutions, including Amazon RDS, Google Cloud SQL, Microsoft Azure Database Services, and ideally cloud-based data lakes.
• Hands-on experience with Databricks, including cluster management, notebook development, and data pipeline creation.
• Experience with data governance, data quality, and data security best practices.
• Strong oral and written communication skills.
• Strong team orientation and ability to collaborate effectively in a multi-disciplinary environment.
• Ability to be on-site for classified work and meetings.
• Proactive, organized, and detail-oriented.

Pay Transparency Statement

AMERICAN SYSTEMS is committed to pay transparency for our applicants and employee-owners. The salary range for this position is USD $108,100.00/Yr. - USD $180,600.00/Yr. Actual compensation will be determined based on several factors permitted by law. AMERICAN SYSTEMS provides for the welfare of its employees and their dependents through a comprehensive benefits program by offering healthcare benefits, paid leave, retirement plans, insurance programs, and education and training assistance.

EEO Statement

EEO Race/Sex/Disability Status/Veteran Status