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 24/7 support for critical situations
.Evaluate and recommend new database technologies
Job Specification
.In depth SQL Server 2008 Database Administration experience.
.Managing multiple MS SQL RDBMS on large systems
.Strong self-sufficiency and initiative working on Database projects
.Practical experience in monitoring and tuning a database to provide a high availability service.
.Experience of Transactional SQL, and DTS stored procedures.
.Practical experience in managing the internal and external MS SQL database security
.ASP.NET programming
.SQL, Stored Procedures
.OOP concepts for .NET for Web/Desktop applications
Other Requirements
.Minimum Computer Graduate
.Microsoft Certified Database Administrator (MCDBA) - Mandatory
.Microsoft Certified Solution Developer (MCSD) - Preferred