Millikin University
no content
Senior Database Administrator

RJ Podeschi

Responsibilities

  • Provide daily support for modules of the administrative system(s)
  • Consult with departmental data owners regularly to ensure data consistency and integrity
  • Ensure reports and data requests are accurate and produced in a timely manner
  • Provide education, training, and awareness on the core functions and capabilities of the administrative system
  • Communicate regularly with internal technical, applications and operational staff, particularly as a liaison between the Database Administrator(s) and the application systems development team(s), as appropriate, in order to ensure the database integrity, security, and availability
  • Assist development staff for applications, procedure, and web system design
  • Prepare project plans and schedule for significant system-related implementation support and efforts
  • Maintain revision control for database, forms, reports and script versions
  • Maintain standards for project development and work processes
  • Maintain system database(s)
  • Perform tuning of the relational database management system(s) and related application database(s) using tuning tools and scripts
  • Design, implement, and maintain security access infrastructure
  • Design, implement, and maintain data and database related standards, procedures, and guidelines
  • Assist in monitoring the direction and growth of the organization to ensure the application of appropriate database technologies and support resources
  • Perform capacity planning evaluations
  • Perform both logical database design in response to requirements for information
  • Perform physical database design in response to requirements for information
  • Replicate databases
  • Perform day-to-day database administration
  • Maintain database backup and recovery procedures
  • Perform system tuning to ensure optimal performance and database efficiency
  • Install new system releases, upgrades, and patches
  • Design logical and physical data structures
  • Perform logical database design in response to requirements for information
  • Perform physical database design in response to requirements for information
  • Design, develop, and implement reporting tools for end-users at all levels (operational, tactical, and strategic) based on requirements for information
  • Identify and resolve data related issues
  • Design, develop, and implement data processing applications in response to requirements for information
  • Design, develop, and implement database integration processes between the administrative system and external databases

Education

    Millikin University, Decatur, Illinois 9/98 – 5/04
    G.P.A. 3.7/4.0
    Bachelor of Science in Management Information Systems 5/02
    Honors:
    James Millikin Scholar (Honors Program)
    Alpha Lambda Delta, All-American Scholar, Dean’s List
    Masters, Business Administration 5/04

Technical Skills

  • Technically knowledgeable in all areas of SCT Banner 5.x

  • Skilled with Oracle 8i and 9i DBA Functions, Oracle Application Server 9i, and Oracle Reports 9i

  • Competent in SQL, PL/SQL and Oracle Web Services

  • Configure and manage all Microsoft operating systems including UNIX

  • Adept in Visual Basic, Active Server Pages, Macromedia Dreamweaver MX

Additional Training

  • Oracle 9i Database Administration, Fundamentals I
  • Oracle 9i Database Performance Tuning
  • Oracle Database 10G: New Features for Administrators

Previous Professional Experience

    Database Administrator/Developer
    Information Technology, Millikin University, Decatur, Illinois 8/01 - Present

  • Support the technical functions of the SCT Banner software product for the finance, payroll, and human resources modules in addition to online extranet services

  • Install, configure, and manage Oracle 8i/9i RDBMS for the campus administrative system(s)

  • Implement integrative technologies using Oracle Reports 9i and Oracle 9iAS Web Application Server

  • Provide administration for related services such as security control systems and telephone call recording
  • Partner
    Braden, Killey & Podeschi: IT Consultants, Decatur, Illinois 11/01 – Present

  • Provide web presence solutions for area businesses

  • Integrate marketing strategies with web presence

  • Provide scalable network solutions for small area businesses
  • Summer Provost Undergraduate Research Fellow
    Millikin University, Decatur, Illinois 5/01 – 8/01

  • Researched the concept of an online plan of study for students and faculty to support academic advising and student success

  • Presented prototypes and research findings to Millikin Board of Trustees

  • Facilitated a summer class that focused on current information technology issues
  • Desktop Support Analyst, Level II - Internship
    Consolidated Communications, Mattoon, Illinois 5/00 – 12/00

  • Focused on troubleshooting end-user problems (network, software, hardware)

  • Developed a new-hire manual for IT department and web-enabled

  • Configured desktop PC’s using Norton Ghost

Extracurricular Activities

  • Trustee Chairman, Sharon United Methodist Church – 2004 - present

  • Delta Sigma Phi Social Fraternity – President 2001, Strategic Planning Committee 2002

  • Alpha Kappa Psi Professional Business Fraternity – President 2000

  • Millikin Student Government – VP of Finance 2001

  • Student Orientation Leader – 1999-2002

  • Tabor Faculty Search Committee, Director of Admissions Search Committee, VP of Finance and Business Affairs Search Committee
Disclaimer|Privacy Statement |Contact Millikin