Summary
As a SQL Data Developer at Civix, you will be responsible for designing, developing, and maintaining our SQL-based data systems and databases. Your primary focus will be as a member of a development team working to ensure efficient and accurate data management, manipulation, and retrieval to support various business operations and analytical needs. You will collaborate with cross-functional teams, including data analysts, data scientists, and software developers, to enable data-driven decision-making and enhance our data capabilities.
Responsibilities
-
Database Design and Development: Design, implement, and maintain SQL databases to efficiently store and manage large volumes of data while ensuring data integrity and security.
-
Database Migration: Design and implement data migration strategies from older to newer version of products.
-
Query Optimization: Optimize SQL queries to enhance database performance, reduce response times, and ensure scalability for handling increasing data volumes.
-
ETL Processes: Develop and maintain Extract, Transform, Load (ETL) processes to facilitate seamless data integration from various sources into our databases.
-
Data Modeling: Create and manage data models to ensure effective data representation and facilitate reporting and analytics requirements.
-
Data Security: Implement robust data security measures, including access controls, encryption, and data masking, to protect sensitive information.
-
Troubleshooting and Debugging: Identify and resolve database-related issues and performance bottlenecks in a timely manner.
-
Performance Monitoring: Monitor database performance, proactively identify potential issues, and implement necessary optimizations.
-
Documentation: Create and maintain comprehensive technical documentation related to databases, data models, and ETL processes.
-
Collaborate with Teams: Work closely with data analysts, data scientists, and software developers to understand data requirements and deliver solutions that meet business needs.
-
Stay Updated: Keep up-to-date with the latest trends, best practices, and emerging technologies in SQL database development and data management.
Requirements
-
Education: Bachelor’s degree in Computer Science, Information Systems, or a related field.