SQL Server DBA

Description

AB utilizes the Microsoft SQL DBMS platform on Windows to host its BEC division database systems. AB is requesting consulting services from Vendor for maintenance, monitoring and support of approximately the SQL databases for BEC in various environments (development, test and production). The activities within the scope of this SOW include but are not limited to the following Assistance executing BEC related projects as directed by ABI project management 24x7 support of the production system for Break/fix situations.Problem research and resolution Firecalls.Recover data from backup.General technical support and Q&A. Problem research and resolution (dev, test and production).Archive log space errors.Tablespace and datafile space errors.Blocking locks.Application errors.Client software issues.Poor performance. Support for upgrades, patches and bug fixes.Upgrade client software, including ITRM and software distribution processes.Test administrative functions.Database upgrades and SQL patches KPI metrics collection and reporting. Application development support.Create/modify database objects (DDL), per ABI standards.Creation of new databases and userids, per ABI standards.Creation of standard roles and granting of accessrights, per ABI standards. Enforcement of AB security rules Removal of userids belonging to individuals who have separated from ABI.Removal of userids in violation of the 10day initial password rule.Removal of inactive userids.Firecalls disable after 24 hours.Change admin passwords every 90 days. Monitor the dev, test and production systems, and adjust/correct as needed.Any failure or error generated by a DBA/Opsowned monitor, report or maintenance job.Overall system performance, realtime. Customer application process alerts. Oracle monitor alerts.Overall system resource usage monitor top consumers and investigate as needed.Backups. Maintain backup scripts review automated report. Review automated report and correct items that could potentially cause failures. Verify successful completion and elapsed time. Investigate discrepancies.Tablespace and datafile usage minimum and maximum thresholds, per ABI standards.Archive log usage metrics collection, primarily for use in problem investigation.Monitor for longrunning transactions which could potentially impact performanceMonitor adherence to standards and correct noncompliant items. General technical support and Q&A.