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)