Data Warehouse Engineer

Key Responsibilities :

Database Administration Maintenance

Install, configure, and maintain database management systems (DBMS) such as MySQL, PostgreSQL, SQL Server, Oracle, or MongoDB.

Ensure database security, backup, and disaster recovery strategies are in place.

Monitor database performance and optimize queries, indexing, and storage.

Apply patches, updates, and upgrades to ensure system stability and security.

Database Design Development

Design and implement database schemas, tables, and relationships based on business requirements.

Develop and optimize stored procedures, functions, and triggers.

Implement data partitioning, replication, and sharding strategies for scalability.

Performance Tuning Optimization

Analyze slow queries and optimize database performance using indexing, caching, and tuning techniques.

Conduct database capacity planning and resource allocation.

Monitor and troubleshoot database-related issues, ensuring minimal downtime.

Security Compliance

Implement role-based access control (RBAC) and manage user permissions.

Ensure databases comply with security policies, including encryption, auditing, and GDPR / HIPAA regulations.

Conduct regular security assessments and vulnerability scans.

Collaboration Automation

Work closely with developers, system administrators, and DevOps teams to integrate databases with applications.

Automate database management tasks using scripts and tools.

Document database configurations, processes, and best practices.

Required Skills Qualifications :

Experience :  4+ years of experience in database administration, engineering, or related fields.

Education :  Bachelor s or Master s degree in Computer Science, Information Technology, or related disciplines.

Technical Skills :

Strong knowledge of SQL and database optimization techniques.

Hands-on experience with at least one major RDBMS (MySQL, PostgreSQL, SQL Server, Oracle).

Experience with NoSQL databases (MongoDB, Cassandra, DynamoDB) is a plus.

Proficiency in database backup, recovery, and high availability solutions (Replication, Clustering, Mirroring).

Familiarity with scripting languages (Python, Bash, PowerShell) for automation.

Experience with cloud-based database solutions (AWS RDS, Azure SQL, Google Cloud Spanner).

Preferred Qualifications :

Experience with database migration and cloud transformation projects.

Knowledge of CI / CD pipelines and DevOps methodologies for database management.

Familiarity with big data technologies like Hadoop, Spark, or Elasticsearch.

Skills Required

Database Design, Performance Tuning, Rdbms, Mysql, Stored Procedures, Automation