Database Administrator

POSITION PURPOSE
The Database Administrator supports a large statewide research repository, which is replicated in near real-time. This repository is crucial for research at the Regenstrief Institute and is currently 50TB and growing. The ideal candidate will provide primary support for Oracle databases and secondary support for Postgres databases.

This position is listed as 100% remote.

POSITION ESSENTIAL DUTIES AND RESPONSIBILITIES
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

JOB KNOWLEDGE
Job knowledge focuses on the understanding and skills one needs to perform well in this role. It also focuses on the expectation to continually refine and improve the required skills by seeking out internal and external learning opportunities.
Related expectations include:

• 
  Has knowledge, familiarity, and experience with the following:
  
  
  
  • 
    Relational database design
    
  • 
    Data-modeling concepts
    
  • 
    Front-end and query tools
    
  • 
    Linux operating systems
    
  • 
    Backup and recovery strategies
    
  • 
    Performance and maintenance techniques
    
  • 
    General business operations
    
  • 
    Data privacy practices and laws
    
  
  
  
  

PEFORMANCE AUTONOMY
The performance autonomy competency focuses on the level of independence one has when performing the work. Time-management skills are also a factor in this competency.
Related responsibilities include:

• 
  Installs and maintains the Oracle RDBMS.
  
• 
  Manages and maintains challenging database storage structures and backups.
  
• 
  Manages database user accounts.
  
• 
  Monitors performance and makes appropriate recommendations and changes.
  
• 
  Regularly reviews and updates database security protocols.
  
• 
  Assists application teams and data analysts with query tuning and debugging application database related issues.
  
• 
  Refactors database maintenance processes for improved performance, stability, and scalability.
  
• 
  Utilizes Shareplex to replicate data from the database in near real-time.
  
• 
  Performs all aspects of data and database administration, including the following:
  
  
  
  • 
    Software evaluation and installation
    
  • 
    Logical and physical database design and implementation
    
  • 
    Support of application testing
    
  • 
    Security administration
    
  • 
    Backup and recovery planning
    
  • 
    Capacity planning
    
  • 
    Database maintenance and performance enhancement
    
  • 
    Research and evaluation of new tools and techniques.
    
  • 
    Development of database policies and procedures
    
  
  
  
  

DECISION MAKING
The decision-making competency focuses on how much one is expected to make decisions when performing the work. It is directly aligned with the performance autonomy competency.
Related responsibilities include:

• 
  Makes decisions regarding database and systems processes.
  
• 
  Seeks approval before making higher-level decisions.
  
• 
  Seeks feedback from others as necessary to ensure decisions do not conflict with business needs.
  

TEAMWORK AND MANAGEMENT
The teamwork and management competency focuses on the interaction and collaboration between team members. It also focuses on the ability to manage people and projects. Inherit in this competency is the ability to communicate orally and in writing and to improve communication skills as time and experience progress.
Related responsibilities include:

• 
  Serves as a resource to team members.
  
• 
  May lead or direct projects and/or the work of team members.
  

QUALIFICATION REQUIREMENTS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

EDUCATION and/or EXPERIENCE

• 
  Requires a bachelor's degree in information systems or a related field. Extensive experience may be considered in place of degree.
  
• 
  Requires at least five (5) years of experience with Oracle database applications.
  
• 
  Requires the ability to successfully complete Human Subjects Certification upon hire.
  
• 
  PostgreSQL and/or Oracle certifications preferred.
  

LANGUAGE SKILLS

• 
  Requires the ability to interact and verbally communicate with a diverse set of internal and external stakeholders.
  
• 
  Requires effective verbal and written communication skills and advanced listening skills.
  
• 
  Requires ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
  

REASONING ABILITY

• 
  Requires the ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
  
• 
  Must be able to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
  
• 
  Requires the ability to think logically to troubleshoot, analyze situations, and make sound decisions.
  

MATHEMATICAL SKILLS

• 
  Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
  

TECHNICAL/COMPUTER SKILLS

• 
  Requires advanced computer skills, including working knowledge of Microsoft Word, Microsoft Excel, and
  e-mail systems.
  
• 
  Requires the ability to operate office equipment, including copiers, fax machines, and phones.
  

PHYSICAL DEMANDS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

• 
  This position requires the physical ability to work 40 hours per week, including the flexibility to work extended hours as necessary to meet organizational needs.
  
• 
  This position requires the ability to sit and/or stand for extended periods of time.
  
• 
  This position requires the manual dexterity to operate a keyboard and pointing device.
  
• 
  This position requires the ability to work from both a home office and a corporate office and the ability to travel locally for meetings as required.
  
• 
  This position requires the ability to perform focused work with close attention to detail.
  
• 
  This position requires some physical activity, such as pushing, pulling, lifting, carrying, and moving (up to 20 pounds)
  

WORK ENVIRONMENT
The work environment characteristics described here are representative of those an employee encounters while performing the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

• 
  This work is fast-paced and deadline-oriented and requires a flexible work schedule.
  
• 
  Use of a computer, business office equipment, and other machinery is necessary.
  
• 
  This position requires working as a team member and independently.
  
• 
  This position requires working and interacting with others, both in person and through phone, e-mail, and written correspondence
  

BENEFITS OF WORKING HERE

• Work with a variety of diverse professionals in the healthcare industry
• Free parking
• Paid holidays, vacation, and sick time
• Group Life and Voluntary Term Life insurance
• Long-term and Short-term Disability plans
• Employee Assistance Program (EAP)
• Flexible Spending Account (FSA)
• 403b Retirement Plan with gracious employer contributions
• Fitness program
• Pet insurance
• Qualified employer for loan forgiveness

Please note sponsorship and/or relocation are not available for this position.

REGENSTRIEF INSTITUTE REQUIRES ALL EMPLOYEES TO RECEIVE THE INFLUENZA VACCINATION ANNUALLY UNLESS APPROVED FOR EXEMPTION