Sql Server Manager
Resume:
Title:Student Technician
******@************.***
Document
Source below
NAME: rashduni, claude
ADDRESS: ** ******* ****
ADDRESS2:
CITY: saddle river
STATE: NJ
ZIP: 07458
CANDIDATE ID: 2248985
US CITIZENSHIP: US
Citizen
EDUCATION: Bachelor Degree
EXPERIENCE: 5
WILL RELOCATE: Yes -
JOB WANTED: Any
RATE NEEDED: Open
TELEPHONE: 201-***-****
EMAIL: ******@************.***
HOMEPAGE:
HOTTEST SKILLS: dba =5+ yrs, sql =5+ yrs, sybase =5+ yrs, oracle =5+ yrs
REVISION: 03-OCT-01
YOE: 5
RESUME:
CLAUDE A. RASHDUNI
25 Cameron Rd
Saddle River, NJ 07458
or
Message
MS SQL / Sybase /ORACLE (DBA)
Work History & Experience:
1. SGCowen (
Society General & Cowen
),
(NY)Apr 1998Current
2. Prudential (NJ) Sep 1997Mar 1998
3.
Morgan Stanley & Co., Inc
. (NY) Mar 1997Sep 1997
4. Prudential
(NJ) Jul 1996Feb 19975. Bankers Trust/First Union
(
NJ) Jan 1996July 19966. L.I.T. Legal Information Technology
(
NY) Sep 1995Jan 1996
7. Comstar, Inc
. (NY) Apr 1994sep 1995
8. Management & Computer Consulting, Inc
.
(NJ) 19911994
Approx. 8 year experience in database administration, development, implementation and
architecture in the financial/ brokerages and banks
Sybase/MS SQL/ORACLE DBA
SGCowen (Society General & Cowen
)
April 1998Current
1 Financial Square, New York
Skills:
MS-SQL SERVER: SQL 2000, 7.0, 6.x, 4.2, Microsoft SQL cluster server, TSQL, Bcp, and Perl
scripts, procedures and triggers, replication server, backup/recovery, MS DTS, cubes,
linked server, Full-Text search.
ORACLE: Oracle 8i.x, 7.x, pl/sql, SQL*PLUS and Perl scripts, sql loader, parallel server,
collections and object views, object types, multiple instances and schemas,
backup/recovery RMAN, security manager, performance tuning, packages, procedures and
functions, data (import/export), performance pack, parallel query, knowledge of
replication.
SYBASE: Sybase 12, 11.x, 10.x, ISQL, BCP, Replication Server, Sybase Monitor Server,
Backup Server, omni connect, proxy tables, performance tuning, disaster recovery site,
perl scripts for backup, maintenance and sever analysis.
Operating system:
Unix: Solaris 8, 7, 2.x, System v, hp unix, aix.
Windows: 2000, NT 4, NT 3.5x
Shell languages: Perl (for Unix and win32), sh, csh, ksh, sed and awk.
Web: Java scripts, VB scripts.
Hardware: Data General cluster, Compaq 6500s, Sun E4500s and E4000, Sun sparc and
ultra, external storage RAID 10 mirrored raid subsystems more than 1/2 tera byte.
DBA Tools: Informatica, DB artisan, autosys, Sybase omni connect, Octopus, Direct
Connect, Erwin, Designer 2000
Experience on Oracle, MS-SQL server Sybase and Perl on cross platform UNIX and Windows
NT.
Experience in Data warehousing, monitoring application databases performance tuning,
security setup, backup and recovery, handling enterprise level databases.
Strong technical, analytical, business skills. Highly motivated and team player.
Managed very complex MS-SQL, Sybase, and Oracle environments on cluster boxes and
subsystems of more than half a tera byte.
Developed Perl scripts for data maintenance and assignment of security based on roles,
developed generic Perl scripts to load and extract data, monitor disk space growth, backup
and restore data, performance tune, automate jobs based on file arrivals, extract control
files for oracle from Sybases format files using the system tables/view in both oracle
and Sybase and visa versa, create generic job dependencies and flags for job automation,
routines to generate Sybase and MS-SQL BCP format files for given number of table and
views, create Perl scripts to load data into oracle using SQL-Loader. Data maintenance
routines using Perl and PL/SQL for Oracle parallel server loads.
Creating databases and all related objects for Sybase, MS-SQL server, and multiple
instance schemas for oracle.
Setup, installation, configuration and tuning of Oracle, Sybase and MS-SQL servers on
multiple cluster platforms Unix and NT servers.
Created server side java scripts using stored procedures to extract data from Microsoft
system management server.
Distribute the logs and data devices segments on different disks for Sybase, MS-SQL
servers and distribute tables, redo logs, archived redo logs and rollbacksegments on
separate disks for Oracle.
Created Security master database. Warehousing on Oracle 8i servers with its subsidiary
data marts on Sybase 11.x, 12 and MS-SQL 2000, 7 servers.
Developed Migration/Upgraded/Copy routines from Oracle 7.3.4 database to Oracle 8.1.7.
Developed Migrate / upgrade tasks for Sybase 11.x to 12 and MS-SQL 6.5 to 7 and 2000.
Developed Backup / restore / recovery (DMZ zone) plans on site / off site for MS-sql,
Sybase and using RMAN Oracle.
Created and maintained consolidated ODS operational data store for security master using
ADP data models.
Developed database physical and logical modules for Security master and account master.
Created scheduled data transformation packages using Perl, Informatica, MS-DTS, autosys
and data scripting and tools.
Sybase/MS SQL DBA/Developer
September 1997March 1998Prudential
(New Jersey)
Design and develop client transition database for a common front-end application in
Prudential. Features of the database are:
BCP data from other systems/databases (i.e. Onyx database),
Providing security grants and permissions on objects within the database for trusted and
non-trusted user logins, managing login securities, and performance tuning the database.
Additional tools used in both Sybase and MS SQL 6.5 on Unix HP9000 and NT platform:
Perl shell scripting, ISQL, BCP, Replication Server, Sybase Monitor Server, Backup
Server, DB Artisan, Erwin, S Designer, SQL Programmer, SP Debugger, SQL Performance
Monitor, SQL Trace, SQL Web Assistant. Sybase 11.5 and MS-SQL server database replication.
Database Analyst/Administrator
MarchSeptember 1997Morgan Stanley & Co., Inc
. (New York)
Develop & design hardware, software and license agreements database. Keeps track of.
Extracting data from Express Software Management, which feeds into System Management
Server (SMS) database located on the SQL Server and extracting hardware data from SMS by
creating views on the SMS Server. Create replication between MS-SQL databases residing on
SQL Server 6.5 to the production environment residing on Sybase 11 Unix platform
Creating multi type cursors to validate data after using BCP command line utility
Creating Logins, Groups, Users, and changing Groups using scripts, changing
Passwords and revoking rights
Creating Tables & Object Security
Analyzing data by creating queries on the System Tables
Creating Extended Stored Procedures, maintaining server side optimization,
Maintaining Query Optimization, using I/O statistics & show-plan
Database replication between countries
Creating analysis scripts to retrieve tables, columns, indexes
Maintaining data integrity
Senior Lead Database Programmer
July 1996February 1997Prudential
(New Jersey)
Database Development and Design involved:
(SQL Server 6.x & SYBASE 11):
SQL Server 6.x (Enterprise manager
)
SYBASE 11
(SQL Server manager)
DB Artisan (Database Development Tool)
ISQL
(in both SYBASE & SQL Server)
Developed stored procedures, Triggers, Rules, Defaults, Primary & Foreign Constraints,
User Defined Types, Tables, Keys, Indexes, Devices
Moving Data from MS_SQL Server to SYBASE using BCP command line utility & using the
temporary database, temp DB
Scripts to handle the referential integrity
Triggers to handle the cascading deletions, updates & insertions
Maintaining database options for (select bulk copy), single user, dumping transactions
log file, increasing database size by adding devices
Scheduling back ups for database devices, creating back up devices
Downloading data from Blomberg & formatting the data to the security Master Database in
Prudential, recording events & messages in error.log files and creating tasks to dump the
log file on a scheduled date.
Creating Alert messages for Blomberg Data download.
Creating Administrative procedures to alert the DBA on many events
i.e. Data device growth, security audit messages.
SHOW PLAN on certain alerts.
Development & Design Security Master Database (back-end using SYBASE 11 and SQL Server.
PVCS for multi developers script migration and versioning.
Financial knowledge, bonds, convertible bonds, securities & investment options, rights,
warrants, splits, futures, securities & issuing classifications, prices, exchanges,
coupons, scheduled corporate events, corporate activities, on-line services, etc.
Lead database Programmer
Jan. 1996July 1996Bankers Trust/First Union
(New Jersey)
Concentrated development in Sybase and MS-Server using stored procedures, triggers,
views, queries and sp_ commands
Sybase and SQL Server database administration, monitoring devices and disk I/O, tables
creation, indexes, user defined types, transaction log file and temp database,
Backup/ recovery plans show-plan and Shell scripting, security and user management.
Manager/Senior Programmer
1995Jan. 1996
L.I.T. Legal Information Technology (New York)
Managing Programmers /DBA s, coordinating project interface with
Directors/Programmers/Clients.
Administering Sybase and MS-SQL servers on NT 3.51, Unix servers.
Projects: Parsons, Bank of Tokyo, Cadwalader, American Express, Freed Frank, and Radio
City Music Hall.
Senior Programmer & System Analyst
19941995Comstar, Inc
. (New York)
Analyzing and developing complete accounting software, which are accounts payable,
accounts receivable, order entry, purchase order, general ledger, inventory control, etc.
ACTV broadcast system using MS Visual C++.
Programming Languages/OS:
Visual Basic for Windows, SQL-Server, Sybase 4.21, 6.0, ODBC, OLE, DDE, Windows NT 3.51,
MS-Visual C++ 1.5 & 2.0, MFC, Crystal Report Writer. UNIX (Altos), UNIX (SCO), Windows NT
3.5, MS Remote. Windows NT, Unix system V. Appgen for Unix, Dynamics for Windows, Real
World for Unix, Platinum and Great Plains
Projects: ACTV, MA Plumbing Supply, American Paper Sales and Medlink.
Programmer & System Analyst 1991/1994
Management & Computer Consulting, Inc. (New Jersey)
Analyzing system specifications, project leader in custom programming, installing,
consulting, interfacing accounting software with different programming languages
and customizing complete software packages.
Programming Languages/OS:
Visual Basic for Windows, Sybase, SQL Server, C language, Magic 5.02-4GL, Xtrieve.OS2
2.0, Unix SCO, TCP/IP, MS DOS 6.0, Windows NT 3.3
Software Packages: Platinum, Great Plains, Market Force, and Dynamics.
Projects: (MFO) Multi National Forces, Local Union 1342, Allied Office Supply,
Hospital Professional & Allied Employees, Jaegers Sportswear, Software House.
Education:
New Jersey Institute of Technology NJIT
Newark, New Jersey
Contact this candidate