|
Project |
Intranet Application,
Dating.com, Internet Card processing Application |
| Organization |
MOVO MEDIA Inc., Los Angeles, California |
|
Project Type |
On-site Consultant and project development |
|
Duration |
Jan 1999 – Dec 1999 |
|
Platform/OS |
Windows NT 4.0, Windows 98 |
|
Position |
SQL Server Production DBA/Data warehouse Designer |
|
Software |
SQL Server 7.0, OLAP Manager, Cold Fusion,
IIS 4.0, Access
2000, FrontPage 2000, Excel 2000 |
|
Description |
The Dating.com facilitates matching people who would like
to get dating for whole world. |
 |
|
Key Features |
- Matching people for dating.
- Searching people based on profiles.
- Provide messaging between parties.
- Searching profiles in data warehouse (DW) for marketing
department
- Updating DW cubes
|
|
My Tasks |
- Installed and upgraded SQL Servers/clients (6.5
and 7.0) on Windows NT Network environment.
- Managed 8 SQL Servers and nearly 30 databases with total of 20 GB of data.
- Setup integrated security with Windows NT and granted/revoked permissions.
- Setup SQL Mail, Agent and MSDTC. Monitored and optimized user accesses, disks spaces
and memory usage and database growths and did reconfiguration on SQL servers.
- Backed up and recovered databases. Replicated databases between servers. Allocated
spaces for databases and transaction logs, and analyzed error logs for troubleshooting.
- Forced and checked data integrity and transferred data in/out from servers with
bcp and MSDTC.
- Redesigned, administered and optimized backend database of
www.dating.com that has over 2 million hits a day.
- Wrote administrative stored procedures. Helped and trained developers to optimize index and queries and normalize databases.
Documented databases.
- Designed OLTP databases for E-Commerce, Credit Card Payment, Customer Service and
Technical Support Intranet projects.
- Created OLAP Databases and cubes for Data Mart, Reporting and Data Warehousing projects.
Used Excel 2000 as OLAP client.
- Trained and educated end-users. Designed data models and diagrams and setup ODBC
links to back-end databases.
- Used Access 2000 and FrontPage 2000 to create dynamic WEB pages and reports for
INTRANET.
- Coordinated developers and projects.
|