Database Administrator

Cairn University - Langhorne, PA

Full-time - Entry Level

Langhorne, PA

Educational Services

About the position

The University's Technology Services department is seeking a Database Administrator to join our dedicated team. This role is crucial for ensuring that our databases and supporting systems are not only maintained but also optimized and secured. As a Database Administrator, you will be actively involved in the planning, implementation, development, and maintenance of information systems, while also providing essential support services to the University. Your contributions will directly impact the efficiency and reliability of our data management processes, which are vital for the institution's operations. In this position, you will participate in all phases of the database development cycle, which includes testing, development of programs, and systems documentation in alignment with departmental objectives and requirements. You will also engage in database server architecture and design, making recommendations for server environments that enhance our overall infrastructure solutions, including storage capacity planning. Your responsibilities will extend to managing and maintaining multiple Microsoft SQL Server databases in a production environment, ensuring that they operate smoothly and efficiently. You will be tasked with managing database-related application installations, configurations, and maintenance. This includes being responsible for database alerts, maintenance plans, and scripts, as well as managing database security and controlling access and permissions to databases and related systems. Additionally, you will be expected to resolve any database and related system problems that may arise, ensuring minimal disruption to services.

Responsibilities

• Actively participate in all phases of the database development cycle including testing, development of programs, and systems documentation according to departmental objectives and requirements.
• Participate in database server architecture and design as well as server environment recommendations for the overall infrastructure solutions including storage capacity planning.
• Manage and maintain multiple Microsoft SQL Server databases in a production environment.
• Manage database related application installation, configuration, and maintenance.
• Responsible for database alerts, maintenance plans, and scripts.
• Manage database security and control access and permissions to databases and related systems.
• Resolve database and related system problems.

Requirements

• Bachelor's degree in computer science or in a related field or commensurate experience.
• One to three years of experience in computer technology, including hardware, software, and network administration.
• Proficient in Microsoft SQL Server.
• Professional level of SQL development - creating/modifying scripts, stored procedures, functions, triggers, views, table structures, and indexes.
• Working experience in performance tuning - indexes, queries, and stored procedures.
• Working knowledge of SSRS.
• Working knowledge of creating, managing, and scheduling SQL Server Agent jobs.
• Working knowledge of SQL backup and recovery methods and tools.
• Some experience or familiarity with PowerShell and/or batch scripting in a Windows environment.
• Strong analytical skills, problem-solving skills, and the ability to perform in pressure situations.
• Ability to effectively manage multiple concurrent priorities and meet deadlines within a dynamic, fast paced, and challenging environment.
• Ability to maintain accurate records in accordance with departmental policy.
• Ability to incorporate problem-solving principles into troubleshooting techniques.
• Accurate mathematical skills are essential with knowledge of basic Algebra.
• Excellent written and verbal communication skills and the ability to express ideas concisely and clearly to both technical and non-technical clients.
• Strong interpersonal skills and the ability to work effectively with a wide range of constituencies.

Nice-to-haves

• Willingness to assist in IT help desk support as a backup to other members of the department.
• Ability to lift and transport various technical components and assist with cable installations.
• Occasional ladder work may be required.
• Availability to be on call 24/7; responding to urgent support needs as determined by the Director of Technology Services.