Founded in 1819, **MEMBERS ONLY**SIGN UP NOW*** 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.
JOB OVERVIEW 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.
ESSENTIAL FUNCTIONS *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. MINIMUM REQUIREMENTS *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.
**MEMBERS ONLY**SIGN UP NOW***, 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.
**MEMBERS ONLY**SIGN UP NOW*** IS AN AFFIRMATIVE ACTION / EQUAL OPPORTUNITY EMPLOYER / MINORITY / FEMALE / DISABILITY / VETERAN.
