Database Lead

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.

Additional Job Need:

• 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: pg_stat_statements, log-based query analysis
• AI-assisted SQL tools (Copilot/Claude Code) for procedure debugging & optimization 
• Cloud - Azure Services, Azure DB