Database Administrator II - Computing and Technology Services

Database Administrator II - Computing and Technology Services Salary: Commensurate with experience Benefits: Generousbenefits include paid time off including holidays and vacation, retirementmatch, and tuition remission for employee and dependents. Details at www.duq.edu/benefits Location: CTS Position Status: Full-time (Hybrid after the first six months.) Hours: Varied Position Number: 435724/10-955 FLSA Status: Exempt POSITIONSUMMARY: The DatabaseAdministrator II is responsible for supporting the mission critical production,test, and development applications used for campus administration. The DatabaseAdministrator II (DBA II) is responsible for several aspects of Oracle databasemanagement for central computing at Duquesne University. Responsibilities include softwareinstallation, patch maintenance, user account management, backup and recoverysupport, monitoring system performance, troubleshooting, assisting Bannerfunctional users, and basic Oracle administration duties. Responsibilities also include administrationof the University reporting environment which includes Oracle products and theCognos and Ellucian Banner suite of business intelligence products. Duties are performed on a varietyof operating systems with a primary focus on Sun Solaris and Windows. The DBA II may be required to work eveningsand weekends to ensure proper administration. The position may be hybrid after the first six months. DUTIESAND RESPONSIBILITIES: Conducts advanced Oracle Database Administration tasks, including database creation and maintenance, tuning, capacity planning, backup and recovery, program migrations, and security implementation/enforcement/audit. Provides technical leadership and guidance to less senior database administrators. Architects high availability systems and implements, documents, and tests Disaster Recovery solutions. Installs, maintains, and integrates Middle Tier technologies including Weblogic and Tomcat. Coordinates with the Project and Portfolio Management Office (PPMO) to onduct project management duties such as research, scoping, resource planning, and risk analysis. Mentors team members, develops documetation and technical guidelines and diagrams. Researches emerging technologies and trends in the Oracle Database and applications market and develops proposals on how these trends impact the Duquesne environment. Works with Duquesne module leaders to plan and implement Ellucian patches and upgrades. Works with vendors to diagnose integration, functionality, and performance issues. Monitors and manages Footprints tickets. Provides Banner application and functional support, maintains support tickets with Ellucian / Oracle / third party vendors. Completes otherduties as assigned. REQUIREMENTS: Minimum qualifications: Bachelor's Degreein Computer Science, IT or a related field from an accredited institution. 5-8 years of relevant experience. Preferred Qualifications: Master's degree in a related field from an accredited institution. Alternately, thesuccessful candidate may possess any equivalent combination of experience andtraining, which provides the knowledge, skills and abilities required toperform the essential job functions. This includes, but is not limited to, thefollowing: Database Administration in Oracle or SQL Server, or Oracle-based ERP Administration Monitoring backup jobs and implementation of backup strategies. Development and implementation of upgrade methodologies. Project management duties - research, scope definition, resource and time estimation, risk analysis. Installation, configuration, upgrades, patches of Oracle databases and Banner applications Experiencedin installing, configuring, and maintaining application server technology suchas Oracle WebLogic, Fusion Middleware, and Apache Tomcat. Ability toexecute fundamental database administration tasks to support the campus ERP andrelated technologies. Ability totroubleshoot and support the campus ERP application with strong analyticalsense. Advanced SQL skills and experience migrating database objects. Advanced Shell Scripting Displays advanced understanding of application server hardware and software architecture. Ability to conduct independent research into technical subjects and present findings or recommendations. Ability to make and defend decisions in ambiguous technical environments. Strong analytical and organizational skills, attention to detail, in addition to outstanding written and verbal communication, technical writing skills, and presentation skills required. Ability to initiate and follow through with work responsibilities and to meet deadlines. Ability and willingness to learn new technologies and skillsets. Ability to correlate fixes available in patches with identified functional and technical issues. Work with Duquesne module leaders as needed to plan for upgrades and patches. Ability to execute complex database administration tasks to support the campus ERP and related technologies. Ability to troubleshoot and support the campus ERP application with strong analytical sense. Install, maintain, and integrate database and application components. Advanced level of applied knowledge of database structures, theories, principles, practices, and processes. Commitment to the University's values of diversity, equity and inclusion, andrecognition of the importance of treating each individual with dignity andrespect consistent with the University's Mission. Demonstrated experience with, and understandingof, the broad diversity of the University community (students, faculty, staffand others). Ability to establish and maintain effective working relationships with theUniversity Community. Ability and willingness to contribute actively to the mission of the Universityand to respect the Spiritan Catholic identity of Duquesne University. Themission is implemented through a commitment to academic excellence, a spirit ofservice, moral and spiritual values, sensitivity to world concerns, and anecumenical campus community. APPLICATION INSTRUCTIONS: Applicants are asked to submit a cover letter, resume, and contact informationfor three professional references. Catholic in its mission and ecumenical in spirit, Duquesne University valuesequality of opportunity as an educational institution and as an employer. Weaspire to attract and sustain a diverse faculty and staff that reflectscontemporary society, serves our academic goals and enriches our campuscommunity. We particularly encourage applications from members ofunderrepresented groups and support dual-career couples through our chartermembership in thisregion's HERC (http://www.hercjobs.org/oh-western-pa-wv/). We invite applicants for this position to learn more about our university andits Spiritan heritage by visiting http://www.duq.edu/about/mission-and-identity/mission-statement.Those invited to campus for an interview may be asked about ways in which theysee their talents contributing to the continued growth of our community andfurthering its mission. Duquesne University was founded in 1878 by its sponsoring religious community,the Congregation of the Holy Spirit. Duquesne University is Catholic inmission and ecumenical in spirit. Motivated by its Catholic identity,Duquesne values equality of opportunity both as an educational institution andas an employer.