SQL Developer

Job Description : Responsibilities :

• Design, develop, and maintain relational databases, schemas, tables, stored procedures, functions, views, and triggers using SQL Server, Oracle, MySQL, PostgreSQL, or other relevant database platforms.
• Write and optimize complex SQL queries for data retrieval, manipulation, analysis, and reporting to meet application and business requirements.
• Develop and implement ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI), or other ETL tools, or through custom SQL scripts.
• Ensure the performance, scalability, and stability of database systems through proactive monitoring, performance tuning, and optimization of queries and database configurations.
• Troubleshoot and resolve database-related issues, including query performance problems, data inconsistencies, and database errors, in a timely and efficient manner.
• Collaborate closely with application developers, system administrators, and other technical teams to understand data requirements and ensure seamless integration between applications and databases.
• Participate in the planning and execution of database backups, recovery procedures, and disaster recovery strategies to ensure data availability and business continuity.
• Monitor database performance metrics, identify potential bottlenecks, and implement proactive measures for improvement.
• Create and maintain comprehensive technical documentation for database designs, schemas, stored procedures, and ETL processes.
• Adhere to database security best practices and implement security measures to protect sensitive data.
• Stay up-to-date with the latest SQL Server features, database technologies, and industry best practices.
• Participate in code reviews and contribute to the team's knowledge sharing and best practices.

Technical Skills :

Bonus Points :

ref : hirist.tech)