Responsibilities

• Performs highly complex data management functions at an enterprise level; installs, integrates, upgrades and manages PeopleSoft database environments and structures; monitors and evaluates PeopleSoft database environments to optimize performance; plans, organizes, tests and executes migration of databases from development and test to production environments; installs and tests new releases, bundles and fixes; ensures data security protocols are maintained and backup/recovery processes are completed as scheduled
• Performs PeopleSoft database administration functions for enterprise databases, including setting up and running database management utilities to backup, reorganize and restore databases and resolve production and operational problems; monitors utilization and manages available database resources
• Administers PeopleSoft enterprise database security processes and procedures; develops, recommends and implements security permissions, privileges, standards and guidelines
• Installs, configures and integrates PeopleSoft application software over data management systems and supporting components and services; installs, upgrades and implements application fixes and patches; administers enterprise application software to ensure security and performance optimization
• Works in coordination and collaboration with other information technology (IT) staff at the colleges and district office, as needed
• Performs highly complex systems management functions at an enterprise level; installs, configures, integrates, tests, maintains and administers enterprise operating system software, including system monitoring and management software, for production, development and supplemental servers running enterprise applications and supporting components; installs and monitors system level security structures and protocols; ensures disaster response and recovery processes are followed
• Provides advanced technical support to PeopleSoft and web team developers and users including advice and guidance on complex processes and system interdependencies; troubleshoots operational and systems issues ranging from difficult to highly complex, including problems with multiple solutions and potential significant consequences; works with other IT staff to develop and implement or recommend the implementation of appropriate solutions to complex problems
• Oversees, reviews and responds to developers on PeopleSoft application customization and security requests, ensuring that development standards are followed, application changes are documented, change control procedures are strictly enforced and change projects are migrated across applications environments in an orderly manner.
• Collaborates with other IT staff to develop and implement technology standards, policies and procedures
• Develops and maintains schematics and other documentation of PeopleSoft database and systems architectures and administration processes
• Keeps abreast of advancements and emerging trends in data management and storage systems, networking and multi-platform communication technologies; consults with vendors and other sources on industry and product direction, functionality and capabilities

Required

• Completion of a bachelor’s degree from an accredited college or university in computer information systems or a related field and four years of related experience; or any combination of education and relevant work experience that would provide the knowledge, skills and abilities for this position

Knowledge of:

• Principles, practices and techniques of information systems management, including applications design, hardware and software options for administrative, business and academic functions and the cost-benefit of systems alternatives.
• Relational database theory, design rules and development practices
• Data storage, warehousing and mining principles, methods and technology solutions
• Database management systems and software, including architectures, diagnostic tools, commands and utilities
• Tools and utilities used in monitoring and tuning database, applications and systems performance
• Operating system architectures, characteristics, components and commands applicable to enterprise information systems and platform operating systems
• Network architectures and theory and principles of network design and integration, including topologies and protocols
• Principles, practices and methods of systems/network administration and maintenance, including configuration, performance tuning and diagnostic tools
• Systems integration design concepts as they apply to areas of responsibility
• Principles and practices of sound business communication
• Principles, practices and methods of project management as they apply to information technology projects