Database Engineer

Iquasar, LLC.
Reston, VA, United States
about 1 month ago
Apply on www.juju.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Working hours
Regular working hours
Job source

Tech stack

Airflow Amazon Web Services Amazon S3 Applications Architecture Bash Shell Cloud Database Databases Information Engineering Data Integrity Extract Transform Load (ETL) Data Loss Database Queries
+18 more
Python (Programming Language) PostgreSQL Performance Tuning SQL Databases Management of Software Versions Workflow Management Systems Data Processing Scripting Cloud Platform System Database Optimization Apache Spark Database Performance Backend Database Migration Information Technology AWS Glue Apache Kafka Data Pipelines

Job description

  • Database engineers will develop applications and data pipelines using PostgreSQL, Python and AWS.
  • Design, develop, and maintain PostgreSQL database architecture for enterprise backend applications.
  • Lead schema design, database migrations, versioning, and ensure backward compatibility.
  • Optimize SQL queries, indexing strategies, execution plans, and overall database performance.
  • Assist in identifying performance bottlenecks in PostgreSQL RDS. Apply basic performance tuning techniques like reviewing query execution plans, adding missing indexes, and recommending parameter adjustments.
  • Monitor ETL workflows and data pipelines for errors, performance bottlenecks, and processing delays. Troubleshoot and resolve issues to ensure reliable and timely data movement.
  • Provide support for data related issues and participate in root cause analysis.
  • Configure and manage database backup and recovery strategies to ensure data integrity and availability in case of failures or data loss.
  • Analyze database query performance and collaborate with developers to optimize SQL queries and schemas.
  • Participate in continuous improvement initiatives to enhance the reliability, scalability, and performance of cloud databases.
  • Assist in the design and optimization of database schemas for cloud environments.

Requirements

  • Familiarity with data pipeline concepts and technologies such as Kafka Connect, and ETL frameworks.
  • Strong understanding of Amazon Glue, Redshift and S3.
  • Exposure to Apache Spark for data processing.
  • Basic understanding of Apache Airflow for workflow orchestration.
  • Strong SQL scripting skills for querying and data manipulation.
  • Strong experience with scripting languages (e.g., Python, Bash).
  • Having ‘AWS Certified Database - Specialty’ certification is a plus., * Bachelor’s degree in computer science, Information Technology, or a related field.
  • 5-8 years of experience in data Engineering, with a focus on AWS Glue, Python and PostgreSQL.
  • 2-4 years of hands-on experience with PostgreSQL RDS

About the company

iQuasar is seeking to fill in a Database Engineer in Reston, VA. At iQuasar we strive to provide the next generation of cutting-edge technologies. Our growth means exciting career opportunities for talented professionals in engineering, software development, and other key areas. We offer competitive compensation and benefits including Health, Vision, and Dental Insurance, matching 401k plan, and other benefits given below, excellent training, and a vibrant working environment. Our employees are exceptional, giving us a competitive advantage by innovating solutions with a strong sense of mission and integrity.

One of our clients in Reston VA needs a Database Engineer for a permanent position.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.juju.com
Prepare application

Good distractions

Loading talks and stories from around this role…