Database Analyst

3 weeks ago

Tallahassee, United States Cai Full time

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 Manager   practices 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 c omplete 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

  • Database Analyst

    1 week ago

    Tallahassee, United States Business Intelligence & Informatics Consulting Services, Inc (BIICS, Inc) Full time

    BIICS, Inc is looking to fill a Sr. Database Analyst position. The position is located in Tallahassee, Florida and work is **onsite**. **Responsibilities**: - Responsible for designing, modeling, developing and supporting Database Management Systems (DBMS). - Review current database structures/Schemas and ETL processes for understanding; enhance...

  • Database Analyst

    1 week ago

    Tallahassee, United States Arthur Lawrence Full time

    Arthur Lawrence is looking to hire a Database Analyst based in Tallahassee, FL. Please find the job description below and send us your updated resume, if interested: Core Requirements: At least 8+ years of relevant experience as a database analyst Experience with Oracle, Data Warehousing, Data Migration, ETL processing, etc. Capability to effectively...

  • Database Analyst

    4 weeks ago

    Tallahassee, United States Info Way Solutions Full time

    Database Analyst Location: Tallahassee, FL Experience: • Experience in Oracle database administration • Proficiency in Linux, Unix, Java, and DBA • Understanding of production environments, technical support, and troubleshooting • Knowledge of ASM, PL/SQL, and RDBMS • Experience with Oracle Exadata • Experience working in UNIX operating system...

  • Database Analyst

    1 month ago

    Tallahassee, United States Crescens Full time

    Job Title: Database Analyst Location: Tallahassee, FL Duration: 12 months Job Description: Contractor staff assigned to this agreement must possess the following minimum qualifications and experience: Three years of experience with Oracle PL/SQL and SQL Server T-SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and...

  • Database Analyst

    2 weeks ago

    Tallahassee, United States Crescens Full time

    Job Title: Database Analyst Location: Tallahassee, FL Duration: 12 months Job Description: Contractor staff assigned to this agreement must possess the following minimum qualifications and experience: Three years of experience with Oracle PL/SQL and SQL Server T-SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and...

  • Database Analyst

    1 month ago

    Tallahassee, United States LanceSoft Full time

    Three years of experience with Oracle PL/SQL and SQL Server T-SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and database links. Three years of experience with Oracle and SQL server relational databases, On-Line Transaction Processing (OLTP) and Decision Support System (DSS). Two years of experience with development and...

  • Database Analyst

    2 weeks ago

    Tallahassee, United States LanceSoft Full time

    Three years of experience with Oracle PL/SQL and SQL Server T-SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and database links. Three years of experience with Oracle and SQL server relational databases, On-Line Transaction Processing (OLTP) and Decision Support System (DSS). Two years of experience with development and...

  • Oracle Database Administrator

    3 weeks ago

    Tallahassee, Florida, United States Randstad USA Full time

    job summary: Database Analyst Responsibilities: The Advanced Database Analyst(s) will be responsible for operational duties and assisting with the administration of the Enterprise Oracle Databases and shall perform, at a minimum, the below tasks and/or activities: Database administration in a large Oracle (12c and 19c) Solaris-based production environment...

  • Oracle Database Administrator

    2 weeks ago

    Tallahassee, Florida, United States Randstad USA Full time

    job summary: Database Analyst Responsibilities: The Advanced Database Analyst(s) will be responsible for operational duties and assisting with the administration of the Enterprise Oracle Databases and shall perform, at a minimum, the below tasks and/or activities: Database administration in a large Oracle (12c and 19c) Solaris-based production environment...

  • Oracle Database Administrator

    3 weeks ago

    Tallahassee, United States Randstad USA Full time

    job summary: Database Analyst Responsibilities: The Advanced Database Analyst(s) will be responsible for operational duties and assisting with the administration of the Enterprise Oracle Databases and shall perform, at a minimum, the below tasks and/or activities: Database administration in a large Oracle (12c and 19c) Solaris-based production environment...

  • Oracle Database Analyst

    5 days ago

    Tallahassee, United States Cleo Consulting Full time

    Job DescriptionJob DescriptionClient: Vitaver/ Florida LotteryJob Title: Oracle Database Analyst (onsite)Location: Tallahassee, FLDuration: 12+ Months (Extendable)Pay rate: $70-75/hr on C2CMust-have skills: 3+ y as a Oracle DBA with PL/SQL exp; ETL; DataWarehouseSeniority on the skill/s required on this requirement: Mid.Earliest Start Date: ASAPEstimated...

  • Database Application Architect

    3 weeks ago

    Tallahassee, United States The Brixton Group, Inc. Full time

    Job Title: Database Application ArchitectLocation: Tallahassee, FLDuration: 20+ Months ContractNote: Onsite Interview is required for this roleRoles & Responsibilities:Job SummaryResponsible for contributing to and/or producing as they relate to the design, development, implementation, or enhancement of Oracle Form application solutions Job DescriptionClient...

  • Database Application Architect

    1 week ago

    Tallahassee, United States The Brixton Group, Inc. Full time

    Job Title: Database Application ArchitectLocation: Tallahassee, FLDuration: 20+ Months ContractNote: Onsite Interview is required for this roleRoles & Responsibilities:Job SummaryResponsible for contributing to and/or producing as they relate to the design, development, implementation, or enhancement of Oracle Form application solutions Job DescriptionClient...

  • Database Application Architect- Onsite

    3 weeks ago

    Tallahassee, United States RapidIT Full time

    Position: Database Application Architect Location: Tallahassee, FL onsite Duration: 6+ months Responsible for contributing to and/or producing as they relate to the design, development, implementation, or enhancement of Oracle Form application solutions What You ll Do Prepare Deliverables within the timeframe specified by the Contract and/or...

  • Oracle PL/SQL Database Developer

    2 weeks ago

    Tallahassee, United States Mindteck Full time

    Job Title: "Oracle PL/SQL Database Developer” Location: Onsite in Tallahassee, FL. Duration: 1 year (extendable) Contract Type: W2 Job Description: Required Tasks to be performed: Provide maintenance, enhancement and support for a variety of the agency's business applications. Assist in the preparation and documentation of program requirements and...

  • Database Application Architect- Onsite

    3 weeks ago

    Tallahassee, FL, United States RapidIT Full time

    Position: Database Application Architect Location: Tallahassee, FL onsite Duration: 6+ months Responsible for contributing to and/or producing as they relate to the design, development, implementation, or enhancement of Oracle Form application solutions What You ll Do Prepare Deliverables within the timeframe specified by the Contract and/or...

  • On-Site Database/Systems Analyst

    4 weeks ago

    Tallahassee, United States Global Information Services Full time

    Skills: Please DO NOT Apply unless YOU:1) can work 100% on-site from day one & have all the Required skill set and have worked as a "On-Site Database/Systems Analyst (Java - SQL/PL-SQL/ETL/Data Cleansing/Conversion/mapping)" in a large & Complex IT Environment. 2) can meet the min required experience as defined under the MANDATORY Skill. 3) can provide at...

  • Oracle PL/SQL Database Developer

    3 weeks ago

    Tallahassee, Florida, United States Randstad USA Full time

    job summary: Education: Bachelor's Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience. Required Tasks to be performed: Provide maintenance, enhancement and support for a variety of the agency's business applications.Assist in the preparation and documentation of program requirements and...

  • Oracle PL/SQL Database Developer

    1 week ago

    Tallahassee, Florida, United States Randstad USA Full time

    job summary: Education: Bachelor's Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience. Required Tasks to be performed: Provide maintenance, enhancement and support for a variety of the agency's business applications.Assist in the preparation and documentation of program requirements and...

  • System Analyst

    4 weeks ago

    Tallahassee, United States Virpie Inc. Full time

    Must be onsite at client location - Tallahasse, FL - W2 only Role Title: System Analyst (Java) Duration: Long Term ContractLocation: Tallahasse, FL (Onsite)Client: State client  Job Description:Client requires the services of a Systems Analyst with technical knowledge andexperience in programming the J2EE/JAVA, JBOSS application server, MS SQL and ORACLE...