SQL DBA

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• The following duties are typical for this position. Incumbents may perform some but not all of the listed duties and/or may be required to perform additional duties from those listed below to meet the city's business needs and changing operating practices. Other duties may be required and assigned.
• Participates in the Information Technology Department's strategic planning processes.
• Designs, develops and maintains city databases hosted on various database servers that serve applications across all departments.
• Troubleshoots database performance problems and provides solutions based on analysis and research using knowledge of operating systems, relational databases and database technologies.
• Designs, develops and maintains a data warehouse that serves as a central repository of data from disparate data sources across the city.
• Designs and develops reporting and data analysis solutions based on the data warehouse using industry standards and methodologies.
• Provides technical input to management regarding proposed applications that would utilize the database
• Performs, maintains and ensures database backups, restores, security, and data corruption/correction.
• Monitors performance and database connectivity issues.
• Stays abreast of current and emerging technologies related to areas of expertise.
• Applies latest service packs and patches.
• Monitors space issues and performs housekeeping of database.
• Develops assigned areas of technology roadmap(s).
• Determines database specific configurations and architecture.
• Obtains quotes and bids and performs request for proposals; identifies vendors and/or software and/or tools associated with database or data warehouse solutions.
• Creates, analyzes and troubleshoots complex queries.
• Leads and participates in project management including scheduling and prioritizing resources.
• Supervises, schedules and evaluates direct reports and other staff assigned during various projects.

KNOWLEDGE AND ABILITIES:
• Knowledge of database administration using MS SQL Server.
• Strong database development skills using MS SQL Server.
• Knowledge of database warehousing and business intelligence.
• Knowledge of trends and developments in database technologies, operating systems and application development.
• Knowledge of project management practices.
• Knowledge of programming or shell scripting.
• Knowledge of production support experience utilizing effective communication, troubleshooting skills.
• Knowledge of business intelligence services for analytics, reporting and data transformation.
• Ability to develop applications using .NET.
• Ability to establish relational data modeling.
• Ability to manage multiple projects simultaneously.
• Ability to write reports.
• Ability to work well in teams.

EXPERIENCE AND EDUCATION:
Bachelor's degree in Information Technology, Management Information Systems, Computer Science or related field from an accredited college or university. Minimum of five to seven years with database administration and three years in database warehousing; minimum of three years experience with SQL.