> Markdown version of [/jobs/ext/1793399-database-developer-remote](https://www.wearedevelopers.com/jobs/ext/1793399-database-developer-remote). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database Developer (REMOTE) - **Company:** Koniag Services, Inc. - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, Application Programming Interfaces (APIs), Airflow, Amazon Web Services, Business Logic, Microsoft Azure, Backup Devices, BASIC (Programming Language), Big Data, Cloud Database, Code Reuse, Databases, Continuous Delivery, Continuous Integration, Data Architecture, Information Engineering, Extract Transform Load (ETL), Data Systems, Data Warehousing, Relational Databases, Database Connection, Database Development, Database Queries, Software Debugging, Dimensional Modeling, Entity Relationship Models, Python (Programming Language), PostgreSQL, Microsoft SQL Server, MySQL, NumPy, Performance Tuning, Query Optimization, SQL Stored Procedures, SQL Databases, Systems Integration, Technical Data Management Systems, Transact-SQL, Data Logging, Data Processing, Scripting, Database Optimization, Indexer, Git, Pandas, Information Technology, Tools for Reporting, Software Version Control, Data Pipelines, Serverless Computing - **Published:** July 14, 2026 - **Apply:** https://www.clearancejobs.com/jobs/9026672/database-developer-remote ## About the Role We are seeking a highly skilled and technical Data Developer to join our team. This role will focus on data modeling, building, and optimizing data engineering pipelines, implementing CI/CD practices, and developing serverless functions, across AWS and Azure environments. The ideal candidate will be adept at managing both data engineering and infrastructure requirements to support seamless data processing, deployment, and monitoring., * Bachelor's degree in computer science, Data Development, Information Technology, or a related field * 7+ years of experience in data engineering, data architecture, or similar technical roles * Demonstrated expertise in database systems, data warehousing, and ETL processes * 6+ years as Python programming language expert Required Skills and Competencies: * ETL/ELT Processes - Building data pipelines using a mix of stored procedures, views, and Python scripts. Knowledge of tools like dbt (for SQL transformations) or simple orchestration (e.g., Airflow basics) is a plus * Data Quality & Testing - Implementing checks, validation, and monitoring for pipelines * Version Control & Collaboration - Git for code (Python + SQL scripts), plus experience with CI/CD basics * Performance & Scalability - Tuning for large volumes, understanding indexing/partitioning impacts, and basic cloud database concepts * Soft Skills - Problem-solving for debugging complex queries/pipelines, clear documentation of models and procedures, and ability to collaborate with members of a team Data Modeling: * Strong experience in designing relational schemas * Entity-Relationship (ER) modeling, dimensional modeling, and understanding trade-offs between normalization vs. denormalization * Practical application: Creating efficient table structures, relationships, constraints, and indexes to support query performance and scalability, * Solid proficiency in Python for scripting, automation, and data manipulation * Key libraries: pandas (data wrangling), NumPy, SQL Alchemy or psycopg2/pyodbc (for database connectivity), requests (APIs), and basic ETL scripting * Writing modular code: Functions, classes, error handling, logging, and integrating Python with databases (e.g., running queries, loading data, or orchestrating processes) * Experience building or supporting data pipelines that combine Python with SQL (e.g., Python calling stored procedures or handling complex transformations) Relational Database Experience: * Hands-on work with at least one major RDBMS (e.g., SQL Server for T-SQL/stored procedures, PostgreSQL, MySQL (Preferably) * Understanding of database-specific dialects, as stored procedures and advanced features vary (e.g., T-SQL vs. PL/pgSQL) Other Key Skills: * Excellent problem-solving and analytical abilities with attention to detail * Strong communication and collaboration skills in cross-functional and distributed teams Security Requirement: * Ability to obtain Public Trust ## Description Koniag IT Solutions is in search of a talented Database Developer to join our team. The Database Developer will play a critical role in designing, building, and maintaining data systems to support business needs. The ideal candidate will have a strong background in data architecture, data modeling, and data warehousing, with expertise in data manipulation and transformation., * Mastery of complex queries: JOINs (all types), subqueries, CTEs (Common Table Expressions), window functions (ROW_NUMBER, RANK, LAG/LEAD, etc.), aggregation, pivoting, and recursive queries * Query optimization and performance tuning: Indexing strategies, execution plans, partitioning, and handling large datasets efficiently * Advanced techniques: CASE statements, dynamic SQL, error handling, and working with timestamps/time zones Database Administration & Objects: * Creating and managing stored procedures (for encapsulating business logic, ETL processes, and reusable code) * Creating and optimizing views (including materialized views where supported) for exposing cleaned/transformed data to reporting applications * Other DBA tasks: Triggers, user-defined functions, permissions/security, backups, and basic maintenance * Familiarity with ACID properties, constraints, and database-specific features ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Vectorize all the things! Using linear algebra and NumPy to make your Python code lightning fast.](https://www.wearedevelopers.com/videos/562-vectorize-all-the-things-using-linear-algebra-and-numpy-to-make-your-python-code-lightning-fast) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Find a Developer Job: 12 Best Job Sites For Developers](https://www.wearedevelopers.com/magazine/165-find-a-developer-job-12-best-job-sites-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)