SQL Server Database Administrator
Responsibilities Include:
- Expertise with full software development life cycle including software system analysis, functional design, technical design, development, testing, code review and production system support.
- Software design and development expertise with n-tier application system architecture including use of PostgreSQL, Microsoft SQL Server Enterprise 2008/2012, and Microsoft SQL Server Reporting Services including SSRS, SSIS, and SSAS.
- Expertise with SSRS. Integration of SSRS Reports with Visual Studio .NET. Write queries within Microsoft SQL Server Reporting Services. Expertise with grouping, sub-grouping, formatting, conditional formatting, and creating complex formulas. Test report output. Export report output to Microsoft Excel format.
- Expertise with software design and development in Microsoft SQL Server 2012 and PostgreSQL database environment using SQL and T-SQL for stored procedures and functions. Expertise in data analysis and data design. Knowledgeable of performance tuning database stored procedures and functions.
- Experienced in providing production system support and solving daily production issues for SACWIS environment. Strong analytical, troubleshooting, and problem solving skills. Effective communication with technical and non-technical personnel. Ability to plan work tasks and projects. Research technical issues, problems, procedures, and methods and advise management. Provides technical expertise and input on projects.
- Expertise with full software development life cycle including software system analysis, functional design, technical design, development, testing, code review and production system support.
- Software design and development expertise with n-tier application system architecture including use of PostgreSQL, Microsoft SQL Server Enterprise 2008/2012, and Microsoft SQL Server Reporting Services including SSRS, SSIS, and SSAS.
- Expertise with SSRS. Integration of SSRS Reports with Visual Studio .NET. Write queries within Microsoft SQL Server Reporting Services. Expertise with grouping, sub-grouping, formatting, conditional formatting, and creating complex formulas. Test report output. Export report output to Microsoft Excel format.
- Expertise with software design and development in Microsoft SQL Server 2012 and PostgreSQL database environment using SQL and T-SQL for stored procedures and functions. Expertise in data analysis and data design. Knowledgeable of performance tuning database stored procedures and functions.
- Experienced in providing production system support and solving daily production issues for SACWIS environment. Strong analytical, troubleshooting, and problem solving skills. Effective communication with technical and non-technical personnel. Ability to plan work tasks and projects. Research technical issues, problems, procedures, and methods and advise management. Provides technical expertise and input on projects.
