Unclassified - Manor, TX

posted 2 months ago

Full-time - Mid Level
Manor, TX

About the position

At Unparalleled Preparatory Academy (UPA), we are committed to redefining education through an innovative blend of career immersion, design thinking, and leadership development. We are looking for a Database Administrator to help support the development of our technology infrastructure as we build a transformative, career-focused educational environment for our students. As the Database Administrator, you will be responsible for the administration and maintenance of UPA's databases, ensuring data integrity, optimizing performance, and providing technical support for applications and data management. You will play a key role in developing standards, managing database objects, and assisting with system integration to ensure our systems support the educational mission of UPA. In this role, you will lead the onboarding and stratification of information systems, manage, maintain, and support the district's Student Information System. You will set up, manage, and troubleshoot features within the Student Information System in support of critical educational processes such as registration, course scheduling, and grading. Additionally, you will administer and maintain user permissions, group permissions, and passwords for the Student Information System. You will coordinate the collection, integration, and formatting of all data required for PEIMS submission according to PEIMS Data Standards, working cooperatively with campus, business office, and personnel office staff to ensure timely submission of district PEIMS data. Your responsibilities will also include providing frequent attendance and demographic reports for back office, campus, and district administration that support decision-making regarding staffing and finance. You will be responsible for submitting complete and accurate PEIMS data in Texas Education Agency (TEA)-prescribed format to the education service center (ESC) for processing. Furthermore, you will install, configure, and upgrade database management systems (DBMS) software and servers, create and maintain databases, tables, views, indexes, and other database objects, and monitor and optimize the performance of databases for efficient data retrieval and storage. You will identify and resolve database performance issues, errors, and bottlenecks, perform routine maintenance tasks such as backups, log analysis, and space management, and collaborate with developers to design efficient database structures. As a Database Administrator, you will also provide technical mentorship and cross-training to peers and team members, assist in the development and refinement of complex queries, reports, and stored procedures, and ensure data integrity and security by working with restricted and sensitive information. Staying updated on the latest database technologies and recommending tools to improve performance, security, and scalability will be essential. You will develop data validation edits and web-based applications using available coding tools, create and maintain documentation, including data dictionaries, system specifications, and standard operating procedures, and provide technical support and troubleshooting assistance to users and stakeholders.

Responsibilities

  • Leads onboarding and stratification of information systems
  • Manage, maintain and support the district's Student Information System
  • Set up, manage and troubleshoot features within the Student Information System in support of critical educational processes such as registration, course scheduling, and grading
  • Administer and maintain user permissions, group permissions and passwords for the Student Information System
  • Coordinate the collection, integration, and formatting of all data required for PEIMS submission according to PEIMS Data Standards
  • Work cooperatively with campus, business office, and personnel office staff to collect, organize, and format data required to submit district PEIMS data in a timely manner
  • Provides frequent attendance and demographic reports for back office, campus, and district administration that support decision making regarding staffing and finance
  • Distribute edits and reports to appropriate staff for analysis, verification, and correction
  • Responsible for submitting complete and accurate PEIMS data in Texas Education Agency (TEA)-prescribed format to education service center (ESC) for processing using computer terminal or personal computer
  • Install, configure, and upgrade database management systems (DBMS) software and servers
  • Create and maintain databases, tables, views, indexes, and other database objects
  • Monitor and optimize the performance of databases for efficient data retrieval and storage
  • Identify and resolve database performance issues, errors, and bottlenecks
  • Perform routine maintenance tasks such as backups, log analysis, and space management
  • Collaborate with developers to design efficient database structures and ensure proper data normalization, indexing, and schema design
  • Provide technical mentorship and cross-training to peers and team members
  • Assist in the development and refinement of complex queries, reports, and stored procedures
  • Ensure data integrity and security by working with restricted and sensitive information
  • Stay updated on the latest database technologies and recommend tools to improve performance, security, and scalability
  • Develop data validation edits and web-based applications using available coding tools
  • Create and maintain documentation, including data dictionaries, system specifications, and standard operating procedures
  • Provide technical support and troubleshooting assistance to users and stakeholders

Requirements

  • Bachelor's degree in Computer Science, Information Systems, or related field OR 10+ years of relevant data management experience (required)
  • At least 5 years of experience in MS SQL Server Administration preferred
  • Experience with database performance tuning, backups, restores, and disaster recovery options
  • Familiarity with Windows Server and Active Directory environments
  • Strong ability to manage databases and ensure high availability (HA) and disaster recovery (DR)
  • Excellent communication skills, both written and verbal
  • Experience in working with sensitive data and maintaining its integrity
  • Ability to work independently and as part of a team in a rapidly changing environment
  • Proficient in troubleshooting and resolving complex database issues

Benefits

  • Dental insurance
  • Health insurance
  • Retirement plan
  • Vision insurance
  • Professional development opportunities
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service