[Remote] SQL Developer, Terra

Note: The job is a remote job and is open to candidates in USA. Brandt Information Services is a leading provider of technology and marketing services for state wildlife and parks agencies. As a SQL Developer, you will design, develop, and maintain databases for enterprise-scale software solutions, collaborating with various teams to ensure data integrity and performance optimization. Responsibilities • Design, develop, and maintain databases, stored procedures, triggers, and views. • Analyze system requirements, client needs, and data models to architect scalable and secure database solutions. • Collaborate closely with software development teams to integrate SQL logic into application features, ensuring seamless data flow • Perform data analysis to identify trends, anomalies, and opportunities that support both customer needs and internal business objectives. • Design and deliver actionable, data-driven reports that provide clear insights, support decision-making, and align with business objectives. • Implement data fixes and enhancements to ensure accuracy, reliability, and responsiveness to customer and internal requests. • Create and maintain technical documentation. • Troubleshoot database performance issues, including query optimization and indexing strategies. • Participate in code reviews, provide technical guidance, and support cross-functional collaboration with software and infrastructure teams. • Ensure data accuracy, consistency, and security across databases. Skills • Must be US Citizen or Green Card holder • 100% Remote - Must reside in the US full time • 4+ years of experience developing and maintaining SQL databases in production environments. • Proficiency with stored procedures, triggers, and performance optimization techniques. • Solid understanding of database security, backups, and version control principles. • Experience collaborating with application developers to integrate database logic into software solutions. • Familiarity with DevOps, CI/CD pipelines, or automated deployment for databases. • Ability to diagnose and resolve database performance issues independently. • Demonstrates ownership of assigned tasks and consistency in delivering quality results. • Expertise in database design, optimization, and data warehousing or ETL frameworks. • Experience architecting scalable database solutions for complex enterprise applications. • Advanced skills in query performance tuning, indexing strategies, and data migration. • Ability to translate business requirements into efficient, secure, and maintainable database models. • Experience mentoring junior developers and guiding database best practices. • Demonstrated ability to balance stakeholder needs with technical priorities. • Previous experience as a SQL Database Developer is helpful as it aligns with role level. • Experience supporting a live functional application. • Expertise in SQL (e.g., T-SQL, PL/SQL) and familiarity with Microsoft SQL Server or similar platforms. • Strong understanding of relational database design, performance tuning, and data normalization. • Proficiency in database tools such as RedGate, SentryOne, or comparable solutions. • Excellent problem-solving skills and the ability to think algorithmically. • Willingness to travel up to 2–3 days quarterly for training and on-site client engagement. • Experience in T-SQL • Experience using SSRS to create reports. • Experience with MySQL (preferred but not required) • Experience with cloud-based databases (AWS RDS, Azure SQL, etc.) • Familiarity with C# or other programming languages and experience integrating databases via APIs. • Exposure to ETL processes and data warehouse concepts Benefits • Health insurance through United Health Care including one plan offering fully covered for the employee (family members can be added at a discounted rate). • Vision insurance fully covered for the employee (family members can be added at a discounted rate). • Dental insurance available for purchase. • Flexible/Open paid time off (PTO) policy (available after 30 days of continuous service). • Nine (9) paid holidays. • 401k plan with matching company contributions. • Annual year-end performance bonuses. • Up to 8 weeks of paid parental leave. • Life insurance fully covered by the company. • Long term disability insurance fully covered by the company. • Free Udemy account for ongoing professional development and learning. Company Overview • Brandt Information Services is a company that creates technology to administer licenses and permits and develops other software. It was founded in 1985, and is headquartered in Tallahassee, Florida, USA, with a workforce of 201-500 employees. Its website is http://www.brandtinfo.com. Apply tot his job Apply To this Job