Position Overview:
We are seeking a skilled and experienced Database Developer to join our dynamic team. The ideal candidate will have a strong background in SQL Server, SQL programming, and C#. This role requires expertise in database design and modeling, as well as performance tuning. Experience with ETL processes, data warehousing, business intelligence tools, and cloud platforms such as Azure is a plus.
Key Responsibilities:
1. Database Management:
– Develop, manage, and maintain SQL Server databases.
– Write efficient and well-documented SQL and C# code.
– Design, implement, and maintain complex database schemas.
2. Database Design & Modeling:
– Create ER diagrams, perform normalization, and design schemas.
– Implement indexing strategies to enhance database performance.
3. Performance Tuning:
– Optimize queries to ensure high performance.
– Implement indexing strategies, partitioning, and load balancing techniques.
4. ETL Processes & Data Warehousing:
– Develop and maintain ETL processes using SSIS.
– Design and implement data warehousing solutions.
– Work with SSRS and SSAS for reporting and analysis.
5. Business Intelligence:
– Utilize BI tools like Tableau and Power BI to create reports and dashboards.
6. Cloud Platforms:
– Work with Azure services such as SQL Database and Cosmos DB.
7. Security:
– Implement data encryption, user access control, and auditing.
– Ensure compliance with GDPR and other data protection regulations.
Qualifications:
Required:
– Proficient in SQL Server, SQL, and C#.
– Strong experience in database design and modeling (ER Diagrams, Normalization, Schema Design).
– Expertise in performance tuning and query optimization.
– Knowledge of indexing strategies and load balancing.
Preferred:
– Experience with ETL processes and tools (SSIS).
– Familiarity with data warehousing and BI tools (SSRS, SSAS, Tableau, Power BI).
– Experience with Azure cloud platform (SQL Database, Cosmos DB).
– Understanding of data security practices, including data encryption, user access control, and auditing.
Additional Skills:
– Excellent problem-solving and analytical skills.
– Strong communication and teamwork abilities.
– Attention to detail and a commitment to quality