Job Information
CAI Database Analyst in Tallahassee, Florida
Job ID Number
R2672
Employment Type
Full time
Worksite Flexibility
Onsite
Job Summary
As Database Analyst, you will be responsible for operational duties and assisting with the administration of the Department’s Enterprise Oracle Databases to manage all stages of database implementation and deployment.
Job Description
We are looking for a Database Analyst This position will be a full-time and onsite 12+ month contract opportunity.
Candidates must be a commutable distance to Tallahassee, FL.
What You’ll Do
Database administration in a large Oracle (12c and 19c) Solaris-based production environment including assisting Department staff, as directed by the Contract Manager or Functional Manager with the following: All stages of database implementation and deployment, Provide maintenance and support of server hardware with Sun Solaris operating systems Reports, and Provide administration and support of Oracle WebLogic, Oracle Forms, and Oracle problem resolution, Monitoring, troubleshooting, and resolving database performance issues or related Analysis, review, coordination, and implementation of new database requests
Provide direct support for Oracle databases as assigned by the Contract Managerpractices and guidelines
Ensure that the logical data model design adheres to the Department’s standards-based upon best best practices and guidelines
Coordinate and deploy application changes, including Procedural Language/Structured Query Language (PL/SQL) object and data model changes, to production databases following industry best practices and Department policies and procedures.
Write 12c and 19c Structured Query Language (SQL), PL/SQL, Oracle Stored Procedures, Functions, Packages, and Database Triggers as required, to augment security and performance requirements of the application development
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 Oracle database versions
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
Ensure that the associated hardware resources allocated to the databases result in high availability and optimum performance as defined by the Department
Design, implement and maintain database maintenance scripts, including replication and monitoring
Perform daily operational duties, including monitoring, statistical analysis, and troubleshooting of performance issues using appropriate and Department-approved tools and scripts
Design and maintain automated processes including DBA jobs, DBA scheduler, and CRON scripts
Attend and participate in all assigned meetings
Attend Department-required training; and complete a Project Report and a Project Timesheet on a weekly basis
What You'll Need
Required
Ability to communicate effectively (verbally and in writing) with Department staff
A minimum of 10 years of IT business/industry work experience
A minimum of 5 years of Oracle Database Management Systems administration
Experience with Sun Solaris operating systems and Oracle WebLogic
A minimum of five 5 years supporting multiple services and multiple databases of medium to high complexity with multiple concurrent users, ensuring control, integrity, and accessibility of data
A minimum of a bachelor's degree in one of the computer sciences fields or in management information systems or 5 years of work experience in information technology, systems analysis, management analysis, program planning, program research, or program evaluation
Preferred
Oracle Database Administration 2019 Certified Professional
Experience leading the planning, design, development, implementation, and maintenance of Oracle Relational Database Management Systems
Experience leading the installation, configuration, and maintenance of Sun Solaris operating systems and Oracle WebLogic
Experience working in a Unix environment
Extensive experience diagnosing, isolating, and resolving complex problems pertaining to the database infrastructure
Extensive experience writing PL/SQL, SQL, and Oracle Stored Procedures, Functions, Packages, and Database Triggers
Extensive experience in designing logical databases and data models
Knowledge of data privacy and protection initiatives
Strong communication and collaborative skills
Physical Demands
Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards
Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
Reasonable Accommodation Statement
If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.
Equal Employment Opportunity Policy Statement
It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.
CAI
- CAI Jobs