Oracle Database Administrator

Signature IT World Inc; Virginia; On-site; USD 110,000 - 140,000; Full time

Job summary

Signature IT World Inc. is seeking an experienced Oracle Database Administrator (DBA) in Virginia to install, configure, maintain, and optimize Oracle Database environments. The role emphasizes performance tuning, security, backup/recovery, and high availability to ensure data integrity and reliability.

The ideal candidate will manage enterprise databases, optimize SQL queries, and support development teams with data access and PL/SQL procedures, functions, packages, and triggers.

Qualifications

• Extensive Oracle DBA experience including installation, maintenance and upgrades.
• Strong SQL/PL/SQL skills and query optimization.
• Experience with performance tuning, indexing, and execution plans.

Responsibilities

• Install, configure, upgrade, and maintain Oracle Database environments.
• Monitor health, availability, storage, and performance; manage tablespaces and logs.
• Write and optimize complex SQL queries, views, and stored procedures; assist developers.

Skills

Oracle DBA

SQL Development

Performance Tuning

Tools

PL/SQL

Job description

Job role: Oracle Database Administrator (DBA)

We are seeking an experienced Oracle Database Administrator (DBA) with strong expertise in Oracle databases and SQL database administration. The candidate will be responsible for database installation, configuration, maintenance, performance tuning, security, backup and recovery, troubleshooting, and high availability.

The ideal candidate should have hands-on experience managing enterprise database environments, writing and optimizing SQL queries, administering database instances, and ensuring data integrity, availability, security, and reliability.

Key Responsibilities

1. Oracle Database Administration

• Install, configure, upgrade, and maintain Oracle Database environments.
• Perform database creation, schema management, user management, and privilege administration.
• Monitor database health, availability, storage utilization, and system performance.
• Manage tablespaces, data files, control files, redo logs, and archive logs.
• Apply database patches, security updates, and version upgrades.
• Troubleshoot database errors and resolve production incidents.

2. SQL Development and Performance Tuning

• Write, analyze, and optimize complex SQL queries, joins, subqueries, views, and stored procedures.
• Analyze execution plans and optimize queries using indexes, statistics, and appropriate SQL tuning techniques.
• Identify and resolve slow-running queries, locking issues, deadlocks, and resource bottlenecks.
• Work with PL/SQL, including procedures, functions, packages, and triggers.
• Support developers with database design, query optimization, and data access issues.