Database AdministratorDesign and setup disaster recovery for cloud databases including Aurora PostgreSQL Global, Dynamo DB, etc. Setup data replication from/to PostgreSQL/Aurora to Data Lake, Sqlserver, Azure Synapse, Redshift, etc. Prioritize work based on project needs and work effectively with minimum supervision. Manage, monitor, troubleshoot database operations, optimize database performance, tuning. Implement high availability, replication, and cluster on databases.
Database refreshes in on-prem and cloud. Support application release deployment and perform data fixes. Work with the application team to rewrite stored procedures. Troubleshooting performance issues in real time. Work in a globally distributed team in an Agile/Scrum approach.
Provide routine status reports to leadership and escalate as necessary. Maintain service levels and department goals for problem resolution. Follow security standards and effectively manage software patches and upgrades. Utilize best practices, standard procedures. Write and maintain clear documentation.
Ensure 24x7 availability for critical database systems hosted on premise and on AWS & Azure Cloud. Be available to participate in 24x7 on-call rotation for the team.