Oracle Database Architect -W2
Posted 1 day ago by 1762534426
Negotiable
Outside
Remote
USA
Summary: The Oracle Database Architect role involves serving as the primary DBA and system architect for a federal program, focusing on the design, optimization, and maintenance of Oracle databases. The position requires proactive monitoring of system performance and managing user access while ensuring compliance with federal standards. Additionally, the role includes collaboration with cloud engineers and making architectural recommendations for system improvements. Candidates should have a Public Trust Clearance and W2 employment status, with a preference for those holding AWS certifications.
Key Responsibilities:
- Serve as the primary Oracle Database Administrator (DBA) and system architect for a high-profile federal program.
- Design, optimize, and maintain Oracle relational database schemas, indexes, partitions, and data models for performance and reliability.
- Administer Oracle database instances, including patching, upgrades, tuning, backup/restore, and high availability (HA) configurations.
- Proactively monitor system performance, storage capacity, and respond to database outages or degraded performance.
- Manage user access, security controls, and ensure compliance with federal audit standards.
- Oversee the integrity and scheduling of data feeds and transfers between legacy systems and external partners.
- Serve as a primary point of contact during production outages, leading incident response and root cause analysis.
- Document service reliability metrics and assist in system uptime reporting.
- Support and manage components of the TPM architecture hosted on AWS, ensuring secure and efficient deployment.
- Make architectural recommendations for system scaling, performance, and cost optimization in the cloud.
- Collaborate with cloud engineers to deploy and monitor database instances and storage solutions.
- Review and assess all system change requests impacting infrastructure or data architecture.
- Conduct risk assessments for proposed system enhancements or migrations, ensuring production stability.
- Lead efforts to implement preventive controls and rollback strategies during critical system changes.
- Ensure compliance with federal security and compliance frameworks (e.g., NIST 800-53, FISMA).
- Produce technical documentation and interface with both technical and non-technical stakeholders.
- (Preferred) Support DevOps/CI-CD integration for database changes and Agile teams using Jira for change management.
- (Preferred) Hold AWS certifications such as AWS Solutions Architect or SysOps Administrator.
Key Skills:
- Public Trust Clearance.
- Experience as an Oracle Database Administrator (DBA).
- Knowledge of Oracle database schemas, indexes, partitions, and data models.
- Proficiency in database administration tasks including patching, upgrades, and tuning.
- Ability to monitor system performance and manage user access and security controls.
- Experience with AWS architecture and deployment.
- Strong documentation and communication skills.
- Familiarity with federal security and compliance frameworks (e.g., NIST 800-53, FISMA).
- Preferred experience with DevOps/CI-CD integration and Agile methodologies.
- Preferred AWS certifications such as AWS Solutions Architect or SysOps Administrator.
Salary (Rate): undetermined
City: Dallas
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
Required: Public Trust Clearance, W2 Employment Only (No C2C)
Job Summary (List Format)
- Serve as the primary Oracle Database Administrator (DBA) and system architect for a high-profile federal program.
- Design, optimize, and maintain Oracle relational database schemas, indexes, partitions, and data models for performance and reliability.
- Administer Oracle database instances, including patching, upgrades, tuning, backup/restore, and high availability (HA) configurations.
- Proactively monitor system performance, storage capacity, and respond to database outages or degraded performance.
- Manage user access, security controls, and ensure compliance with federal audit standards.
- Oversee the integrity and scheduling of data feeds and transfers between legacy systems and external partners.
- Serve as a primary point of contact during production outages, leading incident response and root cause analysis.
- Document service reliability metrics and assist in system uptime reporting.
- Support and manage components of the TPM architecture hosted on AWS, ensuring secure and efficient deployment.
- Make architectural recommendations for system scaling, performance, and cost optimization in the cloud.
- Collaborate with cloud engineers to deploy and monitor database instances and storage solutions.
- Review and assess all system change requests impacting infrastructure or data architecture.
- Conduct risk assessments for proposed system enhancements or migrations, ensuring production stability.
- Lead efforts to implement preventive controls and rollback strategies during critical system changes.
- Ensure compliance with federal security and compliance frameworks (e.g., NIST 800-53, FISMA).
- Produce technical documentation and interface with both technical and non-technical stakeholders.
- (Preferred) Support DevOps/CI-CD integration for database changes and Agile teams using Jira for change management.
- (Preferred) Hold AWS certifications such as AWS Solutions Architect or SysOps Administrator.
- Serve as the primary Oracle Database Administrator (DBA) and system architect for a high-profile federal program.
- Design, optimize, and maintain Oracle relational database schemas, indexes, partitions, and data models for performance and reliability.
- Administer Oracle database instances, including patching, upgrades, tuning, backup/restore, and high availability (HA) configurations.
- Proactively monitor system performance, storage capacity, and respond to database outages or degraded performance.
- Manage user access, security controls, and ensure compliance with federal audit standards.
- Oversee the integrity and scheduling of data feeds and transfers between legacy systems and external partners.
- Serve as a primary point of contact during production outages, leading incident response and root cause analysis.
- Document service reliability metrics and assist in system uptime reporting.
- Support and manage components of the TPM architecture hosted on AWS, ensuring secure and efficient deployment.
- Make architectural recommendations for system scaling, performance, and cost optimization in the cloud.
- Collaborate with cloud engineers to deploy and monitor database instances and storage solutions.
- Review and assess all system change requests impacting infrastructure or data architecture.
- Conduct risk assessments for proposed system enhancements or migrations, ensuring production stability.
- Lead efforts to implement preventive controls and rollback strategies during critical system changes.
- Ensure compliance with federal security and compliance frameworks (e.g., NIST 800-53, FISMA).
- Produce technical documentation and interface with both technical and non-technical stakeholders.
- (Preferred) Support DevOps/CI-CD integration for database changes and Agile teams using Jira for change management.
- (Preferred) Hold AWS certifications such as AWS Solutions Architect or SysOps Administrator.