Skip to main content

This job has expired

Database Developer Administrator II

Employer
Lone Star College
Location
Texas, United States
Salary
Salary Not Specified
Date posted
Jan 27, 2022


Commitment to Mission

This job carries with it the obligation to uphold the Mission of Lone Star College (LSC) in carrying out the duties of the position. A commitment to positive interpersonal behaviors, professional communication, diversity, integrity, leadership, stewardship, respect and accountability to LSC students and employees is essential.

Cultural Beliefs
  • One LSC
  • Student Focused
  • Own It
  • Advance Equity
  • Cultivate Community
  • Choose Learning
The Chronicle of Higher Education’s “Great Colleges to Work For” is designed to recognize colleges that have been successful in creating great workplaces and to further research and understanding of the factors, dynamics and influences that have the most impact on organizational culture at higher education institutions.

Lone Star College was recognized in five areas: Confidence in Senior Leadership; Diversity; Facilities, Workspace & Security; Job Satisfaction; and Work/Life Balance .

Campus Marketing Statement

Lone Star College-System Office

Lone Star College offers high-quality, low-cost academic transfer and career training education to 93,000+ students each semester. LSC has been named a 2021 Great Colleges to Work For® institution by the Chronicle of Higher Education and ranked 35th in Texas in the Forbes ‘America’s Best Employers By State’ list.

LSC consists of eight colleges, seven centers, eight Workforce Centers of Excellence and Lone Star Corporate College.

Lone Star College-System Office employees are based at one of two System Office locations; The Woodlands and University Park. Both are the site for multiple administrative departments and system-wide training programs.

Location address is 5000 Research Forest Drive, The Woodlands, TX 77381.

Job Description

PURPOSE AND SCOPE:

The Database Developer/Administrator II provides support for the Business Intelligence (BI) and Data Warehousing systems at LSC, including but not limited to installation of software, patching, tuning, troubleshooting, ETL management and maintenance activities. Serving as subject matter expert and end-user liaison for Business Intelligence tools and SQL Server Database, position supports end-users in BI- and database-related activities as required. Assists in the design, implementation and use of databases and their associated environments, manages and maintains all production and non-production databases, and performs backup, restoration and disaster recovery on deployed database systems. Responsible for standards and design of physical data storage, maintenance, access and security administration.

Works closely with business, infrastructure and application development teams to recommend architecture solutions based on the data storage and retrieval needs within Lone Star College. Makes decisions about what data is being collected, how data flows through the system, and how data is used and analyzed, and works closely/liaisons with Analytics, Institutional Reporting, OTS, TS-Server and other operations teams in the performance of duties. Reviews, analyzes and documents defined architectural models or views that show how the needs of the organization will be met in an efficient, sustainable, agile and adaptable manner.

ESSENTIAL JOB FUNCTIONS:

  1. Responsible for installation, maintenance, upgrade and decommission of application and database software in physical and virtual environments.Manages all Business Intelligence and supporting software deployments
  2. Controls and optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Assists in performing a variety of critical database functions such as review, evaluation, design, implementation and maintenance.
  3. Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluates current systems.Develops database solutions by designing proposed systems, defining database physical structure and functional capabilities, security, back-up, and recovery specifications
  4. Manages ETL jobs and systems that support the Data Warehouse systems.Designs, develops and implements ELT/ELT jobs to meet current and future business data needs
  5. Develops and implements migration methods for moving existing data from legacy systems into new solutions
  6. Designs, builds, optimizes and maintains conceptual, logical and physical data models and flowcharts.Creates, analyzes, and validates detailed functional specifications
  7. Investigates and resolves complex application and operational issues and improve system performance by conducting tests, troubleshooting and integrating new elements.Monitor and identify performance trends and work to improve processes and procedures.Tests and drives implementation of new technologies to meet current and future business needs of the AIR department, its stakeholders and clientele
  8. Assists data stewards and subject matter experts with ensuring data integrity, testing of system changes, and analyzing data flows for process improvement opportunities.Ensure data solutions are built for performance, fault tolerance and security
  9. Assists staff in the creation, management, and troubleshooting of BI Dashboards.Document stakeholder requirements, measure/monitor process efficiency, report project status and assist with communication programs and training
  10. Cross-trains, builds, and maintains skills in adjacent work areas of the workgroup to facilitate team problem solving.Mentors less experienced Database Developer/Administrator I
  11. Serves as a liaison between various business units and IT to drive the implementation of improvement opportunities by mapping out process changes, defining requirements and scope, and proactively communicating project vision to business leaders, stakeholders, and users.Facilitates design sessions with the implementation team to define solutions
  12. Responsible for other reasonable related duties as assigned, which may include but is not limited to scripting or light programming, automation, and project management for systems- and database-related projects


