Apply Now

PostgreSQL Aurora and AWS EMR Specialist Job Requisition

Woodlawn, MD, US • Posted 13 hours ago • Updated 1 hour ago

Full Time

On-site

NetVision Resources Inc

Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

IAM
CloudWatch
VPC) High Availability
Amazon Aurora PostgreSQL Administration PostgreSQL Database Administration &amp;amp; Internals AWS Cloud Services (RDS
Disaster Recovery &amp;amp; Backup Performance Tuning &amp;amp; Query Optimization

Summary

Position Summary

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.

Responsibilities

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.

Required Qualifications

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.

NetVision Resources, Inc(NVR) is a fast growing, IS9001, IS20000, CMMI DEV/2, MBE certified technology consulting and software development firm, based out of DC Metro areaTo know more, please visit

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10106770
Position Id: 2026-9389
Posted 13 hours ago

Company Info

About NetVision Resources Inc

NetVision Resources "NVR" is a fast-growing IT consulting and services company located in the Washington DC metro area. Since its inception in 1999, NVR has provided complete end-to-end solutions to the IT needs of a diverse clientele, from large corporate giants to small business enterprises and from local and state government to federal agencies.

NVR belongs to a unique breed of small, minority-owned technology businesses offering consulting and development services across the IT spectrum. Today we are a well-recognized organization with highly qualified employees skilled in all of the top technologies in IT and serving a vast network of clients across the country every day.

Over the last decade we have provided IT solutions and consulting services across the entire service spectrum, right from training and help desk support to custom application development, ERP implementation and Business Process Re-engineering. Having worked with some of the biggest names in the industry as well as on emerging technologies, NVR has established itself as a service provider of choice for many.

NVR is a ISO 9001:2008 certified company.

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

LAN Support Specialist

Independence, Missouri

•

Today

Position Summary LAN Support Specialist to provide onsite IT support at the Social Security Administration's National Records Center (NRC) in Independence, Missouri. This is a 5 day a week onsite position at the SSA National Records Center in Independence, Missouri. Your Future Duties and Responsibilities Provide daily hands on technical support for ~55+ distributed workstations across the NRC facility. Maintain and support LAN racks located in four Data Control Rooms. Support specialized produ

Easy Apply

Full-time, Contract, Third Party

$$80/Hourly

Search all similar jobs

More jobs at NetVision Resources Inc in Woodlawn, MD