Database Administrator II

Position:                      Database Administrator II

Department:                Information Technology Services

Reports To:               IT Manager – Data Management

Location:                    Lenexa, KS


OVERVIEW
:
Grantham University was founded in 1951 by Donald Grantham, a WWII veteran with a desire to make education achievable for fellow military service members and veterans. Throughout the decades, Mr. Grantham’s vision has remained steadfast. Today, the 100 percent online university’s culture of service extends to all adult learners with a desire to improve their lives through higher education. Grantham’s commitment to affordability, accessibility and quality of its more than 50 undergraduate and graduate certificate and degree programs has earned Grantham University a distinguished record as a respected online learning university.

Grantham employees – or Life Changers – have access to a comprehensive and flexible benefits package, a celebrated corporate wellness program, paid volunteer opportunities and a shared commitment to making a difference for Grantham University students, each other and the community. Apply today!

POSITION DESCRIPTION:  Is data is your passion? Do you want to learn new technologies?  We have a job you’d like!  We are looking for an experienced Database Administrator who seeks to expand their passion for data technology and help grow our data team.  Traits we are looking for include a self-learner, detail-oriented, proactive, has initiative, excited about learning new technologies, and is comfortable with self-directed learning.  Query tuning, clustering, and working on newer SQL servers 2016-2017 are part of the functions of this role. This position provides some mentoring to the Database Administrator I.  This role is responsible for installing, configuring, maintaining all MS SQL servers. This is mid-level position requires some oversight, but is expected to perform process analysis and provide recommendations in an autonomous manner. This non-supervisory role works on site in Lenexa, KS. 

KEY JOB RESPONSIBILITIES:

  • Install, configure and maintain the operation of a group of MS SQL Servers (2012 – 2016) to ensure performance and availability.
  • Function as team member with other IT employees and numerous functional team leaders from throughout the University.
  • Responsible for 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.
  • Design 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.
  • Calculate optimum values for database parameters such as amount of computer memory to be used by database and storage I/O configurations.
  • Specify which users can access databases and what data can be accessed by user in each environment.
  • 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.
  • Confer with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.
  • Work directly with consultants and technicians from vendor companies.
  • Other Duties as assigned

 

EDUCATION/ WORK EXPERIENCE REQUIREMENTS AND DESIRED SKILLS:

  • Relevant (i.e. Computer Science) Bachelor’s degree from an accredited four-year college or university, or relevant job experience is preferred.
  • Requires a minimum of three years’ experience in installation, configuration and maintenance with SQL Server (2008R2 or newer)
  • Experience in setting up and maintaining MS SQL Server Clusters desired.
  • Experience with PowerShell for automating management tasks desired.
  • Experience with reporting tools such as Microsoft SSRS desired.
  • Experience with ETL tools such as Microsoft SSIS desired.
  • 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 and staff.
  • 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.
    • The work station for this role is a cubicle-styled work station. The ability to work in a cubicle-setting and the ability to navigate through surrounding conversations to keep on task is required.
    • 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.