Database Administrator 2 (Informatica Specialist), Digital Technology Solutions

University of Cincinnati • Cincinnati, OH

448d

About The Position

The Database Administrator 2 (Informatica Specialist) at the University of Cincinnati is a new role focused on data integration, requiring expertise in Informatica and Snowflake. The position involves designing and implementing ETL and ELT pipelines, maintaining documentation, and troubleshooting various systems. The ideal candidate will have a strong understanding of the software development life cycle and will oversee system upgrades and integration-related projects.

Requirements

• Bachelor's Degree in Information Technology, Computer Science, or related field.
• Two (2) years of relevant experience in database administration or related field.
• Experience in Informatica and Snowflake is required.
• Experience in Modern Data architecture is a great asset.
• Relational database design and stored procedure development on MS SQL would be a plus.

Nice To Haves

• Experience with software and hardware troubleshooting.
• Understanding of the development life cycle (SDLC).

Responsibilities

• Create, modify or develop moderate to high complexity databases including set-up, file structure, and device allocation.
• Participate in the preparation of moderately complex design specifications and functional documentation for assigned database projects.
• Create moderately complex functions, scripts, stored procedures, and triggers to support application development.
• Participate in basic to moderately complex database design and architecture to support application development projects.
• Participate in the research, design, implementation, and support of systems for stand-alone and high availability environments.
• Participate in the development, maintenance, and utilization of standard operating procedures.
• Assist in the development of policies and procedures to access or interact with remote resources; assist in data transfers or sharing of files.
• Review checklists for continued ways to improve procedures to save time and money.
• Participate in the creation and maintenance of moderately complex ETL/ELT solutions and integration of systems as they relate to databases.
• Monitor database performance, usage, and data integrity.
• Coordinate database upgrades and patch maintenance.
• Participate in the performance, reliability, tuning, and sizing of databases.
• Follow established standards to help maintain the security of the system and for testing new software releases.
• Ethically handle export control of restricted and controlled data.
• Troubleshoot and resolve any related hardware, software, user access, or other issues.
• Participate in tasks for business continuity and disaster recovery.
• Analyze and resolve security and access problems related to the overall system and database.
• Participate in the oversight of vendor database support.
• Assist with database updates and integration of changes through the database environments.
• Participate in the development and maintenance of moderately complex reports and visualizations.
• Work with the user community to understand data access and integration needs.
• Participate in peer knowledge sharing groups.
• Perform related duties based on departmental need.

Benefits

• Competitive salary range dependent on the candidate's experience.
• Comprehensive insurance plans including medical, dental, vision, and prescription coverage.
• Flexible spending accounts and an award-winning employee wellness program, plus an employee assistance program.
• Financial security via life and long-term disability insurance, accident and illness insurance, and retirement savings plans.
• Generous paid time off options including vacation, sick leave, annual holidays, and winter season days in addition to paid parental leave.
• Tuition remission available for employees and their eligible dependents.
• Discounts for on and off-campus activities and services.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Educational Services
• Education Level: Bachelor's degree
• Number of Employees: 10,001+ employees