Sr. Database Developer Or Principal Software Engineer - Data Management

Sr. Database Developer or Principal Software Engineer - Data Management

Employment Type: 0 - Full-time Regular

Pay Range: $101,704.00 - 172,754.00

Location: Castle Rock, CO

Overtime Exempt: Y

Elected Office / Department: INFORMATION TECHNOLOGY

This position is responsible for advancing Application Services' technologies and practices, and leading the analysis and design, development, testing, maintenance, and support of Douglas County business applications to ensure effective data management / application services delivery and support enterprise strategies. The person in this role is also responsible for working with Information Technology (IT) Infrastructure Services to ensure server platform and security needs of applications are met. In coordination with the IT Project Management Office, the person in this role will assist in defining project scope, requirements, and timeline.

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.

Classification (job level) and associated compensation are based on qualifications and experience as it relates to the position.

Sr. Database Developer: Generally, the hiring range is $101,704-$127,130 annually.

Principal Software Engineer: Generally, the hiring range is $112,361-$140,451 annually.

This position is based in Colorado and may be eligible for a hybrid work schedule.

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.

• 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/Power BI.

• Performs data modelling and database design for data and reporting applications as well as other applications as needed.

• Performs SQL Server database administration in the development environment.

• Evaluates techniques and design patterns and makes recommendations that will improve solution delivery.

• 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.

• Leads the development and communication of best practices covering development technologies, implementation patterns, integration techniques, design options and application security.

• Acts as a technical leader in a team-based, agile development environment.

• Provides direction and mentoring to Application Services staff assisting them in resolving technical issues and applying best practices.

• Works toward achieving I.T.'s Mission, Vision, and Values.

• Performs other duties as assigned.

SUPERVISION RECEIVED: Plans own work to meet given objectives and processes, works under general direction within a clear framework of accountability, and exercises substantial personal responsibility.

SUPERVISORY RESPONSIBILITIES: Depending on qualifications, this position may assist, apply, and/or influence work, function in a lead capacity, or have supervisory responsibilities delegated from an IT Manager.

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 QUALIFICATIONS:

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.

• A combination of experience and education may be considered for a well-qualified candidate.

• Professional certifications in software languages, cloud platforms and services (Microsoft Azure preferred), software quality, ITIL are preferred.

Sr. Database Developer:

• 5+ years' experience as an engineer in a consulting organization or an internal IT department is required.

Principal Software Engineer:

• 10+ years' experience as an engineer in a consulting organization or an internal IT department is required.

2+ years' experience as a lead is preferred.

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.

• Knowledgeable in application integration best practices, event driven processing, and API development.

• Well-versed in systems integration, application architecture, application security, database design, and object-oriented design.

• Knowledgeable in enterprise architecture and associated frameworks.

• 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.

• Working knowledge of waterwall and agile methodologies.

• Understand artificial intelligence and machine learning.

• Familiar with ITIL for IT Service Management.

• Is fully familiar with recognized industry bodies of knowledge both generic and specific.

• Actively seeks out new knowledge for own personal development and the mentoring or coaching of others.

• Develops a wider breadth of knowledge across the industry or business.

• Applies knowledge to help to define the standards which others will apply.

SKILLS:

Application Support

Drafts and maintains procedures and documentation for applications support. Manages application enhancements to improve business performance. Advises on application security, licensing, upgrades, backups, and disaster recovery needs. Ensures that all requests for support are dealt with according to set standards and procedures.

Data Management

Devises and implements master data management processes, including classification, security, quality, ethical principles, retrieval, and retention processes. Derives data management structures and metadata to support consistency of information retrieval, combination, analysis, pattern recognition and interpretation, throughout the organization. Plans effective data storage, sharing and publishing within the organization. Independently validates external information from multiple sources. Assesses issues which might prevent the organization from making maximum use of its information assets.

Data Modeling and Design

Sets standards for data modelling and design tools and techniques, advises on their application, and ensures compliance. Manages the investigation of corporate data requirements, and co-ordinates the application of data analysis, design, and modelling techniques, based upon a detailed understanding of the corporate information requirements, in order to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions). Manages the iteration, review and maintenance of data requirements and data models.

Database Administration

Develops and maintains procedures and documentation for databases. Identifies, evaluates, and manages the adoption of appropriate database administration tools and processes, including automation. Contributes to the setting of standards for definition, security and integrity of database objects and ensures conformance to these standards. Manages database configuration including installing and upgrading software and maintaining relevant documentation. Monitors database activity and resource usage. Optimizes database performance and plans for forecast resource needs.

Database Design

