[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