Information Technology Spec 3 - Data Base Administrator / Integration Specialist - Minnesota Careers : Job Details

Job Details Working Title: Information Technology Spec 3 - Data Base Administrator / Integration Specialist Job Class: Information Technology Specialist 3 Agency: Minnesota State

• Job ID: 82134
• Location: Bemidji
• Telework Eligible: No
• Full/Part Time: Full-Time
• Regular/Temporary: Unlimited
• Who May Apply: Open to all qualified job seekers
• Date Posted: 12/02/2024
• Closing Date: 01/07/2025
• Hiring Agency/Seniority Unit: MN St Colleges & Universities / Bemidji State University-MAPE
• Division/Unit: MnSCU Bemidji SU / MnSCU BSU Class M&E Payroll
• Appointment Type: Unlimited, Full-time
• Work Shift/Work Hours: 8a.m. - 4:30 p.m.
• Days of Work: Monday - Friday
• Travel Required: No
• Salary Range: $32.89 - $54.06 / hourly; $68,674 - $112,877 / annually
• Job Class Option: Application
• Classified Status: Classified
• Bargaining Unit/Union: 214 - MN Assoc of Professional Empl/MAPE
• FLSA Status: Nonexempt
• Designated in Connect 700 Program for Applicants with Disabilities : Yes

The work you'll do is more than just a job. At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities. Job Summary Bemidji State University (BSU) and Northwest Technical College (NTC) invite applicants to join our Information Technology Services (ITS) team as a Data Base Administrator/Integration Specialist. The Data Base Administrator/Integration Specialist provides technical expertise in the analysis, design, development, testing, implementation, and maintenance of applications and database systems in support of the academic and administrative information technology requirements for Bemidji State University (BSU) and Northwest Technical College (NTC). Additionally, the position provides online, real-time and ad-hoc data reporting using university and Minnesota State Colleges and Universities (Minnesota State) relational databases. Responsibilities of the Data Base Administrator / Integration Specialist Include:

• Administering database systems utilizing industry standards for the analysis, design, testing, implementation, and maintenance while integrating database system tools and applications to optimize security, effectiveness, and efficiency. Overseeing the integration of Minnesota State operational data with other BSU and NTC database systems. Monitoring current and plan for future resource requirements to ensure database systems can handle expected workload and growth. Providing input to the development of guidelines, policies, and procedures for data management and adhere to Minnesota State security guidelines. Participating in the development of Disaster Recovery and Business Continuity Plans as it pertains to database and application recovery. Participating in data governance initiatives. Ensuring that databases are tuned for optimization, provide data integrity, are backed up, maintained, and secure. Inclusion in the user provisioning and de-provisioning process are part of expected outcomes.
• Developing and maintaining system and software integrations and components, including but not limited to; application to application integrations, services, internal and external APIs, file transfers, and EDI and SQL queries. Collaborating with appropriate instructional and technical staff to support, manage, and optimize the use of software to support quality teaching and learning. Working with end users to understand data requirements. Providing comprehensive solutions that meet the requirements of end users. Ensuring seamless communication and data exchange. Ensuring different systems work together and that new software programs are compatible with existing software. Developing and maintaining system and software integrations and components, encompassing various functionalities such as application-to-application integrations, services, both internal and external APIs, file transfers, and handling of EDI and SQL queries. Collaborating closely with instructional and technical personnel to effectively support, manage, and enhance software utilization in facilitating high-quality teaching and learning experiences. Engaging with end users to ascertain their data requirements and deliver comprehensive solutions that fulfill their needs. Ensuring smooth communication and data exchange across different systems, guaranteeing compatibility between new software programs and existing ones.
• Developing applications in support of academic and administrative business requirements to include all phases of application development: analysis, design, testing, implementation, maintenance, documentation, and training. Conducting analysis of business processes to ensure the integration of multiple programming languages, tools, databases, operating systems, and platforms are in alignment with the requirements of the various business and academic units. Provisioning and de-provisioning of data access levels for information security integrity will be provided to ensure the stability of mission critical applications for BSU, NTC and Minnesota State. Ensuring that expected outcomes include applications developed to meet design and functionality requirements and align with business objectives. Outcomes also include maintaining applications for a secure, robust, and stable computing environment.
• Providing programming to extract, store, manage, and report data from the Minnesota State ERP and databases in an appropriate format. Working with business analysts to derive functional requirements broken down into appropriate table sources, schemas, relationships, application design, and data presentation format. Developing and implementing applications and query sets for self-service and web-based delivery. Creating and organizing documentation for future development, historical information, contingency and life-cycle planning. Ensuring that applications and query sets meet the specified requirements, data is presented in a useful and easy-to-understand format. Expected outcomes include providing a secure environment, ensuring data integrity, data efficiency and life-cycle planning.
• Professional development and continuous improvement will be obtained by attending conferences or participating in web-based training. Professional development and continuous improvement will also include obtaining knowledge of current technology trends by reviewing trade publications, software and hardware documentation, and participation in professional IT organizations through personal attendance, e-mails, and newsletters.
• Performing other duties as assigned to ensure the continuity of operations of the Information Technology Services department for BSU and NTC.

