Database Administrator I

Live Chat

more

• Home
• Degrees
• Colleges and Schools
• View all degrees
• College of Arts and Sciences
• College of Nursing and Allied Health
• Mark Skousen School of Business
• College of Engineering and Computer Science
• Associate Degrees
• Business Administration
• Business Management
• Computer Science
• Criminal Justice
• Engineering Management Technology
• Electronics and Computer Technology
• General Studies
• Medical Coding and Billing
• Multidisciplinary Studies
• Bachelor Degrees
• Accounting
• Business Administration
• Business Management
• Computer Engineering Technology
• Computer Science
• Criminal Justice
• Electronics Engineering Technology
• Engineering Management Technology
• General Studies
• Health Systems Management
• Human Resource Management
• Information Systems
• Information Systems Security
• Multidisciplinary Studies
• RN to BSN Degree Completion Program
• Master Degrees
• Business Administration (MBA)
• Business Intelligence
• Case Management (MSN)
• Healthcare Administration (MHA)
• Health Systems Management
• Information Management (MBA)
• Information Management - Project Management
• Information Management Technology
• Information Technology
• Nursing Education (MSN)
• Nursing Informatics (MSN)
• Nursing Mgmt and Organizational Leadership (MSN)
• Performance Improvement
• Project Management (MBA)
• Tuition & Financial Aid
• Tuition Rates
• Financial Aid
• Military Programs
• Scholarships and Other Programs
• Student Consumer Information
• Admissions
• Admission Requirements
• Admissions Process
• Technical Requirements
• Transfer Credit Policy
• Degree Program Changes
• Online Application
• Resources
• Career Services
• About Us
• Mission, Values and Vision
• University Administration
• Student Resources
• Work at Grantham
• Disclosures
• Alumni
• Newsroom
• Help
• Contact Us
• Driving Directions
• Live Chat
• Online Communities
• Articulation Agreements

Company Overview

Grantham University is proud of its 60-year history and continuous commitment of service to the Armed Forces of the United States of America, Veterans, Active Guard, and their families, as well as public agency staff and students from around the world. Grantham University is 100% online with administrative offices located in Kansas City, Missouri. The University offers 38 associate, baccalaureate and master degree programs which position its graduates for success in their chosen career paths.

Position Description

This position assists the Database Administrator II in completing development work tasks and serving as a secondary for all facets of database administration and development. This is a non-supervisory position. This position is located on the Kansas City, Missouri campus.

Key Job Responsibilites

• Write scripts to create databases and database objects.
• Write scripts to create views, procedures, and functions in support of application development.
• Create packages and scripts to migrate data or perform ETLs.
• Assist with the following: database definitions; backups; disaster recovery planning (jointly with the Systems Administrator and/or Infrastructure Management); security planning; account set up and access rights.
• Assist with design of logical and physical database or review description of changes to database design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics such as location, amount of space, and access method).
• Establish physical database parameters.
• Code database descriptions and specific identifiers of database to database management system or directs others in coding database descriptions.
• Configure user access level for each segment of one or more data items such as insert, update, query, or delete data.
• Test, correct errors, and refine changes to the database.
• Use of utility programs to monitor database performance including query execution plans, query execution times, indexing, and resource usage.
• Direct programmers and analysts to make changes to database management system.
• Train users and answer user questions.
• Confer with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.
• Modify database programs to increase processing performance, referred to as performance tuning.

• Requires a minimum of one year experience with one of the following; Oracle PL/SQL, T-SQL, or MySQL.
• Experience with optimization tools such as Toad preferred.
• Experience with data integration tools such as Microsoft SSIS preferred.
• Oracle and/or Microsoft SQL Server certifications a plus.
• Previous experience with Sungard Banner products a plus.
• Able to effectively communicate orally (in person and by telephone) and in writing.
• Able to multi-task, yet maintain close attention to detail and timeliness of work production.
• Able to work in a positive team-oriented manner with a variety of people (students, faculty, staff, administrators, vendors, and members of the general public).
• Language Skills: Able to read, analyze, and interpret common scientific and technical journals, financial reports, and legal documents. Able to respond to common inquiries or complaints from customers, regulatory agencies, or members of the business community. Able to write speeches and articles for publication that conform to prescribed style and format. Able to effectively present information to executive management, faculty, staff, students, and/or board of directors.
• Mathematical Skill: Able to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Able to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
• Reasoning Ability:Able to define problems, collect data, establish facts, and draw valid conclusions. Able to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables
• Physical Demands:The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• Frequently required to use hand to finger, handle, or feel (including the use of computer keyboards) and talk or hear (including the use of a telephone).
• Occasionally required to walk, stand.
• Specific vision abilities include: close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus
• The noise level in the work environment is usually moderate.

• Integrity – operates within the highest ethical standards and integrity in all aspects of the position
• Motivated/Results Oriented – fantastic record of personal drive and the determination to succeed
• Mission Oriented - passionate about helping others; ownership spirit with a competitive disciplined execution for results
• Listening Skills – must be an active listener to insure client needs are fully understood and met
• Influence – skilled at directing and motivating others towards personal, academic and professional success

Core Competencies

• Integrity – operates within the highest ethical standards and integrity in all aspects of the position
• Motivated/Results Oriented – established record of personal drive and the determination to succeed
• Mission Oriented - passionate about helping others; ownership spirit with a disciplined desire to achieve the mission