DBP - SQL Developer - Database Design

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 Skills :
• SQL : Excellent and demonstrable proficiency in writing complex SQL queries, stored procedures, functions, views, and triggers using Transact-SQL (for SQL Server), PL / SQL (for Oracle), or other database-specific SQL dialects (MySQL, PostgreSQL).
• Database Design : Strong understanding of relational database design principles, normalization, data modeling techniques (ER diagrams, etc.), and schema design.
• ETL (Extract, Transform, Load) : Proven experience in designing, developing, and implementing ETL processes using tools like SQL Server Integration Services (SSIS), Oracle Data

Integrator (ODI), Apache NiFi, or through custom SQL scripting.

performance.

database development and management.

platforms.

effectively.

(ref : hirist.tech)