Cai - Tallahassee, FL
posted 6 months ago
As a Database Analyst at CAI, you will play a crucial role in the operational duties and administration of the Department's Enterprise Oracle Databases. This position is a full-time, onsite role that spans over 12 months, requiring candidates to be within a commutable distance to Tallahassee, Florida. Your primary responsibilities will include managing all stages of database implementation and deployment, ensuring the smooth operation of Oracle databases in a Solaris-based production environment. You will assist Department staff under the guidance of the Contract Manager or Functional Manager, providing maintenance and support for server hardware and Oracle WebLogic, as well as troubleshooting and resolving database performance issues. In this role, you will be responsible for writing and executing SQL, PL/SQL, and Oracle Stored Procedures, Functions, Packages, and Database Triggers to enhance security and performance. You will also coordinate and deploy application changes, ensuring adherence to best practices and Department policies. Your expertise will be essential in running diagnostic tools to identify performance issues and implementing corrective actions to optimize database performance. Collaboration with development teams to tune SQL queries and maintain high availability of database resources will be a key aspect of your job. Additionally, you will design and maintain automated processes, including DBA jobs and CRON scripts, and perform daily operational duties such as monitoring and statistical analysis. Participation in meetings and training sessions, along with the completion of project reports and timesheets, will also be part of your responsibilities. This position requires a strong ability to communicate effectively with Department staff and a commitment to maintaining the integrity and accessibility of data across multiple databases.