Required Skills
- Database Administrator
Required Industry Experience
- Aerospace & Defense
Core Roles and Responsibilities
Installation and Configuration: Installs, configures, and upgrades RDBMS software (such as MySQL, PostgreSQL, Oracle, or SQL Server) and sets up system storage.
Performance Tuning and Optimization: Monitors database activity, optimizes slow SQL queries, manages indexes, and allocates system resources to prevent bottlenecks.
Security and Access Control: Defines user roles, grants or revokes permissions, enforces authentication, and implements data encryption to protect sensitive information.
Backup and Disaster Recovery: Schedules regular backups (full, differential, and transaction logs) and tests recovery procedures to prevent data loss during system failures.
Data Integrity and Maintenance: Enforces constraints and rules to maintain accurate relationships between data tables, running routine cleanups and health checks.
Troubleshooting and Support: Diagnoses operational errors, resolves connectivity issues, and provides on-call technical response for production alerts.
Capacity Planning: Analyzes data growth trends to forecast future storage, memory, and processing requirements.