DATABASE ADMINISTRATOR

• 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 corruption 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 database-related issues, including performance problems, connectivity issues, and data corruption, 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.

• 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 problem-solving and troubleshooting skills.
• Ability to work independently and collaboratively in a team environment.
• Strong communication and documentation skills.

Duncan & Ross