Post Job Free
Sign in

Sql Server Engineer

Location:
Chicago, IL
Posted:
November 23, 2012

Contact this candidate

Resume:

Title:No Title

********@*******.***

Document

Source below

NAME:,

ADDRESS:

ADDRESS2:

CITY:

STATE: IL

ZIP:

CANDIDATE ID: 2924087

US CITIZENSHIP:

EDUCATION:

EXPERIENCE: 0

WILL RELOCATE: No -

JOB WANTED:

RATE NEEDED:

TELEPHONE: 312-***-****

EMAIL: ********@*******.***

HOMEPAGE:

HOTTEST SKILLS: database, sql, unix, database administrator, pentium, programming, cobol,

engineer, mfc, microsoft, oracle, os/2, software engineer, audit, economic, journal,

transaction

REVISION: 08-SEP-02

RESUME:

NAME: Sankari Kannan

ADDRESS: 544 W Melrose, Apt #464

Chicago, IL 60657

CITY:

STATE:

ZIP:

COUNTRY:

CANDIDATE ID: NA

EXPERIENCE: Not Entered

DESIRED POSITION: Not Entered - See Resume

WILL RELOCATE: Not Entered

US CITIZENSHIP: YES

JOB WANTED:

EDUCATION: Not Entered

RATE NEEDED: Not Entered

TELEPHONE: 312-***-****

EMAIL: ********@*******.***

HOMEPAGE:

COMMENTS:

HOTTEST SKILLS:

Sankari Kannan

544 W Melrose, Apt #464

Chicago, IL 60657

312-***-****

773-***-****

********@*******.***

SUMMARY:

Four years experience in Database Administration, Database Logical and

Physical Designing, Maintenance and software development and testing.

Primarily worked as MS SQL Server Database Administrator and Developer.

Strong skills in C, C, Visual C Programming, Quality Assurance and Testing.

I am looking for an assignment in Maryland or Washington DC Area.

OPERATING SYSTEM: Win 95, Win NT 3.51, DOS / Win 3.1, UNIX, Digital OSF/1,

ULTRIX.

LANGUAGES/GUIS:C, C, Visual C, SQL, COBOL, FOCUS

DATABASES:SYBASE, SQL Server, ORACLE.

HARDWARE:DEC Alpha, Intel Pentium based PCs.

ANALYSIS AND DESIGN:ERwin,OO Tool - Rational Rose for C

EXPERIENCE:

Chicago Title and Trust

(Aug '98- till date)

DBA (Consultant)

OS used:Windows NT

Database:MS SQL Server 6.5

Software Tool:Erwin 3.5

Work Description:

The job involves Database Administration and designing. The work also involves

complete database support and maintenance.The responsibilities as a DBA

are

Designing Logical and Physical Data Model.

Installation of SQL Server and its clients.

Creation/ Maintenance of user databases.

Performance tuning and monitoring the Database.

Running the database consistency checks.

Databases access co-ordination.

Database crash recovery.

Database dumps and back ups.

Creation/Maintenance of database users.

Creation/Maintenance of user defined tables.

Loading, Maintenance and bulk copying of data in the Table.

Advanced Health/Med-E-Systems

(Jul 97 - Jul '98)

DBA Consultant

OS used:UNIX, Windows '95

Database:Sybase SQL Server 11.5

Software Tool:CAST workbench

Version Manager:PVCS 5.3.00

Work Description:

The work involved administration and development in SQL server. As a Database

developer/administrator, responsible for,

Creating new user database.

Running the database consistency checks.

Maintaining the database users and creating new users.

Database security management.

Databases access co-ordination.

Bulk copying, database backup and loading data.

Writing and executing scripts to start shutdown and monitor the system.

Database designing, both Physical and Logical Layout using CAST workbench.

Writing transaction models.

Maintenance and management of the versions control.

Writing and implementation of store procedures and triggers.

Writing unit test scripts for all the stored procedures.

Testing the basic functionality of the stored procedure.

Query optimization.

Writing shell scripts in UNIX to convert from a Database version to another.

Writing and implementation of shell scripts to generate Index Sequential

Access Method(ISAM) files.

Organization:

The Oberoi, Bangalore (Jun 96 - Jun 97)

Systems Supervisor / System Administrator

OS used:ULTRIX, Digital OSF/1, and WinNT.

Database:SQL Server

Work Description:

The work involved System Administration, Database Administration and

maintenance of hardware and software, along with Trouble Shooting and helpdesk

Functions.Major portion of the work involved database administration.

As a Database Administrator, was responsible for the following:

Installation of Operating System Windows NT and MS-SQL Server Database.

Maintenance and Trouble Shooting of the server.

Database Design, including Physical and Logical Layout.

Database Access Co-ordination.

Security Processing.

Creating User Profiles and Assigning Requisite Security Levels.

Creating User Databases.

Maintenance and updating of system tables.

Database Auditing and Journaling to track the usage of system resources.

Implementation and Maintenance of Database and System Mirroring.

Implementation of Database Replication across Multiple Servers.

Database Crash Recovery.

Database Performance Tuning.

Maintenance and management of the user databases.

Writing Scripts for Automation of Database Backup and Recovery.

Timely database backups and purging of data.

Writing and implementation of Stored Procedures and Triggers.

Helpdesks functions.

User Training.

Organization:

NIIT, Bangalore(Jan 95 - Jun 96)

Database Administrator, Software Developer

OS:Windows NT, SCO-Unix

Database:SQL (4.x, 10.x), SQL Server.

Responsibilities:

Involved in System Setup, System and Database Maintenance, Database Design,

Installation, Setup and Administration.Major activity as the Database

Administrator included:

Installation of System and MS-SQL Server Databases.

Installation of Windows NT and SCO-Unix Servers.

MS SQL Server Database Administration and Maintenance.

Database Design and Modeling, including Physical and Logical Layout.

Database Performance Monitoring and Tuning.

Writing of Stored Procedures and Triggers.

Query Optimization.

Creating Database Partitions.

Creation of User and Security Profiles.

Implementation of automated Hot and Cold Backup and Restore Procedures.

Trouble Shooting and Training of Users.

Organization:

Sundram Numeric Pt. Ltd

. (Feb '94 - Jan '95)

Software Engineer

H/W and OS:Pentium, Win3.1.

Language:Visual C, MFC.

Project description:

The project involved developing an error handler for the CNC platform system

made by Grundig Numeric. It has two parts - Error Server and the Error Viewer.

While the server manages the data, storing it in log file etc., the viewer

provides the user interface. The development was done with Visual C, and

Microsoft Foundation Classes.

H/W and OS:PC with Pentium processor, OS/2.

Tools Used:CAST, SHAPE, iC286, PC Lint, IPMD Debugger.

Language:C, C.

Project description:

The project involved testing and integration of the PL/M 2 to C files. The

testing was done using the SHAPE (Shopfloor Assisting Programming Environment)

and also with the help of CAST (Computer Aided Software Testing).The final

testing was also done on the target system.Used IPMD debugger for

debugging.Also wrote part programs for testing the modules.

OTHER STRENGTHS:

MS Office tools for documentation.

UNIX System administration.

QUALIFICATIONS:

BS (Economics)

Advanced Computer Systems Management.

TRAINING:

Trained and Certified in software development using OOA/OOD.

VISA STATUS:

H1 -B (Work Permit)



Contact this candidate