Hiring for Database Engineer (Microsoft Fabric) for manufacturing client for Bengaluru location

Job Description:

Database Engineering:

• Design, implement, and maintain RDBMS databases for transactional systems with focus on performance, scalability, and reliability
• Develop and manage data solutions within Microsoft Fabric ecosystem, including data warehousing, lakehouses, and real-time analytics
• Optimize database performance through query tuning, indexing strategies, and resource management
• Implement and maintain database security, backup, recovery, and disaster recovery procedures
• Monitor database health, troubleshoot issues, and ensure high availability
• Automate database deployment and maintenance tasks using DevOps practices
• Manage database migrations, upgrades, and version control

Data Modeling:

• Design and implement logical and physical data models for both OLTP and OLAP systems
• Create dimensional models (star/snowflake schemas) for analytics and reporting
• Develop normalized data models for transactional systems ensuring data integrity and optimal performance
• Document data models, data dictionaries, and metadata management
• Collaborate with business analysts and stakeholders to translate business requirements into technical data models
• Establish and enforce data modeling standards and best practices
• Perform data profiling and analysis to support modeling decisions

Cloud Database Administration:

• Administer and manage cloud-based database services in Microsoft Azure and Microsoft Fabric environments
• Configure and optimize Azure Database for PostgreSQL
• Manage Microsoft Fabric Data Warehouse instances, capacity planning, and resource allocation
• Implement and maintain cloud database security
• Monitor and optimize cloud database costs
• Manage cloud database monitoring and alerting
• Coordinate with cloud architects on database placement and network topology
• Perform capacity planning and scaling operations for cloud databases
• Troubleshoot production incidents, perform root cause analysis, and drive preventive actions.
• Support SRE / DevOps teams with database automation and reliability engineering.
• Implement and manage database connection pooling and load balancing

Analytics Engineering (Microsoft Fabric):

• Lakehouse Architecture: Build and manage the Data Lakehouse architecture using OneLake and Delta Parquet tables.
• Integration Pipelines: Design low-latency data movement from RDBMS (ex – PostgreSQL) to Fabric using Fabric Mirroring, CDC (Change Data Capture), or Data Factory pipelines.
• Compute Optimization: Write efficient PySpark notebooks and T-SQL queries for data transformation and aggregation.

Integration & Collaboration:

• Work with data engineers and ETL developers to implement data pipelines
• Partner with cloud, platform, and DevOps teams for CI/CD, IaC, and automation.
• Collaborate with application developers to optimize database interactions
• Partner with business intelligence teams to support reporting and analytics requirements
• Participate in architecture reviews and technical design sessions
• Provide technical guidance and mentorship to junior team members

Required Education and Experience:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or related technical field
• 6+ years of experience in database engineering and data modeling
• Expert-level proficiency in PostgreSQL including:
• Advanced SQL, PL/pgSQL, and query optimization
• Performance tuning and troubleshooting
• Replication, partitioning, and high availability configurations
• Strong experience with Microsoft Fabric components:
• Data Warehouse, Lakehouse, and Data Factory
• Power BI integration and semantic models
• OneLake and data mesh architectures
• Proven experience designing data models for both transactional (OLTP) and analytical (OLAP) systems
• Proficiency in data modeling tools (e.g., ERwin, PowerDesigner, ER/Studio, or similar)
• Strong understanding of database normalization, dimensional modeling, and data warehousing concepts
• Strong understanding of cloud security principles and implementation
• Experience with version control systems (Git) and CI/CD pipelines
• Excellent SQL skills across multiple database platforms
• Proven experience in managing cloud database services (ex – Azure/AWS PostgreSQL)
• Strong analytical and problem-solving abilities
• Excellent communication skills with ability to explain technical concepts to non-technical stakeholders