> Markdown version of [/jobs/ext/2029050-postgresql-aurora-and-aws-emr-specialist](https://www.wearedevelopers.com/jobs/ext/2029050-postgresql-aurora-and-aws-emr-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # PostgreSQL Aurora and AWS EMR Specialist - **Company:** NetVision Resources Inc. - **Location:** United States - **Contract:** Permanent contract - **Skills:** Query Performance, Amazon Web Services, Amazon S3, Audit Trail, Backup Devices, Bash Shell, Big Data, Databases, DevOps, Hadoop Distributed File System, Apache HBase, Apache Hive, Identity and Access Management, Subnetting, Information Systems Security Architecture Professional, Python (Programming Language), PostgreSQL, Node.Js, Performance Tuning, Windows PowerShell, Query Optimization, Ansible, Data Logging, Scripting, Cloud Platform System, Autoscaling, System Availability, Delivery Pipeline, Database Optimization, Apache Spark, Indexer, Amazon Virtual Private Cloud (VPC), Git, Cloudformation, Apache Flink, Presto, Cloudwatch, Terraform, Serverless Computing, Amazon Elastic Mapreduce (EMR), Jenkins - **Published:** August 11, 2026 - **Apply:** https://www.dice.com/job-detail/134db4a3-5714-464b-9287-f783b3c5a8d6 ## About the Role * Hands on experience engineering, operating, and optimizing Aurora PostgreSQL clusters. * Strong proficiency in PostgreSQL internals, query tuning, indexing, vacuum strategies, and replication. * Experience with Aurora failover behavior, storage mechanics, endpoints, and performance tuning. * Strong skills with EMR architecture including node roles, EMRFS, HDFS behavior, and lifecycle operations. * Experience tuning Spark and Hive workloads in production environments. * Proficiency using AWS native services including IAM, VPC networking, CloudWatch, CloudTrail, and Secrets Manager. * Experience with snapshot management, point in time recovery, and high availability database architectures. * Strong scripting skills using Python, Bash, or PowerShell. * Experience integrating database or EMR workloads into CI and CD workflows. * Familiarity with automation tools including Ansible, CloudFormation, Terraform, or CDK. * Ability to troubleshoot performance issues, errors, and architectural bottlenecks. * Strong written and verbal communication skills. * Resource is expected to work onsite 5 days a week at our customer location. Preferred Qualifications * Experience creating governance standards and compliance best practices for EMR and database workloads. * AWS certifications including Solutions Architect, Database Specialty, or DevOps Engineer. ## Description CGI Federal is seeking a PostgreSQL Aurora and AWS EMR Specialist to support mission critical cloud-based data platforms using Amazon Aurora PostgreSQL and AWS EMR. This role requires deep knowledge of Aurora architecture, PostgreSQL internals, EMR cluster operations, Spark and Hive performance optimization, and AWS native automation and security practices., * Engineer, operate, and optimize Amazon Aurora PostgreSQL clusters including architecture, failover mechanics, storage layer behavior, and reader and writer topology. * Configure and manage Aurora Serverless v2, autoscaling, and cost optimized cluster designs. * Implement logical and physical replication, version upgrades, patching, backups, restores, snapshots, and point in time recovery. * Perform advanced PostgreSQL tuning including indexing strategies, execution plan analysis, vacuum operations, and slow query diagnostics. * Engineer and operate AWS EMR clusters including master, core, and task node design, HDFS and EMRFS behavior, and full cluster lifecycle management. * Optimize big data workloads using Spark including partitioning and shuffle management. * Tune Hive workloads including query performance and execution engine selection. * Manage distributed compute tools such as HBase, Presto, or Flink depending on workload requirements. * Use CloudWatch, CloudTrail, and EMR metrics for monitoring, logging, and performance tuning. * Design resilient EMR clusters using multi master configurations, instance fleets, Spot usage strategies, and autoscaling policies. * Automate EMR operations including bootstrapping, EMR steps, Spark job submission, and pipeline scheduling. * Integrate EMR and database workloads into CI and CD workflows using Git, Jenkins, CodePipeline, and related automation tools. * Implement secure architectures including encryption in transit and at rest, secure S3 access, EMR security configurations, IAM governance, and audit logging. * Configure VPC networking including subnets, security groups, network ACLs, and private cluster deployments. ## Related Videos - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Postgres in the Age of AI (and Devin)](https://www.wearedevelopers.com/videos/1042-postgres-in-the-age-of-ai-and-devin) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)