Tech Stack
AWSAzureCloudMongoDBMySQLOraclePostgresRDBMSSQLTerraform
About the role
- Collaborate with development teams to optimize database performance for mission-critical applications
- Rigorously monitor, troubleshoot, and resolve complex database issues to ensure optimal system performance
- Execute and manage critical database backups, restores, and recovery models
- Implement and maintain stringent database access and security protocols
- Conduct comprehensive database performance tuning and maintenance to maximize efficiency
- Oversee and execute database installations and upgrades with precision and minimal downtime
- Develop and maintain comprehensive documentation of standard processes
- Work closely with Product Development to identify database performance issues, provide tuning, and design suggestions
- Develop and implement long-term strategies for database architecture and scalability to support future business growth and technological advancements
- Develop and maintain comprehensive disaster recovery plans, ensuring business continuity in the event of data loss or system failures
- Establish and maintain performance benchmarks, conducting regular reviews and optimizations to ensure databases meet or exceed performance standards.
- Oversee the database cost management, ensuring cost-effective use of resources and alignment with organizational financial goals
Requirements
- 8+ years of proven experience across various Database Technologies, must have SQLServer and good to have Oracle, MySQL, PostGres, and MongoDB Database Administration
- Experience of provisioning and supporting databases on Azure and Amazon AWS RDS, DocumentDB
- Managing data migration projects and ensuring data integrity during transfers
- Skilled at optimizing large complicated SQL statements
- Proficient in Scripting in any language
- Experience in troubleshooting and resolving database problems using Database and OS specific tools
- Experience in identifying and resolving database performance bottlenecks
- Solid SQL Performance Tuning
- Experience in Database Installs/Clustering, Upgrades, Patching, Replication, Security, and Monitoring. In-depth knowledge of Database backup and recovery
- Experience in tuning databases for optimal efficiency (including both hardware and software)
- Solid understanding of Database design “best practices”
- Experience with Git, publishing code, code versioning, branching, Terraform
- Excellent communication skills
- Ensuring databases comply with industry standards and regulations.
- Mentoring a team of DBAs, providing guidance and support
- Contributing to strategic planning and decision-making regarding database technologies and infrastructure