What are the responsibilities and job description for the Senior Database Developer position at Douglas County Government (CO)?
The Senior Database Developer acts as a senior member of the Technology Capabilities Group within IT Application Services and is responsible for the overall design, development, test, release, maintenance, and technical support of data and reporting applications to ensure effective data services delivery and support enterprise strategies. This role is also responsible for working with Information Technology (IT) Infrastructure Services to ensure server platform and security needs of data and reporting systems are met. In coordination with the IT Project Management Office, this role will assist in defining project scope, requirements, and timeline.ESSENTIAL DUTIES AND RESPONSIBILITIES: (The following examples are illustrative only and are not intended to be all inclusive.)
• Participates in a team-based, agile development environment.
• Adheres to established Douglas County best practices, standards and agreed upon design patterns for data and reporting application development and support.
• Analyzes and understands business users' requirements, clarifying inconsistencies, conflicts, or ambiguities, to effectively develop solutions that meet business needs.
• Responsible for the design, development, test, release, maintenance, and technical support of custom data applications such as data pipelines/ETLs/data processing/APIs.
• Responsible for the design, development, test, release, maintenance, and technical support of data analysis reports and dashboards using Power BI and paginated reports using Power BI Report Builder or SSRS.
• Performs data modelling and database design for data and reporting applications as well as other applications as needed.
• Performs analysis, design and implementation of data migration as needed.
• Participates in design/code reviews.
• Performs SQL Server database administration in the development environment.
• Documents data and reporting application implementations, configurations, and support requirements as needed.
• Creates deployment packages and instructions for releasing data and reporting applications across environments.
• Evaluates techniques and design patterns and makes recommendations that will improve solution delivery.
• Corrects reported incidents on data and reporting applications and releases fixes through the change control processes.
• Creates and maintains application runbooks on the supported data and reporting applications.
• Administers Power BI Online environment including managing security, data gateways, and workspaces.
• Participates in the development and management of governance and frameworks for managing data across the County.
• Performs solution assessment as needed.
• Conducts proof of concept to guide technical implementation as needed.
OTHER DUTIES:
Performs other duties as assigned including, but not limited to: participating in projects where their skills are applicable. This could include, but are not limited to, work on business intelligence efforts, low-code development, and geospatial data management, work with managed services, and vendor management.
SUPERVISION RECEIVED: This position reports to the IT manager. Performs duties under general supervision; tasks are expected to be completed with substantial independence.
SUPERVISORY RESPONSIBILITIES: This position has no direct supervisory responsibilities but does function in a lead capacity in collaborating with cross-functional teams.
INDEPENDENT JUDGMENT: Incumbent is given broad terms and format, allowing a great amount of latitude and individual judgment to accomplish goals and achieve desired results.
MINIMUM QUALIFICATION REQUIREMENTS:
EDUCATION and/or EXPERIENCE:
• A Bachelor’s degree in Computer Science, Management Information Systems or a closely related field from an accredited college or university is preferred.
• Five years of experience in the solution development life cycle for developing and maintaining data processing and reporting applications.
• A combination of experience and education may be considered for a well-qualified candidate.
KNOWLEDGE, SKILLS AND ABILITIES:
Knowledge:
• Strong knowledge of professional software engineering practices, software quality assurance practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations.
• Working knowledge of waterfall and agile methodologies.
• Knowledgeable in data integration and/or data migration design and implementation, data management principles and best practices, and the architecture and design of Business Intelligence solutions.
• Familiar with the design and application of software design pattern.
• Familiar with ITIL for IT Service Management.
• Knowledge of new and emerging technologies related to data management such as data catalog, data lineage, and data quality management
Skills:
• Proficient in developing solutions using SQL Server, T-SQL, Stored procedures, Azure Data Lake, Azure Data Factory, Master Data Services, SSIS, and SSRS.
• Well versed in developing data models and reports with Power BI and Power BI Report Builder.
• Proficient in performing system and/or integration testing.
• Skilled in scripting using Python and Power Shell.
• Skilled in performing system analysis and design.
• Proficient in using Azure DevOps to manage CI/CD pipelines and artifacts.
• Proficient in source code management using GitHub.
• Competent in planning and managing software quality assurance activities throughout the SDLC to ensure security, reliability, efficiency, and maintainability.
• Proficient in applying critical thinking skills in problem solving.
• Skilled in communicating with functional teams of different technical experience.
Abilities:
• Ability to establish effective working relationships at all levels.
• Ability to work as a part of a team, using both verbal and written communications, to resolve problems, complete project related tasks, and interface to Douglas County departments.
• Ability to clearly document technical configurations and summarize technical information.
• Ability to identify problems, establish facts, correlate data to a series of events, effectively evaluate risk, and develop logical plans of action for implementing and troubleshooting solutions.
• Ability to interpret an extensive variety of technical instructions and environments in written, mathematical or diagrammatic form and understand abstract and concrete concepts
• Ability to Keep up-to-date technically and apply new knowledge to your job.
• Ability to manage multiple activities concurrently, allocating time to each according to prioritization.
• Ability to adhere to County guidelines and standards and be able to work.
• Strong work habits, organization, and time management skills.
CERTIFICATIONS, LICENSES, & REGISTRATIONS:
This position requires successful completion of a criminal background check including fingerprinting through a national database.
For more information on job functions, requirements and to apply please visit: https://douglasco.csod.com/ux/ats/careersite/5/home/requisition/2733?c=douglasco
Douglas County offers an excellent comprehensive benefit package including but not limited to: Medical/Dental/Vision.
For a more detailed overview please view the full Employee Benefit Guide.
• Participates in a team-based, agile development environment.
• Adheres to established Douglas County best practices, standards and agreed upon design patterns for data and reporting application development and support.
• Analyzes and understands business users' requirements, clarifying inconsistencies, conflicts, or ambiguities, to effectively develop solutions that meet business needs.
• Responsible for the design, development, test, release, maintenance, and technical support of custom data applications such as data pipelines/ETLs/data processing/APIs.
• Responsible for the design, development, test, release, maintenance, and technical support of data analysis reports and dashboards using Power BI and paginated reports using Power BI Report Builder or SSRS.
• Performs data modelling and database design for data and reporting applications as well as other applications as needed.
• Performs analysis, design and implementation of data migration as needed.
• Participates in design/code reviews.
• Performs SQL Server database administration in the development environment.
• Documents data and reporting application implementations, configurations, and support requirements as needed.
• Creates deployment packages and instructions for releasing data and reporting applications across environments.
• Evaluates techniques and design patterns and makes recommendations that will improve solution delivery.
• Corrects reported incidents on data and reporting applications and releases fixes through the change control processes.
• Creates and maintains application runbooks on the supported data and reporting applications.
• Administers Power BI Online environment including managing security, data gateways, and workspaces.
• Participates in the development and management of governance and frameworks for managing data across the County.
• Performs solution assessment as needed.
• Conducts proof of concept to guide technical implementation as needed.
OTHER DUTIES:
Performs other duties as assigned including, but not limited to: participating in projects where their skills are applicable. This could include, but are not limited to, work on business intelligence efforts, low-code development, and geospatial data management, work with managed services, and vendor management.
SUPERVISION RECEIVED: This position reports to the IT manager. Performs duties under general supervision; tasks are expected to be completed with substantial independence.
SUPERVISORY RESPONSIBILITIES: This position has no direct supervisory responsibilities but does function in a lead capacity in collaborating with cross-functional teams.
INDEPENDENT JUDGMENT: Incumbent is given broad terms and format, allowing a great amount of latitude and individual judgment to accomplish goals and achieve desired results.
MINIMUM QUALIFICATION REQUIREMENTS:
EDUCATION and/or EXPERIENCE:
• A Bachelor’s degree in Computer Science, Management Information Systems or a closely related field from an accredited college or university is preferred.
• Five years of experience in the solution development life cycle for developing and maintaining data processing and reporting applications.
• A combination of experience and education may be considered for a well-qualified candidate.
KNOWLEDGE, SKILLS AND ABILITIES:
Knowledge:
• Strong knowledge of professional software engineering practices, software quality assurance practices & best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations.
• Working knowledge of waterfall and agile methodologies.
• Knowledgeable in data integration and/or data migration design and implementation, data management principles and best practices, and the architecture and design of Business Intelligence solutions.
• Familiar with the design and application of software design pattern.
• Familiar with ITIL for IT Service Management.
• Knowledge of new and emerging technologies related to data management such as data catalog, data lineage, and data quality management
Skills:
• Proficient in developing solutions using SQL Server, T-SQL, Stored procedures, Azure Data Lake, Azure Data Factory, Master Data Services, SSIS, and SSRS.
• Well versed in developing data models and reports with Power BI and Power BI Report Builder.
• Proficient in performing system and/or integration testing.
• Skilled in scripting using Python and Power Shell.
• Skilled in performing system analysis and design.
• Proficient in using Azure DevOps to manage CI/CD pipelines and artifacts.
• Proficient in source code management using GitHub.
• Competent in planning and managing software quality assurance activities throughout the SDLC to ensure security, reliability, efficiency, and maintainability.
• Proficient in applying critical thinking skills in problem solving.
• Skilled in communicating with functional teams of different technical experience.
Abilities:
• Ability to establish effective working relationships at all levels.
• Ability to work as a part of a team, using both verbal and written communications, to resolve problems, complete project related tasks, and interface to Douglas County departments.
• Ability to clearly document technical configurations and summarize technical information.
• Ability to identify problems, establish facts, correlate data to a series of events, effectively evaluate risk, and develop logical plans of action for implementing and troubleshooting solutions.
• Ability to interpret an extensive variety of technical instructions and environments in written, mathematical or diagrammatic form and understand abstract and concrete concepts
• Ability to Keep up-to-date technically and apply new knowledge to your job.
• Ability to manage multiple activities concurrently, allocating time to each according to prioritization.
• Ability to adhere to County guidelines and standards and be able to work.
• Strong work habits, organization, and time management skills.
CERTIFICATIONS, LICENSES, & REGISTRATIONS:
This position requires successful completion of a criminal background check including fingerprinting through a national database.
Douglas County offers an excellent comprehensive benefit package including but not limited to: Medical/Dental/Vision.
For a more detailed overview please view the full Employee Benefit Guide.
Salary : $120,437 - $180,655
