Database Engineer - Washington, United States - SecuriGence LLC

Description

Job Title: Database Engineer

Location: Washington, DC. Hybrid possibility for local candidate.

Clearance Level: Public Trust

Summary

We deliver essential technology services to our customers in support of their missions to sustain the national security and economic interests of our nation. SecuriGence is seeking a Database Engineer to join us in support of the FCC Enterprise Engineering and Architecture Services (EE&AS) Program to help contribute to our success. As a Database Engineer, you will play a crucial role in designing, developing, and maintaining our data and database infrastructure in the cloud while also supporting the migration of data and databases from on-premise to the cloud. Your expertise in Sybase, Oracle, RDS, SQL, and Aurora will be essential in exceeding the expectations of the position and customer. Help us solve problems with Innovation Through Intelligence.

Responsibilities

• Support the migration of Sybase and Oracle databases to RDS, SQL, and Aurora
• Use of AWS DMS, SSMA, and Azure ADF to migrate databases to the cloud
• Creation of data replication pipelines and flows
• Migration of Proxy tables
• Work closely with cross-functional teams to understand data requirements and design optimal data models and architectures for data/database migrations.
• Troubleshoot data and/or database migration/replication issues
• Provide Tier IV SME support for the O&M DBA team
• Manage large data and database migration projects inception to completion
• Create and optimize data pipelines from scratch, ensuring scalability, reliability, and high-performance processing.
• Perform data cleansing, data integration, and data quality assurance activities to maintain the accuracy and integrity of large datasets.
• Leverage big data technologies to efficiently process and analyze large datasets, particularly those encountered in a federal agency.
• Implement and enforce data governance policies and procedures, ensuring compliance with regulatory requirements and industry best practices.
• Maintain documentation for software applications, workflows, and processes.
• Stay updated with emerging trends and advancements in data engineering and recommend suitable tools and technologies for continuous improvement.

Qualifications

• Minimum of 7 years of experience as a Data Engineer, with demonstrated experience managing and migrating large data and databases
• Advanced knowledge of cloud database solutions and technologies along with advanced knowledge and experience with migrating to cloud database platforms
• High level proficiency with Sybase, Oracle, RDS, SQL, and Aurora database platforms
• High level proficiency with database migration tools - DMS, SSMA, ADF
• High level of proficiency in ETL processes and demonstrated, hands-on experience with technologies such as Databricks, Python, Spark, Scala, JavaScript/JSON, SQL, and Jupyter Notebooks.
• Strong problem-solving skills and ability to solve complex data-related issues.
• Demonstrated experience working with large datasets and leveraging big data technologies to process and analyze data efficiently.
• Understanding of data modeling/visualization, database design principles, and data governance practices.
• Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams.
• Detail-oriented mindset with a commitment to delivering high-quality results.
• Current Public Trust preferred

About

SecuriGence LLC (SG) is an agile, Veteran-owned small business headquartered in the Washington, DC metropolitan region. Established in April 2010 we have been supporting the Department of Defense and other United States Civil agencies in Systems Engineering, Software Engineering, Software Development, Cyber Security, and Cloud/Virtualization Management.

SecuriGence provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.