DBP - SQL Developer - Database Design

<p><p><b>Responsibilities :</b></p><p><p><b><br/></b></p>- 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.<br/><br/></p><p>- Write and optimize complex SQL queries for data retrieval, manipulation, analysis, and reporting to meet application and business requirements.<br/><br/></p><p>- 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.<br/><br/></p><p>- Ensure the performance, scalability, and stability of database systems through proactive monitoring, performance tuning, and optimization of queries and database configurations.<br/><br/></p><p>- Troubleshoot and resolve database-related issues, including query performance problems, data inconsistencies, and database errors, in a timely and efficient manner.<br/><br/></p><p>- Collaborate closely with application developers, system administrators, and other technical teams to understand data requirements and ensure seamless integration between applications and databases.<br/><br/></p><p>- Participate in the planning and execution of database backups, recovery procedures, and disaster recovery strategies to ensure data availability and business continuity.<br/><br/></p><p>- Monitor database performance metrics, identify potential bottlenecks, and implement proactive measures for improvement.<br/><br/></p><p>- Create and maintain comprehensive technical documentation for database designs, schemas, stored procedures, and ETL processes.<br/><br/></p><p>- Adhere to database security best practices and implement security measures to protect sensitive data.<br/><br/></p><p>- Stay up-to-date with the latest SQL Server features, database technologies, and industry best practices.<br/><br/></p><p>- Participate in code reviews and contribute to the team's knowledge sharing and best Skills : </b><br/><br/></p><p>- 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).<br/><br/></p><p>- Database Design : Strong understanding of relational database design principles, normalization, data modeling techniques (ER diagrams, etc.), and schema design.<br/><br/></p><p>- ETL (Extract, Transform, Load) : Proven experience in designing, developing, and implementing ETL processes using tools like SQL Server Integration Services (SSIS), Oracle Data </p><p>Integrator (ODI), Apache NiFi, or through custom SQL scripting.<br/><br/></p><p>- Database Performance Tuning : Demonstrated ability to analyze and optimize SQL query performance, identify and resolve database bottlenecks, and implement indexing strategies.<br/><br/></p><p>- Stored Procedures and Functions : Expertise in developing, debugging, and maintaining efficient stored procedures, functions, and triggers to encapsulate business logic and improve </p><p>performance.<br/><br/></p><p>- Database Administration Fundamentals : Basic understanding of database administration tasks such as database backups, restores, user management, security configurations, and performance monitoring.<br/><br/></p><p>- Version Control : Familiarity with version control systems like Git for managing database scripts and schema changes.<br/><br/></p><p>- Operating Systems : Comfortable working with Windows Server or Linux operating systems as they relate to database : </b></p><p><br/></p>- Bachelor's degree in Computer Science, Information Technology, or a related field.<br/><br/></p><p>- 5-10 years of professional experience as a SQL Developer, with a strong focus on relational </p><p>database development and management.<br/><br/></p><p>- Proven expertise in writing and optimizing complex SQL queries across various database </p><p>platforms.<br/><br/></p><p>- Solid understanding of database design principles and ETL processes.<br/><br/></p><p>- Strong analytical and problem-solving skills with the ability to troubleshoot database issues </p><p>effectively.<br/><br/></p><p>- Good verbal and written communication skills to interact effectively with technical and non-technical stakeholders.<br/><br/></p><p>- Ability to work independently and collaboratively within a team Points : </b></p><p><br/></p>- Experience with specific database platforms such as SQL Server, Oracle, MySQL, or PostgreSQL.<br/><br/></p><p>- Knowledge of data warehousing concepts, dimensional modeling, and OLAP techniques.<br/><br/></p><p>- Experience with database scripting languages like Python or PowerShell for automation tasks.<br/><br/></p><p>- Familiarity with NoSQL databases (MongoDB, Cassandra).<br/><br/></p><p>- Experience working with cloud-based database services (Azure SQL Database, AWS RDS, Google Cloud SQL).<br/><br/></p><p>- Experience in an Agile development environment.<br/><br/></p><p>- Relevant certifications (Microsoft Certified : Database Administrator, Oracle Database SQL Certified Associate)</p><br/></p> (ref:hirist.tech)