Senior Database & BI 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

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