Monitors database health, performance, and capacity, tuning SQL queries, indexes, and instance parameters to support program availability targets.
Implements and maintains Oracle Data Guard or comparable high-availability/replication configurations to support ICAM uptime requirements.
Performs database patching, upgrades, and security hardening in accordance with VA and federal security requirements.
Manages database user accounts, roles, and privileges, enforcing least-privilege access and supporting audit and compliance requirements.
Supports data integrity and reconciliation efforts across ICAM data stores, including validation of identity resolution and person-matching data.
Administers Oracle databases hosted on Microsoft Azure cloud infrastructure, coordinating with systems administration and cloud engineering teams.
Writes and maintains PL/SQL scripts, stored procedures, and database maintenance jobs to support ICAM application and reporting needs.
Troubleshoots and resolves database-related incidents escalated from the IAM Help Desk, coordinating with Tier 3 engineering as needed.
Develops and maintains database documentation, including configuration baselines, backup/recovery procedures, and runbooks.
Participates in change management processes, coordinating database changes with the IAM Release Manager to minimize service disruption.
Qualifications
Required Skills & Experience
Bachelor's degree in Computer Science, Information Systems, or a related field, and 12 years of experience. (or commensurate experience)
5+ years of experience as an Oracle Database Administrator (or commensurate combination of education and experience).
Demonstrated experience administering Oracle database environments, including backup/recovery (RMAN), performance tuning, and high availability (e.g., Data Guard, RAC).
Demonstrated experience administering databases hosted on Microsoft Azure cloud infrastructure.
Experience with database patching, configuration management, and security hardening.
Experience writing and maintaining PL/SQL scripts, stored procedures, and database maintenance jobs.
Strong troubleshooting skills and experience supporting Tier 3 escalations.
Strong written and verbal communication skills, including database documentation.
Clearance Required: Ability to obtain and maintain a Suitability/Public Trust clearance.
Preferred Skills & Experience
Experience administering databases on Red Hat Enterprise Linux (RHEL) systems.
Experience supporting an IAM/ICAM or other IT program at the Department of Veterans Affairs or another federal civilian agency.
Familiarity with IAM/ICAM concepts and data stores, such as Master Person Index (MPI)/identity resolution, IGA, and PAM.
Experience with Oracle Enterprise Manager or comparable database monitoring tools.
Oracle certification (e.g., Oracle Certified Professional – Database Administrator).
Experience with Microsoft Azure database services (e.g., Azure SQL, Oracle on Azure).
Posted Salary Range
USD $130,000.00 - USD $150,000.00 /Yr.
Installs, configures, and administers Oracle database instances supporting ICAM products, including IGA, PAM, and the Master Person Index (MPI).
Performs database backup, recovery, and disaster recovery planning using Oracle RMAN and related tools to protect identity data.
Monitors database health, performance, and capacity, tuning SQL queries, indexes, and instance parameters to support program availability targets.
Implements and maintains Oracle Data Guard or comparable high-availability/replication configurations to support ICAM uptime requirements.
Performs database patching, upgrades, and security hardening in accordance with VA and federal security requirements.
Manages database user accounts, roles, and privileges, enforcing least-privilege access and supporting audit and compliance requirements.
Supports data integrity and reconciliation efforts across ICAM data stores, including validation of identity resolution and person-matching data.
Administers Oracle databases hosted on Microsoft Azure cloud infrastructure, coordinating with systems administration and cloud engineering teams.
Writes and maintains PL/SQL scripts, stored procedures, and database maintenance jobs to support ICAM application and reporting needs.
Troubleshoots and resolves database-related incidents escalated from the IAM Help Desk, coordinating with Tier 3 engineering as needed.
Develops and maintains database documentation, including configuration baselines, backup/recovery procedures, and runbooks.
Participates in change management processes, coordinating database changes with the IAM Release Manager to minimize service disruption.
Required Skills & Experience
Bachelor's degree in Computer Science, Information Systems, or a related field, and 12 years of experience. (or commensurate experience)
5+ years of experience as an Oracle Database Administrator (or commensurate combination of education and experience).
Demonstrated experience administering Oracle database environments, including backup/recovery (RMAN), performance tuning, and high availability (e.g., Data Guard, RAC).
Demonstrated experience administering databases hosted on Microsoft Azure cloud infrastructure.
Experience with database patching, configuration management, and security hardening.
Experience writing and maintaining PL/SQL scripts, stored procedures, and database maintenance jobs.
Strong troubleshooting skills and experience supporting Tier 3 escalations.
Strong written and verbal communication skills, including database documentation.
Clearance Required: Ability to obtain and maintain a Suitability/Public Trust clearance.
Preferred Skills & Experience
Experience administering databases on Red Hat Enterprise Linux (RHEL) systems.
Experience supporting an IAM/ICAM or other IT program at the Department of Veterans Affairs or another federal civilian agency.
Familiarity with IAM/ICAM concepts and data stores, such as Master Person Index (MPI)/identity resolution, IGA, and PAM.
Experience with Oracle Enterprise Manager or comparable database monitoring tools.
Oracle certification (e.g., Oracle Certified Professional – Database Administrator).
Experience with Microsoft Azure database services (e.g., Azure SQL, Oracle on Azure).
