Database Engineer at Institute of Chartered Accountants of Nigeria (ICAN)

Department: Information Technology Directorate

Job Description

• Design and document database architecture.
• Data Modeling.
• Design Data Warehousing and Business Intelligence platform.
• Build database scheme, tables, procedures and permissions.
• Set up data sharing and disk partitioning>
• Develop database utilities and automated reporting.
• Create shell scripts for task automation.
• Create, test and execute data management languages.
• Analyze and sustain capacity and performance requirements.
• Analyze, consolidate and tune database for optimal efficiency.
• Monitor systems and platforms for availability.
• Oversee backup, clustering, mirroring, replication and failover.
• Restore and recover corrupted databases.
• Install and test upgrades and patches.
• Implement security and encryption.
• Provide support for critical situations.
• Evaluate and recommend new database technologies.  

Requirements

• Bachelor’s Degree in Computer Science or a related field.
• 4 - 6 years of experience in database administration, integration and architecture.
• Experience with Backup, High Availability and Replication of databases.
• MCSE/MCSA certifications preferred.
• Experience with Linux and Windows Server environments.
• Extensive experience with database technologies (MS SQL, PostgreSQL Oracle).
• Experience with cloud services (Microsoft Azure) a plus.
• Strong command of SQL and SQL server tools.
• Advanced  knowledge  of  database  security,  backup  and  recovery  and  performance monitoring tools.
• Understanding of relational and dimensional data modeling.
• PowerShell and Unix shell scripting skills.