|
Project |
NTS Dating.com optimization
and e-Commerce Development
|
| Organization |
Network Telephone Services, Woodland Hills, California |
|
Project Type |
On/Off-site Consultant and project development |
|
Duration |
Jan 2001 – Dec 2003 |
|
Platform/OS |
Windows NT 4.0, Windows 2000 |
|
Position |
SQL Server DBA and Technical Support Analyst. |
|
Software |
SQL Server 7.0/2000, ASP, Cold Fusion,
IIS 4.0/5.0 |
|
Description |
The project updates existing Dating.com site for better
performance and makes the site an e-commerce application with credit card processing on the internet. The site is getting 5-6 million hits a day. |
 |
|
Key Features |
- Instant, simple, and advanced search for matching
people
- Who is online
- Credit card payment
- Payment Administration
|
|
My Tasks |
- Install SQL Server 2000 and convert 7.0 databases and rewrite some stored procedures
for utilizing new features of SQL Server 2000.
- Apply SQL Server 7.0 Service Packs, archive old data, optimize SQL Server configuration,
and create maintenance
plans.
- Create or modify indexes, stored procedures, and views for better database performance
and new features.
- Support network administrators for SQL Server problems.
- Transfer data
into new databases and fix database corruption, rewrite stored procedures,
and triggers.
|