Senior Database Developer II at SSG

Syms Strategic Group (SSG)is seeking a talented Senior Database Developer - IILocation: RemoteDepartment: Veterans AffairsType:Full TimeMin. Experience:ExperiencedSecurity Clearance Level:Public Trust (MBI)Military Veterans are highly encouraged to apply!Essential Duties and ResponsibilitiesEstablish database management systems standards requirements guidelines and quality assurance for database deliverables such as conceptual design and architecture logical database capacity planning external data interface specification data loading plan data maintenance plan and security policyWork with clients to translate business requirements into a logical model that will accurately support and represent the clients entity relationship and flow of dataDevelop the appropriate database framework to convert the logical model into a physical model including the creation and maintenance of schemas containing windows screens tables and columns and reports that support the modelMake recommendations to maximize operating efficiency support storage requirements and vendor software updates enforce data governance and ensure recovery is maintainedParticipate in quality assurance and develop test application code in client server environmentRequired Skills and ExperienceA proven track record of working with complex database systems and data warehousing solutionsExperience with database design architecture and data modelingProficiency in Structured Query Language (SQL) programming and query optimizationStrong knowledge of database management systems (DBMS) such as Microsoft SQL Server Oracle MySQL or PostgreSQLExperience with performance tuning indexing and database query optimization techniquesAn ability to write and troubleshoot complex SQL queries stored procedures and triggersFamiliarity with Extract Transform and Load (ETL) processes and tools (e.g. SQL Server Integration Services (SSIS) Informatica Talend)An understanding of data warehousing concepts and technologiesKnowledge of backup and recovery processesExperience with database security user roles and permissionsProficiency in scripting languages such as Python or PowerShell for database automation tasksStrong analytical and problem-solving skillsExcellent communication and collaboration abilitiesCapability to work independently and as part of a teamAttention to detail and commitment to high-quality workAbility to prioritize multiple tasks and meet deadlinesA strong understanding of business processes and requirements gatheringAbility to mentor and provide technical guidance to junior developersExperience in a high paced DevOps environment Experience in large scale Enterprise environments U.S. Citizenship required for this positionProfessional CertificationsNone required but advanced certifications in database management systems (e.g. Microsoft SQL Server Oracle Certified Professional) are preferredYears of Professional ExperienceEight (8) or more years of relevant experienceFive (5) or more years of experience in SQL development and database managementDesired experienceElectronic Data Interchange X.12 (EDI) Medical ClaimsX.12 medical claims (etc)Experience in a high paced DevOps environmentExperience working with remote U.S. based teams (Not Offshore teams)Familiarity with cloud database solutions (e.g. Amazon Web Services Relational Database Service (AWS RDS) and Azure SQL Database)Experience with version control systems (e.g. Git)Familiarity with Agile development methodologiesFormal EducationBachelors degree in Computer Science Electronics Engineering or a related technical discipline (Eight plus (8) years of additional relevant experience may be substituted for educationCitizenship RequirementU.S. Citizenship required for this specific opportunitySecurity Clearance RequirementsMust possess or qualify for a Public Trust (MBI)CRITICAL NOTES: SSG will not make assumptions regarding your qualifications. Your answers to the mandatory screening questions must be supported by the information on your resume. Applications with inconsistencies will not be considered.Recruiters or Third parties will not be considered.This is a 100% U.S. based remote position. However candidates from CA CO IL NJ or NY will not be considered.This can be a W-2 or a 1099 positionAll interviews will be conducted on Microsoft Teams with your camera on; there will be no exceptionsAs part of our screening process you will be requested to provide a link to your LinkedIn profileU.S Citizenship is required for this specific opportunity. Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information and be able to obtain a government-granted security clearance. Individuals may also be subject to a background investigation including but not limited to criminal history employment and education verification drug testing and creditworthiness.Syms Strategic Group LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race color religion sex age national origin marital status disability veteran status sexual orientation or genetic information. Required Experience:Senior IC Key Skills Databases,SQL,Database Development,PL/SQL,Microsoft SQL Server,ssrs,Database Design,SSIS,T Sql,Sybase,Data Warehouse,Oracle Employment Type : Full-Time Experience: years Vacancy: 1 Yearly Salary Salary: 97617 - 115205