Saisystems - Senior Database Developer - C#/SQL Server (10-15 yrs)

Job Responsibilities :

- Database Design and Development :

- Design and develop database schemas, tables, views, and indexes based on application requirements.

- Write and optimize complex SQL queries and stored procedures.

- Implement data normalization and de normalization strategies to improve database performance.

Database Maintenance and Optimization :

- Monitor database performance and implement tuning strategies to ensure optimal efficiency.

- Regularly backup and restore databases, ensuring data integrity and availability.

- Manage database security, including user access control and data encryption.

Collaboration and Support :

- Work closely with software developers, data analysts, and system administrators to support application development and dataintegration.

- Provide technical support and troubleshooting for database-related issues.

- Document database design, procedures, and standards.

- Data Integration and Migration:

- Develop ETL (Extract, Transform, Load) processes to integrate data from various sources.

- Plan and execute data migration strategies for system upgrades or changes.

Reporting and Analysis :

- Create and maintain reports and dashboards to support business analysis and decision-making.

- Analyze and interpret complex data sets to provide actionable insights.

Education Necessary for Position :

- Bachelor's degree in computer science, Information Technology, or a related field.

- Advanced degree or relevant certifications (e.g , Microsoft SQL Server, Oracle, MySQL) is a plus.

Experience & Skills Necessary for Position :

- 5+ years of experience with database design, performance tuning, optimization, data warehousing and ETL processes.

- Proficiency in SQL and database management systems (e.g, SQL Server, Oracle, MySQL, PostgreSQL).

- Proficiency with programming languages such as Python, or C# is a plus.

Notice Period - Immediate -15 days