Qualification Profile
Bachelor’s degree in Computer Science, Information Technology, or a related field.
Proficiency with MSSQL, DB2, MySQL, Hadoop, and Hive databases.
Strong understanding of database design principles, normalization, and data modelling.
Experience with performance tuning and optimization techniques.
Familiarity with data warehousing concepts and ETL processes.
Knowledge of database security practices and data protection regulations.
Excellent problem-solving skills and attention to detail.
Strong communication and collaboration skills
Job Responsibilities
Database Design and Development:
Design, develop, and maintain complex database systems.
Create database objects such as tables, views, indexes, and stored procedures.
Develop and optimize complex SQL queries for data retrieval and reporting.
Performance Optimization:
Analyze and optimize database performance, including query optimization and indexing strategies.
Monitor and enhance database performance to ensure optimal efficiency.
Data Management:
Ensure data integrity and security.
Implement data backup, recovery, and archiving procedures.
Manage and maintain data warehouse solutions.
Collaboration and Support:
Work closely with application developers to ensure efficient database usage.
Provide technical support and troubleshooting for database-related issues.
Mentor and guide junior database developers.
Project Management:
Lead database-related projects, ensuring timely delivery and adherence to quality standards.
Coordinate with stakeholders to gather requirements and translate them into technical solutions.
Documentation and Standards:
Maintain comprehensive documentation for database designs, configurations, and procedures.
Ensure compliance with industry standards and best practices.
Continuous Improvement:
Stay updated with the latest database technologies and trends.
Recommend and implement improvements to database systems and processes