Minimum qualifications for this position include:

• Experience in professional database administration, software integration or application development.
• Experience and knowledge of relational database design and creation which includes table design and creation, joining logic, developing stored procedures, and database optimization using one of the following database engines: Oracle, MSSQL Server, or MySQL
• Experience in application development that integrates multiple programming languages, data sources, operating systems, and platforms into single solution systems.
• Experience programming to extract, store, manage, and report data.
• Demonstrated written and verbal communication skills sufficient to write technical documentation in a concise manner and convey technical information using non-technical language.

Preferred qualifications include:

• Bachelor's degree in computer science, computer information systems, or related degree.
• Two (2) years of professional database administration, software integration or application development experience.
• Experience and knowledge with Minnesota State databases.
• Experience and knowledge with MSSQL Server, MySQL, Visual Studio, .Net, XML, and Microsoft Access
• Demonstrated interpersonal and analytical skills to work closely and effectively with customers in the design, development, and ongoing support of application and reporting systems to support the business needs of the institution.
• Demonstrated skills with critical and strategic thinking, planning, project management, and problem-solving.
• Ability to establish priorities on multiple projects to meet deadlines while paying attention to details.
• Ability to lead and work as part of a team, as well as independently toward assigned goals.
• A demonstrated commitment to the principles of diversity, equity, inclusion, and anti-racism.

Application Details How to Apply To view the full job posting and to apply please go to: . Contact If you have questions about this position, contact Mary Miller at [email protected] or 218-###-#### . To receive consideration as a Connect 700 Program applicant, apply online, email the Job ID#, the Working Title and your valid Proof of Eligibility Certificate by the closing date to Mary Miller at [email protected] . About Minnesota State Minnesota State is making a difference. From the students we serve, to our business partners, to those we employ, chances are good you or someone you know has benefited from the work of your state colleges and universities. It is the core value of the Minnesota State Colleges and Universities to provide an opportunity for all Minnesotans to create a better future for themselves, for their families, and for their communities. Working together to improve the state we love. What do Minnesota's State employees have in common?

• A sense of purpose in their work
• Connection with their coworkers and communities
• Opportunities for personal and professional growth

Benefits As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well. Your benefits may include:

• Paid vacation and sick leave
• 12 paid holidays each year
• Low-cost medical, dental, vision, and prescription drug plans
  • Fertility care, including IVF
  • Diabetes care
  • Dental and orthodontic care for adults and children
• 6 weeks paid leave for parents of newborn or newly adopted children
• Pension plan that provides income when you retire (after working at least three years)
• Employer paid life insurance to provide support for your family in the event of death
• Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury
• Tax-free expense accounts for health, dental, and dependent care
• Resources that provide support and promote physical, emotional, social, and financial well-being

Support to help you reach your career goals:

• Training, classes, and professional development
• Tuition reimbursement
• Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov )

Employee Assistance Program (EAP) for work/life support:

• A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance
• Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
• Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care

Programs, resources and benefits eligibility varies based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota. Other Information Employment information for this position can be found in its collective bargaining agreement or its plan document at . AN EQUAL OPPORTUNITY EMPLOYER Minnesota State is an equal opportunity employer/educator committed to the principles of diversity. We prohibit discrimination against qualified individuals based on their race, sex, color, creed, religion, age, national origin, disability, protected veteran status, marital status, status with regard to public assistance, sexual orientation, gender identity, gender expression, or membership in a local commission as defined by law. As an affirmative action employer, we actively seek and encourage applications from women, minorities, persons with disabilities, and individuals with protected veteran status.