· Administer SQL Server and PostgreSQL databases end to end — performance tuning, query optimization, indexing strategy, and execution plan analysis.
· Design, implement, and regularly test backup, replication, and disaster recovery procedures for databases, ensuring high availability across production environments.
· Manage database security — roles, permissions, access control, and auditing.
· Monitor and plan for database capacity — storage growth, connection pooling, and resource allocation.
· Manage database version upgrades, patching cycles, and configuration tuning.
· Perform routine database maintenance — index/statistics upkeep, vacuuming, storage optimization, and space reclamation — to sustain performance over time.
· Proactively monitor database health and performance, identifying and resolving issues before they affect production.
· Manage cloud cost optimization and capacity planning, including license reporting and true-ups, resource forecasting, and optimization of Azure compute spend through Savings Plans, Reserved Instances, and related strategies.
· Partner with the Data Architect and engineering teams to establish database standards, improve operational practices, and proactively address reliability and performance concerns.
· Plan and execute database migrations to the cloud, optimizing configurations for target environments, and ensuring performance, security, resiliency, and recoverability throughout the transition.
· Build strong working relationships with engineering teams, communicating database constraints and recommendations in terms they can act on.
· Share database expertise and best practices with less experienced administrators and engineering team members.
· Performs other duties as assigned.