PL/SQL Developer, PL

Job not on LinkedIn

🕒 June 10

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Spread Tecnologia

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1983

🤝 B2B

📱 Media

🛍️ eCommerce

B2B • Media • eCommerce

Spread Tecnologia is a company dedicated to providing a comprehensive collection of emojis for various devices, including iOS and Android. They offer an easy-to-use platform for searching, copying, and pasting emojis, along with detailed meanings and examples of emoji usage. The company focuses on enhancing the way users communicate through emojis, continuously working to introduce new features and collections.

📋 Description

• Develop, maintain, and optimize stored procedures used in analytical processes and data integrations for BI environments. • Create high-performance SQL queries to support reports, metrics, and management dashboards. • Implement and maintain ETL processes and data load routines. • Collaborate with BI teams and business stakeholders to gather requirements, analyze scenarios, and define technical solutions. • Analyze, diagnose, and resolve issues related to query and database process performance. • Ensure the quality, integrity, and consistency of data provided in analytical environments. • Support maintenance, evolution, incident resolution, and continuous improvement of database processes. • Contribute to optimizing data structures and improving the organization’s analytical routines.

🎯 Requirements

• Solid experience with Microsoft SQL Server and SQL Server Management Studio (SSMS). • Advanced knowledge of T-SQL for development, maintenance, and optimization of complex queries. • Experience manipulating data with SELECT, INSERT, UPDATE, and DELETE statements. • Development and maintenance of stored procedures, functions (scalar and table-valued), and database objects for analytical processes and integrations. • Knowledge of data modeling for Business Intelligence (BI) and Data Warehouse environments, including Star Schema and Snowflake Schema. • Experience with ETL processes (Extract, Transform, Load), ensuring data quality, integrity, and reliability. • Experience with importing, exporting, and processing CSV, XLS, TXT files and other formats used in data integrations. • Knowledge of performance analysis and database tuning, including execution plans, index creation, partitioning, and query optimization. • Understanding of Business Intelligence architecture, metrics, reports, and analytical dashboards. • Experience with technical documentation, code standardization, and application of development best practices. • Ability to work alongside business areas and BI teams to gather requirements and provide strategic data. • Analytical, consultative, and proactive profile, with the ability to identify improvements and propose solutions aligned with business needs. • Strong interpersonal communication and ease interacting with users and multidisciplinary teams.

🏖️ Benefits

• 100% remote work, depending on the contract model • Support, evolution, incident resolution, and continuous improvement of database processes • Technical documentation, code standardization, and application of development best practices • Database performance analysis and tuning