Oracle Database Administrator

Signature IT World Inc; North Carolina; On-site; USD 100,000 - 150,000; Full time

Job summary

Signature IT World Inc. is seeking an experienced Oracle Database Administrator (DBA) in North Carolina to manage Oracle Database environments, optimize SQL queries, and ensure data integrity and security.

The role covers installation, maintenance, tuning, and recovery, with a focus on high availability. The ideal candidate will handle database instances, performance monitoring, and collaboration with developers to optimize data access and PL/SQL routines.

Qualifications

• Hands-on experience managing enterprise database environments.
• Writing and optimizing SQL queries.
• Administering database instances and ensuring data integrity.

Responsibilities

• Install, configure, upgrade, and maintain Oracle Database environments.
• Monitor health, availability, storage, and performance.
• Manage tablespaces, data files, redo logs, and archivelogs.
• Apply patches and security updates; troubleshoot incidents.

Skills

Oracle DBA

SQL development

Performance tuning

Backup & recovery

High availability

PL/SQL

Tools

Oracle RMAN

SQL Developer

Enterprise Manager

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.