Database Administrator

Category DBA responsibility
Application Designing schema, access patterns, locking strategy, MYSQL development, and tuning.
Modifying the database structure
Optimizing application and end-user queries (reactive tuning)
Maintaining Mongo & Cassandra DB's
Archiving data
Generating needed ad hoc reports by querying from the database
Proactive performance tuning
Cloud (AWS) Familiarity Aurora RDS , Redshift
Experience in Building and Maintaining a Data Lake Infrastructure in AWS/Hadoop Ecosystem, ETL pipelines using Spark/Scala/Python, AWS Glue, Athena, Hive etc
Access Enrolling users and maintaining system security
Controlling user access to the database
Locking down host access
Securing database privileged credentials (SYSDBA or SYSTEM for Oracle; sa for SQL Server)
Database Parameter configuration and tuning
Cache management
Job scheduling
Monitoring Monitoring performance metrics, response times, and request rates
Alerting
Object access
Logs
Platform Ensuring compliance with database vendor license agreement
Designing and implementing disaster recovery (DR) solutions
Allocating system storage and planning future storage requirements for the database system
Installing and upgrading the database software
Performing data backups
Creating, managing, and monitoring high-availability (HA) systems
Patching the software that powers your database
Troubleshooting DB errors and potentially contacting vendors for technical support