- ERP Systems
Maintain the institutions Ellucian Colleague ERP system by providing best practice preventive maintenance and management. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes code for database access, modifications, constructions, and backups. Relies on knowledge and professional discretion to achieve goals. Supports the design, development, and modification of custom applications and programs that support the client business services and processes. Works on identified projects and assignments, reports to a site director, utilizes professional judgment and ingenuity.
Supports all client SQL databases related to Ellucian applications: Colleague, portal, self-service, data extracts, patches and upgrades, and CRM based products.
Bachelor's Degree in computer science or related field is preferable (equivalent combination of experience, education, and training will be considered)
Ten (10) years of DBA experience.
Minimum five (5) years' experience in higher education.
5+ years of relevant database administration experience with SQL Server databases (2008, 2012, or newer)
Industry certifications such as MCSE, MCDBA, MCSA, or others
Experience with ERP software, Extract Transform Load - ETL, and data integrations
Experience maintaining SharePoint environments (security, databases, sites)
Experience with database design, T-SQL, maintenance, and performance tuning
Demonstrated experience with other SQL server packages (SSIS, SSRS)
Experience with data modeling concepts (Relational and dimensional
MS SQL Server 2008/2012/2016 Database Systems
Database and application development methodologies
Experience with patching and upgrading all components of Colleague across all instances
Query reporting tools including SQL, or similar reporting tools
Knowledge of and experience with large ERP databases
Experience resolving functional and technical issues related to an ERP system.
The highest level of personal and professional integrity.
Ability to exercise a high degree of accurate and independent professional judgment.
Ability to manage multiple tasks, meet deadlines, and be both flexible and adaptable in a rapidly changing environment
Strong analytical and organizational skills and strong critical thinking and problem solving skills with the ability to make independent decisions.
An ability to work effectively with cross-functional teams
An ability to work effectively with end-users and understand their technical and operational needs and translate them into viable technical solutions.
Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures and governmental regulations.
The successful candidate must be able to write reports, business correspondence, and procedure manuals and to effectively present information in one-on-one and small groups.
Essential Duties and Responsibilities
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Creating indexes and maintaining them
Finding and resolving DB integrity issues
Sizing new and replacement database servers
Install new databases, perform upgrades, and patch databases as needed.
Share domain and technical expertise, providing technical mentorship and cross training to other peers and team members.
Maintain familiarity with new technology standards and how each may be applied to the future growth and development of the services provided by the Ellucian Colleague database system.
Participate in project design and project planning processes as needed.
Develop and support backup and recovery procedures.
Maintain, and update issue/solution documentation in a project tracking system.