Oracle Database Administrator

12 hours ago

North Carolina, United States Signature IT World Inc Full-time
Job role: Oracle Database Administrator (DBA)

Location:
Richardson, TX , Tempe, AZ , Hartford, CT , Raleigh, NC 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.