SQL Developer

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 :- 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.- Database Performance Tuning : Demonstrated ability to analyze and optimize SQL query performance, identify and resolve database bottlenecks, and implement indexing strategies.- Stored Procedures and Functions : Expertise in developing, debugging, and maintaining efficient stored procedures, functions, and triggers to encapsulate business logic and improve performance.- Database Administration Fundamentals : Basic understanding of database administration tasks such as database backups, restores, user management, security configurations, and performance monitoring.- Version Control : Familiarity with version control systems like Git for managing database scripts and schema changes.- Operating Systems : Comfortable working with Windows Server or Linux operating systems as they relate to database environments.Qualifications :- Bachelor's degree in Computer Science, Information Technology, or a related field.- 5-10 years of professional experience as a SQL Developer, with a strong focus on relational database development and management.- Proven expertise in writing and optimizing complex SQL queries across various database platforms.- Solid understanding of database design principles and ETL processes.- Strong analytical and problem-solving skills with the ability to troubleshoot database issues effectively.- Good verbal and written communication skills to interact effectively with technical and non-technical stakeholders.- Ability to work independently and collaboratively within a team environment.Bonus Points :- Experience with specific database platforms such as SQL Server, Oracle, MySQL, or PostgreSQL.- Knowledge of data warehousing concepts, dimensional modeling, and OLAP techniques.- Experience with database scripting languages like Python or PowerShell for automation tasks.- Familiarity with NoSQL databases (MongoDB, Cassandra).- Experience working with cloud-based database services (Azure SQL Database, AWS RDS, Google Cloud SQL).- Experience in an Agile development environment.- Relevant certifications (Microsoft Certified : Database Administrator, Oracle Database SQL Certified Associate) (ref:hirist.tech)