Informatica developer Jobs in Virginia Beach, VA

Syms Strategic Group (SSG)  is seeking a talented Senior Database Engineer

Location : Remote

Department : Veterans Affairs

Type :   Full Time

Min. Experience :   Experienced

Security Clearance Level :   Public Trust (MBI)

Military Veterans are highly encouraged to apply!

Essential Duties and Responsibilities

Establish 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 policy

Work with clients to translate business requirements into a logical model that will accurately support and represent the client’s entity relationship and flow of data

Develop 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 model

Make recommendations to maximize operating efficiency, support storage requirements and 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

A proven track record of working with complex database systems and data warehousing solutions

Experience with database design, architecture, and data modeling

Proficiency in Structured Query Language (SQL) programming and query optimization

Strong knowledge of database management systems (DBMS) such as Microsoft SQL Server, Oracle, MySQL, or PostgreSQL

Experience with performance tuning, indexing, and database query optimization techniques

An ability to write and troubleshoot complex SQL queries, stored procedures, and triggers

Familiarity 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 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 database automation tasks

Strong analytical and problem-solving skills

Excellent communication and collaboration abilities

Capability 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

A strong 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 for this position

Professional Certifications None required but 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

Five (5) or more years of experience in SQL development and database management

Desired experience Electronic Data Interchange X.12 (EDI) Medical Claims

• X.12 medical claims (837, 834, 277, etc)

Experience in a high paced DevOps environment

Experience 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 methodologies

Formal Education Bachelor’s degree in Computer Science, Electronics Engineering, or a related technical discipline (Eight plus (8+) years of additional relevant experience may be substituted for education

Citizenship Requirement U.S. Citizenship required for this specific opportunity

Security Clearance Requirements Must 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 position

All interviews will be conducted on Microsoft Teams with your camera on; there will be no exceptions

As part of our screening process, you will be requested to provide a link to your LinkedIn profile

U.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.

Powered by JazzHR