Database Administrator 2, Digital Technology Solutions
University of Cincinnati
Cincinnati, OH
Full-time
Information Services / Technology (IT)
Posted on May 1, 2024
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
Database Administrators participate in the Installation, structure, tuning, backup and maintenance of database management systems and software on physical and virtual servers. This may include the support for an ERP solution (s). Database administrators design, develop, test, and implement, ETL/ELT solutions in addition to developing complex queries to mine data from the Enterprise Data Warehouse and the Big Data Platform. Database administrators are also responsible for maintaining the on-going reliability, performance, management, and support of database server environments supporting education, research, administration, medical, and other activities. This DBA position will entail both administration and development. It will support a cross-functional team that supports custom development, vendor supported apps and data warehousing.
Essential Functions
Two (2) years of relevant experience.
Physical Requirements/Work Environment
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.
To learn more about why UC is a great place to work, please visit our careers page at https://www.uc.edu/careers.html.
For questions about the UC recruiting process or to request accommodations with the application, please contact Human Resources at jobs@uc.edu.
The University of Cincinnati is an Equal Opportunity Employer.
REQ:95950
SF:OMJ SF:RM SF:HEJ, SF:INS SF:HERC SF:DIV SF:LJN SF:IHE
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
Database Administrators participate in the Installation, structure, tuning, backup and maintenance of database management systems and software on physical and virtual servers. This may include the support for an ERP solution (s). Database administrators design, develop, test, and implement, ETL/ELT solutions in addition to developing complex queries to mine data from the Enterprise Data Warehouse and the Big Data Platform. Database administrators are also responsible for maintaining the on-going reliability, performance, management, and support of database server environments supporting education, research, administration, medical, and other activities. This DBA position will entail both administration and development. It will support a cross-functional team that supports custom development, vendor supported apps and data warehousing.
Essential Functions
- Advanced level experience and possesses broad and deep knowledge of own area and related areas and contributes through advanced knowledge, skill and experience
- Function as the subject matter expert on one or multiple systems
- Participates in code and system level reviews of the work of other database administrators
- Create highly complex functions, scripts, stored procedures and triggers to support application development
- Participate in moderately to highly complex database design and architecture to support application development projects
- Participate in the preparation of moderate to highly complex design specifications and functional documentations for assigned database projects
- Participate in the research, design, implementation and support of systems for stand-alone and high availability environments
- Coordinate the development, maintenance and utilization of standard operating procedures
- Coordinate the creation and maintenance of moderate to highly complex ETL/ELT solutions and integration of systems as they relate to databases
- Participate and coordinate the performance, reliability, tuning and sizing of databases
- Monitors database performance, usage and data integrity
- Participate the creation, implementation and maintenance of established standards to help maintain the security of the system at the direction of the Office of Information Security and senior level database administrators
- Ethically handling export control, restricted, and controlled data
- Coordinate database upgrades and patch maintenance
- Troubleshoots and resolves any related hardware, software, user access or other problems
- Analyze and resolve security and access problems related the overall system and database
- Participate in the oversight vendor database support; assist with database updates and integration of changes through the database environments
- Participate in the development and maintenance of highly complex reports and visualizations
- Help to create and follow established standards for testing new software releases.
- Work with user community to understand data access and integration needs
- Supports integration of changes in test, preproduction, and production environments
- Collaborate with various teams for database configurations, support and integrations
- Assist in development of policies and procedures to access or interact with remote resources; assist in data transfers or sharing of files.
- Participates in peer knowledge sharing groups
- May participate as part of a scrum team focused on database related delivery initiatives
- Participate in tasks for business continuity and disaster recovery
- Maintains history reports, identifies and addresses reoccurring problems
- Responds to escalated system problems
- Researches and evaluates emerging technologies
- Coordinate plans for business continuity and disaster recovery
- Review checklists for continued ways to improve procedures to save time and money
- Bachelor's Degree in Information Technology, Computer Science, or related field.
- Six (6)years of relevant work experience and/or other specialized training can be used in lieu of education requirement.
Two (2) years of relevant experience.
Physical Requirements/Work Environment
- Office environment/no specific unusual physical or environmental demands.
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 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.
To learn more about why UC is a great place to work, please visit our careers page at https://www.uc.edu/careers.html.
For questions about the UC recruiting process or to request accommodations with the application, please contact Human Resources at jobs@uc.edu.
The University of Cincinnati is an Equal Opportunity Employer.
REQ:95950
SF:OMJ SF:RM SF:HEJ, SF:INS SF:HERC SF:DIV SF:LJN SF:IHE
Your Privacy Choices