Senior Database Developer - II

SSG Official Website; Remote; GBP 60,000 - 80,000; Full time

Job summary

A technology solutions firm is seeking a Senior Database Developer - II for a remote role. The ideal candidate will have extensive experience with complex database systems and demonstrate proficiency in SQL, database design, and data warehousing technologies. Primary responsibilities include establishing database management standards and translating business requirements into effective data solutions. Strong analytical skills and the ability to work collaboratively are essential for success in this position.

Qualifications

• Proven track record with complex database systems and data warehousing.
• Experience in database design, architecture, and data modeling required.
• Ability to write and troubleshoot complex SQL queries and stored procedures.
• Experience with database security, user roles, and permissions.

Responsibilities

• Establish database management systems and quality assurance for deliverables.
• Translate business requirements into logical data models.
• Develop framework for converting logical models into physical models.
• Participate in quality assurance and develop test application code.

Skills

Database management systems

Structured Query Language (SQL)

Database design and architecture

Performance tuning

Data warehousing concepts

Scripting languages (Python, PowerShell)

Extract, Transform, and Load (ETL)

Agile methodologies

Education

Bachelor’s degree in Computer Science or related field

Tools

Microsoft SQL Server

Oracle

MySQL

PostgreSQL

SQL Server Integration Services (SSIS)

Git

Job description

Syms Strategic Group (SSG) is seeking a talented Senior Database Developer - II

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

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)

Security Clearance Requirements

Must possess or qualify for a Public Trust (MBI)

Equal Opportunity Statement

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.