06 Sep
|
harbinger-systems
|
Pune
06 Sep
harbinger-systems
Pune
Job Description:
Design, develop, and maintain robust database solutions.
Manage and administer databases such as SQL Server, Oracle, MySQL, PostgreSQL, or MongoDB.
Monitor database performance and implement tuning strategies to improve efficiency.
Perform database backup, recovery, replication, and disaster recovery planning.
Ensure database security, compliance, and data integrity.
Troubleshoot database issues and provide root cause analysis.
Develop and optimize complex SQL queries, stored procedures, functions, and triggers.
Support application teams during deployments and database migrations.
Implement database monitoring and automation solutions.
Collaborate with development, infrastructure, and business teams to meet data requirements.
Create and maintain technical documentation and operational procedures.
Skills Required:
Database: PostgreSQL (PL/pgSQL)
stored procedures, functions, triggers, views, query optimization
Backend: C# / .NET Framework (ASP.NET Web Forms) — for procedure integration with application layer
Data Access: ADO.NET / Npgsql (PostgreSQL .NET driver)
Tools: pgAdmin / DBeaver (query & schema management), SQL Profiler / EXPLAIN ANALYZE (performance tuning)
Version Control: Git / SVN / TFS (for SQL script & procedure versioning)
Deployment: IIS (Windows hosting), Windows Server
Database migration/versioning tools (e.g., Flyway, Liquibase, or custom scripts)
Monitoring: pgstatstatements, log-based query analysis
AI-assisted SQL tools (Copilot/Claude Code) for procedure debugging & optimization
📌 Database Engineer Pune
🏢 harbinger-systems
📍 Pune