VetsEZ
SQL Database Architect (Remote Opportunity)
VetsEZ, Tampa, Florida, us, 33646
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 processesMaintain 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 automationMonitor systems and platforms for availability; oversee database mirroring, database replication and failover, and provide technical recommendations on emerging technologies and trends in the commercial marketParticipate in technical working groups diagnosing issues, strategizing for future requirements and propose enhancements to increase efficiencySupport & Implement SQL Server Analysis, SQL Clustered Column store Index (CCI) technologyGenerate/produce queries and reports with SQL Management Studio, SQL server tools, - SSAS, SSIS, SSRS, SSMA and Sentry Diagnostic UtilitiesCreate, populate, and maintain databases and data cubes for a variety of analysis and reporting projectsReview, enhance, and combine existing data modelsCreate database and file structures to include definitions of file characteristics, file layouts, data dictionary entries, file indices for each subsystemRestore DB from backup and support DR activitiesCreate data as datasets, database schema or views to databases for projects/studies; current and accurate data models and metadata; and data for application developmentCommunicate 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 metRequirements:
Bachelor's degree in Information Technology, Computer Science, Engineering, or any equivalent discipline is requiredA minimum of 5+ years of relevant work experience required; 8 years of additional relevant experience may be substituted for educationExperience with PostgresSQL DDL and DML scriptsPython scripting to extract data from JSON endpoint into PostgresSQL DBSSIS ETL project to pull data from SSAS Cube and SQL Server and load into PostgresSQL DBExperience with AWS CloudWatch with RDS ServiceSolid interpersonal skills and demonstrable team building skillsAdditional 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 tasksComfortable in a fast-paced environmentAbility to obtain a government clearanceBenefits:
Medical/Dental/Vision401k with Employer MatchPTO + Federal HolidaysCorporate LaptopTraining opportunitiesRemote 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
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 processesMaintain 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 automationMonitor systems and platforms for availability; oversee database mirroring, database replication and failover, and provide technical recommendations on emerging technologies and trends in the commercial marketParticipate in technical working groups diagnosing issues, strategizing for future requirements and propose enhancements to increase efficiencySupport & Implement SQL Server Analysis, SQL Clustered Column store Index (CCI) technologyGenerate/produce queries and reports with SQL Management Studio, SQL server tools, - SSAS, SSIS, SSRS, SSMA and Sentry Diagnostic UtilitiesCreate, populate, and maintain databases and data cubes for a variety of analysis and reporting projectsReview, enhance, and combine existing data modelsCreate database and file structures to include definitions of file characteristics, file layouts, data dictionary entries, file indices for each subsystemRestore DB from backup and support DR activitiesCreate data as datasets, database schema or views to databases for projects/studies; current and accurate data models and metadata; and data for application developmentCommunicate 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 metRequirements:
Bachelor's degree in Information Technology, Computer Science, Engineering, or any equivalent discipline is requiredA minimum of 5+ years of relevant work experience required; 8 years of additional relevant experience may be substituted for educationExperience with PostgresSQL DDL and DML scriptsPython scripting to extract data from JSON endpoint into PostgresSQL DBSSIS ETL project to pull data from SSAS Cube and SQL Server and load into PostgresSQL DBExperience with AWS CloudWatch with RDS ServiceSolid interpersonal skills and demonstrable team building skillsAdditional 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 tasksComfortable in a fast-paced environmentAbility to obtain a government clearanceBenefits:
Medical/Dental/Vision401k with Employer MatchPTO + Federal HolidaysCorporate LaptopTraining opportunitiesRemote 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