Sr. Data Architect, Digital Technology Solutions

Current UC employees must apply internally via SuccessFactors > http://bit.ly/UCEMPL

 

Founded in 1819, the University of Cincinnati ranks among the nation’s best urban public research universities. Home to more than 50,000 students, 11,000 faculty and staff and 340,000 alumni, UC combines a Top 35 public 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, nine straight years of record enrollment, worldwide leadership in cooperative education, a dynamic academic health center and entry into the Big 12 Conference, UC’s momentum has never been stronger. UC’s annual budget tops $1.65 billion and its endowment totals $1.8 billion. The University’s overall regional economic impact exceeds $10.6 billion, paving the way for the future of Cincinnati.

Job Overview

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.

Essential Functions

• Structure and implement moderately to highly complex 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. Conduct file maintenance. Set-up and monitor tables, indexes, views, triggers, table spaces, etc.
• 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. 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.
• May 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.
• Serves as an expert resource to others; serve on committees and projects.
• Perform related duties based on departmental need. This job description can be changed at any time.

Required Education

• Bachelor's Degree in Computer Science, Information Technology, Computer Engineering, or related field.
• Eight (8) years of relevant work experience and/or other specialized training can be used in lieu of education requirement.

Required Experience

Four (4) years of relevant experience.

Additional Qualifications Considered

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• 7+ years of experience in data architecture, data management, or a related role.
• Proficiency