Sr. Systems Engineer

Plano ISD; United States; On-site; USD 85,000 - 110,000; Full time

Job summary

Plano ISD is seeking a skilled Database Administrator to manage district-wide SQL Server environments, ensuring high availability, security, and performance. You will design, implement, and maintain database architecture, backups, and ETL processes, while collaborating with application teams to optimize data storage and analytics across the district.

Five years of SQL Server DBA experience, Windows Server administration, SDLC/Agile, and strong communication skills are required; a BS in CS or

Qualifications

• Bachelor's degree in Computer Science or related field (preferred)
• Microsoft certifications (preferred)
• Five years of hands on experience with SQL Server as a database administrator
• Five years of experience with Windows Server administration, tuning and troubleshooting
• Five years of experience with SQL Server backup/restore, schedulers, etc
• Five years of experience using Systems Development Life Cycle (SDLC) and Agile methodologies
• Understanding of concepts of High Availability, such as Always-on, Clustering, Database Mirroring and/or other technologies

Responsibilities

• Ensure integrity, high availability and optimum performance of Production database systems by providing technical support and maintenance
• Partner with application teams to review their current database estates, analyze business drivers and technical KPIs, review modernization plans and help them select a proper technology solution for data storage needs
• Design, develop, and maintain ETL processes for but not limited to the data warehouse, linked servers, SSIS packages, third party ETL interfaces
• Manage data loads, security, and integration of the data warehouse platform for BI reporting
• Support BI tools and database updates through development, testing, debugging and documentation
• Monitor reports and job response times; tune queries, stored procedures, and functions to optimize and improve performance
• Support integrated ITIL processes with Incident, Change and Problem management
• Develop plans to resolve problems and prevent them from recurring; maintains high service levels for the user community in accordance with SLAs
• Ensure all changes are well communicated, coordinated, and documented
• Maintain up-to-date documentation, including diagrams, on all BI/applications development, database systems, integration services, and connectivity
• Be customer service oriented and maintain a professional approach regarding all district matters
• Perform R&D, remain knowledgeable of emerging trends in technology, and keep abreast of innovative practices
• Attain and keep current, relevant technology certifications
• Perform special projects, after-hours support and upgrades, and other related duties
• Follow all rules, regulations, and policies of Plano ISD and follow directives from supervisor
• Follow attendance policy as assigned by supervisor
• Perform other functions that may be assigned by the Administration and/or supervisor

Skills

Data warehousing

Data modeling

Data management

Data extraction

Business intelligence

Communication skills

Multiple priorities

Relationship building

Education

Bachelor's degree in Computer Science or related field

Microsoft certifications

Job description

Location: Administration Bldg

Primary Purpose:

This position is responsible for managing and supporting district-wide files and database systems, enterprise integrations, including the performance, integrity, and security of those systems. In this role, they will configure and maintain database servers and processes. Monitor the system's health and performance, ensuring high-performance levels, availability, sustainability, and security. Plan and develop database architecture, logical and physical design, automation, documentation, installations, backup and recovery concepts, and troubleshooting of any database performance or data integrity issues.

Qualifications: Education/Certification:

• Bachelor's degree in Computer Science or related field (preferred)
• Microsoft certifications (preferred)

Experience:

• Five years of hands on experience with SQL Server as a database administrator
• Five years of experience with Windows Server administration, tuning and troubleshooting
• Five years of experience with SQL Server backup/restore, schedulers, etc
• Five years of experience using Systems Development Life Cycle (SDLC) and Agile methodologies
• Understanding of concepts of "High Availability," such as Always-on, Clustering, Database Mirroring and/or other technologies

Special Knowledge/Skills:

• Demonstrated knowledge and experience in systems architecture, application development, data warehousing, data modeling, and data management
• Knowledge and experience developing comprehensive DB architecture, implementation and upgrade plans for applications Database
• Ability to extract data from various sources and connect, import and transform data for business analysis and intelligence
• Ability to relate business goals to data elements and structures to support performance measurements
• Knowledge of research techniques, methods and procedures to develop best practices and resolve technical issues
• Excellent verbal and written communications skills
• Ability to manage multiple priorities effectively
• Ability to develop and maintain effective working relationships

Major Responsibilities and Duties:

• Ensure integrity, high availability and optimum performance of Production database systems by providing technical support and maintenance
• Partner with application teams to review their current database estates, analyze business drivers and technical KPIs, review modernization plans and help them select a proper technology solution for data storage needs
• Design, develop, and maintain ETL processes for but not limited to the data warehouse, linked servers, SSIS packages, third party ETL interfaces
• Manage data loads, security, and integration of the data warehouse platform for BI reporting
• Support BI tools and database updates through development, testing, debugging and documentation
• Monitor reports and job response times; tune queries, stored procedures, and functions to optimize and improve performance
• Support integrated ITIL processes with Incident, Change and Problem management
• Develop plans to resolve problems and prevent them from recurring; maintains high service levels for the user community in accordance with SLAs
• Ensure all changes are well communicated, coordinated, and documented
• Maintain up-to-date documentation, including diagrams, on all BI/applications development, database systems, integration services, and connectivity
• Be customer service oriented and maintain a professional approach regarding all district matters
• Perform R&D, remain knowledgeable of emerging trends in technology, and keep abreast of innovative practices
• Attain and keep current, relevant technology certifications
• Perform special projects, after-hours support and upgrades, and other related duties
• Follow all rules, regulations, and policies of Plano ISD and follow directives from supervisor
• Follow attendance policy as assigned by supervisor
• Perform other functions that may be assigned by the Administration and/or supervisor

Working Conditions: Mental Demands:

• Reading; ability to communicate effectively (verbal and written); maintain emotional control under stress; work with frequent interruptions

Physical Demands/Environmental Factors:

• Frequent standing, stooping, bending, kneeling, pushing and pulling; prolonged use of computer and repetitive hand motions; occasional lifting up to 50 pounds