Performs data modeling based on business requirements. Ensure the data model will be flexible enough to cater for current requirement and future needs as documented in the business requirement.
Develops and maintains policies and standards on areas related to database development activities.
Provides development support to all database application development including performance tuning. Ensure codes developed follow internal standards and executed efficiently.
Works closely with data steward to ensure corporate data standards are followed and no violation on the usage of data.
Performs technical administrative tasks relative to the environments on a daily basis to ensure the databases are accessible and stable via the applications. Provides assistance and technical support to other staff members/vendors to ensure the design and management of the databases are operational.
Prevents security breaches, intrusions or attacks to the environment by ensuring appropriate measures are in place to allow for auditing, alerts and reporting on a daily basis.
Investigates with vendor support any patches or upgrades that apply permanent fixed to current versions of software/hardware. Performs risk mitigation steps as it related to these types of changes to ensure the environments are stable on a scheduled basis.
Develops and maintains strategic plans for upgrades to the environments to ensure high levels of standards are achieved.
Requirements:
DBA Certification – DB2/SQL Server
Unix/NT Training
Web Based Application Development Training – VB/C# .Net
2 years Community College Diploma or related academic computer training
Database administration Product knowledge, vendor interaction and end user support
Data modeling Relational modeling and dimensional modeling
Application development and design Familiar with .Net, VB Script, T-SQL, SSIS, SSAS
Advanced troubleshooting skills for Web based environment