Job Title: Senior DBA + .NET Developer (MSSQL to PostgreSQL Migration)
Experience Required:
- 4–5 years (hands-on with .NET, MSSQL, PostgreSQL)
Role Overview:
- We are looking for a hands-on DBA + Senior .NET Developer to lead and execute a full database migration from MSSQL to PostgreSQL for an existing live application.
- The application layer is already developed. Your primary responsibility is to migrate, optimize, and stabilize the database layer, along with required changes in the .NET application, ensuring a seamless transition with strong performance and reliability.
- You will own the migration outcome end-to-end.
Working Model:
- Full-time (approx. 4–5 months, extendable based on performance)
- Flexible working hours
- Mandatory availability during critical migration and production issues
Key Responsibilities:
Database Migration:
- Lead end-to-end migration from MSSQL to PostgreSQL
- Convert schema, tables, constraints, indexes
- Rewrite stored procedures, functions, triggers (T-SQL → PL/pgSQL)
- Ensure data integrity, validation, and reconciliation
- Execute large-scale data migration with minimal downtime
Database Optimization:
- Optimize queries specifically for PostgreSQL
- Redesign indexing strategies based on workload
- Analyze execution plans and eliminate bottlenecks
- Ensure efficient handling of high-volume transactions
.NET Application Changes:
- Modify .NET codebase for PostgreSQL compatibility
- Replace MSSQL-specific queries and ORM dependencies
- Ensure proper transaction handling and DB connectivity
- Identify and resolve performance issues at application level
Performance & Stability:
- Maintain fast response time (target: 10–20 ms where applicable)
- Identify and fix slow queries and heavy operations
- Ensure system stability under production load
Maintenance & Monitoring:
- Implement PostgreSQL monitoring and alerting
- Perform routine maintenance (VACUUM, ANALYZE, indexing)
- Troubleshoot and resolve production issues quickly
Technical Skills Required:
- Strong hands-on experience in MSSQL and PostgreSQL
- Proven experience in database migration projects
- Strong knowledge of .NET (C# / .NET Core)
- Deep expertise in:
- Query optimization
- Execution plan analysis
- Index design and tuning
- Experience with:
- Stored procedure conversion (T-SQL → PL/pgSQL)
- Data migration strategies and tools
- Solid understanding of:
- Transactions, locking, concurrency
- High-load and high-throughput systems
Preferred Qualifications:
- Experience with large-scale databases
- Experience in live production migration with minimal downtime
- Familiarity with AWS / Linux environments
- Experience with ORM tools (Entity Framework / Dapper)
Engagement & Payment Terms:
- Full-time engagement
- Monthly payout cycle
- Long-term opportunity based on performance
Outcome Expectations:
- Accurate and complete migration from MSSQL to PostgreSQL
- Well-optimized PostgreSQL database structure
- Stable and performant system post-migration
- Minimal downtime during transition
- Clean, maintainable, and scalable database + application code
Key Focus Area:
The application flow is already defined. The focus is:
- Correct and safe migration
- Performance optimization
- Stability under high load
- Clean integration between .NET and PostgreSQL
Pay: Up to ₹42,000.00 per month
Benefits:
Work Location: In person
