Sql Server Project

Search Jobs

Create Resume

Edit Resume

Free Resume Search

Member Resume Search

YourCompany.RecruiterHome.com

Name: Mohammed Amir Khan Desired

Job Type:

Phone

Number: Desired

Employment Type:

E-Mail: Willing

to Relocate:

My

City: Degree

Obtained:

My

State/Prov/Country: Willing

to Travel:

My

Experience: Authorized

to Work in U.S.:

Currently

Looking: Industry

Category:

Professional

MOHAMMED AMIR KHAN

Profile Summary

Over 8 years of experience that includes analysis, programming, support, installation, network and database administration.

Worked 4 years as a database administrator for MS SQL Server databases, and supported applications with efficient back-end processing.

Proven abilities to direct and troubleshoot, database administration and network administration.

Physical database design, Development, Performance Tuning (with Profiler) and Query optimization (with Show Plan).

User Management, Security, Backup and Recovery.

Well versed in implementing and administering Windows NT 4.0, SQL Server 7.0 and internetworking with TCP/IP.

Including the back end development, writing stored procedures and triggers with Transact SQL (T-SQL), worked with the development team in implementing Object Oriented, Client/Server applications using Visual FoxPro 5, Visual Basic 5 in the Environment of Windows 9x, Windows NT 4.0, Novell 4.11, and SQL Server.

Software

Database : SQL Server 6.5 / 7.0 / 2000, ORACLE 8 and MS Access.

Languages : Visual basic, Visual Foxpro

Operating System : Windows 98 / NT / 2000, Novell, Citrix and UNIX

Knowledge of : IIS, ASP, MS Project, Crystal Reports, Forest & Trees

Experience

(In order of most recent first)

Credit Research, USA January 2001 - June 2001

Credit Research Inc. is a national company specializing in credit reports. It has an extensive background in mortgage banking and real estate industries.

Database / Network Administrator

Responsibilities and Achievements

Installation and administration of Windows 2000 and SQL Server 2000.

Installation of ORACLE 8 and data conversion with SQL 2000.

Creating database and indexes

Creating stored procedure.

Working on testing of database, queries optimization and performance.

Implementing a DBA maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space).

Backup / Restore, User creation, Security policy.

DULSCO, Dubai, UAE.(Group of companies) June 1997 - December 2000

Systems Specialist

Responsibilities

Responsible for the overall integrity of the project.

Upgrade SQL Server 6.5 to SQL Server 7.0 in production environment.

Overall management of the system including conceptual and physical database design.

Responsible for backup, restoration, maintenance plans and databases security.

Batch programming, stored Procedures, triggers with T-SQL and optimizing queries with Show Plan.

Transform and Uploading of periodic data from remote with DTS and.Configuring SQL clients.

Other then administration, the job responsibilities include helping in developing applications using Visual Foxpro, Visual Basic.

Following are some of the in house projects:

System Upgrade Project in Test Environment

Description

Testing the Upgrade process from the existing NT 4.0 and SQL 7.0 to Windows 2000 / SQL 2000 and Citrix Server.

Role

Finding the feasibility and problems in the process if there is any.

Test all the applications are performing with new environment.

Documenting the process

Payroll Project

Description

00Full featured Payroll system from time card processing to check printing. Payroll system has been specially designed to provide the high-level sophisticated information over the corporate network. Which also allows management the ability to track cost/job accounting, employee Information etc. and allows individual employees to view there own payroll and personal information.

Role

Installing and configuring MS SQL Server Service Packs applicable.

Participated in Database Designing.

Setting up MS SQL Server and database configuration parameters.

Configuring MS SQL Server Clients.

Developing and implementing DBA maintenance plan.

Daily monitoring of MS SQL Server activity, error logs, NT event logs, space usage and security.

Developing and testing a backup and disaster recovery Plan.

Configuring and auditing MS SQL Server security.

Managing database object permissions, user accounts and passwords.

Administering NT Security for MS SQL Server.

MS SQL Server performance monitoring and optimization.

Analysis of MS SQL Server long-term performance trends.

Creation of MS SQL Server database devices, databases and database objects.

Scheduling and managing jobs on MS SQL Server.

Monitoring jobs performance and impact on normal operations.

