Design and document database architecture, data modeling.
Build database scheme, tables, procedures and permissions.
Develop database utilities and automated reporting.
Create shell scripts for task automation.
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.
Install and test upgrades and patches.
Provide 24/7 support for critical situations.
Evaluate and recommend new database technologies.
Manage and update Index\\query tuning for developers.
Ensure timely SQL patching and app add-ons on regular basis.
Ensure local/live Database Backups are taken regularly and maintained properly.
Maintain strong liaisonwith in-house developers for any issue that effect the applications.
Conduct regular Database health check and maintain all the records.
Forecast for future requirements in terms of space, storage and other related hardware/software to meet future requirements.
Ensure proper planning and steps for disaster management and recovery.
Take precautionary measures for database health and disaster management.
Other duties and responsibilities as assigned by the management.
Skills Required:
Experience and/or knowledge with large scale clustering, migrations, load balancing, and high availability environments
Experience with SQL 2005 / 2008, SQL 2008 Developer & Enterprise, Transact SQL (TSQL), and SQL high availability technologies.