Provides expert guidance in the selection, provision and use of database and data warehouse architectures, software, and facilities. Provides specialist expertise in the design characteristics of database management systems (DBMS) or data warehouse products/services. Ensures that physical database design policy supports transactional data requirements for performance and availability. Ensures that data warehouse design policy supports demands for business intelligence and data analytics.

Methods and Tools

Provides advice, guidance, and expertise to promote adoption of methods and tools and adherence to policies and standards. Evaluates and selects appropriate methods and tools in line with agreed policies and standards. Implements methods and tools at programme, project and team level including selection and tailoring in line with agreed standards. Manages reviews of the benefits and value of methods and tools. Identifies and recommends improvements. Contributes to organizational policies, standards, and guidelines for methods and tools.

Programming / Software Development

Takes technical responsibility across all stages and iterations of software development. Plans and drives software construction activities. Adopts and adapts appropriate software development methods, tools and techniques selecting appropriately from predictive (plan-driven) approaches or adaptive (iterative/agile) approaches. Measures and monitors applications of project/team standards for software construction including software security. Contributes to the development of organizational policies, standards, and guidelines for software development.

Software Design

Selects, adopts and adapts appropriate software design methods, tools and techniques; selecting appropriately from predictive (plan-driven) approaches or adaptive (iterative/agile) approaches. Specifies and designs large or complex software components. Undertakes impact analysis on major design options, makes recommendations and assesses and manages associated risks. Specifies prototypes/simulations to enable informed decision making. Evaluates the quality of others' systems designs to ensure adherence to standards and identifies corrective action, if needed. Ensures that the system design balances functional, quality, security, and systems management requirements. Contributes to development of organizational software design and architecture policies and standards.

Testing

Coordinates and manages planning of the system and/or acceptance tests, including software security testing, within a development or integration project or programmer. Takes responsibility for integrity of testing and acceptance activities and coordinates the execution of these activities. Provides authoritative advice and guidance on any aspect of test planning and execution. Defines and communicates the test strategy for the project. Manages all test processes, including test plans, resources, costs, timescales, test deliverables and traceability. Manages client relationships with respect to testing matters. Identifies process improvements and contributes to corporate testing standards and definition of best practice.

Technology Stack:

• SQL Server, T-SQL, Stored Procedures, PowerShell, Python, C#, .NET framework

• Azure Services including Azure Data Lake, Azure Data Factory, Azure SQL, Azure App Service, and Azure Service Bus

• GitHub

• Azure DevOps

• SSIS, SSRS

• Master Data Services

• Power BI

ABILITIES:

• Demonstrates leadership.

• Communicates effectively, both formally and informally.

• Facilitates collaboration between stakeholders who have diverse objectives.

• Analyses, designs, plans, executes, and evaluates work to time, cost and quality targets.

• Analyses requirements and advises on scope and options for continuous operational improvement.

• Takes all requirements into account when making proposals.

• Demonstrates creativity, innovation, and ethical thinking in applying solutions for the benefit of the customer/stakeholder

• Advises on the available standards, methods, tools and applications relevant to own specialty and can make appropriate choices from alternatives.

• Maintains an awareness of developments in the industry.

• Takes initiative to keep skills up to date.

• Mentors colleagues.

• Assesses and evaluates risk.

• Proactively ensures security is appropriately addressed within their area by self and others.

CERTIFICATIONS, LICENSES, & REGISTRATIONS: This position requires successful completion of a criminal background check including fingerprinting through a national database.

WORK ENVIRONMENT:

Physical Work Environment: Work is generally performed in a typical office environment. Drives to various County buildings as needed. Ability to work beyond scheduled hours and respond to production issues and business needs in a time critical manner is required.

Hybrid work: Currently, Douglas County IT provides hybrid work options. Remote work, including days permitted, is dependent on the ability to meet the needs of the job and on supervisory approval.

Physical Demands: Position is primarily sedentary. Requires the ability to communicate clearly and professionally, understand and be understood. Frequent computer use.

Material and Equipment Directly Used: Personal computer, telephone, iPad or similar device, office equipment such as scanner, copies, and fax machine. May use audio/visual equipment for presentations.

ADDITIONAL INFORMATION:

Closing Date: 04/5/2024 5:59PM MST. Review of applications will begin immediately and continue until a suitable candidate is selected.

The job details outlined in this posting may represent a modified summary of the full job description. For a full copy of the job description CLICK HERE to view our job classifications.

In the event of an emergency/disaster in or near the County, all County employees are expected to make every effort to be available to assist the County Manager, Elected/Appointed Officials and Department Directors to ensure the continued operation of any and all necessary County functions. This may mean being available to perform additional duties and hours beyond what is normally required. In the event that an exempt employee does work more than 40 hours a week in support of County operations during an emergency, such employee may receive overtime or other appropriate wage compensation in accordance with existing County policies or at the discretion of the County.