Database Administrator II

  • Sioux Falls
  • Premier, Inc.
Location: Sioux Falls, SD
Shift: Monday-Friday, 8am-5pm
Job Schedule: Full-Time
Company: PREMIER Bankcard
About the Role Responsible for all activities related to administration of computerized databases including design, control, and maintenance. Analyzes information requirements and develops specifications for data base construction and maintenance to ensure economy, efficiency, safety of information and utilization of new technical developments. May confer and advise other associates on administrative policies and procedures, technical problems, priorities and methods and of new or existing data files. May project long-range requirements for database administration in conjunction with other managers in the data processing function.
Job Duties and Responsibilities
  • Administers and maintains the company database and data warehouses.
  • Implements and monitors database access and configurations.
  • Resolves database performance and capacity issues.
  • Performs database recovery and back-up.
  • May involve capacity planning, and some development work.
  • Responsible for ongoing data schema and documentation of all internal databases and tables. May also include maintaining data dictionaries.
  • Completes Internal projects as assigned by Software Development management.
  • Provides problem management support. Makes daily decisions about the best way to resolve issues with the least impact to users under management supervision.
  • Typical scope of the assignment is usually related to enhancements or functionality of multiple PREMIER internal databases or tables.
  • Test functionality including necessary documentation for review by supervisor as defined in the SDLC.
  • Accurately complete reports consisting of work time spent on projects within the department’s standard timeline.
  • Ability to follow a stringent Software Development Life Cycle (SDLC).
  • Must be able to efficiently manage time by organizing and prioritize tasks to maximize productive results, and allow for flexibility where necessary to serve a change in priorities or an additional challenge.
  • Must be able to communicate thoughts, observations to participate and present information to various levels within the organization. May require communication in written or verbal form.
  • Perform associated tasks with on-call assignments including answering help desk phone and monitoring the completion daily processes.
  • Performs work that affects business operations to a substantial degree of multiple internal databases and tables. This includes database maintenance and setup including backup monitoring, documentation, logging and setting up the database scheme structures for internal projects, and running space monitoring scripts.
  • Completes major assignments affecting the operations of the business through multiple internal databases and tables. Conducts DBA level installation and upgrades including application level patches and upgrades.
  • Maintains and documents installation and upgrades, computer system validation, disaster recovery information, problem management planning for the application or system.
  • Investigate and resolves matter of significance for the PREMIER applications on behalf of Software Development management. Maintains the highest level of database security. Maintains user accounts and access, determining the approval level and maintaining access forms for the application.
  • Ensure projects are implemented in an uninterrupted and non-detrimental fashion by participating in the software releases. These assignments will directly relate to general business operations performing as expected.
  • Complete projects as assigned by Software Development management.
  • Typical scope of the assignment is usually related to enhancements and/or the creation of new databases or tables. These assignments will directly relate to general business operations performing as expected.
  • Ensure that database/table changes do not impact other areas of the application or database.
  • Document changes to new databases/tables by completing the project form template and submitting to Software Development management as required in established internal and external audit requirements as defined in the SDLC.
  • Must be able to facilitate the flow of work within the work unit as it is handed off to and from the work unit, within established productivity requirements.
  • Analyzes and develops timely, conclusive solutions to a variety of more complex issues.
  • Perform associated tasks with on-call assignments including answering help desk phone and monitoring the completion daily processes.
Skills and Qualifications
  • AWS/Azure cloud experience preferred
  • Data modeling experience preferred
  • Strong development skills specifically in SSIS, Fivetran, Coalesce
  • Windows domain and/or database experience/knowledge is necessary to perform essential functions and tasks of position.
  • Proficiency of the English language.
  • 1-2 years of related experience, prefer a minimum of 2 years of experience in a software development environment. May require a bachelor’s or master’s degree or its equivalent.
  • Bachelor or Master's degree in related field.
  • Experience with SQL, Windows PowerShell Scripting, Microsoft Visual Studio, VB scripting, and VMWare Virtual Environment.
Competitive Benefits Package
  • Full medical benefits when working 20+ hours per week
  • Traditional and High Deductible health plan options available
  • FREE dental and vision coverage
  • Generous Paid Time Off plans
  • 401(k) – dollar-for-dollar match up to 5% of total compensation
  • Special discounts and offers for events at the Denny Sanford PREMIER Center
  • PREMIER Wellness Program
  • Paid Community Volunteer Hours – PREMIER averages 30,000 hours per year
  • Fun Employee Parties
Our Culture
  • Emphasis on personal success, respect, health, wellness, fun and giving back
  • Employees are rewarded, valued, and celebrated for hard work
  • Various Career advancement opportunities and growth
  • Appreciation is shown through concerts, outdoor bashes, cash, car giveaways and more