Oracle DBA Consultant - W2 contract

Overview

The Oracle DBA Consultant plays a critical role in managing and optimizing Oracle databases to ensure their availability, performance, and security in a dynamic environment. As part of a collaborative IT team, the consultant will be responsible for designing and administering databases, implementing backup solutions, and ensuring data integrity across systems. Their expertise will support business objectives by enabling responsive database solutions that adapt to evolving requirements. This position requires a keen analytical mindset to troubleshoot issues, optimize database performance, and maintain high standards of data protection. The Oracle DBA Consultant will also work closely with developers to provide optimal access to data and will leverage industry best practices to recommend and implement effective database strategies. This role is crucial for maintaining data workflows that empower decision-making throughout the organization. Overall, the consultant will be a key player in the broader efforts to streamline database operations while ensuring robust support for technical and business aims.

Key Responsibilities

• Design, install, and configure Oracle databases.
• Monitor database performance and implement tuning measures.
• Develop and execute backup and recovery strategies.
• Perform routine maintenance, including patching and upgrades.
• Create and maintain data models and structures.
• Analyze and optimize SQL queries for performance improvements.
• Implement and enforce database security protocols.
• Assist in data migration projects and ensure minimal downtime.
• Document database configurations, processes, and procedures.
• Collaborate with application developers to support database access.
• Manage user roles and permissions to ensure data security.
• Conduct regular capacity planning and forecasting.
• Diagnose and resolve database issues in a timely manner.
• Stay updated on Oracle technologies and industry trends.
• Provide 24/7 on-call support as needed.
  
  

Required Qualifications

• Bachelor's degree in Computer Science or related field.
• 5 years of experience as an Oracle DBA.
• Strong expertise in Oracle database design and management.
• Proficiency in SQL and PL/SQL.
• Experience with Oracle RAC and Data Guard.
• Hands-on experience with backup and recovery solutions.
• Knowledge of database security management.
• Familiarity with Oracle Cloud services is a plus.
• Experience with performance monitoring tools (e.g., AWR, ADDM).
• Strong troubleshooting and problem-solving abilities.
• Excellent communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Experience with scripting languages (e.g., Bash, Perl).
• Understanding of data migration methodologies.
• Certifications like OCP or OCM preferred.
  
  

Skills: performance tuning,backup and recovery,sql proficiency,data migration,shell scripting,database security,capacity planning,database