Database Developer (SOC 2136)
Job Summary
A database developer is a software developer who specializes in designing, implementing, and maintaining databases. As a Database developer, you will create and maintain database structures, make sure that data is stored efficiently, and write and test database code, including SQL queries, procedures, and functions.Job Duties:
- Responsible for the design, programming, construction, and implementation of new databases, as well as modifying existing databases for platform updates and changes in user needs
- Collaborate with cross-functional teams, such as software developers, data analysts, and business stakeholders, to understand data requirements and provide database solutions
- Implement and manage access controls, user roles, and permissions to ensure data security and protect against unauthorized access or data breaches.
- Continuously assess database performance, identify bottlenecks, and implement optimization strategies to improve query performance, response times, and overall database efficiency
- Monitor and maintain data quality and integrity by regularly validating data, identifying and resolving data anomalies or inconsistencies, and implementing data cleansing and validation routines
- Craft complex queries and perform data manipulation tasks to extract, insert, update, and delete data efficiently. Optimize query performance through indexing, query tuning, and implementing best practices
Skill & Experience
- Proficiency in working with popular database management systems (DBMS) such as MySQL, Oracle, SQL Server, or PostgreSQL is essential. In-depth knowledge of SQL (Structured Query Language) is crucial for querying and manipulating databases effectively.
- Strong skills in database design, including understanding normalization principles, entity-relationship (ER) modeling, and designing efficient database schemas.
- Effective communication skills to understand requirements from stakeholders, collaborate with data analysts or business users, and translate business needs into database solutions
- Knowledge of database development tools: Familiarity with tools and frameworks specific to database development, such as database design tools, query optimization tools, and data modeling tools.
- Data manipulation and optimization: Expertise in writing complex SQL queries to extract, manipulate, and analyze data efficiently