Database systems administrator job description

The Colleague DBA/Systems Admin position for CampusWorks is an important part of the service delivery team and requires technical knowledge of operating systems, databases, reporting tools and web applications to support the needs of one or more clients. A significant part of the work requires the ability to provision, install/configure, operate, and maintain systems hardware and software and related infrastructure. The Colleague Systems Admin is resourceful, able to problem-solves quickly, and works effectively across teams.

Team members successful in this role are: self-driven, able to understand the needs of the client and communicate effective solutions to multiple stakeholders, and experienced at managing multiple technical projects.

Job Type: 1099 Contract Consultant
A Day in the Life
As an experienced Colleague DBA/Systems Admin with working experience at a Colleague client site, or more formally with either Datatel or Ellucian your expertise will be used daily at CampusWorks. While there are opportunities for some travel, both when it is safe to do so and for a good client need you will be at home. One of the great benefits of being part of the CampusWorks' team is that your expertise is used at multiple clients but you still get to add value to your own home community.

Key AccountabilitiesProvisions, installs/configures, operates, and maintains systems hardware and software and related infrastructure (25%) Manages server and end-user application infrastructure, resolves issues as needed (20%) Monitors and installs system and security patches. (20%) Participates in Colleague/Ellucian module project implementation and/or Unidata to SQL migration for Colleague (20%) Monitors system configuration and log files, takes preventive and/or corrective action. (5%) Architects, installs, and maintains data backup and disaster recovery technical processes in support of overall business continuity strategy. (5%) Develops and maintains technical architecture documentation. (5%)
Requirements5-7 Years of ExperienceExperience at a higher education institution Ability to communication clearly Ability to work independently and to self manage Systems and Architecture InterfacesDevelopment and Architecture DocumentationProject Management and Supervision of Technical ProjectsAll Colleague Modules, WebAdvisor and Self-ServiceSQL Server, Unidata and Oracle (as needed) relational databases Software Updates and Vendor PatchesColleague Security ClassesSA ValetCron JobsPayment GatewaysPerformance Tuning (DMI)
What You Can Expect from Us
At CampusWorks, we don't just help our clients succeed; we help our employees succeed. Competitive pay, robust benefits for full-time employees, and professional development opportunities are a few of the many reasons that CampusWorks is a great place to build your career. Our employees enjoy:

Meaningful work. Our employees often tell us that their work gives them a sense of purpose because it makes a difference in the lives of students and educators.
A CEO who cares. Chairman and CEO Liz Murphy has made it her mission to create a culture that appreciates and takes good care of its people. As a result, being an employee of CampusWorks feels like being a member of a big family.
A virtual and onsite workplace. In an effort to reduce our environmental footprint, CampusWorks became a virtual company in 2012. As such, our team members are located across the U.S. and Canada, where they work from their home offices and at client sites.
Flexibility. We value work-life balance because we know that happy employees create happy customers. T hat's why CampusWorks offers both full-time and part-time 1099 consulting career opportunities to fit life's unique demands.
A company that gives back. Every year CampusWorks proudly supports numerous charitable fundraising initiatives that align with our vision to make higher education accessible to everyone.

There are many things our employees love about working for CampusWorks, but don't take our word for it. Hear what they have to say. Read employee testimonials»

About CampusWorks
Founded in 1999, CampusWorks is dedicated to helping higher education overcome business and technological challenges that stand in the way of student success and completion. We work with community colleges, technical colleges, four-year public and private institutions, multi-college districts, and statewide higher education systems to tackle problems big and small. Our services are rooted in systems thinking and reach across the institution-from Student Services to Human Resources to Finance to Academics-to achieve transformative results.

AAP/EEO Statement: CampusWorks, Inc. provides equal employment opportunities (EEO) and Affirmative Actions (AA) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, genetic information, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state and local laws.

Hybrid - SQL DBA. 10 years of in-depth experience with MS SQL database administration - 5 years of in-depth experience in design, installation, and configuration of MS SQL Cluster with AlwaysOn high availability group in multi-subnet - 5 years of in-depth experience in Azure SQL database configuration, migration, and administration
SUMMARY STATEMENT:

