Database Administrator

Fusion Technology

About The Position

Fusion Technology is a performance-driven HUBZone Small Business concern residing in the heart of the beautiful mountainsides of West Virginia, steps away from the Federal Bureau of Investigation's Criminal Justice Information Services Division's Headquarters. Founded in 2007 by an Engineer-by-trade, Fusion Technology dedicates our valuable resources to providing comprehensive IT services and solutions to mission-critical US Government programs and the Intel Community. 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. Education is important to us: You have a Bachelor's Degree with 2-5 years of experience. 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

Experience as a Database Administrator with a focus on Aurora Postgres, PostgreSQL, or Oracle databases in large-scale, enterprise environments (create and run queries, monitor health, install system patches, create reports, add users, reset passwords, etc.).
Experience with SQL
Familiar with infrastructure code
Knows Atlassian suite to include Jira, Bitbucket, Confluence Bamboo or Jenkins
Strong skills with Shell Scripting or Bash, 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.
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 to include CLI, CloudFormation, RDS, Auora, EC2, and etc.
Excellent problem-solving skills and the ability to work effectively in a collaborative, fast-paced environment.
You have an active DOD Secret security clearance.
You have a Bachelor's Degree with 2-5 years of experience.

Nice To Haves

Python
AWS certification
DynamoDB
Oracle certification (OCP)
PL/PGSQL or PL/SQL

Responsibilities

Oversee routine patching, maintenance, and upgrades 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.