Documenting MS SQL Server logical and physical design.

Stock Control & Production Management System Project

Description

Full featured stock control / production management system integrated with GL, payable and receivable. The production module keeps track of production-related issues like waste management and unit conversion.

Role

Configuring MS SQL Server.

Implementing business rules.

Setting up referential integrity.

Creating stored procedures, triggers and other databases level constraints.

Setting up user rights integrated with Windows NT security

Optimization and tuning by setting up appropriate indexes and regular data maintenance.

Participating in database modeling and logical and physical design.

Participating in the application development process and code reviews of database objects.

Creating database design and development standards.

Bench marked and run time improved production systems.

Uploading of periodic data from remote sites.

Documenting MS SQL Server database design, implementation and configuration.

Developing scheduled task scripts.

Sakshym Services Pvt. Ltd., India, (IT Consultants) June 1996 - January 1997

Systems Analyst

Systems Study, Database designing, Leading the team of four programmers. Following are the Projects details:

Software for Full Fledged Money Changers Project

Description

This is the total solution for foreign currency exchangers having complete functionality of financial accounting, keep records of money exchanging and producing FLMs & MIS.

Development Tool : Visual Basic 4.0, MS Access 2.0

Operating System : Windows 95, LAN 3.0

Responsibilities : Analysis, Database Designing and provide help in coding.

Senior Project Assistant May 1994 - June 1996

Analyzing the problems on customer sites, trouble shooting, provide training to the clients and software demos, support in conversion of manual accounting to computerized, providing help in developing new software and systems administration. Following are the Projects details:

Clinic Management System Project

Description

This has been made for Nafees Clinic to make invoices and cash memo and record the patient history and doctor s earnings and produces other informative reports.

Development Tool : Visual Basic 4.0, MS Access 2.0

Operating System : Windows 95, LAN 3.1

Responsibilities : Analysis, Database Designing, Programming and Support

Integrated Travel Management Project

Description

Software is meant for IATA approved travel Agents to provide Airlines reporting, financial accounting, ticket stock maintenance and MIS.

Development Tool : Foxpro 2.6 for Windows

Operating System : Windows 3.1, LAN 3.1

Responsibilities : Trouble Shooting, Training, Developing new Modules as per

the client requirements.

M. K. AGGARWAL & CO. India, (Chartered Accountants) April 1993 - April 1994

Programmer /Network Administrator

Computerizing the office work supervising the operators, provide training to the users, auditing the network resources and user creation, taking regular backups and securing the application and database. Working environment consist of DOS and LAN 3.1, xBase packages and financial application.

Educational and Professional Qualification

Graduated from Delhi University in English Hon s. From Delhi, India.

Higher Diploma in Software Engineering

From APTECH, South Ex., New Delhi, India.

Covered Structured Systems Design, C, UNIX, Computer Network, Client Server Technology, CASE, RDBMS with ORACLE, SQL*Plus, PL/SQL, SQL *Forms, SQL *ReportWriter.

Diploma in Computer Applications

From American Institute of Technology, South Ex, New Delhi, India.

Covered Systems Analysis & Design, DOS, UNIX, WordStar, Lotus, dBase, BASIC, COBOL, C, EDP Concepts and Computer Center Management.

Certificate from Real Time Information Technology, Safdarjung Enclave, Delhi, India.

Covered Developer 2000/(Forms 4.5 & Reports 2.5) in ORACLE 7.

Certificates From Institute of Network Technology (Microsoft Authorized Technical Education Center) Vikas Marg, New Delhi, India. (www.intindia.com)

Covered (578) Networking Essential,

(803) Administering MS Windows NT Server,

(687) Supporting MS Windows NT [Core Technologies],

(689) Supporting MS Windows NT Server [Enterprise Technologies],

(688) Internetworking Microsoft TCP/IP on MS Windows NT,

(936) Creating & Managing Web Server MS Internet Information Server 4.0.

Diploma in Financial Accounting from Delhi Institute of Management Services, Cannaught Place, New Delhi, INDIA.

Reserve Yours Today! - YourCompany.RecruiterHome.com

©2007 Bright and Professional - Web Resume

©2007 Bright and Professional - Web Resume

Contact this candidate