KNOWLEDGE, SKILLS AND ABILITIES:
  • Knowledge of UNIX or Linux is helpful
  • In-depth understanding of database design and structure principles
  • Knowledge of and skills in the following areas preferred; SQL Server Database Administration, Database Analysis & Design, Physical Disk Storage and Partitioning, Access and Data Security Management, Backup, Restoration and Disaster Recovery, Advanced SQL programming, MS Visual Studio 2017 or newer
  • Familiarity with reporting, analysis and data visualization tools (e.g., Power BI, Tableau, R)
  • Understanding current product trends and technology innovations
  • Excellent problem solving and analytical skills
  • Knowledge of Kimball dimensional modeling design concepts and OLAP database designs and implementation strategies
  • Analytical, detail oriented, organized, creative thinker and problem solver
  • Ability to respond in a rapid manner to problems and issues related to the RDBMS and the platform environment
  • Ability to manage a variety of competing priorities and to work productively with colleagues to ensure that goals are attained in a timely manner
  • Ability to objectively troubleshoot and resolve issues in complex technical environments
  • Excellent organizational and analytical skills, good interpersonal skills, excellent written and verbal English communications skills
  • Ability to assume responsibility for independent action
  • Ability to develop, understand and follow standard operating procedures
  • Ability to convey technical or complex information to others in non-technical terms
PHYSICAL ABILITES:

The work is sedentary. Typically, the employee sits comfortably to do the work. However, there may be some walking; standing; bending; carrying of light items, such as papers, books, or small parts; or driving an automobile. No special physical demands are required to perform the work.

WORK SCHEDULE AND CONDITIONS:
  • Equipment used includes, PC workstation running on a LAN in a Microsoft Windows environment, calculator, phone and other general office equipment
  • Interface with internal and external contacts as needed to carry out the functions of the position
  • Work is performed in a climate-controlled office with minimal exposure to safety hazards
REQUIRED QUALIFICATIONS:
  • Bachelor’s degree in a related field and at least 3 years of related work experience or equivalent combination of education and experience
  • At least 3 years of experience in a data architecture, data analysis or data management role
  • At least 3 years of experience developing, installing, configuring and administering large relational database platforms including Microsoft SQL Server 2016 and newer
  • At least 3 years of experience with SQL Server Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS)
  • At least 3 years hands-on database tuning and troubleshooting experience
Salary

Hiring salary range is $69,679 - $80,130

Lone Star College provides a hiring salary range for all posted full-time non-faculty positions. Where your salary offer would fall in that range is determined by your related experience and education. Should you receive an offer of employment from Lone Star College, the resume submitted in the application process will be utilized to calculate your salary offer. The information outlined below will provide the Office of Human Resources everything needed to determine an accurate starting salary.

Your resume should provide a complete picture of your work experience. The resume should include the following information for each position listed:

  1. Length of time (specific months and years) of employment
  2. If the position was full time or part time
  3. If the position was paid or unpaid
  4. Unofficial transcript for highest earned degree


Additionally, any certifications listed as required or preferred in the Lone Star College job description should be included in the resume submitted.

Benefits Marketing Statement

By joining our top-notch institution, you will enjoy being a part of an organization that offers a supportive, collegial work environment and excellent work/life balance. This includes a full comprehensive and competitive benefits package, a generous number of paid holidays and vacation days, wellness programs, tuition waiver, professional development opportunities and more.

Special Instructions

Go to the Job Search page, click on ‘My Activities’ at the top of the page. Under My Cover Letters and Attachments you will click on ‘Add Attachment.’ Please be sure to put the Job ID# in the title once you name your file for cover letters only, unless you attached your cover letter with your resume.

If you are applying for an Instructional position (i.e. Faculty, Adjunct Faculty, Instructor), please ensure you include the following to be considered: Resume/CV, Cover Letter, Teaching Philosophy, and unofficial transcripts.

You must limit your file name for any attachment to 40 characters or less.

How to Apply

ALL APPLICANTS MUST APPLY ONLINE ONLY

We will not accept application material received via fax, email, mail, or hand delivered.

Postings for part-time and adjunct positions are active for the academic year. By selecting the option to receive notifications on your profile, you will begin receiving electronic communication regarding new opportunities with Lone Star College (LSC).

If selected for an interview, a recruiter will contact you by phone, or email to schedule an interview.

Lone Star College participates in the E-Verify program, under which Lone Star College provides the federal government with information from each new employee's Form I-9 to confirm that the employee is authorized to work in the United States.

More information on the E-Verify program is available at www.dhs.gov/E-Verify .

Lone Star College is an EEO Employer. All positions are subject to a criminal background check.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert