- 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.
Job description provided by Training Basket.
View the original posting