SQL Developer

• Design, develop, and implement database solutions including tables, views, stored procedures, functions, and triggers to meet application and business requirements
• Write and optimize complex SQL queries for data retrieval, manipulation, and reporting

Roles and Responsibilities:

• Design, develop, and implement database solutions including tables, views, stored procedures, functions, and triggers to meet application and business requirements
• Write and optimize complex SQL queries for data retrieval, manipulation, and reporting
• Ensure efficient performance of queries to handle large datasets
• Analyze database performance, identify bottlenecks, and apply performance tuning techniques to optimize query execution and system performance
• Maintain data integrity and security through appropriate database constraints, permissions, and access controls
• Regularly monitor database systems to ensure data availability, reliability, and scalability
• Perform backups, restorations, and disaster recovery tasks as required
• Design and implement ETL processes to integrate data from multiple sources while ensuring data consistency
• Collaborate with developers, data analysts, and business stakeholders to gather requirements and understand data needs
• Maintain clear and comprehensive documentation for database designs, schemas, and changes
• Identify and resolve database-related issues such as data inconsistencies, performance problems, and system failures
• Stay updated on the latest database technologies, best practices, and industry trends

Academic Requirements:

• Bachelors degree in Computer Science or a related field
• Master s degree is a plus

Required Skills:

• Proven experience as an SQL Developer or Database Developer with expertise in database management systems (eg, SQL Server, MySQL, Oracle)
• Proficiency in writing and optimizing complex SQL queries across various database platforms
• Familiarity with database design principles, indexing strategies, and data normalization
• Experience with ETL processes and data integration tools
• Strong knowledge of performance tuning and database optimization techniques
• Excellent analytical and problem-solving skills
• Strong communication and teamwork abilities
• Ability to work independently and manage tasks effectively
• Preferred Skills (Optional): Experience with NoSQL databases (eg, MongoDB, Cassandra)
• Knowledge of data warehousing concepts and methodologies
• Familiarity with business intelligence and reporting tools (eg, Tableau, Power BI)
• Experience with cloud-based database solutions (eg, AWS RDS, Azure SQL Database)