Unbeatable Resumes (43 page)

Developed ER diagrams (physical and logical using Erwin and Visio) and mapped the data into database objects.

Wrote SQL queries to generate reports based on the business requirements.

Created stored procedures, views, triggers, constraints, and indexes.

SQL Server Developer

Veteran Flight is a world leader in commercial and military aviation repair, maintenance, and engineering. Developed the Helpdesk application database and worked with application developer to complete portions of the Chat application's database design and create objects.

Roles & Responsibilities:

Installed and configured MS SQL 2000 for Helpdesk and Chat application.

Installed service packs and security patches for MS-SQL Server.

Assisted in design, development, and implementation of various applications.

Migrated schema and data from development to production server.

Managed the use of disk space, memory, and connections. Ran DBCC consistency checks and fixed data corruption in application databases.

Experienced on backing up databases on HP Tru64 UNIX 4.0g.

A. Helpdesk Application:

Designed and implemented database for a Helpdesk application.

Created tables and column-level check constraints (primary & foreign keys).

Created stored procedures.

Created normalized tables.