What are the responsibilities and job description for the SQL Developer position at BakeMark?
Purpose:
The SQL Developer is responsible for designing, developing, and maintaining database systems, ensuring data accuracy, security, and efficiency. The developer will work with large datasets, write queries, create reports, and manage database performance.
Job Responsibilities:
Write, optimize, and manage SQL queries in SQL Server Management Studio (SSMS) or similar tools.
Develop reports using SQL Server Reporting Services (SSRS) or open-source platforms.
Maintain and manage Microsoft SQL Server and MySQL databases with at least 100,000 records.
Create and optimize data cubes using SQL Server Analysis Services (SSAS) or other relevant platforms.
Ensure data accuracy and integrity by managing database performance and indexing.
Design database solutions to improve process automation and reporting capabilities.
Collaborate with other teams (internal and external) to support database-related inquiries and issues.
Work closely with the Data Processing Manager to ensure database operations align with business objectives.
Monitor database health and performance using metrics such as latencies, disk I/O, and throughput.
Scope of Position:
Reports to: Data Processing Manager
Supervisory Responsibility (direct reports): None
Budget Accountability/Administration: None
Knowledge & Skills:
Proficient in Microsoft SQL Server and MySQL.
Expertise in writing and optimizing SQL queries.
Knowledge of SSRS for report generation, with open-source reporting tools being an advantage.
Experience with SSAS or other data cube platforms is a strong advantage.
Familiarity with database indexing, optimization, and integrity management.
Basic understanding of cybersecurity practices related to database security.
Ability to manage and automate database processes.
Education:
Bachelor's Degree in Computer Science, Information Technology, or a related field.
Experience:
At least 2 years of experience writing SQL queries or administering databases containing at least 100,000 records.
Compensation:
The starting hourly for this position is $40.00 per hour, with final compensation based on experience and qualifications.
Salary : $40
