Sr. SQL Databases Administrator

” The Job Descriptions”

Manage the entire SQL servers environment in OSHCO and OFC (Day to day operation for SQL servers, implementation for a new SQL server environment, Documentation, Policy/Procedure).

• Scope of Work :

1. Conduct performance tuning activities designed to optimize data management processes; and recommend performance enhancements such as increasing storage capacity or modifying interfaces working with desired applications.
2. Perform load balancing, redundancy and fault tolerance, optimize systems performance, reallocate resources, and recommend additional components to improve overall system performance.
3. Design in writing, MS SQL database structures as well as make design enhancements to existing MS SQL databases based on application requirements.
4. Document all elements of existing and new database designs.
5. Produce design documents supporting the automated exchange of data between internal and external data sources.
6. Design data models and database schemas.
7. Produce an implementation plan or plans relating to new and/or enhanced database technologies.
8. Develop and/or enhance MS SQL database structures based on application requirements.
9. Develop the automated exchange of data between internal and external data sources.
10. Consolidate the SQL servers in central Cluster environment.

Tagged as: DB, MS., SQL