FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in PostgreSQL database management, including deployment, optimization, and security within AWS environments. Proficient in database automation, CI/CD processes, and performance tuning, while effectively collaborating with development teams and mentoring junior members.
Highest-signal resume keywords
PostgreSQL Database ManagementAWS RDS DeploymentDatabase Automation ScriptingQuery OptimizationDynatrace Monitoring
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
PostgreSQLSQL Query OptimizationDatabase TuningPostGISPython ScriptingBash ScriptingCI/CD PipelinesData ModelingPerformance TuningDatabase Security Policies
Soft Skills
Troubleshooting SkillsProblem-Solving SkillsCommunication SkillsCollaboration SkillsAttention to Detail
Tools & Technologies
DynatraceAWSPostgreSQL RDSETL PipelinesData Warehouse Architecture
Certifications & Qualifications
AWS Certified Database – SpecialtyPostgreSQL DBA CertificationDHS Public Trust Clearance
Industry Keywords
Database SecurityRole-Based Access ControlData EncryptionData ReplicationSharding StrategiesGovernment Regulatory Compliance
Tech Stack
Tools & technologiesAWSCloudETLPostGISPostgresPythonSQL
About the role
Key responsibilities & impact- Configure and administer managed PostgreSQL instances in AWS
- Maintain database security policies, including role-based access control and data encryption
- Analyze and optimize SQL queries, particularly on large tables
- Work with development teams to review and enhance database-related code
- Set up and monitor Dynatrace alerts for database reliability and availability
- Investigate and resolve performance issues identified by monitoring tools or users
- Develop database automation scripts for deployments, scaling, and maintenance
- Assist with CI/CD processes for database updates
- Monitor database health and resolve capacity or connectivity issues
- Conduct root-cause analysis for database incidents and implement preventive measures
- Provide input on data modeling and schema design
- Collaborate with developers and data engineers to ensure efficient data access patterns
- Create and maintain documentation of database environments, procedures, and standards
- Enforce database best practices and policies
- Mentor junior team members
- Train application developers and stakeholders on database-related topics
Requirements
What you’ll need- Bachelor's degree and 5+ years of relevant experience
- 5+ years of PostgreSQL experience, including RDS PostgreSQL deployment, maintenance, and optimization
- Strong knowledge of database tuning, query optimization, and indexing strategies
- Experience with Postgres GIS queries using the PostGIS addon
- Experience with database monitoring tools, particularly Dynatrace or similar platforms
- Proficiency in scripting languages such as Python and 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
- Experience designing tables; writing functions and stored procedures; performance tuning and optimization; checking indexes; partitioning; and working in an AWS environment
- AWS Certified Database – Specialty, PostgreSQL DBA Certification, or similar certification is a plus
- Knowledge of ETL pipelines and data warehouse architecture is preferred
- Familiarity with analytics/modeling tools is preferred
- Exposure to data replication and sharding strategies is preferred
- Knowledge of government regulatory compliance standards is preferred
- Strong communication and collaboration skills
- Ability to manage multiple priorities in a fast-paced environment
- Attention to detail and commitment to delivering high-quality results
- Must be a U.S. Citizen
- Current DHS Public Trust clearance or ability to obtain one; employment is contingent upon having or obtaining the clearance before starting