Aurora Postgres Database Administrator Apply
Role:Database Administrator (Sr) - Aurora Postgres (onsite)
Location:Baltimore,MD Onsite from Day(Need only locals to VA,MD,DC)
Duration:Long Term
Job Description:
Database Administrators (DBAs) play a vital role in addressing the challenges associated with a shared platform environment where multiple applications and tools use the same databases, ETL processes, and reporting tools. DBAs contribute significantly to the reliability, performance, stability, and observability of the shared platform. Their proactive monitoring, optimization efforts, and collaboration with various stakeholders help create a robust and well-maintained data infrastructure, facilitating smooth operations for all applications and tools sharing the platform.
Responsibilities:
Performance Monitoring and Tuning: DBAs continuously monitor database performance, identifying bottlenecks, and proactively optimizing query execution plans, indexes, and database configurations. This ensures efficient use of resources and enhances overall system performance.
Resource Allocation and Management: DBAs manage database resources, such as CPU, memory, and storage, to prevent resource contention and ensure fair distribution among applications and tools.
Backup and Recovery: DBAs implement robust backup and recovery strategies to safeguard data integrity and provide rapid data recovery in case of failures or disasters. This ensures the reliability and stability of the shared platform.
Security and Access Controls: DBAs enforce security measures, access controls, and encryption to protect sensitive data from unauthorized access and ensure data privacy and compliance with regulations.
Database Provisioning and Scaling: DBAs handle the provisioning of new databases and scaling existing databases to meet the evolving demands of applications and tools on the shared platform. This ensures scalability and flexibility in data storage.
Data Replication and High Availability: DBAs configure database replication and high availability mechanisms to minimize downtime and provide continuous access to critical data for applications and users.
Query Optimization and Troubleshooting: DBAs optimize complex queries, identifying and resolving performance issues. They collaborate with application developers to troubleshoot and resolve database-related problems.
Version and Change Management: DBAs manage database schema changes and versioning to coordinate updates and ensure compatibility between different applications and tools.
Monitoring and Alerting: DBAs set up monitoring and alerting systems to proactively detect issues and promptly respond to potential problems in the shared platform, ensuring observability and quick incident resolution.
Capacity Planning: DBAs conduct capacity planning to forecast future resource requirements and ensure that the shared platform can meet growing demands while maintaining optimal performance.
Collaboration with Data Architects and Developers: DBAs collaborate with data architects and application developers to understand data requirements and recommend database design improvements, data modeling enhancements, and best practices.
Database Security Audits: DBAs conduct regular security audits and vulnerability assessments to maintain a secure database environment and address potential security risks.
Qualifications:
Bachelor's degree in Computer Science, Information Technology, or related field. Master's degree is a plus.
Proven experience as a Database Administrator, with a focus on managing cloud based databases such as RDS Postgres, RDS Aurora for Postgres, RDS SQL Server in AWS cloud environments.
Extensive knowledge of AWS cloud services such as Networking, Security, and Alerts and Monitoring.
Strong understanding of data modeling principles, governance, and security practices.
Demonstrated expertise in designing data integration solutions and optimizing data processing performance.
Strong communication and presentation skills to effectively convey complex technical concepts to non-technical stakeholders.
