Database Administrator
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+15 more
Job description
- Administer and maintain Oracle and PostgreSQL databases across Linux, RHEL, and Windows environments, ensuring reliability and availability.
- Perform database installations, configurations, upgrades, and routine maintenance activities with minimal supervision.
- Write, optimize, and troubleshoot SQL queries, applying best practices in normalization and indexing to support application performance.
- Execute and monitor backup and recovery processes, including pg_dump, pg_basebackup, and point-in-time recovery (PITR).
- Analyze and improve database performance using explain plans and monitoring tools, resolving performance issues as they arise.
- Support AWS-based infrastructure and database services, including EC2, CloudWatch, CloudTrail, and RDS (Oracle, Aurora, PostgreSQL).
- Manage PostgreSQL schemas, roles, and access controls, ensuring adherence to security and compliance standards.
- Develop and maintain PL/pgSQL scripts to support database functionality and automation needs.
- Perform system and software maintenance, including patching, upgrades, and coordination of hardware-related changes when required.
- Create and enhance shell scripts to automate monitoring, alerting, and routine operational tasks.
What matters to you matters to us.
Fusion Technology values its employees and works hard to ensure proper care for them and their families. We desire to compensate employees in a competitive, motivational, fair, and equitable way with other employers in the marketplace. Salary is only one component of employee compensation but an integral part of recruiting and retaining qualified employees. However, at Fusion Technology, we take a comprehensive approach and consider each employee’s needs to tailor a compensation plan that provides financial security and peace of mind. Our competitive package includes a best-in-class matching 401K program, a comprehensive healthcare plan through Cigna, a competitive employer contribution to a health savings account, vision and dental plans, life insurance, short- and long-term disability, and personal leave, in addition to paid certifications and training.
Requirements
Security-cleared Professional: A DOD Secret Clearance or a Top Secret Clearance is required to be considered for this position.
Education and Experience: You have a Bachelor’s Degree in a related field with 3+ years of experience as a Database Administrator. Can accept experience in lieu of degree. Additional requirements for the Mid-Level Database Administrator position include:
- Database experience of working in different OS platform like Linux, RHEL and Windows
- Experience in Oracle 19C/21C database administration, support, implantation, configuration and upgrade.
- Experience in Oracle Data Guard, RMAN (BackupRecovery), Cloning, Resource Management, OEM Grid administration and Implementation for version 19C/21C databases.
- Experience in Oracle database performance tuning using AWR/ASH/ADDM reports for troubleshooting performance issues.
- Working experience of AWS Cloud Services (Cloud Watch Cloud Trail, EC2) and Databases (ORACLEPostgres RDS)
- Database performance tuning, database upgrades, and database patching to all COTS database products.
- Database script writing (PL/SQL), database storage management, database interfaces, external application database interfaces, and other systems database interfacing.
- Performance tuning, hardware replacement, firmware upgrades, and patching to all COTS software products, including operating systems.
- Experience in shell scripting to enhance and update daily monitoring tasks.
- Working experience of AWS Cloud Services (Cloud Watch Cloud Trail, EC2) and Databases (Oracle, AuroraPostgres RDS)
- Strong understanding of postgres schema, user roles, access control and security model.
- Postgres script writing (PL/pgSQL) with loops, conditions and variables.
Benefits & conditions
Pulled from the full job description
- Paid training
- 401(k) matching
- Vision insurance
- Health savings account
- Dental insurance
- Life insurance
- Disability insurance
About the company
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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on indeed.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
Making Data Warehouses Fast: A Developer’s Story
Data Engineer Salary UK
What Are The Top Skills Required For Azure Developers?
Highest Paying Tech Companies for Developers