{bc}
Apply
oracle

PostgreSQL Database Engineer

SAIC
Ashburn, USA
Mid · 5+ years experience
Hybrid
Discovered 2 weeks ago
awsbashdynatracepostgresqlpython

Full Job Posting

Responsibilities:

  • Database Administration:
  • Configure and administer managed PostgreSQL instances in the AWS environment.
  • Maintain database security policies, including role-based access control and data encryption.
  • Query Tuning and Optimization:
  • Analyze and optimize SQL queries for performance improvement, particularly on large tables.
  • Work with development teams to review and enhance database-related code.
  • Monitoring and Alerts:
  • Set up and monitor Dynatrace alerts to ensure database reliability and availability.
  • Investigate and resolve performance issues identified through monitoring tools or reported by users.
  • Automation and Deployment:
  • Develop and implement database automation scripts for routine tasks such as deployments, scaling, and maintenance.
  • Assist in Continuous Integration/Continuous Deployment (CI/CD) processes for database updates.
  • System Health and Troubleshooting:
  • Proactively monitor database health and resolve capacity or connectivity issues.
  • Conduct root-cause analysis for database incidents and implement preventive measures.
  • Database Design and Support:
  • Provide input on data modeling and schema design for new and existing applications.
  • Collaborate with developers and data engineers to ensure efficient data access patterns.
  • Documentation and Best Practices:
  • Create and maintain detailed documentation of database environments, procedures, and standards.
  • Enforce database best practices and policies.
  • Training and Guidance:
  • Act as a technical mentor to junior team members.
  • Provide training to application developers and other stakeholders on database-related topics.

Required Skills:

  • Bachelors and 5+ years of relevant experience.
  • 5+ years of PostgreSQL experience: RDS PostgreSQL, including deployment, maintenance, and optimization.
  • Strong knowledge of database tuning, query optimization, and indexing strategies.
  • Must have experience with Postgres GIS queries using the PostGIS addon.
  • Experience with database monitoring tools, particularly Dynatrace or similar platforms.
  • Proficiency in scripting languages (e.g., Python, Bash) for database automation.
  • Understanding of cloud database architectures and services, such as AWS RDS.
  • Familiarity with CI/CD pipelines and database version control.
  • Excellent troubleshooting and problem-solving skills.
  • Must have experience with:
  • Design tables.
  • Writing functions, stored procedures.
  • Performance tuning and optimization.
  • Checking indexes.
  • Partitioning.
  • AWS environment.
  • Certifications such as AWS Certified Database - Specialty, PostgreSQL DBA Certification, or similar are a plus.

Preferred Skills:

  • Knowledge of ETL pipelines and data warehouse architecture.
  • Familiarity with analytics/modeling tools.
  • Exposure to data replication and sharding strategies.
  • Knowledge of government regulatory compliance standards.
  • Soft Skills:
  • Strong communication and collaboration skills for working with cross-functional teams.
  • Ability to manage multiple priorities in a fast-paced environment.
  • Attention to detail and a commitment to delivering high-quality results.
  • BI Requirement:
  • Must be a U.S. Citizen.
  • Current holder of a DHS Public Trust clearance or the ability to obtain one.
  • Note: Employment will be contingent upon having/obtaining a DHS Public Trust clearance prior to starting.

Qualifications

  • Bachelors and 5+ years of relevant experience.
  • 5+ years of PostgreSQL experience: RDS PostgreSQL, including deployment, maintenance, and optimization.
  • Strong knowledge of database tuning, query optimization, and indexing strategies.
  • Must have experience with Postgres GIS queries using the PostGIS addon.
  • Experience with database monitoring tools, particularly Dynatrace or similar platforms.
  • Proficiency in scripting languages (e.g., Python, Bash) for database automation.
  • Understanding of cloud database architectures and services, such as AWS RDS.
  • Familiarity with CI/CD pipelines and database version control.
  • Excellent troubleshooting and problem-solving skills.
  • Must have experience with: Design tables. Writing functions, stored procedures. Performance tuning and optimization. Checking indexes. Partitioning. AWS environment.
  • Design tables.
  • Writing functions, stored procedures.
  • Performance tuning and optimization.
  • Checking indexes.
  • Partitioning.
  • AWS environment.
  • Certifications such as AWS Certified Database - Specialty, PostgreSQL DBA Certification, or similar are a plus.
  • Knowledge of ETL pipelines and data warehouse architecture.
  • Familiarity with analytics/modeling tools.
  • Exposure to data replication and sharding strategies.
  • Knowledge of government regulatory compliance standards.
  • Strong communication and collaboration skills for working with cross-functional teams.
  • Ability to manage multiple priorities in a fast-paced environment.
  • Attention to detail and a commitment to delivering high-quality results.
  • Must be a U.S. Citizen.
  • Current holder of a DHS Public Trust clearance or the ability to obtain one.
  • Note: Employment will be contingent upon having/obtaining a DHS Public Trust clearance prior to starting.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at SAIC

Drafter/CAD Operator

Bedford, USA

Discovered Today

TWF Air Traffic Control Instructor-II

Twin Falls, USA

Discovered Today

Supply Technician

North Charleston, USA

Discovered Today

Senior MBSE Engineer

El Segundo, USA

Discovered Today

Systems Administrator

San Diego, USA

Discovered Today

Infrastructure Operations Manager

Washington, USA

Discovered Yesterday

Acquisition Systems Engineer

Chantilly, USA

Discovered 2 days ago

Senior Drupal Developer

Washington, USA

Discovered 2 days ago