SQL Database Architect (Remote Opportunity)

Sorry, this job was removed at 08:13 p.m. (CST) on Tuesday, Sep 24, 2024
Be an Early Applicant
Hiring Remotely in Tampa, FL
Remote
7+ Years Experience
Artificial Intelligence • Cloud • Information Technology • Machine Learning
The Role

VetsEZ is seeking a SQL Database Architect to be a part of a remote team supporting the Department of Veterans Affairs. The ideal candidate needs experience and knowledge in database design, coding, testing, debugging and documentation of software in a variety of programming languages. Has extensive experience in creating strategies for developing IT systems and applications, along with experience in evaluating and selecting alternative and optimal database approaches.

The candidate must reside within the continental US.

Responsibilities:

  • Analyze and maintain the database environment; sustain capacity and performance requirements, optimize and tune databases for maximum efficiency, keep systems and platforms functioning at 99.9% availability, ensure data integrity through daily, weekly, and monthly checklists for monitoring of logs, database growth, audit reports, and backup and recovery processes
  • Maintain and update the database architecture, perform database-related duties such as building schemas, tables, stored procedures, and applying permissions; provide recommendations on policies and procedures, maintain database utilities, and provide reports and scripts for task automation
  • Monitor systems and platforms for availability; oversee database mirroring, database replication and failover, and provide technical recommendations on emerging technologies and trends in the commercial market
  • Participate in technical working groups diagnosing issues, strategizing for future requirements and propose enhancements to increase efficiency
  • Support & Implement SQL Server Analysis, SQL Clustered Column store Index (CCI) technology
  • Generate/produce queries and reports with SQL Management Studio, SQL server tools, - SSAS, SSIS, SSRS, SSMA and Sentry Diagnostic Utilities
  • Create, populate, and maintain databases and data cubes for a variety of analysis and reporting projects
  • Review, enhance, and combine existing data models
  • Create database and file structures to include definitions of file characteristics, file layouts, data dictionary entries, file indices for each subsystem
  • Restore DB from backup and support DR activities
  • Create data as datasets, database schema or views to databases for projects/studies; current and accurate data models and metadata; and data for application development
  • Communicate effectively both orally and written with customers, stakeholders, and technical specialists. Effectively lead detailed technical discussions and develop and present required briefing materials to ensure the customer’s needs are met

Requirements:

  • Bachelor’s degree in Information Technology, Computer Science, Engineering, or any equivalent discipline is required
  • A minimum of 5+ years of relevant work experience required; 8 years of additional relevant experience may be substituted for education
  • Experience with PostgresSQL DDL and DML scripts
  • Python scripting to extract data from JSON endpoint into PostgresSQL DB
  • SSIS ETL project to pull data from SSAS Cube and SQL Server and load into PostgresSQL DB
  • Experience with AWS CloudWatch with RDS Service
  • Solid interpersonal skills and demonstrable team building skills 

Additional Qualifications:

  • Experience with VA Health Portfolio and Informatics Product Line is a plus.
  • Experience in Data Integration Modernizations and Secure Messaging is a plus.
  • Demonstrates attention to detail and ability to prioritize tasks
  • Comfortable in a fast-paced environment
  • Ability to obtain a government clearance 

Benefits:

  • Medical/Dental/Vision
  • 401k with Employer Match 
  • PTO + Federal Holidays
  • Corporate Laptop 
  • Training opportunities
  • Remote Opportunity

Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability, or protected veteran status.

Sorry, we are unable to offer sponsorship at this time

The Company
HQ: San Diego, CA
144 Employees
On-site Workplace
Year Founded: 2012

What We Do

VetsEZ is a digital services firm with expertise in the rapid delivery of modern, user-centric, and data-driven digital solutions that helps the federal government serve our people better. We accelerate the missions of our federal partners through human-centered design (HCD), DevSecOps practices, and automation and by leveraging the power of artificial intelligence, machine learning, and cloud computing in public and private clouds.

VetsEZ is a mature Service-Disabled, Veteran-Owned Small Business (SDVOSB), appraised at CMMI-DEV L3 and certified as an ISO 9001, ISO 20000-1, and ISO 27001 company. VetsEZ is a prime contractor on VA T4NG, NITAAC CIOSP3, SEC OneIT, and GSA MAS.

Jobs at Similar Companies

MassMutual India Logo MassMutual India

Associate

Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana, IND

Silverfort Logo Silverfort

Sales Operations Analyst

Information Technology • Sales • Security • Cybersecurity • Automation
Remote
United States
357 Employees

Jobba Trade Technologies, Inc. Logo Jobba Trade Technologies, Inc.

Customer Success Specialist

Cloud • Information Technology • Productivity • Professional Services • Software
Hybrid
Chicago, IL, USA
45 Employees

Similar Companies Hiring

MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana
Silverfort Thumbnail
Security • Sales • Information Technology • Cybersecurity • Automation
SG
357 Employees
Jobba Trade Technologies, Inc. Thumbnail
Software • Professional Services • Productivity • Information Technology • Cloud
Chicago, IL
45 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account