Database Analyst

DATABASE ANALYST

Tallahassee, FL - Onsite Job

Contract

Client: State of Florida.

Knowledge, Skills and Abilities required:

• 8 Years of experience as a Database Administrator with Oracle, PL/SQL

• 1 year’s experience with Oracle 19c Multi-Tenant Architecture and database infrastructure design on RAC Databases.

• Experience Red Hat Linux & Oracle Linux Operating Systems.

• Experience in following processes and procedures to standardize Database installations and configuration.

• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools.

• Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c.

• Comprehensive understanding of Oracle backup methodologies

• Experience with setup and scheduling of RMAN backups as well as successful database restores.

• Monitor alert logs, OEM and system alerts, acting on the results.

• Willingness to participate in after-hours Production support.

• Proficiency in Linux, Unix, Java, and DBA

• Understanding of production environments, technical support, and troubleshooting

• Knowledge of Automatic Storage Management (ASM)

• Experience with Oracle Exadata

• Experience working in UNIX operating system

• Ability to write simple to complex Linux/Unix shell scripts and Perl scripts

• Strong knowledge in Unix/Linux System administration,

• Ability to work independently and to resolve complex Oracle issues

• Experience with data pump and working knowledge to use expdp and impdp.

• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure

• Ability to write, SQL, PL/SQL, Oracle Stored Procedures,

• Functions, Packages and Database Triggers

• Ability to Tune Oracle SQL and PL/SQL performance

• Experience in logical database design and data models

• Understanding of the software development lifecycle process

• Practical experience in monitoring and tuning a database to provide a high availability service

• Experience with Oracle Enterprise Manager (OEM).

• Knowledge of data privacy and protection initiatives

• Strong communication and collaborative skills

• Excellent verbal and written communication skills

Preferred KSA’s:

• Excellent working skills with Oracle Exadata

• 3 years' experience with SQL performance tuning and database architecture.

• Experience in converting non CDB databases to CDB

• Experience in working with Informatica