VAYUZ Technologies - SQL Database Developer - Design & Maintenance

Key Responsibilities :

- Develop, debug, and maintain T-SQL and stored procedures.

- Write efficient and scalable SQL queries for complex datasets.

- Perform database performance tuning and query optimization.

- Analyze business requirements and translate them into technical solutions using SQL.

- Work with developers and other stakeholders to ensure data integrity and reliability.

- Write clear and concise technical documentation.

- Troubleshoot and resolve issues related to database performance or data anomalies.

Key Responsibilities :

- Develop, debug, and maintain T-SQL and stored procedures.

- Write efficient and scalable SQL queries for complex datasets.

- Perform database performance tuning and query optimization.

- Analyze business requirements and translate them into technical solutions using SQL.

- Work with developers and other stakeholders to ensure data integrity and reliability.

- Write clear and concise technical documentation.

- Troubleshoot and resolve issues related to database performance or data anomalies.

Technical Skills :

- Strong expertise in Microsoft SQL Server, Oracle, MySQL, and T-SQL/PL-SQL programming.

- Experience in performance tuning, execution plans, and database profiling.

- Knowledge of backup and recovery strategies, disaster recovery solutions, and database replication.

- Experience in creating and managing ETL pipelines and data migration processes.

- Experience with Transparent Data Encryption (TDE) and database security best practices.

- Proficiency in writing optimized Common Table Expressions (CTEs) and indexing strategies.

- Understanding of cloud database services (Azure SQL, AWS RDS, Oracle Cloud, etc. ) is a plus