Senior Database Administrator

Fusion Technology

1d•Onsite

About The Position

The DBA will work extensively with Amazon Aurora Postgres and Amazon DynamoDB, handling both the operational and developmental aspects of database management. The role involves working with cross-functional teams, maintaining high performance, and ensuring data security across complex, large-scale architectures.

Requirements

Security-cleared Professional: You have made it through the process of receiving a United States government security clearance - congratulations! We know you are a trustworthy intel professional because you have an active DOD Secret security clearance.
Bachelor's Degree with 6-8 years of experience.
Experience as a Database Administrator with a focus on Aurora Postgres and DynamoDB in large-scale, enterprise environments.
Strong skills with Bash Scripting, experience related to automation and line experience is required.
Proficiency in database maintenance, patching, security best practices, connection protocols, troubleshooting, and backup/recovery strategies.
Strong experience with database tuning, query optimization, and performance monitoring tools.
Solid understanding of microservices architectures and experience connecting databases to distributed systems.
Experience with DevOps practices and automation of database tasks (scripting, CI/CD pipelines).
Familiarity with cloud infrastructure (preferably AWS) and hands-on experience in managing databases in a cloud environment.
Excellent problem-solving skills and the ability to work effectively in a collaborative, fast-paced environment.

Responsibilities

Oversee routine patching, maintenance, and upgrades for Aurora Postgres and DynamoDB to ensure system integrity and reliability.
Implement patch management strategies to address security vulnerabilities and performance improvements.
Implement robust security measures for database systems, including encryption, authentication protocols, access control, and regular auditing.
Monitor and analyze database performance, identifying areas for improvement.
Apply tuning techniques for query optimization, indexing strategies, and resource management to enhance overall performance.
Address database slowdowns, perform root cause analysis, and apply corrective actions to maintain optimal performance.
Develop and manage database backup strategies, including automated snapshotting and disaster recovery plans.
Ensure high availability and reliability by creating scalable recovery solutions for both Aurora Postgres and DynamoDB.
Collaborate with development teams to ensure smooth database connections in microservice architectures.
Manage different database connection protocols, such as JDBC, ODBC, and other integration methods, to support various applications.
Troubleshoot connection issues across development, testing, and production environments.
Collaborate with DevOps teams to integrate database management into CI/CD pipelines and automate routine database tasks such as backups, replication, and deployment through scripting and DevOps tools.
Use performance monitoring tools (e.g., AWS CloudWatch, Datadog) to proactively track and manage database health.
Generate reports on system usage, performance metrics, and security compliance.
Work with cross-functional teams, including development, security, and operations teams, to support enterprise-level applications.
Engage with stakeholders to align database solutions with organizational goals and future scaling needs.