About the role
Design, develop, and maintain SQL databases, tables, views, and stored procedures.
Write and optimize complex SQL queries for data retrieval and reporting.
Develop stored procedures, functions, triggers, and database scripts.
Perform database performance tuning and query optimization.
Ensure data accuracy, integrity, consistency, and security.
Troubleshoot database-related issues and resolve errors.
Work with large datasets and perform data extraction, transformation, and loading (ETL).
Create database reports and support business intelligence requirements.
Collaborate with developers, data analysts, and other technical teams.
Assist in database backup, recovery, and maintenance activities.
Maintain proper documentation of database structures and SQL scripts.
Requirements
Strong knowledge of SQL and RDBMS concepts.
Hands-on experience with MySQL, Microsoft SQL Server, PostgreSQL, or Oracle.
Good understanding of SQL queries, joins, subqueries, and aggregate functions.
Knowledge of stored procedures, functions, triggers, and views.
Understanding of database normalization and indexing.
Familiarity with database design and data modeling.
Knowledge of query optimization and performance tuning.
Understanding of primary keys, foreign keys, and database constraints.
Basic knowledge of ETL processes and data warehousing.
Strong analytical and problem-solving skills.