SQL Production Support

As a SQL Development and Production Support Engineer at Datafortune Software Solution, you will play a crucial role in supporting and maintaining SQL-based applications, optimizing SQL queries, and ensuring the stability and performance of production databases. Your responsibilities will include: - Develop, test, and maintain SQL queries, stored procedures, and database scripts. - Provide production support for database-related issues, troubleshooting and resolving incidents effectively. - Perform data analysis and contribute to data migration or ETL activities. - Collaborate with development and QA teams to ensure database stability and performance. - Work with team members to resolve technical issues and implement solutions promptly. - Perform basic query optimization and performance tuning to enhance database efficiency. - Maintain documentation related to SQL code and support processes. - Monitor nightly jobs and proactively handle failures or performance lags. To excel in this role, you should possess the following qualifications and skills: - 12 years of hands-on experience with SQL databases like MySQL, SQL Server, PostgreSQL, or Oracle. - Proficiency in writing complex SQL queries, joins, subqueries, and aggregations. - Basic knowledge of performance tuning and query optimization techniques. - Familiarity with version control tools such as Git. - Knowledge of ETL and reporting tools like SSIS, Talend, or Power BI would be advantageous. - Strong analytical and problem-solving abilities. - Positive attitude, proactive approach to tasks, and excellent communication skills. - Ability to work independently and collaboratively in a team environment. - Flexibility to work in night shifts and provide on-call support when necessary. Join Datafortune Software Solution and leverage your SQL expertise to drive the success of our database operations. As a SQL Development and Production Support Engineer at Datafortune Software Solution, you will play a crucial role in supporting and maintaining SQL-based applications, optimizing SQL queries, and ensuring the stability and performance of production databases. Your responsibilities will include: - Develop, test, and maintain SQL queries, stored procedures, and database scripts. - Provide production support for database-related issues, troubleshooting and resolving incidents effectively. - Perform data analysis and contribute to data migration or ETL activities. - Collaborate with development and QA teams to ensure database stability and performance. - Work with team members to resolve technical issues and implement solutions promptly. - Perform basic query optimization and performance tuning to enhance database efficiency. - Maintain documentation related to SQL code and support processes. - Monitor nightly jobs and proactively handle failures or performance lags. To excel in this role, you should possess the following qualifications and skills: - 12 years of hands-on experience with SQL databases like MySQL, SQL Server, PostgreSQL, or Oracle. - Proficiency in writing complex SQL queries, joins, subqueries, and aggregations. - Basic knowledge of performance tuning and query optimization techniques. - Familiarity with version control tools such as Git. - Knowledge of ETL and reporting tools like SSIS, Talend, or Power BI would be advantageous. - Strong analytical and problem-solving abilities. - Positive attitude, proactive approach to tasks, and excellent communication skills. - Ability to work independently and collaboratively in a team environment. - Flexibility to work in night shifts and provide on-call support when necessary. Join Datafortune Software Solution and leverage your SQL expertise to drive the success of our database operations.