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 fail over 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 Common IT Hardware, Software and Systems Knowledge
Job Specification
Oracle, SQL Server, MySql, OLTP, T-SQL, PL/SQL, Storage tuning (RAID, SAN, filegroups), DTS, SSIS, SSRS, SSAS, CLR programming