SQL DBA & Application / Web Developer

Ability to analyze existing data, tables, queries, stored procedures and reports to determine application operation
Ability to quickly and succinctly troubleshoot application and data issues from user observations; must be able to work closely with users to determine requirements
Thought leader who can envision innovative solutions which drive improvements for overall organizational information delivery
Ability to recommend and implement timely and appropriate solutions, including:
Changes to SQL objects, web-based reports, and various home-grown and off-the-shelf applications
Small application development using Operational Data Stores (ODS) architecture or similar
Creating or changing data tables, queries, stored procedures, reports and web pages
Integration with other mainframe and non-mainframe applications
Updating / refreshing test environments; following version control and change control processes
Support user requests to research specific questions related to SQL or other relational data stores
Must be a self-starter who can leverage multiple sources for technical support (e.g., Stack Overflow, user groups, Google)
Must be able to manage multiple priorities to deliver to deadlines; resilient when faced with rapidly changing demands:
Develops, modifies, and provides input to project plans; experienced in Waterfall or Agile SDLC methodologies
Proficient in prioritizing and completing projects and assigned tasks to time, budget, schedule, yet flexible to change priorities when necessary
Contribute to IT Project Roadmap: input to strategic planning, create tactical plans, drive project delivery in line with overall IT Strategy and Master Plan
Ensures appropriate application- or development-related training and documentation are made available to users (IT and / or Business, as appropriate)

QUALIFICATIONS:
Strong Experience (2-3 yrs)
MS Power BI (preferred) or Tableau
Visual Modeling, KPI Dashboards
Data transformation, Operational Data Stores, Dimensional Modeling, Star Schema Data Architecture or Data Cubes
SQL Server 2008 and 2012
SQL Server Reporting Service (SSRS), SQL Server Integration Service (SSIS) (version 2008R2 minimum
SQL queries, stored procedures: creating, modifying, debugging
Web App development using ASP.net Web Forms
Web Services
Intermediate Experience (1-2 yrs)
Visual Basic (VB), including VB.net, VBA and vbscript
VB development, VB desktop app development or MS Access form design experience