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 systemsecurity
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 vendorlicense agreement
Designing and implementing disaster recovery (DR) solutions
Allocating system storage andplanningfuture storage requirements for the database system
Installingandupgradingthe 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
Siri 1  Technologies India Pvt. Ltd is an IT staffing company across Pan India. Siri 1  Technologies has been immensely successful in creating a global network of highly adept intelligent workforce that can help a firm to achieve their mission-critical projects and goals. Keeping pace wit...