Database Developer

IT Ally Corporation
United States
about 1 month ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$93,000.0 - $165,000.0
Working hours
Regular working hours
Job source

Tech stack

Third Normal Form Application Programming Interfaces (APIs) Agile Methodology Big Data Software Bug Management Cloudera Impala Databases Data Validation Data Integration Data Integrity Extract Transform Load (ETL) Relational Databases
+14 more
Database Development Database Queries Database Storage Structures Microsoft SQL Server NoSQL SQL Stored Procedures SQL*Plus SQL Databases Freeform SQL Cloud Platform System Database Optimization Software Version Control Database Tools and Utilities Databricks

Job description

We are seeking a detail-oriented and technically skilled Database Developer to support the design, development, maintenance, and optimization of enterprise database solutions. The ideal candidate will have experience working with relational and NoSQL database technologies, performing data integration activities, and supporting ongoing system enhancements and performance improvements.

The Database Developer will collaborate with technical teams, business stakeholders, and data users to ensure data integrity, system performance, and reliable database operations across multiple environments., * Create, modify, and maintain relational database objects in third-normal form (3NF).

  • Develop and execute SQL queries, stored procedures, views, functions, and scripts.
  • Utilize SQL and NoSQL interfaces including MS SQL Server Management Studio, Hue/Impala, SQL*Plus, and related database tools.
  • Modify, load, delete, and query data within DataBricks and MS SQL Server environments.
  • Upload and integrate records from flat files, APIs, and cross-database schemas.
  • Perform data validation, troubleshooting, and root cause analysis for data-related issues.
  • Conduct database performance tuning and optimization activities to improve query efficiency and system responsiveness.
  • Respond to change requests, system enhancements, and bug fixes in a timely manner.
  • Support database deployments, testing, and migration activities.
  • Collaborate with development and business teams to gather requirements and implement technical solutions.
  • Maintain technical documentation related to database structures, processes, and procedures.

Requirements

  • Bachelor’s degree or equivalent experience
  • U.S Citizenship
  • Three (3) or more years of experience in:
  • Creating and modifying relational database objects in third-normal form (3NF)
  • Utilizing SQL and NoSQL interfaces such as MS SQL Server Management Studio, Hue/Impala, and SQL*Plus
  • Modifying, loading, deleting, and querying data within DataBricks and MS SQL Server
  • Uploading records from flat files, APIs, and across database schemas
  • Conducting database performance tuning
  • Responding to change requests, enhancements, and bug fixes
  • Understanding relational database concepts, normalization, and data integrity principles
  • Writing complex SQL queries and troubleshooting database issues
  • Working independently and collaboratively within a team environment
  • Strong analytical, organizational, and communication skills, * Experience working in enterprise or government environments
  • Familiarity with ETL processes and data integration methodologies
  • Knowledge of Agile development methodologies
  • Experience supporting cloud-based data platforms and big data environments
  • Exposure to version control and change management processes

Work Environment

  • Mainly remote, with the ability to travel to Washington, DC for quarterly summits
  • Requires collaboration with geographically dispersed teams

Clearance Requirement (Mandatory)

  • Ability to obtain and maintain a SECRET government security clearance. Already having a clearance is a bonus, but is not required., * Bachelor’s (Preferred), * SQL: 3 years (Required)

Benefits & conditions

Pulled from the full job description Referral program Tuition reimbursement Parental leave 401(k) Health insurance Retirement plan 401(k) matching, * 401(k)

  • 401(k) matching
  • Dental insurance
  • Flexible schedule
  • Health insurance
  • Paid time off
  • Parental leave
  • Referral program
  • Retirement plan
  • Tuition reimbursement

Application Question(s):

  • Are you a U.S. citizen? This is required for this role.
  • Although this is a remote position, mandatory quarterly summits are held in Washington, DC. Do you feel comfortable commuting to this location for these events?
  • Would you be willing to be drug tested as needed?
  • Do you hold an active DoD Security Clearance? If so, for what level?
  • If you do not hold an active security clearance, would you be open to obtaining one after starting work? If you hold an active clearance, respond with N/A.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · World Congress 2021

2:10 min

Why organizations combine big data and machine learning

Ayon Roy · LIVE

3:16 min

Terminology differences between relational and NoSQL databases

Tim Faulkes · LIVE

1:06 min

Developer experience and project variety at scale

Alexandra Petri · World Congress 2023

Videos

See all

Related articles

See all