SMX Services & Consulting, Inc.
Senior Oracle Database Administrator (Key Personnel)
SMX Services & Consulting, Inc., Washington, District of Columbia, us, 20022
Senior Oracle Database Administrator (Key Personnel)
Customer/Project: RFQ1786036 – FY26 SQL/ORACLE DBA Support
Role Type: Key Personnel (senior technical lead – Oracle)
Clearance/Background: TBD by RFQ/agency
Work Location: Onsite/Hybrid/Remote – TBD by RFQ/agency
Schedule: Full-time; may include on-call/after‑hours for maintenance windows and incident response
Start: Upon award/authorization
Compensation: W‑2 Pay Target: $75.00 - $80.06/hr
Role Summary The Senior Oracle DBA (Key Personnel) leads the planning, implementation, hardening, and operations of Oracle database platforms supporting mission applications. The role owns availability, performance, backup/recovery posture, security/auditing, and change control—while partnering with app teams, infrastructure, and other DBAs to meet SLAs and compliance requirements.
Core Scope of Work
Own end‑to‑end Oracle database lifecycle: install, configure, patch, upgrade, and decommission per policy.
Engineer and maintain HA/DR (e.g., Data Guard/Active Data Guard); define/meet RTO/RPO.
Implement/operate backup & recovery (e.g., RMAN) with regular validation/restores.
Performance engineering: AWR/ASH analysis, SQL tuning, indexing/partitioning strategies.
Security & compliance: user/role management, least privilege, auditing, encryption, and vulnerability/patch cadence.
Create/run operational documentation: SOPs, runbooks, build standards, and turnover artifacts.
Lead incident response and problem management; drive root‑cause and corrective actions.
Primary Responsibilities
Plan and execute Oracle patching/upgrades with rollback plans and stakeholder communications.
Design and administer Data Guard topologies; test failover/switchover and document procedures.
Establish backup/restore policies; conduct periodic recovery drills and report evidence.
Monitor capacity/performance; baseline key metrics (waits, I/O, CPU, memory, buffer cache, top SQL).
Tune application SQL (plans, stats, hints when necessary) and schema objects (indexes, partitions).
Implement and review security controls and audit trails; support compliance assessments.
Maintain environments across DEV/TEST/PROD with change control, approvals, and CAB participation.
Mentor junior DBAs; coordinate with application, network, storage, and security teams.
Provide leadership presence during incidents, releases, and major cutovers.
Minimum Qualifications (Required)
Senior‑level Oracle DBA expertise supporting production, highly available systems.
Hands‑on experience with Oracle backup/recovery (RMAN), Data Guard/Active Data Guard, and patching/upgrade cycles.
Proven performance tuning using AWR/ASH, optimizer statistics, and indexing/partitioning.
Strong SQL/PL‑SQL; ability to read/interpret execution plans and remediate problem SQL.
Demonstrated experience with security hardening and auditing in regulated environments.
Clear documentation and stakeholder communication; ability to lead bridge calls and RCA reviews.
Preferred (Optional)
Oracle certification (e.g., Oracle Database Administrator Professional or newer equivalents).
Experience integrating with SQL Server/PostgreSQL ecosystems and data engineering teams.
Familiarity with automation (shell/PowerShell/Python) and CI/CD concepts for DB changes.
Exposure to cloud‑hosted Oracle (IaaS/DBaaS) and enterprise monitoring/ITSM toolsets.
Success Metrics / KPIs
Availability: Meets/exceeds application SLA (e.g., 99.9% as defined by the program).
Recovery: Tested RTO/RPO compliance with documented evidence.
Performance: Key workload baselines maintained or improved.
Change Quality: Zero unplanned outages from standard patching; change success rate within target.
Security: Patch/vulnerability KPI adherence; audit findings closed on schedule.
Deliverables
Build standards, SOPs/runbooks, topology diagrams, and DR playbooks.
Backup/recovery policy with drill calendar and after‑action reports.
Monthly KPI reports (availability, performance, backup success, patch compliance).
Change records with implementation/rollback steps and validation results.
Knowledge transfer artifacts and turnover checklist.
Collaboration & Reporting Reports to: Project Manager / Operations Manager.
Partners: Application owners, other DBAs, infrastructure, security, and service desk leads.
Cadence: Operations reviews (weekly/monthly), CAB participation, incident postmortems.
Tools/Environment
Oracle Database (on‑prem or cloud‑hosted), RMAN, Data Guard/Active Data Guard.
Monitoring/Diagnostics: AWR/ASH, alerting platforms per agency standard.
ITSM/Change: Ticketing, change control, CMDB per agency standard.
Source control/automation: Git-based workflows and scripting as permitted.
#J-18808-Ljbffr
Role Type: Key Personnel (senior technical lead – Oracle)
Clearance/Background: TBD by RFQ/agency
Work Location: Onsite/Hybrid/Remote – TBD by RFQ/agency
Schedule: Full-time; may include on-call/after‑hours for maintenance windows and incident response
Start: Upon award/authorization
Compensation: W‑2 Pay Target: $75.00 - $80.06/hr
Role Summary The Senior Oracle DBA (Key Personnel) leads the planning, implementation, hardening, and operations of Oracle database platforms supporting mission applications. The role owns availability, performance, backup/recovery posture, security/auditing, and change control—while partnering with app teams, infrastructure, and other DBAs to meet SLAs and compliance requirements.
Core Scope of Work
Own end‑to‑end Oracle database lifecycle: install, configure, patch, upgrade, and decommission per policy.
Engineer and maintain HA/DR (e.g., Data Guard/Active Data Guard); define/meet RTO/RPO.
Implement/operate backup & recovery (e.g., RMAN) with regular validation/restores.
Performance engineering: AWR/ASH analysis, SQL tuning, indexing/partitioning strategies.
Security & compliance: user/role management, least privilege, auditing, encryption, and vulnerability/patch cadence.
Create/run operational documentation: SOPs, runbooks, build standards, and turnover artifacts.
Lead incident response and problem management; drive root‑cause and corrective actions.
Primary Responsibilities
Plan and execute Oracle patching/upgrades with rollback plans and stakeholder communications.
Design and administer Data Guard topologies; test failover/switchover and document procedures.
Establish backup/restore policies; conduct periodic recovery drills and report evidence.
Monitor capacity/performance; baseline key metrics (waits, I/O, CPU, memory, buffer cache, top SQL).
Tune application SQL (plans, stats, hints when necessary) and schema objects (indexes, partitions).
Implement and review security controls and audit trails; support compliance assessments.
Maintain environments across DEV/TEST/PROD with change control, approvals, and CAB participation.
Mentor junior DBAs; coordinate with application, network, storage, and security teams.
Provide leadership presence during incidents, releases, and major cutovers.
Minimum Qualifications (Required)
Senior‑level Oracle DBA expertise supporting production, highly available systems.
Hands‑on experience with Oracle backup/recovery (RMAN), Data Guard/Active Data Guard, and patching/upgrade cycles.
Proven performance tuning using AWR/ASH, optimizer statistics, and indexing/partitioning.
Strong SQL/PL‑SQL; ability to read/interpret execution plans and remediate problem SQL.
Demonstrated experience with security hardening and auditing in regulated environments.
Clear documentation and stakeholder communication; ability to lead bridge calls and RCA reviews.
Preferred (Optional)
Oracle certification (e.g., Oracle Database Administrator Professional or newer equivalents).
Experience integrating with SQL Server/PostgreSQL ecosystems and data engineering teams.
Familiarity with automation (shell/PowerShell/Python) and CI/CD concepts for DB changes.
Exposure to cloud‑hosted Oracle (IaaS/DBaaS) and enterprise monitoring/ITSM toolsets.
Success Metrics / KPIs
Availability: Meets/exceeds application SLA (e.g., 99.9% as defined by the program).
Recovery: Tested RTO/RPO compliance with documented evidence.
Performance: Key workload baselines maintained or improved.
Change Quality: Zero unplanned outages from standard patching; change success rate within target.
Security: Patch/vulnerability KPI adherence; audit findings closed on schedule.
Deliverables
Build standards, SOPs/runbooks, topology diagrams, and DR playbooks.
Backup/recovery policy with drill calendar and after‑action reports.
Monthly KPI reports (availability, performance, backup success, patch compliance).
Change records with implementation/rollback steps and validation results.
Knowledge transfer artifacts and turnover checklist.
Collaboration & Reporting Reports to: Project Manager / Operations Manager.
Partners: Application owners, other DBAs, infrastructure, security, and service desk leads.
Cadence: Operations reviews (weekly/monthly), CAB participation, incident postmortems.
Tools/Environment
Oracle Database (on‑prem or cloud‑hosted), RMAN, Data Guard/Active Data Guard.
Monitoring/Diagnostics: AWR/ASH, alerting platforms per agency standard.
ITSM/Change: Ticketing, change control, CMDB per agency standard.
Source control/automation: Git-based workflows and scripting as permitted.
#J-18808-Ljbffr