Desired Skills and Experience
- Install, configure and maintain MySQL and PostgreSQL databases
- Optimize and tune database performance and SQL queries
- Improve monitoring, perform database capacity and usage planning
- Assist developers with query tuning and schema design
- Write and maintain scripts to automate tasks
- Troubleshoot database-related application performance issues
- Perform tests and evaluations regularly to ensure data security and integrity
- Ensure security and data integrity of databases
- Perform routine, periodic and proactive maintenance
- Implement tools to automate database operation and monitoring
- Backup/recovery, replication, cluster failover and disaster recovery
- BS/MS in Computer Science, Engineering, related field, or equivalent experience or relevant certification
- 4+ years of experience as a Database Administrator
- 4+ years of SQL experience
- 2+ years of performance tuning
- 2+ years of disaster recovery and backup experience
- 2+ years of professional experience with MySQL or PostgreSQL
- Highly proficient in all aspects of database administration, including backup/recovery/replication, clustering, advanced performance tuning, and proactive monitoring
- Familiarity with microservice data schema design
- eCommerce experience
- Experience with AWS
- Experience with DB monitoring tools such as Monyog
- Experience with configuration management tools such as Chef and Puppet
- Able to read and understand ERDs
- Familiarity with iterative software development
- Experience with NoSQL DBs such as MongoDB and Redis
- Experience with high availability configurations