AWS Lambda, Access Control, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Auditing, Best Practices, Capacity Management, Code Reviews, Cryptography, Data Analysis, Data Cleaning, Data Management, Data Modeling, Data Partitioning, Data Recovery, Database Administration, Database Extract Transform and Load (ETL), Database Programming, Disaster Recovery, Identify Issues, Information/Data Security (InfoSec), MongoDB, NoSQL, Operations Processes, Performance Tuning/Optimization, PostgreSQL, Product Support, Python Programming/Scripting Language, Query Optimization, Replication and Remote Mirroring, Scalable System Development, Scripting (Scripting Languages), Theater Production, Time Management
At Staffworxs, we don't just connect talent we power transformation. Headquartered in Frisco, TX, with teams in Bengaluru and Hyderabad, we combine global reach with deep expertise. Our Digital & Data Analytics practice drives growth and innovation for some of the world's top brands, who continue to retain us as their trusted partner. If you're ready to make an impact, you're in the right place.
Job Details:
Position : Data Engineer/Database Administrator
Location: Bellevue, WA
Duration : Longterm Project
Job Description:
About the Role
We're looking for a mid-level Data Engineer & DBA to join our data platform team. You'll build and maintain scalable data pipelines while ensuring our databases are reliable, secure, and high-performing. You'll work closely with analysts, engineers, and product teams to deliver clean and timely data.
Mandate: MongoDB expert level
What You'll Do
" Design, build and maintain ETL/ELT pipelines across multiple systems
" Design and optimize data models in PostgreSQL, MongoDB, and Amazon Redshift
" Develop and manage data workflows using AWS (S3, Glue, Lambda, Step Functions, Kinesis)
" Administer and maintain database environments across development, staging, and production
" Monitor data pipelines and databases, troubleshoot issues, and implement alerts
" Optimize query performance, indexes, and configurations across relational and NoSQL systems
" Manage database provisioning, upgrades, backups, and disaster recovery (RDS, MongoDB, Redshift)
" Ensure database security, including access control, encryption, and role management
" Plan capacity and scale systems to support growing data needs
" Define and enforce data retention and archival policies
" Collaborate with analytics and product teams to support reporting and data needs
" Document data pipelines, database processes, and operational procedures
" Participate in code reviews and follow engineering best practices
Core Skills & Experience:
" 3 7 years of experience in data engineering, database administration, or similar role
" Strong experience with PostgreSQL, MongoDB, and Amazon Redshift
" Solid SQL skills for both transactional and analytical workloads
" Experience with AWS data and database services (S3, Glue, Lambda, RDS, Redshift, etc.)
" Proficiency in Python or another scripting language
" Experience with workflow orchestration tools (Airflow, Step Functions, etc.)
" Hands-on database administration experience, including:
" MongoDB (replica sets, sharding, indexing, backups)
" Redshift (cluster management, query tuning, WLM, snapshots)
" PostgreSQL (replication, performance tuning, connection pooling)
" Familiarity with monitoring tools (CloudWatch, pgBadger, MongoDB Atlas, etc.)
" Understanding of database security (encryption, auditing, least-privilege access)
Staffworxs is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive workplace for all employees, regardless of race, color, religion, gender, sexual orientation, national origin, age, disability, or veteran status.