Pros: great people and a great atmosphere. the usual startup comforts also.
Cons: long hours due to a small team setup, and a changing team. this is to be expected in a startup.
My typical day would be to check the main databases via alerts and various tools. I would have many meeting for various projects and join the engineers for their scrums to assist with agile development projects. Engineering assistance would range from SQL tuning and optimization to a complete architecture on migrations from Oracle to Oracle, Oracle – more... to postgres. Also dealing with new client systems, installing Oracle and new products, setting up and tuning Oracle, Mysql.
Solutions provided would be managed by me to delegate to the other dbas or engineers, for prod and QA envs. Documentation on JIRA for the solutions, such as QA refreshes, migrations, SQL deployment, database remediations etc.
Working with the other DBAs was enjoyable, I try to lead by example and whilst training DBAs one learns more as well.
Hardest part would be the managing of multiple components that relate to the database, many tomcat web servers and apps would need to be rolling restarted with high prod change docs to ensure changes were smoothly implemented. Also time frames to advise clients would need to be managed closely.
The most enjoyable part would be optimizing queries, as an example taking a query from not responding to 20 minutes to meet critical financial billing to our customers. Also introducing redesing and re architecting of databases and ensuring new databases are tuned and optimmized pre production as to pre empt possible problems with performance and eventual outages if ignored. – less