• Install Oracle, Postgres database and troubleshoot various issues related to database patching. • Perform production database health check. • Detect potential issues that may impact production database operation and resolve the issues. • Performs database support for both production and development environments, including the installation of databases, back-ups, replication, restores, patches, and upgrades. • Ability to configure replication as a part of disaster recovery process. • Identify and resolve database issues that impact application performance. • All other duties and responsibilities as assigned. • Strong command of Oracle, Oracle server tools and Oracle Data Guard. • Advanced knowledge of database security, backup and recovery, performance monitoring and tuning standards. • Understanding of relational and dimensional data modelling. • Develop processes for optimizing database security. • Create and manage database reports, visualizations, and dashboards. • Create automation for repeating database tasks. • Be available for on-call support as needed.

• Administer, operate, and optimize production databases including Couchbase, PostgreSQL, DynamoDB, DocumentDB, Cosmos DB, and Snowflake. • Manage Couchbase clusters, including XDCR replication configuration, monitoring, and troubleshooting. • Perform database installations, upgrades, patching, and configuration management across cloud and on-prem environments. • Monitor database health, performance, and resource utilization across multi-cloud infrastructure. • Optimize query performance through indexing strategies, query tuning, and execution plan analysis. • Plan and manage database scaling strategies, including vertical and horizontal scaling, sharding, and capacity planning. • Implement and manage database security controls, including access management, encryption, and compliance requirements. • Design and maintain comprehensive backup strategies with appropriate retention policies. • Implement and validate restore procedures to meet defined RTO/RPO objectives. • Develop and maintain point-in-time recovery (PITR) capabilities. • Execute disaster recovery drills and document outcomes and improvements. • Participate in a 24/7 on-call rotation supporting mission-critical database systems. • Lead database-related incident response efforts, including outage resolution and performance degradation. • Perform root cause analysis and implement corrective and preventative actions. • Troubleshoot complex production issues such as replication lag, memory pressure, connection limits, and deadlocks. • Coordinate closely with application and infrastructure teams during critical incidents. • Implement and maintain monitoring and alerting using tools such as Datadog, CloudWatch, Azure Monitor, and database-native solutions. • Create and manage dashboards for database KPIs and SLAs. • Configure intelligent alerting with appropriate thresholds and escalation paths. • Automate routine operational tasks using Python, Bash, PowerShell, AWS CLI, and cloud-native tooling. • Lead and support database migration initiatives across cloud providers and platforms. • Plan and execute database upgrades and migrations with minimal downtime. • Support new database implementations and data architecture initiatives. • Validate data integrity and reconciliation during migrations. • Develop and maintain runbooks, SOPs, and Architecture Decision Records (ADRs). • Document database configurations, schemas, and topology. • Implement database security best practices including IAM roles, network isolation, secrets management, and encryption. • Manage credentials using AWS Secrets Manager and Azure Key Vault. • Ensure compliance with data residency, privacy, and regulatory requirements. • Participate in security audits, vulnerability assessments, and remediation efforts. • Partner closely with Data Engineering, DevOps, and application teams. • Provide database expertise and guidance across engineering teams. • Communicate database status, incidents, and maintenance activities to stakeholders. • Mentor junior DBAs and engineers on database best practices.

• Cloud Database Administration • Performance Optimization • Backup, Recovery & HA • Scripting & Automation • Monitoring & Troubleshooting • Security & Compliance Support

• The Senior Database Administrator/Engineer installs, configures upgrades, administers, and monitors enterprise database systems. • Works closely with Infrastructure and Applications team to design and consult on new and existing systems to optimize performance and reliability. • Manage, monitor, and optimize relational databases including Oracle and SQL Server. • Manage and optimize cloud database services (AWS RDS/Aurora, Azure SQL, Google cloud services). • Design and implement cloud-based database architectures. • Perform stored procedure tuning and code optimization. • Manages installation, patching, and upgrades on all enterprise database systems. • Maintains the integrity of data within the production environment. • Provides guidance and input on the selection and implementation of all database administration tools. • Administers database cleanup and optimization activities. • Provides escalated support and resolution of open database issues from IT Customer Support.