Oracle Database Architect

HonorVet Technologies is a Service Disable Veteran-Owned IT staffing firm, ISO 9001, and ISO 27001 certified, working with federal agencies, state governments, and Fortune 500 enterprise clients across the US. What makes us different isn't a tagline; it's the way we work. We don't forward resumes and hope for the best. We take the time to understand where a professional like you are headed and only reach out when we genuinely believe there's a fit worth exploring.

Title: Oracle Database Architect

Project Duration: 12+ months to start with the possibility of extension

Location: Downey, CA, 90242

W2 Only (USC and GC)

Position Description

A Technical Architect will serve as the manager of complex technology implementations, with an eye toward constant reengineering and refactoring to ensure the simplest and most elegant system possible to accomplish the desired need; understand how to maximize leverage of the open source community to deploy systems on Infrastructure as a Service (IaaS) providers; be comfortable sharing knowledge across a multi-disciplinary team and working within various methodologies; and be a full partner in the determination of vision, objectives, and success criteria.

The Technical Architect will architect the overall system by using prototyping and proof of concepts, which may include: modern programming languages (e.g., Ruby, Python, Node.js) and web frameworks (e.g., Django, Rails), modern front-end web programming techniques (e.g., HTML5, CSS3, RESTful APIs) and frameworks (e.g., Twitter Bootstrap, jQuery), relational databases (e.g., PostgreSQL), and "NoSQL” databases (e.g., Cassandra, MongoDB), automated configuration management (e.g., Chef, Puppet, Ansible, Salt), continuous integration/deployment, and continuous monitoring solutions; use version control systems (e.g., Git and GitHub); ensure strategic alignment of technical design and architecture to meet business growth and direction, and stay on top of emerging technologies; decompose business and system architecture to support clean-interface multi-team development; develop product roadmaps, backlogs, and measurable success criteria, and write user stories (i.e., can establish a path to delivery for breaking down stories) and clearly communicate and work with stakeholders at every level.

Skills Required

• The Technical Architect will possess knowledge and experience in analyses and development of conceptual designs and detail designs; developing JBOSS Messaging and connectivity with Spring-JMS connectivity.
• Designing DB schema as per the requirements and in sync with the old system.
• Implementing the daily and weekly jobs that interact with external interfaces.
• Coordinating with business stakeholders to understand their requirements.
• Communicate with cross-divisional personnel at both team and executive levels to understand performance measurement methodologies; and direct team members in compiling business requirements and executing project milestones.

Additional Skills Required

• Skilled in Oracle database performance tuning.
• Knowledge in database cloning using Dell/EMC AppSync Copy Data Management and CommVault.
• Knowledge in Cloud monitoring and logging services.
• Ability to deploy Oracle database security patches following industry best practices.
• Knowledge of high availability and disaster recovery architectures and implementations.
• Possess excellent communication skills to effectively interact with internal and external management teams, developers, network and infrastructure teams.
• Skilled in Foundations of Generative Artificial Intelligence.
• Proactive attention to customer requests and projects providing speed reliability and value.
• Skilled in using automation technology such as Ansible or Jenkins for database administration tasks.
• Skilled in database scripting technologies such as PSQL and PGSQL; Skilled in provisioning and managing database management and monitoring tools such as Oracle Enterprise Manager, Toad, or Zabbix.
• Skilled in architecting and managing database systems in Cloud environments.
• Experience Required This classification must have a minimum of eight (8) years of experience in systems development, analysis, programming or testing.

Additional Experience Required

10+ years in the following:

• Supporting Oracle versions 12.x and above.
• Planning, deploying, managing Oracle Patch Security Updates.
• Architecting Oracle database system deployments on Windows O/S, Linux, Unix, running on IBM AIX and VMware infrastructures and Cloud environments.

2+ years in the following:

• Configuring, deploying and managing Oracle Advanced Security Option for database security.
• Deploying, configuring, upgrading and supporting databases for ERP solutions using CGI Advantage and InfoAdvantage.
• Utilizing Oracle replication methods such as Data Guard.
• Developing scripts using tools such as Bash Shell, Perl, Python, Jenkins, Ansible Tower, Control-M, and Oracle Enterprise Manager to automate manual database administration tasks.
• Deploying, upgrading, managing, and monitoring Oracle databases in Oracle Cloud Infrastructure (OCI) platform.
• Performing database backups, restores, cloning, disaster recovery processes using Dell/EMC AppSync Copy Data Management and CommVault solutions.
• Configuring Oracle Audit Vault, Key Vault, and Oracle Enterprise Manager.
• Configuring and managing Oracle RAC.
• Deploying, configuring, monitoring, securing MySQL, MariaDB, PostgreSQL, AWS Aurora Database and AWS RDS database servers.
• Interfacing Oracle databases to Databricks systems using CDC.
• Deploying, managing and monitoring PostgreSQL and MySQL database systems on premise and Cloud environments.
• Migrating on premise Oracle or SQL Server database systems to Cloud database systems like AWS PostgreSQL or MariaDB.
• Creating and deploying automation technologies such as Ansible, Jenkins or Terraform.
• Education Required This classification requires the possession of a bachelor's degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.

Additional Education Required

Hold AWS, OCI, Azure Certifications. Active member or organizer of an Open-Source Community Projects and Events, such as Scale or similar.