Database Specialist

3 weeks ago


Indianapolis, Indiana, United States state of indiana Full time
About the Role

We are seeking a highly skilled Database Analyst to join our team at the State of Indiana. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our databases to ensure efficient data management and analysis.

Key Responsibilities
  • Design and implement logical and physical databases of a moderately complex nature
  • Determine aggregation, partitioning, and indexing strategies for physical data
  • Monitor and tune database performance
  • Administer end-user access and security at the database level
  • Ensure data is appropriately protected via database backup and related strategies
  • Load, process, and apply fixes dependent upon the complexity of the environment
  • Assist with the evaluation and selection of infrastructure components
  • Provide operational support for the database ensuring data integrity, database availability, and performance
  • Implement and maintain database catalogs and dictionaries
  • Develop integration of database systems through standardized database design techniques
  • Provide resolutions to technical problems
  • Implement innovative procedures and methods through understanding of product capabilities and utilize those capabilities in unique ways to fully use products on the system and meet user's goals and objectives
  • Assist management with short/long-range planning for hardware and software changes and additions
  • Serve as a project lead for software products
  • Provide technical assistance to lower-level staff
  • Prepare reports which assist management in understanding the current hardware/software conditions, performance, and future trends
Requirements
  • Master's degree with 2+ years of experience, or
  • Bachelor's Degree with 5+ years of experience, or
  • At least 9+ years of experience applying the below, outlined knowledge, skills, and abilities in a similar role
  • Advanced knowledge in the technology of both the DBMS and the operating system chosen for the data warehouse or data mart
  • Advanced knowledge in software and utilities related to supported DBMS such as Reorg, Backup, Recovery, Load, and Unload
  • Advanced knowledge of capacity planning and disaster recovery
  • Advanced knowledge of relational database and data warehouse design techniques and dimensional modeling processes
  • Advanced knowledge of computer hardware/software capabilities and configurations
  • Advanced knowledge of a variety of computer languages
  • Advanced knowledge of and the ability to apply complex diagnostic, structure, logic, and performance and tuning procedures relative to the operating system
  • Advanced knowledge of specialty area(s) of database administration and/or system software such as communication, storage management, operating systems, or capacity planning
  • Advanced knowledge of applications development and maintenance
  • Ability to analyze, communicate, and recommend future needs and direction for agency's data processing software/hardware environment
  • Ability to apply theories, principles, and methodologies to existing and new computer hardware/software
  • Ability to manage multiple hardware/software projects and priorities
  • Ability to guide and coordinate the work of others
  • Effectively communicate, both orally and in writing
  • Ability to perform advanced logic analysis
Benefits of Employment with the State of Indiana
  • Three (3) medical plan options (including RX coverage) as well as vision and dental plans
  • Wellness Rewards Program: Complete wellness activities to earn gift card rewards
  • Health savings account, which includes bi-weekly state contribution
  • Flexible work scheduling options, including the potential for hybrid remote work for employees whose work may be performed outside state facilities
  • Deferred compensation 457B account (similar to 401k plan) with employer match
  • Two (2) fully-funded pension plan options
  • A robust, comprehensive program of leave policies covering a variety of employee needs, including but not limited to: 150 hours of paid new parent leave, up to 15 hours of paid community service leave, combined 180 hours of paid vacation, personal, and sick leave time off, 12 paid holidays, 14 on election years
  • Education Reimbursement Program
  • Group life insurance
  • Referral Bonus program
  • Employee assistance program that allows for covered behavioral health visits
  • Qualified employer for the Public Service Loan Forgiveness Program
  • Free parking for most positions
  • Free LinkedIn Learning access
Equal Employment Opportunity

