Job Description
Oracle Database Architect / DBA
Active Secret Preferred Hybrid-within commutable distance to Northern VA/DCA Nationwide IT Services, NIS, is seeking an Oracle Database Architect/DBA for a potential opportunity. In this position, the Architect/DBA will:
- 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.
Primary Objectives: 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 Qualifications: - 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.
About Nationwide IT Services NIS is an IT and Management consulting company that is a CVE-verified Service-Disabled Veteran- Owned Small Business. Our mission is to deliver value-added services to our customers, leveraging technology, people, and industry best practices to implement innovative solutions through our trusted employees and team members.
Our benefits package includes 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), and educational reimbursement, along with Pet Insurance.
Nationwide IT Services, Inc. provides equal employment opportunities (EEO) to all qualified applicants regardless of race, color, religion, sex, national origin, sexual orientation, gender identity, genetics, disability, or protected veteran status.
Job Tags
Full time,