SQL Developer - Data Warehousing

Job Description

The impact that you will be making: The role would require you to develop sophisticated products that add value to the client and result in new projects and revenue streams.

What this role entails

1. Design, develop, and optimize SQL databases, tables, views, and stored procedures to meet business requirements and performance goals.
2. Write efficient and high-performing SQL queries to retrieve, manipulate, and analyze data.
3. Ensure data integrity, accuracy, and security through regular monitoring, backups, and data cleansing activities.
4. Identify and resolve database performance bottlenecks, optimizing queries and database configurations.
5. Investigate and resolve database-related issues, including errors, connectivity problems, and data inconsistencies.
6. Collaborate with cross-functional teams, including Data Analysts, Software Developers, and Business Analysts, to support data-driven decision-making.
7. Maintain comprehensive documentation of database schemas, processes, and procedures.
8. Implement and maintain security measures to protect sensitive data and ensure compliance with data protection regulations.
9. Assist in planning and executing database upgrades and migrations.

What lands you in this role

1. Relevant work experience as a SQL Developer or in a similar role.
2. Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
3. Proficiency in SQL, including T-SQL for Microsoft SQL Server or PL/SQL for Oracle.
4. Strong knowledge of database design principles, normalization, and indexing.
5. Experience with database performance tuning and optimization techniques.
6. Familiarity with data modeling tools and techniques.
7. Understanding of data warehousing concepts is a plus.
8. Excellent problem-solving skills and attention to detail.
9. Strong communication and teamwork abilities.
10. Ability to work independently and manage multiple tasks simultaneously.
11. Certifications in database management (e.g., Microsoft Certified: Azure Database Administrator Associate) is a plus.

Skills

SQL, T-SQL, Oracle SQL, Triggers, Stored Procedures, DML, DDL, Functions.