|
A news media distribution application, which has in excess of 70 users, maintains 90,000 subscription accounts and has more than 8,000 bulk supply accounts. This application has over 10 external interfaces (BNZ Bank, printing companies, financial interfaces, internet interfaces, IVR phone system interface, etc) and is used for distribution, circulation, invoicing, financial reporting, internet data, and all subscriber information.
As a database administrator, Business Mechanix was responsible for the daily operations of the SQL 7 database, maintaining and optimizing scripts, performance monitoring and tuning, creating triggers, stored procedures and indexes, report writing and data integrity. |