DBA – Oracle

Vortalsoft Inc; New Jersey; On-site; USD 80,000 - 110,000; Full time

Job summary

Vortalsoft Inc is seeking a Database Administrator with expertise in Oracle databases located in New Jersey. The role involves resolving user queries, managing database users, and ensuring compliance with organizational processes.

The ideal candidate will be skilled in SQL performance tuning and possess strong documentation skills. Responsibilities include conducting training and mentoring team members, with a proactive approach to collaboration with infrastructure support teams.

Qualifications

• Experience with Oracle databases and user management.
• Ability to conduct user training and create documentation.
• Familiarity with performance monitoring and tuning.

Responsibilities

• Resolve user queries in production and test databases.
• Create and manage database users and their privileges.
• Conduct training sessions for users and team members.

Skills

Database performance tuning

User management

SQL

Documentation skills

Team mentoring

Tools

Oracle OEM 12C

RMAN

Data Pump utility

Job description

Job Description – Database Administrator Oracle

• Resolving User related queries in Production and Test Databases.
• As per client request creating new users and assigning profiles in production databases.
• User management and maintenance of all database users like granting a subset of privileges as per client’s policy.
• Logical backup using Export-Import and Data Pump utility as per user request.
• Database bug-patching on requirement
• Creating Sql tuning sets and sql tuning advisory reports using OEM 12C for Improving performance of the database.
• Executing weekly analyzer on database for performance improvement.
• Monthly purging activity to gain database level space improvement
• Archival activity for performance improvement.
• Performance monitoring, Database installation and configuration
• Schedule RMAN backup and monitor RMAN status of all production databases.
• Interface proactively with other Infrastructure support teams such as UNIX, Windows, Network, Storage, Monitoring etc
• Document issues and associated resolutions to problems
• Prepare documentation and presentation of progress reports to customers
• Conduct users, customers and Teams training
• Guide/Mentor the team members on technical problems which cannot be resolved at their level
• Ensure that Systems, Organization processes, & Unit practices adhere to Organization policies
• Active participation in Organization and Unit level initiative