SQL Database Administrator

Mandatory Skills:

• Install configure and maintain SQL Server Clusters and PowerBI Report Server.
• Monitor and optimize SQL performance.
• Develop complex data extracts applications reports dashboards and adhoc queries by using TSQL.
• Research troubleshoot and resolve data issues.
• Work within the project team to assist with system analysis and application design.
• Work closely with Business Analysts and customers to refine requirements and ensure data quality.
• Collaborate on the definition development and maintenance of standards and processes.
• Must possess expertise with TSQL and development of stored procedures.
• Report writing experience with SSRS and PowerBI.
• Drive continuous improvement and automation in BI solutions and processes.
• Work effectively with System Administrators Project Manager(s) Developers Customers and Management.
• Participate in a team development environment using JIRA.
• Must possess excellent written and verbal communication skills

Desirable Skills:

• Degree in Computer Science business or related discipline.
• Knowledge of data integration e.g. extract transform and load (ETL) process development/support.
• Able to develop and troubleshoot SSRS reports and PowerBI dashboards; requires good analytical skills.
• Experience with data access performance tuning and database performance optimization.
• Application Development Lifecycle knowledge and experience.
• Data transport protocols e.g. SFTP XML and JDXDML.
• Experience with Case Management data and/or Justice System data.
• Documentation of system support information.
• Basic understanding of networking principles.
• Ability to analyze system resource usage and constraints.
• Strong communication skills; ability to interact at all levels including management.
• Works independently and follows through on assignments