Database Developer

Expose the power of data

Database Developer

OVERVIEW

The Database Developer builds databases and applications that ensure optimal functionality of the server environment and contributes to accurate, timely delivery of client project data.

ESSENTIAL DUTIES AND RESPONSIBILITIES

  • Identifies/develops database schema, functions, and procedures
  • Automates and optimizes data transfer with multiple sources such as Azure SQL, Hadoop, SQL Server, flat files, etc. using queries, PowerShell, SSIS and SSAS
  • Creates and debugs custom queries and stored procedures for disparate data sources
  • Processes ad hoc data import and export requests
  • Identifies weak/churning code deficiencies and works with team to improve vulnerable sections
  • Troubleshoots applications to provide strategic direction and implementation of solutions
  • Develops methods of aggregating customer data for analytical purposes
  • Identifies and adopts new development methodologies, best practices, and tools
  • Contributes to work estimates, designs, policies, and documentation
  • Develops demos/proofs of concept at the application and/or data persistence layer
  • Designs metric reports, strategy, and procedures for interpreting results/performance/security at an advanced level that spans data persistence layers
  • Designs and implements technical documentation for all internal and client-facing projects

QUALIFICATIONS AND EXPERIENCE

  • Bachelor’s degree in computer science, software engineering, computer engineering, and/or related field and 3+ years of experience as a combination of database administration and development in a live production environment in information technology, finance, analytics, and/or statistics, or equivalent combination of education and experience
  • 2+ years of working with large datasets (example, 10+ million records)
  • Ability to define problems, collect data, establish facts, and draw valid conclusions that demonstrate good judgment
  • Ability to proactively manage workload and priorities with minimal supervision
  • A strong level of proficiency is required in the following areas:
    • Microsoft SQL Server 2012 or newer, Azure SQL
    • Database modeling and design
    • Performance tuning & optimization
      • Indexing
      • Query tuning
    • Unit testing principles, database unit testing
    • Data Encryption Fundamentals
    • Database Documentation, including data flows
    • Database stored procedures, user-defined types, user defined-functions
    • Handling sensitive customer data
    • Experience working with Visual Studio 2010, 2012, TFS, Git
  • The following skills are preferred but not required:
    • Integrating with third-party systems
    • C#, Java, or other OO language
    • Advanced Security
    • Data warehousing
    • Cloud (Azure) Data Environments
    • Familiarity with Cubes
    • Analysis Services
    • Google Analytics
    • Azure Data Lakes
    • PowerShell
    • .NET Framework
    • UML or similar

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to use hands and fingers and reach with hands and arms. The employee frequently is required to sit, talk, and hear. The employee is occasionally required to walk and climb stairs. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 20 pounds. Specific vision abilities required by this job include close vision, peripheral vision, depth perception, and the ability to adjust focus.

WORK ENVIRONMENT

Work is typically performed in office environments. The noise level in the work environment is usually moderate, however, it may vary.

The preceding position description is not intended to describe in detail the multitude of tasks that may be assigned, but rather to provide a general overview of the expectations and responsibilities of this position. As the nature of business demands change, so may the functions of this position. Additional duties and responsibilities may be assigned.

To apply please email us at:

[x]

Contact Us


Catalysis
1601 East John St
Seattle WA 98112
[map]

206-826-8000

General inquiries: info@catalysis.com
Partnership inquiries: connect@catalysis.com

Connect With Us


© 2019 Catalysis LLC. All Rights Reserved. Privacy Policy | Terms of Use