Oracle DBA

Job Description

Install, configure, and maintain Oracle databases.

In charge of developing and implementing database backups and disaster recovery strategies.

Optimize database performance by fine-tuning database settings.

Troubleshoot and resolve database-related issues to contribute to continuous improvements.

Develop, implement, and manage database security policies and procedures to guarantee a seamless and successful flow of activities.

Work closely with team members to guarantee database operation and integrity.

Introduce and deploy new database technology.

Maintain database reports, visualizations, and dashboards to help existing workflows.

Interact with clients to comprehend, design, assess, and analyze customers' wants and requirements and provide technical experience in developing technical, structural, and organizational specifications.

Assess the suitability of data for storage and the best way to organize storage.

Creates, builds, and integrates complex database systems for internal and external users/clients.

Defines, documents, and implements standards and complicated models to monitor and improve the database's capacity and performance.

Complex programs are coded, and logical processes are derived on technological platforms.

Develops and monitors the implementation of test application code in client-server settings to ensure that software adheres to build management guidelines.

Maintains knowledge of and assesses new and developing technologies and tools for field application

Reduce database downtime and control parameters to ensure quick query responses.

Ensure SLAs and operational KPIs are fulfilled, collaborating with internal and external support departments as needed when large events occur.

Primary Skills

Proficiency in SQL and SQL server tools

Advanced understanding of database security, backup and recovery, and performance monitoring requirements

Deep understanding on Golden Gate configuration, tuning and related activities.

Having Devops experience like with CI/CD pipelines will be an added plus.

Modeling of relational and dimensional data

PowerShell and Unix shell scripting abilities are required.

Impeccable attention to detail, excellent mathematics, and statistical expertise

Strong written and oral communication abilities

Bachelor's degree in IT or a similar discipline

Knowledge of Linux and Windows Server infrastructures

Thorough understanding of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)

Must have a DoD Secret Clearance with SSBI or be able to get one.

Key skills:

• RAC (Real Application Clusters)
• GoldenGate (GG)
• OEM (Oracle Enterprise Manager)
• TDE (Transparent Data Encryption)
• Ansible