SQL Developer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
SQL Developer at Frontline Managed Services responsible for database solutions. Designing, optimizing, and maintaining secure and efficient databases for various applications.
Responsibilities:
- Develop, test, and maintain complex SQL queries, stored procedures, functions, triggers, cursors, and views.
- Design and implement transactional SQL scripts to support data processing, automation, and system integrations.
- Create and maintain scalable database solutions for business applications and reporting requirements.
- Implement data validation, error handling, and logging mechanisms within SQL processes.
- Optimize database performance through query tuning, indexing strategies, and execution plan analysis.
- Analyze and resolve database bottlenecks, locking issues, and performance degradation.
- Monitor database performance and proactively identify opportunities for improvement.
- Perform database maintenance activities including backups, restores, archiving, and integrity checks.
- Monitor database health to ensure high availability, reliability, and security.
- Troubleshoot database-related issues and provide timely resolutions to minimize downtime.
- Support ETL processes, data migration, and system integration activities.
- Collaborate with development and integration teams to support data movement and transformation requirements.
- Validate data accuracy and integrity during migration and integration processes.
- Maintain database documentation, technical specifications, standards, and best practices.
- Ensure compliance with data governance, security, and company policies.
Requirements:
- Bachelor’s degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and experience.
- Minimum of 5 years of experience as a SQL Developer, Database Developer, or in a similar role.
- Strong hands-on experience with:
- SQL Server, MySQL, PostgreSQL, and/or Oracle databases
- T-SQL and/or PL/SQL scripting
- Stored procedures, triggers, functions, and cursors
- Transactional SQL scripting
- Database optimization and performance tuning
- Query execution plans and indexing strategies
- Database backup, recovery, and maintenance processes
- Experience with database monitoring and troubleshooting tools.
- Knowledge of ETL processes, data integration, and migration concepts.
- Familiarity with version control systems such as Git.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent verbal and written communication skills.
- Ability to manage multiple priorities and work collaboratively in a team environment.
Benefits:
- Health insurance
- Paid time off
- Flexible work hours
Similar Jobs
Senior 3D Pipeline Developer – Houdini
Senior 3D Pipeline Developer creating automation tooling for Barnstorm VFX. Developing 3D workflows in Houdini and Maya while mentoring junior developers in a collaborative environment.
React Native Developer – TV
Join as a React Native Developer for an international client in the TV sector, working fully remote. Engage in functional experiences and create entertainment solutions with innovative technology.
Developer
Developer building web applications using JavaScript, React, and TypeScript at a global engineering firm.
Manager, Engineering – Integrations
Engineering Manager leading the Integration team at Wrapbook. Building high performance teams and high quality products for the project economy.
Engineering Manager
Engineering Manager at Wrapbook, building technology for the project economy in the entertainment industry. Leading teams and guiding product development in a high-growth environment.
Director of Product Management – Developer Tools
Director of Product Management overseeing product teams for APILayer, Filestack, Froala, and FusionCharts. Responsible for strategy, customer engagement, and team development in a remote capacity.
General Manager – Developer Tools
General Manager leading multi-product Developer Tools business. Focus on revenue growth and performance improvement, integrating software sales with professional services.
NPS Research Developer – Principal Investigator
Research Developer Engineer leading energy initiatives at the Naval Postgraduate School in Monterey, California. Supporting Department of Defense operational and installation energy initiatives with advanced research and engineering innovation.
AI/ML Developer – Specialist, Platform & Enablement
AI/ML Developer enabling engineering teams on AI platforms and best practices for solutions deployment. Focused on documentation and cross-team communication.
Developer, High-Level Platform – COBOL
Desenvolvedor COBOL integrando soluções digitais para empresas em transformação digital. Colaborando em equipe para inovar na plataforma IBM e mainframe.
VP, Engineering – AI
VP Engineering and AI at Podimetrics managing data science and analytics for healthcare improvement. Leaders multidisciplinary teams ensuring AI-enabled capabilities enhance patient care and business growth.
Senior SAP ABAP Developer
Senior SAP ABAP Developer working on complex SAP IS-U solutions for Swiss utility customers. Involvement in projects from analysis to implementation with a focus on utility services.
Senior Appian Developer
Senior Appian Developer supporting federal customers with high-performance IT solutions. Engaging in software development using Appian and Agile methodologies.
Lead ERP Programmer
ERP Programmer-Lead designing and developing solutions for UT San Antonio's ERP applications. Managing application functionalities and collaborating with IT teams to ensure data quality and resolve issues.
Técnico de Engenharia de Qualidade
Quality Engineering Technician executing manual and automated software tests. Collaborating with teams to enhance software quality and contribute to continuous improvement processes.
Analista de Engenharia de Automação de Qualidade SR
Senior analyst for automated quality engineering at Inmetrics. Develops automated testing strategies and ensures software quality across projects.
Analista de Engenharia de Automação de Qualidade Sênior
Quality Automation Analyst developing and implementing testing strategies for digital transformation at Inmetrics. Collaborating with teams to ensure software quality through automated solutions.
Engineering Designer, Site Civil, Energy Practice
Engineering Designer in Energy Group at Woolpert creating site layout plans and utilizing AutoCAD Civil 3D. Strong interest in survey, hydrology, and project delivery with occasional field work.
C# Developer
C# Developer at SONDA working remotely on system integration and corporate maintenance projects. Involves teamwork and SLA management with flexibility and professional development opportunities.
Windchill Developer
Windchill Developer joining EPLM Team to develop software and maintain client relationships. Requires strong Java and Windchill development experience with a focus on project efficiency.