Duties
Designing, implementing, and maintaining database systems to meet organizational needs, including data modeling, schema design, and capacity planning. Ensuring data integrity, security, and compliance with regulatory requirements by implementing access controls, encryption, and regular audits. Monitoring database performance and optimizing queries, indexes, and configurations for efficient data retrieval and storage. Planning and executing database backups, disaster recovery procedures, and high availability solutions to minimize downtime and data loss. Creating and managing Extract, Transform, Load (ETL) processes to facilitate seamless data integration, transformation, and migration between various systems and databases, ensuring data consistency and accuracy across the organization's data ecosystem. Collaborating with developers, system administrators, and other stakeholders to troubleshoot database issues and support application development and deployment. Providing technical guidance and training to colleagues on database best practices, performance tuning, and troubleshooting techniques. Evaluating and recommending new database technologies, tools, and methodologies to enhance system performance and scalability. Documenting database configurations, procedures, and troubleshooting steps to maintain system knowledge and facilitate knowledge sharing within the team. Requirements
Degree in Information Technology Honors Degree is advantageous Industry Certification in Data Administration advantageous Minimum 5 years working experience with 5 years as a Database Administrator for a medium to large company. Proficiency in database management in MS SQL Server. Familiarity with Azure Strong understanding of database design principles, normalization, and data modeling techniques. Knowledge of SQL programming for querying, scripting, and automation tasks. Proficient in Microsoft Office Suite (Word, Excel, PowerPoint). Proficient in MS SQL Server and administration thereof. Familiarity with database performance tuning, query optimization, and indexing strategies. Understanding of database security concepts, including authentication, authorization, and encryption methods. Experience with backup and recovery procedures, disaster recovery planning, and high availability solutions. Ability to troubleshoot database issues, diagnose performance bottlenecks, and implement solutions. Familiarity with ETL tools and processes for data integration, transformation, and loading.