Under the direction of DBA & Data Warehouse supervisor, the Database ADM 4 provides support for database server administration. Major functions include design, build, implementation, and support of SQL database environments. Responsible for day-to-day operational support, trouble tickets, DB maintenance and configuration, and adhering to standard operating procedures within ISS IT Systems, including staff training and documentation. Role functions also include, but are not limited to design, design validation, installation, performance monitoring, optimization, troubleshooting and maintenance of a variety of RDBMS database platforms and environments. Working directly with project managers, application owners, and vendors, the incumbent is responsible for providing database administration support by assessing SQL server requirement from business/functional/technical aspects, proposing and implementing database solutions following ISS DBA standards and the industrial best practice. In addition, the individual needs to be available 24 x 7 for effective coverage of production database support.

TYPE OF SUPERVISION RECEIVED:

The individual is expected to work independently and with minimal supervision. The individual's manager/supervisor will identify guidelines, objectives and deliverables. The individual is expected to determine the most effective way of accomplishing these objectives/deliverables and to properly validate these approaches with the manager/supervisor. The individual will then keep his/her manager effectively informed and receive ongoing guidance through regularly scheduled one-on-ones, and/or other means.

LIST DUTIES TO BE PERFORMED BY THE INCUMBENT:

The Database Administrator is responsible for:
•Setting up SQL database server on both Azure and on-premises;
•Configuring and tuning database server for optimal performance, high availability, sustainability and security;
•Upgrading, migrating, and patching database servers on varies SQL releases;
•Configuring and monitoring SQL database servers, in particular, SQL clusters with AlwaysOn Availability Groups;
•Providing database maintenance support, including database backup/recovery, index optimization/statistics update, and user/group access management, etc.;
•Providing database operational support with the ability to analyze, solve, and correct issues in reasonable time;
•Providing DBA support to project managers by:

o ssessing SQL server requirement from business, functional, and technical aspects;

o Proposing and implementing database solutions following ISS DBA standards and the industrial best practice.
•Supporting all development, test/staging, and production database environments, security assessments and remediation, detail procedure documentation.

PURPOSE:

To provide end user support and full system administration of one or more of the company's Enterprise software applications and related databases.

ESSENTIAL JOB FUNCTIONS:

* Responsible for installing, configuring, monitoring, upgrading, maintaining, and supporting segments of the Enterprise Application infrastructure which includes, but is not limited to the server hardware, operating system, MS SQL Server Database and the business software application itself.

* Responsible for implementing and completing projects as they relate to the maintaining and upgrading of these Enterprise Applications.

PHYSICAL REQUIREMENTS:

Must be able to remain in a stationary position throughout much of the working day. Ability to occasionally move about inside the office. Ability to operate a computer and other office productivity equipment. Must have the ability to install and connect computer equipment in confined areas, sometimes low to the ground and sometimes at height. Must be able to move items weighing up to 50lbs.

Additional Info

JOB QUALIFICATIONS:

* Bachelor's degree in Business Administration, Information Systems or equivalent experience is required.
* Must possess strong MS SQL Server database administration skills on a Windows platform.
* Must be able to follow directions and work independently.
* Must have excellent verbal and written communication skills.
* Must have the ability to interact and provide support at all levels, including end users, software vendors, and peers in a professional manner.
* Must have the ability to travel when needed to various Grimmway facilities.
* Must have a valid driver's license with a clean DMV driving record.
* Must pass pre-placement drug/alcohol screen, physical and functional capacity evaluation.
* Must pass background check.

Benefits

ADMINISTRATIVE EMPLOYEES:

* Competitive benefits package including Medical, Dental, and Vision
* 401k plan with a discretionary match, subject to a vesting schedule
* Paid Sick, Vacation, Holiday Time and Personal Hours
* Employee Vehicle Purchase/Lease Programs
* Subsidized gym membership with InShape health clubs
* Free on-site personal training and other wellness-focused activities at company gym
* Tuition discount partnership program with University of La Verne
* Discounted tickets to major theme parks throughout California
* Work life balance