Sr Data Engineer & Database Administrator

Hi,

Greetings from DIA SOFTWARE SOLUTIONS LLC!

We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?

Direct client Req:: Need Sr Data Engineer & Database Administrator ,Onsite

PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !

Job Description:

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.

What You ll Do

• 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

What We re Looking For

Core Skills & Experience

• 9 years of experience in data engineering, database administration, or similar roles
• 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)
• Design, build and maintain ETL/ELT pipelines across multiple systems

DIA SOFTWARE SOLUTIONS LLC.

Austin, TX 78727| Direct:

DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Dia soft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer