Database Developer

SQL Database Developer

About us At Strategic Solutions Group (SSG), we're not just redefining public health; we're leading a revolution in cutting-edge software solutions. Our mission is to transform the landscape of public health by empowering organizations through the modernization of technology. Using our innovative low-code platform, Casetivity, we deploy enterprise solutions that revolutionize health programs like Immunization Registries, Disease Surveillance Systems, and Early Intervention.

Why join SSG? Excitement is in the air at SSG as we experience incredible growth! We're expanding our footprint in the public health industry and are on the lookout for tech enthusiasts who are passionate about making a positive impact in healthcare technology. Ready to be a trailblazer in the public health sector? Join us and play a pivotal role in reshaping the capacity of public health organizations!

What sets us apart? Passionate Team Dynamics: Our success is fueled by a powerhouse team of critical thinkers and problem solvers who genuinely love what they do. Join forces with us to turn challenges into triumphs!Collaborative Innovation: Thrive in an environment where diversity and collaboration are the driving forces behind our success. Our inclusive remote environment encourages optimism, creativity, and critical thinking to build solutions that break new ground.Impactful Contributions: Be a driving force behind transformative change in healthcare and society. Your work at SSG will directly contribute to the modernization of technology solutions, revolutionizing public health organizations across the US.Continuous Learning: Immerse yourself in a culture that values open communication and unwavering commitment to continuous learning. Fuel your professional growth with opportunities that keep you at the forefront of the ever-evolving industry.

Ready to embark on an exhilarating journey with SSG? Join us in shaping the future of public health technology – Apply now and be part of our legacy!

What sets you apart?As the ideal candidate for the SQL Database Developer position, you will have a deep understanding of data modeling and be well-versed in data normalization principles. You will create data models for new applications to meet both functional and performance needs. Your experience in data conversion projects will enable you to work with project teams.

Your Role as a SQL Database DeveloperYou will optimize existing data models and assist development teams in understanding their data models. In addressing complex production issues involving queries that affect large data sets, you will validate and safeguard against data corruption while optimizing problem queries. You will develop or review highly tuned SQL scripts with developers and execute them effectively. Your thorough understanding of relational database architecture, including Oracle, PostgreSQL, and MS SQL Server, will be crucial in comprehending the intricate interactions with applications. You will maintain existing database schemas for security, speed, and data optimization, demonstrating your expertise in this area.

As an advocate for fundamental database schema best practices, you will share your knowledge with various teams, including developers, QA, and development architects. Your ability to promote these best practices across teams will contribute to the organization's success.

We are looking for a skilled SQL Developer with strong expertise in Oracle, PostgreSQL, RDS, and AWS. This role involves hands-on responsibilities in database query writing, debugging, performance tuning, and writing data conversion SQL scripts. Your key responsibilities will include:Developing and optimizing complex SQL queries for Oracle, PostgreSQL databases, and Amazon RDS on AWSConducting thorough debugging and performance tuning to ensure efficient database operationsWriting and maintaining SQL scripts for data conversion, focusing on data integrity and accuracyCollaborating with development teams and stakeholders to understand database requirements and investigate production issues to create and integrate the solutions effectivelyMaintaining and optimizing databases for performance, security, and scalability across Oracle, PostgreSQL, and Amazon RDS environments

Our Typical Stacks:React/Java/J2EE/Spring/Hibernate, PostgreSQL, Oracle Database, MS SQL Server, Tomcat/WebLogic, Windows/Linux, and AWS (Amazon Web Services)Whatever technology provides the best solution for the project

Preferred Career Experience Degree in Computer Science/IT or equivalent practical experienceAdvanced experience with Oracle and PostgreSQL databases, along with Amazon RDS and AWSExpertise in SQL query writing, debugging, and performance tuningProficiency in data modeling and data normalizationFamiliarity with Java/Spring Boot development and version control systems like GitKnowledge of database schema versioning tools, ORMs, and cloud-based data storageAgile methodology experience and adaptability to fast-paced development environmentAbility to optimize existing data models working with other developers in a teamExperience in addressing complex production issues involving large data sets, including data validation, corruption prevention, and query optimizationProficiency in developing, reviewing, and executing highly tuned SQL scripts in collaboration with developers

QualificationsWe are looking to build and grow diverse, equitable, and inclusive teams. We value transferrable skills and experience. We encourage that you apply even if you do not meet all the qualifications below:Knowledge of working with healthcare-related data (EHRs (electronic health records), Lab Tests, Claims Data, etc.)Expert knowledge of database schema versioning tools such as Liquibase and ORMs such as Hibernate, JPAThe ability to work with code outside of the database, specifically Java/Spring Boot developmentExperience working with version control systems like Git, and an understanding of best practices for code management and collaborationKnowledge of cloud-based data storage and computing platforms, such as AWS, Google Cloud Platform, or Microsoft Azure, and experience working with their data servicesFamiliarity with agile methodologies, such as Scrum or Kanban, and the ability to adapt to a fast-paced, iterative development environmentAbility and willingness to contribute to other functional solution domains, such as: requirement management, low code platform solution design and configuration, etc.

How we care about you We value your time and offer full-time remote work based in the US.We are committed to equitable compensation based on your career background and transferrable skills. Full-time roles are eligible for performance bonuses.We understand your time is valuable. We offer flexible time off for your vacations, wellness needs, etc. We also offer paid time off as needed for bereavement and jury duty.We care about your health and wellness needs. We offer extensive healthcare benefits packages (medical, dental, vision, FSA plans) across the US.SSG covers 100% of the cost for your basic life insurance plan, AD&D, short and long-term disability.We support your financial health by matching up to 3.5% in your 401(k) contributions.We provide the tools to be successful. We’ll send you a company-issued laptop, tools, and tech accessories for your workspace. We also offer a $500 stipend for you to use towards additional workspace needs.Your feedback is important and your voice matters. Our inclusive environment values diversity, innovation, and your perspective.We care about your professional growth. We support continued professional career development, education, and certifications that would add skills to your current or next role with SSG.We like saving you money. We have an employee program for discounts on retail, amusement parks, movies, fun experiences, company gifts, and more!

Join us at SSG, an equal opportunity employer where your voice matters, and your contributions make a lasting impact on public health. We look forward to learning more about the unique value you bring to elevate this role and contribute to our exciting journey of technological transformation. Apply now and be part of the SSG success story!

Key Skills

• PostgreSQL