DATABASE ADMINISTRATOR

Responsibilities:

• Database Installation and Configuration: Install and configure database management systems (DBMS) such as MySQL PostgreSQL Oracle SQL Server etc. ensuring optimal performance and security.
• Database Design and Implementation: Design implement and maintain database schemas tables indexes and views based on organizational requirements and best practices for data integrity and performance.
• Data Security and Access Control: Implement and manage database security measures including user authentication authorization encryption and access control policies to protect sensitive data from unauthorized access and ensure compliance with regulations such as GDPR or HIPAA.
• Backup and Recovery: Develop and implement backup and recovery strategies to ensure data availability and integrity in case of hardware failures disasters or data incidents.
• Performance Tuning and Optimization: Monitor and optimize database performance by analyzing query execution plans identifying bottlenecks optimizing SQL queries and tuning database parameters to enhance efficiency and scalability.
• Database Maintenance: Perform routine maintenance tasks such as database software updates patch management data archiving and purging to maintain system stability and reliability.
• Troubleshooting and Issue Resolution: Diagnose and troubleshoot databaserelated issues including performance problems connectivity issues and data and implement effective solutions to minimize downtime and ensure data integrity.
• Documentation and Reporting: Maintain comprehensive documentation of database configurations procedures and troubleshooting steps. Generate reports on database usage performance metrics and security compliance for management and auditing purposes.

Qualifications:

• Proficiency in SQL and database query optimization techniques.
• Strong understanding of database management systems (DBMS) and relational database concepts.
• Experience with database administration tools and utilities for monitoring backup and performance tuning.
• Knowledge of database security principles and best practices.
• Familiarity with high availability and disaster recovery solutions such as clustering replication and failover.
• Excellent problemsolving and troubleshooting skills.
• Ability to work independently and collaboratively in a team environment.
• Strong communication and documentation skills.

Vertical:

Technology

Remote Work :

No