Science Applications International·7 hours ago
7 hours agoBe an early applicant
PostgreSQL Database Administrator
Sign up free to see how well your resume matches this role.
What you'll do
- Configure and administer managed PostgreSQL instances in the AWS environment.
- Maintain database security policies, including role-based access control and data encryption.
- Analyze and optimize SQL queries for performance improvement, particularly on large tables.
- Work with development teams to review and enhance database-related code.
- 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.
- 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.
- Proactively 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 for new and existing applications.
- Collaborate with developers and data engineers to ensure efficient data access patterns.
What they're looking for
- Highly skilled and experienced Database Subject Matter Expert (SME)
- Strong Database Administrator (DBA) capabilities
- Specialization in PostgreSQL (RDS)
- Expertise in deployment, administration, query tuning, and database monitoring
Summarised by NextRaise from the employer’s description, which follows in full below.
Full description from employer
SAIC is seeking a highly skilled and experienced Database Subject Matter Expert (SME) with strong Database Administrator (DBA) capabilities to join our team. The ideal candidate will specialize in PostgreSQL (RDS), bringing expertise in deployment, administration, query tuning, and database monitoring.
This role requires a proactive professional capable of managing database operations, optimizing performance, and supporting application development teams.
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.
Company
Science Applications International
Ashburn, United States of America
Company facts come from this company's own listings. We only show what the postings themselves carry.