Database Engineer

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:  / Npgsql (PostgreSQL .NET driver)
• Tools: pg Admin / 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: _statements, log-based query analysis
• AI-assisted SQL tools (Copilot/Claude Code) for procedure debugging & optimization