Database Administrator
Bigbear.ai
- Ashburn, Virginia, United States
- Ashburn, Virginia, United States
Über
What you will do
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.
What you need to have
Bachelor's Degree and 5 to 8 years of experience; Master's Degree and 3 to 6 years of experience; PhD and 0 to 3 years of experience (in lieu of Bachelor’s degree, 6 additional years of relevant experience)
Extensive experience with RDS PostgreSQL, including 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 (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.
Design tables
Writing functions, stored procedures
Performance tuning and optimization
Checking indexes
Partitioning
What we'd like you to have
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.
BigBear.ai is an Equal opportunity employer for all protected groups, including protected veterans and individuals with disabilities.
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.