Resident Engineer

Scope of Work (SOW)

Provide end-to-end database administration, operations, and support across enterprise database platforms:

• Microsoft SQL Server (MSSQL)
• MySQL
• Oracle Database

Technical Responsibilities

• Administer, configure, and maintain MSSQL, MySQL, and Oracle databases in production and non-production environments.
• Perform proactive database performance monitoring, analysis, and tuning (query optimization, indexing strategies, execution plans, wait statistics).
• Design, implement, and support database backup, recovery, and high availability solutions (e.g., SQL Server Always On, Oracle Data Guard, MySQL Replication).
• Manage database security, including user access, roles, permissions, and auditing.
• Troubleshoot complex database incidents, perform root cause analysis (RCA), and implement preventive measures.
• Execute database patching, upgrades, and version maintenance in li...