[Hiring] Senior Oracle DBA @Software Technology

Role Description

As the Database Analyst Senior, you will support Oracle databases to ensure data integrity, security, and stability. This position is needed to maintain minimum staffing needs of the Oracle Database Services team. The IOT Oracle team manages the data for the majority of the State's agency applications, including:

• DOR
• DWD
• DOT

Agency applications are dependent upon timely response to accurate and secure data. Successful candidates will have extensive experience with the latest releases of Oracle RDBMS and be proficient with Oracle - both in Standalone and RAC clustered environments. The candidate should be a self-starter, have excellent communication skills, and work seamlessly in a team environment as well as independently.

In this position, you will be responsible for:

• Providing adequate computer resources and up-to-date software environment to our various customers.
• Monitoring and tuning database performance.
• Ensuring that data is appropriately protected via database backup and related strategies.
• Loading, or assisting in loading, database software, upgrades, and patching.
• Assisting with the evaluation and selection of infrastructure components.
• Providing operational support for the database, ensuring data integrity, database availability, and performance.

The essential elements of the job duties include:

• Developing and advising on standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.
• Evaluating technology and products to determine the feasibility of adding to agency standards.
• Developing work plans for assigned projects and managing the execution.
• Designing and implementing logical and physical databases of a moderately to large complex nature.
• Determining aggregation, partitioning, and indexing strategies for physical data.
• Monitoring and tuning database performance, including SQL scripts, hints, execution plans, and materialized views.
• Administering end-user access and security at the database level.

Qualifications

• Extensive experience with the latest releases of Oracle RDBMS.
• Proficiency with Oracle in Standalone and RAC clustered environments.
• Excellent communication skills.
• Ability to work independently and in a team environment.

Requirements

• Self-starter with strong problem-solving skills.
• Experience in monitoring and tuning database performance.
• Knowledge of database backup and related strategies.

Benefits

• Remote work opportunity (Candidate should be local to Indiana State).
• Opportunity to work with various state agency applications.