Database Designer/Developer (4951) jobs in United States
info-icon
This job has closed.
company-logo

SMX · 8 hours ago

Database Designer/Developer (4951)

SMX is a team of technical and domain experts dedicated to enabling mission success. The Database Designer/Developer will support Airworthiness and Flight Clearance systems by ensuring database integrity, performance, and security across Oracle and SQL Server environments.

AnalyticsCloud ComputingCloud Data ServicesCloud SecurityCyber SecurityInformation TechnologyIT ManagementSoftware
badNo H1BnoteSecurity Clearance RequirednoteU.S. Citizen Onlynote

Responsibilities

Performance tuning using Toad and SQL Server Management Console
Data modeling and ERD creation
Writing and optimizing SQL and PL/SQL for Oracle and SQL Server
Evaluating and rewriting procedures and queries for performance improvements
Implementing constraints, foreign keys, primary keys, and indexes
Managing version control and deployment processes using GitLab
Ensuring database security (SQL injection mitigation, Label Security, Column Security, STIG compliance)
Supporting modernization efforts from on-premises to cloud/serverless technologies
Using dynamic SQL and metadata-driven approaches to reduce repetitive coding tasks
Collaborating effectively with cross-functional teams and customers

Qualification

OracleSQL ServerPerformance tuningSecure coding practicesCloud services (AWS)Toad for OracleGitLabData modelingCollaboration

Required

Clearance Required: Secret
Minimum of Interim Secret is required to start
Bachelor's degree and 3+ years of experience
Allowable substitution: Associate's and 7 years of experience, or 9 years of experience in lieu of a degree
Experience designing/developing Oracle and SQL Server databases for application backend required
Solid understanding of Oracle RDBMS concepts required
Experience in performance tuning and query optimization required
Familiarity with secure coding practices and compliance standards, including application STIGs required
Familiarity with cloud services (preferably AWS) and migration from on-prem to serverless required
Toad for Oracle and SQL Server Management Console experience required

Preferred

Experience using GitLab for version control and deployment highly desired

Benefits

Health insurance
Paid leave
Retirement

Company

SMX

twittertwitter
company-logo
SMX is a provider of information technology (IT), services, and advanced engineering with a focus on Cloud Solutions.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Peter LaMontagne
Chief Executive Officer
linkedin
Company data provided by crunchbase