Nationwide IT Services, Inc. · 2 weeks ago
Oracle Database Architect / DBA
Fairfax, VA
Full-time
Hybrid
Senior Level
7+ years expNationwide IT Services, Inc. is seeking an Oracle Database Architect/DBA for a potential opportunity. In this position, the Architect/DBA will design a high-performance Oracle database architecture and optimize performance across various datasets while ensuring database security and compliance.
Cyber SecurityInformation ServicesInformation TechnologyManagement Consulting
No H1B
Security Clearance Required
Responsibilities
Design a redundant, normalized, high-performance Oracle database architecture
Apply patches, provision backups, and optimize performance across various datasets
Analyze AWR (Automatic Workload Repository) reports, wait events, and execution plans to rewrite inefficient PL/SQL and optimize indexes
Review and approve schema changes proposed by software developers to ensure changes won't cripple the database production environment
Forecast storage and compute needs for the next fiscal year based on growth trends
Apply DISA STIGs (Security Technical Implementation Guides) to the database layer. This involves locking down permissions, enabling auditing, and encrypting data at rest and in transit
Implement "Least Privilege" models, often integrating with Smart Card (CAC/PIV) authentication for DB access
Lead initiative of transferring large datasets from on-prem to AWS Cloud via AWS Database Migration Service and AWS Glue
Script infrastructure provisioning using AWS CloudFormation, Terraform, or Ansible to create reproducible database environments
Qualification
Required
Design a redundant, normalized, high-performance Oracle database architecture
Apply patches, provision backups, and optimize performance across various datasets
Analyze AWR (Automatic Workload Repository) reports, wait events, and execution plans to rewrite inefficient PL/SQL and optimize indexes
Review and approve schema changes proposed by software developers to ensure changes won't cripple the database production environment
Forecast storage and compute needs for the next fiscal year based on growth trends
Apply DISA STIGs (Security Technical Implementation Guides) to the database layer. This involves locking down permissions, enabling auditing, and encrypting data at rest and in transit
Implement 'Least Privilege' models, often integrating with Smart Card (CAC/PIV) authentication for DB access
Lead initiative of transferring large datasets from on-prem to AWS Cloud via AWS Database Migration Service and AWS Glue
Script infrastructure provisioning using AWS CloudFormation, Terraform, or Ansible to create reproducible database environments
Assist in the Discovery Phase activities of gathering user requirements, business analysis, legacy system analysis, Epic/Story creation, external data integration planning, and product backlog management
Preferred
Active Secret Clearance Preferred
Bachelor's Degree in Computer Science or Information Systems
7+ years of deep Oracle Database experience (Versions 12c, 19c, 21c)
Must hold or be able to obtain a CompTIA Security+ CE certification (or higher, like CASP+ or CISSP)
Knowledge/experience with Oracle GoldenGate is a plus
Benefits
Medical, dental, and vision insurance
Life and disability insurance
401(k) plan with employer match
Paid holidays
PTO (sick/vacation)
Commuter benefits
Employee assistance program (EAP)
Educational reimbursement
Pet Insurance
Company
Nationwide IT Services, Inc.
Nationwide IT Services, Inc.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase