Founded in 1819, the University of Cincinnati puts education into action, ranking among the nation's best urban public research universities. Home to more than 47,000 students, 10,500 faculty and staff and 330,000 alumni, UC combines a Top 35 research university with a physical setting The New York Times calls "the most ambitious campus design program in the country."
With the launch of Next Lives Here, the Cincinnati Innovation District, a $100 million JobsOhio investment, worldwide leadership in cooperative education, a dynamic academic health center and entry into the Big 12 athletic conference, UC's momentum has never been stronger. UC's annual budget tops $1.6 billion and its endowment totals $1.8 billion.
At UC, today's possibilities spark tomorrow's reality.
Under general supervision from a designated administrator, responsible for integrating systems, creating, modifying or developing databases to include set-up and monitor tables, indexes, views, triggers, table spaces, fragmentation issues, monitoring processes, referential integrity, security, performance tuning and sizing.
This position will primarily involve database development for the software development team as part of an Agile scrum team. The ideal candidate with have relational database design/architecture and store procedure development experience on Microsoft SQL Server or similar database server. A background with Oracle to be cross functional would be a plus.
Structure and implement (moderate to complicated) databases to optimize data access and security; design database systems and programs which include access methods, access time, file structure, device allocation, validation checks, and statistical methods.
Work with user community to understand data access and integration needs; support client/server database access tools; provide consultation to programmers on relational database design.
Ensure the integration of systems through the database structure; ensure data and its sources are accurate and easily accessible to the user community; develop assigned databases to support specific applications; conducts file maintenance, set-up and monitor tables, indexes, views, triggers, table spaces, fragmentation issues, monitoring processes, referential integrity, security, performance tuning and sizing.
Monitor database standards and procedures, systems usage and performance; troubleshoot and resolve database problems; conduct virus avoidance procedures; oversee vendor software fault resolution; develop benchmarks for testing new software releases; completes database upgrades and patch maintenance.
Monitor, analyze, and verify data to ensure data integrity; run checks on data integrity; maintain data security and integrity by developing system access standards and procedures.
Maintain the database archives by acquiring and installing data sets and documentation; design data storage capacity to provide for efficient and timely response and operating time; calculate data storage media and cost alternatives; specify sources and methods of data storage; manage database organization and data storage; plan for efficient allocation of system storage capacity; develop system backup and archival methodology; develop and administer disaster recovery plans.
Assist in data transfers or sharing of files; assist in development of policies and procedures to access or interact with remote resources.
Position may also develop specifications and requirements for the optimal integration of systems which may include applications, databases, networks, and related systems.
Install, structure, tune, and maintain database management systems and software on mainframe and/or mini-computers.
Serve as a seasoned & proficient professional.
Bachelor's degree in Computer Science, Information Technology, Computer Engineering, or related degree with two (2) years' experience; -OR- an Associate's degree with four (4) years' experience ; or six (6) years of intermediate level related.
Possesses a thorough understanding of commonly-used concepts, practices, and procedures and contributes through experience, collaboration and problem resolution.
Compensation and Benefits
UC offers a wide array of complementary and affordable benefit options, to meet the financial, educational, health, and wellness needs of you and your family. Eligibility varies by position and FTE.
Competitive salary range of $65,000 - $70,000 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 our life and long-term disability insurance, accident and illness insurance, and retirement savings plans.
Generous paid time off work options including vacation, sick leave, annual holidays, and winter season days in addition to paid parental leave.
Tuition remission is available for employees and their eligible dependents.
Enjoy discounts for on and off-campus activities and services.
The University of Cincinnati, as a multi-national and culturally diverse university, is committed to providing an inclusive, equitable and diverse place of learning and employment. As part of a complete job application you will be asked to include a Contribution to Diversity and Inclusion statement.
The University of Cincinnati is an Affirmative Action / Equal Opportunity Employer / Minority / Female / Disability / Veteran.
HISTORY IN BRIEF - The University of Cincinnati is a public urban serving research institution that was founded in 1819 and today is one of the country’s largest universities offering more than 350 academic programs to more than 44,000 students. UC has many top ranked programs in areas such as Music and Arts, Medical and Human-Services, Criminal Justice and more. Located in an urban setting, UC is close to the heart of Cincinnati and allows easy access for students to enjoy all that the city offers. UC is also the alma mater of many notables such as President William Howard Taft; Albert Sabin, developer of the oral polio vaccine; Astronaut Neil Armstrong and Mary Weinberg, 2008 Olympic gold medalist. UC is classified as a Research University (Very High Research Activity) by the Carnegie Commission and is ranked as one of America’s top 35 public research universities by the National Science Foundation. UC jumped 17 spots in the U.S. News & World Report rankings in the past two years alone. In addition to being named a “green university” by Princeton Review, UC has been named one of the world’s most beautiful campuses by Forbes and Delta Sky magazines. Learn more at www.uc.edu.MISSIO...N STATEMENT - The University of Cincinnati serves the people of Ohio, the nation, and the world as a premier, public, urban research university dedicated to undergraduate, graduate, and professional education, experience-based learning, and research. We are committed to excellence and diversity in our students, faculty, staff, and all of our activities. We provide an inclusive environment where innovation and freedom of intellectual inquiry flourish. Through scholarship, service, partnerships, and leadership, we create opportunity, develop educated and engaged citizens, enhance the economy and enrich our University, city, state and global community.