Sr Data Engineer & Database Administrator

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Dia Software Solutions, is seeking the following. Apply via Dice today!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 ,OnsitePLEASE 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 DoDesign and optimize data models in PostgreSQL, MongoDB, and Amazon RedshiftDevelop and manage data workflows using AWS (S3, Glue, Lambda, Step Functions, Kinesis)Administer and maintain database environments across development, staging, and productionMonitor data pipelines and databases, troubleshoot issues, and implement alertsOptimize query performance, indexes, and configurations across relational and NoSQL systemsManage database provisioning, upgrades, backups, and disaster recovery (RDS, MongoDB, Redshift)Ensure database security, including access control, encryption, and role managementPlan capacity and scale systems to support growing data needsDefine and enforce data retention and archival policiesCollaborate with analytics and product teams to support reporting and data needsDocument data pipelines, database processes, and operational proceduresParticipate in code reviews and follow engineering best practicesWhat We Re Looking ForCore Skills & Experience9 years of experience in data engineering, database administration, or similar rolesStrong experience with PostgreSQL, MongoDB, and Amazon RedshiftSolid SQL skills for both transactional and analytical workloadsExperience with AWS data and database services (S3, Glue, Lambda, RDS, Redshift, etc.)Proficiency in Python or another scripting languageExperience 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