The State of Indiana is an Equal Opportunity Employer



  • Indianapolis, Indiana, United States JWM Neurology Full time

    Credentialing Specialist Job DescriptionAt JWM Neurology, we are seeking a highly skilled Credentialing Specialist to join our team. As a Credentialing Specialist, you will play a critical role in ensuring that our providers have the necessary credentials to deliver high-quality patient care.Key Responsibilities:Maintain accurate and up-to-date provider...


  • Indianapolis, Indiana, United States Defense Finance and Accounting Service Full time

    Job SummaryWe are seeking a highly skilled Cybersecurity Specialist to join our team at the Defense Finance and Accounting Service. As a key member of our IT department, you will be responsible for providing technical support and guidance to our team regarding database management systems.Key ResponsibilitiesProvide technical support and guidance to IT...


  • Indianapolis, Indiana, United States Edward Jones Full time

    Job Title: Data Analytics SpecialistWe are seeking a highly skilled Data Analytics Specialist to join our team at Edward Jones. As a Data Analytics Specialist, you will be responsible for designing, developing, and operationalizing dashboards and reports to support business decision-making.Key Responsibilities:Design and develop data visualizations to...


  • Indianapolis, Indiana, United States Franciscan Health Full time

    Job Title: Coding Integrity SpecialistFranciscan Health is seeking a skilled Coding Integrity Specialist to join our team. As a key member of our coding department, you will play a critical role in ensuring the accuracy and integrity of our clinical data.Key Responsibilities:Collaborate with coding staff to identify and resolve coding discrepancies and...

  • Service Specialist

    3 weeks ago


    Indianapolis, Indiana, United States Thats Dood HR Full time

    Thats Dood HR is Hiring a Service SpecialistAbout the Role:We are seeking a highly organized and detail-oriented Service Specialist to join our team. As a Service Specialist, you will be responsible for performing data entry, updating company archives, and generating reports.Key Responsibilities:Enter customer applications into our database with high...


  • Indianapolis, Indiana, United States Franciscan Health Full time

    Job Title: Coding Integrity SpecialistFranciscan Health is seeking a skilled Coding Integrity Specialist to join our team. As a key member of our coding department, you will play a critical role in ensuring the accuracy and integrity of our clinical documentation.Key Responsibilities:Serve as a liaison between the coding department and regional RMD CDI...


  • Indianapolis, Indiana, United States Elgen Staffing Full time

    Job OverviewElgen Staffing is seeking a skilled Field Service Technician to join our team in Indianapolis. As a Field Service Specialist, you will be responsible for performing hands-on equipment maintenance and repair of industrial packaging machinery.Key Responsibilities:Conduct thorough equipment inspections to identify potential issues and perform...


  • Indianapolis, Indiana, United States Technical Assurance Full time

    Job DescriptionCommercial Roofing SpecialistWe are seeking a highly skilled Commercial Roofing Specialist to join our team at Technical Assurance. As a Commercial Roofing Specialist, you will be responsible for designing and managing commercial roofing projects from start to finish.Key Responsibilities:Design and develop commercial roofing plans and...


  • Indianapolis, Indiana, United States Parkview North Hospital Full time

    Job SummaryThe Quality/Accreditation Specialist plays a crucial role in supporting Parkview North Hospital's mission and vision by assisting with the development, implementation, and evaluation of patient safety and quality improvement projects.Key ResponsibilitiesAssist in researching and analyzing quality improvement projects to identify areas for...

  • IT Support Specialist

    2 weeks ago


    Indianapolis, Indiana, United States JD Finish Line Full time

    Job SummaryWe are seeking a highly skilled IT Support Specialist to join our team at JD Finish Line. As a key member of our IT department, you will be responsible for providing technical support to our stores and corporate employees, ensuring the smooth operation of our technology systems.Key ResponsibilitiesResolve day-to-day IT issues reported to the Tech...


  • Indianapolis, Indiana, United States NebulaTech Full time

    Are you looking for a challenging role that combines business administration and computer science? As a Business Informatics Specialist at NebulaTech, you will act as a liaison between departments and IT, providing solutions for business-related issues using modern information and communication technology.Key Responsibilities:Learn about the exciting fields...


  • Indianapolis, Indiana, United States Roche Holdings Inc. Full time

    Job Title: Technical Support Specialist 2At Roche, we are committed to fostering a culture of diversity, equity, and inclusion. As a Technical Support Specialist 2, you will play a critical role in providing exceptional customer service and technical support to our customers.Job Summary:This is an exciting opportunity to join our team as a Technical Support...


  • Indianapolis, Indiana, United States Emarsys UK Ltd Full time

    Emarsys UK Ltd is a leading SaaS company that empowers e-commerce brands to grow their commercial value through personalized customer engagement. Our predictive intelligence fuels real-time marketing automation, and we're looking for a skilled Technical Support Specialist to join our team. As a Technical Support Specialist, you will be the primary point of...


  • Indianapolis, Indiana, United States ShiftCode Analytics Full time

    Job Title: POS Quality Assurance Specialist Job Summary: We are seeking a highly skilled POS Quality Assurance Specialist to join our team at ShiftCode Analytics. As a POS Quality Assurance Specialist, you will be responsible for ensuring the highest levels of functionality of our retail technology systems, including point of sale, self-serve kiosk, and...


  • Indianapolis, Indiana, United States Thunderbolt Inc Full time

    Key ResponsibilitiesWe are seeking a highly skilled IT Support Specialist to join our team at Thunderbolt Inc. As an IT Support Specialist, you will be responsible for installing and maintaining the IT infrastructure of our clients for our software FEPA.Key responsibilities include:Installing and configuring Windows client and server operating systems,...

  • Housing Specialist

    3 weeks ago


    Indianapolis, Indiana, United States Vaya Health Full time

    Housing Specialist Job DescriptionJob Summary:Vaya Health is seeking a highly motivated and detail-oriented Housing Specialist to join our team. As a Housing Specialist, you will be responsible for administering state and federally funded housing programs and services, managing housing initiatives, and providing expertise and guidance to internal and...


  • Indianapolis, Indiana, United States Global Pharma Tek Full time

    Job Title: Cybersecurity SpecialistJob Summary:Global Pharma Tek is seeking a highly skilled Cybersecurity Specialist to join our team. As a Cybersecurity Specialist, you will be responsible for analyzing code scan output from Veracode and SonarQube, identifying security risks associated with code vulnerabilities, and developing a prioritization strategy to...


  • Indianapolis, Indiana, United States ZSG Full time

    Job SummaryZSG is seeking a highly skilled and experienced Maintenance Specialist to join our team. As a key member of our maintenance team, you will be responsible for ensuring the smooth operation of our production and auxiliary support equipment.Key Responsibilities:Troubleshoot Complex Mechanical Systems: Identify and resolve issues with mechanical...


  • Indianapolis, Indiana, United States Vergence Group Full time

    Job SummaryWe are seeking a highly organized and detail-oriented individual to join our team as a Health Information Management Support Specialist. In this role, you will be responsible for providing critical support to our immunization programs, ensuring the smooth operation of our vaccine distribution systems, and maintaining accurate and up-to-date...


  • Indianapolis, Indiana, United States BioSpace, Inc. Full time

    Job SummaryWe are seeking a highly skilled and detail-oriented Quality Assurance Specialist to join our team. As a Quality Assurance Specialist, you will be responsible for ensuring the quality of our materials and products, maintaining compliance with regulatory requirements, and collaborating with cross-functional teams to drive quality initiatives.Key...