Senior Oracle Database Administrator (DBA)

Veriipro; City of Schenectady (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Veriipro is seeking an experienced Oracle Database Administrator to manage and optimize Oracle database environments. The role focuses on RAC, Data Guard, RMAN, performance tuning, security, and high availability.

You will install, configure, and maintain databases, monitor performance, and lead disaster recovery activities, with on-call production support as needed. Strong collaboration with development and infrastructure teams is essential.

Qualifications

• Experience administering Oracle Database 11g/12c/19c.
• Expertise in Oracle RAC, Data Guard, RMAN.
• Hands-on performance tuning and query optimization.
• Proficient in PL/SQL scripting and database automation.
• Experience with Oracle Enterprise Manager (OEM) and monitoring tools.
• Knowledge of Exadata and cloud platforms (OCI, AWS).
• Strong troubleshooting and migration skills.
• Excellent communication and collaboration abilities.

Responsibilities

• Install, configure, administer, and maintain Oracle databases (11g, 12c, 19c).
• Monitor performance, optimize queries, and perform performance tuning.
• Manage Oracle RAC, ASM, Data Guard, and RMAN backup/recovery.
• Migrate, upgrade, patch, and perform disaster recovery activities.
• Troubleshoot performance issues, corruption, and outages.
• Implement database security, user management, encryption, and auditing.
• Automate DBA tasks using PL/SQL, Bash, or Perl scripting.
• Monitor storage, capacity, and database health.
• Collaborate with development and infrastructure teams to improve performance and availability.
• Provide on-call production support as needed.

Skills

Oracle Database

Oracle RAC

Data Guard

RMAN

Performance tuning

PL/SQL scripting

OEM/Monitoring

Exadata knowledge

OCI/AWS

Automation scripting

Job description

We are seeking an experienced Oracle Database Administrator (DBA) to manage, optimize, and support Oracle database environments. The ideal candidate will have expertise in Oracle RAC, Data Guard, RMAN, performance tuning, backup and recovery, database security, and high availability solutions.

Primary Responsibilities

• Install, configure, administer, and maintain Oracle databases (11g, 12c, 19c).
• Monitor database performance, optimize queries, and perform performance tuning.
• Manage Oracle RAC, ASM, Data Guard, and RMAN backup and recovery.
• Perform database migrations, upgrades, patching, and disaster recovery activities.
• Troubleshoot database performance issues, corruption, and outages.
• Implement database security, user management, encryption, and auditing.
• Automate DBA tasks using PL/SQL, Bash, or Perl scripting.
• Monitor storage, capacity planning, and database health.
• Collaborate with development and infrastructure teams to improve database performance and availability.
• Provide on-call production support as needed.

Required Skills

• Strong experience administering Oracle Database (11g, 12c, 19c).
• Expertise in Oracle RAC, ASM, Data Guard, RMAN, backup, and recovery.
• Hands-on experience with Oracle performance tuning and database optimization.
• Proficiency in PL/SQL scripting and database automation.
• Experience with Oracle Enterprise Manager (OEM) and monitoring tools.
• Knowledge of Oracle Exadata and cloud platforms such as Oracle Cloud Infrastructure (OCI) and AWS.
• Strong troubleshooting, problem-solving, and database migration skills.
• Excellent communication and collaboration skills.