Info Way Solutions
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
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