Syms Strategic Group, LLC (SSG)
Senior Database Engineer
Syms Strategic Group, LLC (SSG), Charlottesville, Virginia, United States, 22904
Syms Strategic Group (SSG) is seeking a talented
Senior Database Engineer .
Location:
Remote
Department:
Veterans Affairs
Type:
Full Time
Minimum Experience:
Experienced
Security Clearance Level:
Public Trust (MBI)
US Citizenship required.
Essential Duties and Responsibilities
Establish database management systems, standards, requirements, guidelines, and quality assurance for database deliverables, such as conceptual design, architecture, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan, and security policy.
Work with clients to translate business requirements into a logical model that accurately supports and represents the client’s entity relationship and data flow.
Develop the appropriate database framework to convert the logical model into a physical model including the creation and maintenance of schemas containing tables and columns that support the model.
Make recommendations to maximize operating efficiency, support storage requirements, vendor software updates, enforce data governance, and ensure recovery is maintained.
Participate in quality assurance and develop test application code in client‑server environment.
Required Skills and Experience
Proven track record working with complex database systems and data warehousing solutions.
Experience with database design, architecture, and data modeling.
Proficiency in SQL programming and query optimization.
Strong knowledge of DBMS such as Microsoft SQL Server, Oracle, MySQL, or PostgreSQL.
Experience with performance tuning, indexing, and query optimization techniques.
Ability to write and troubleshoot complex SQL queries, stored procedures, and triggers.
Familiarity with ETL processes and tools (e.g., SSIS, Informatica,end).
Understanding of data warehousing concepts and technologies.
Knowledge of backup and recovery processes.
Experience with database security, user roles, and permissions.
Proficiency in scripting languages such as Python or PowerShell for automation tasks.
Strong analytical and problem‑solving skills.
Excellent communication and collaboration abilities.
Ability to work independently and as part of a team.
Attention to detail and commitment to high‑quality work.
Ability to prioritize multiple tasks and meet deadlines.
Understanding of business processes and requirements gathering.
Ability to mentor and provide technical guidance to junior developers.
Experience in a high‑paced DevOps environment.
Experience in large‑scale enterprise environments.
U.S. Citizenship required.
Professional Certifications None required; advanced certifications in database management systems (e.g., Microsoft SQL Server, Oracle Certified Professional) are preferred.
Years of Professional Experience Eight (8) or more years of relevant experience.
Desired Experience
Electronic Data Interchange (EDI) X.12 medical claims (837, 834, 277, etc.).
Experience with cloud database solutions (e.g., AWS RDS, Azure SQL Database).
Experience with version control systems (e.g., Git).
Familiarity with Agile development methodologies.
Experience working with remote U.S. based teams.
Formal Education Bachelor’s degree in Computer Science, Electronics Engineering, or a related technical discipline. Eight (8) years of additional relevant experience may be substituted for education.
Security Clearance Requirements Must possess or qualify for a Public Trust (MBI).
Equal Opportunity Employer 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.
#J-18808-Ljbffr
Senior Database Engineer .
Location:
Remote
Department:
Veterans Affairs
Type:
Full Time
Minimum Experience:
Experienced
Security Clearance Level:
Public Trust (MBI)
US Citizenship required.
Essential Duties and Responsibilities
Establish database management systems, standards, requirements, guidelines, and quality assurance for database deliverables, such as conceptual design, architecture, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan, and security policy.
Work with clients to translate business requirements into a logical model that accurately supports and represents the client’s entity relationship and data flow.
Develop the appropriate database framework to convert the logical model into a physical model including the creation and maintenance of schemas containing tables and columns that support the model.
Make recommendations to maximize operating efficiency, support storage requirements, vendor software updates, enforce data governance, and ensure recovery is maintained.
Participate in quality assurance and develop test application code in client‑server environment.
Required Skills and Experience
Proven track record working with complex database systems and data warehousing solutions.
Experience with database design, architecture, and data modeling.
Proficiency in SQL programming and query optimization.
Strong knowledge of DBMS such as Microsoft SQL Server, Oracle, MySQL, or PostgreSQL.
Experience with performance tuning, indexing, and query optimization techniques.
Ability to write and troubleshoot complex SQL queries, stored procedures, and triggers.
Familiarity with ETL processes and tools (e.g., SSIS, Informatica,end).
Understanding of data warehousing concepts and technologies.
Knowledge of backup and recovery processes.
Experience with database security, user roles, and permissions.
Proficiency in scripting languages such as Python or PowerShell for automation tasks.
Strong analytical and problem‑solving skills.
Excellent communication and collaboration abilities.
Ability to work independently and as part of a team.
Attention to detail and commitment to high‑quality work.
Ability to prioritize multiple tasks and meet deadlines.
Understanding of business processes and requirements gathering.
Ability to mentor and provide technical guidance to junior developers.
Experience in a high‑paced DevOps environment.
Experience in large‑scale enterprise environments.
U.S. Citizenship required.
Professional Certifications None required; advanced certifications in database management systems (e.g., Microsoft SQL Server, Oracle Certified Professional) are preferred.
Years of Professional Experience Eight (8) or more years of relevant experience.
Desired Experience
Electronic Data Interchange (EDI) X.12 medical claims (837, 834, 277, etc.).
Experience with cloud database solutions (e.g., AWS RDS, Azure SQL Database).
Experience with version control systems (e.g., Git).
Familiarity with Agile development methodologies.
Experience working with remote U.S. based teams.
Formal Education Bachelor’s degree in Computer Science, Electronics Engineering, or a related technical discipline. Eight (8) years of additional relevant experience may be substituted for education.
Security Clearance Requirements Must possess or qualify for a Public Trust (MBI).
Equal Opportunity Employer 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.
#J-18808-Ljbffr