Senior Database Developer

Syms Strategic Group, LLC (SSG)•Salisbury, MD

1d•Remote

About The Position

Syms Strategic Group (SSG) is seeking a talented Senior Database Developer Location: Remote Department: Veterans Affairs (VA) 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, columns, and reports that support the model Make recommendations to maximize opening 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

Requirements

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 performing 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., 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
An ability to prioritize multiple tasks and meet deadlines
A strong understanding of business processes and requirements gathering
An ability to mentor and provide technical guidance to junior developers
Eight (8) or more years of professional experience
Eight (8) or more years of experience in SQL development and database management
Bachelor’s degree in Computer Science, Electronics Engineering, or other engineering/technical discipline
U.S. Citizenship required for this specific opportunity
Must possess or qualify for a Public Trust (MBI)

Nice To Haves

Electronic Data Interchange X.12 (EDI) Medical Claims
X.12 medical claims (837, 834, 277, etc)
Experience with T-SQL
Experience in a high paced DevOps environment
Experience working with remote U.S. based teams (Not Offshore teams)
Master’s degree in Computer Science, Electronics Engineering, or other engineering/technical discipline
Familiarity with cloud database solutions (e.g., Amazon Web Services Relational Database Service (AWS RDS), Azure SQL Database)
Experience with version control systems (e.g., Git)
Familiarity with Agile development methodologies
None required, but advanced certifications in database management systems (e.g., Microsoft SQL Server, Oracle Certified Professional) are preferred

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, columns, and reports that support the model
Make recommendations to maximize opening 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

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume