Oracle DB Senior Database Analyst

This is the perfect opportunity for you! At Alianza Tecnológica de Capital, we are looking for a talented and motivated Database Analyst (Systems Engineer) to join our dynamic team.

Company: Capital Technology AllianceLocation: Tallahassee, FloridaJob Type: Contract

Responsibilities:• Provide direct support to Oracle databases as assigned by the Contract Manager.• Ensure logical data model design meets Department standards based on best practices and guidelines.• Coordinate and implement application changes, including procedural language/structured query language (PL/SQL) object and data model changes, to production databases following industry best practices and industry policies and procedures. department.• Write Structured Query Language (SQL) 12c and 19c, PL/SQL, Oracle Stored Procedures, Functions, Packages, and Database Triggers as required to increase application development security and performance requirements.• Write and use custom scripts and processes to handle data loads, data cleansing, and data migration to include migrations to and from multiple data sources and types, such as Access, SQL Server, Excel, flat files, and different versions of Oracle databases. G. Run diagnostic tools to identify database performance issues and take appropriate corrective actions to improve database performance.• Work with development teams to tune SQL queries and improve performance. I. Ensure that associated hardware resources assigned to databases result in high availability and optimal performance as defined by the Department.• Design, implement and maintain database maintenance scripts, including replication and monitoring. K. Perform daily operational tasks, including monitoring, statistical analysis, and performance issue resolution using appropriate Department-approved tools and scripts.• Design and maintain automated processes, including DBA jobs, DBA scheduler, and CRON scripts. M. Attend and participate in all assigned meetings.• Attend Department required training and complete a Project Report and Project Time Sheet weekly.Academic preparation:A minimum of a bachelor's degree in one of the fields of computer science or management information systems or five years of work experience in information technology, systems analysis, management analysis, program planning, program research, or evaluation of programs.