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 :
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).