Sami Syed

ORACLE CERTIFIED DBA

               - Introduction to Oracle 9I: SQL  

       - Oracle9I Database: Fundamentals I

       - Oracle9I Database: Fundamentals II

 - Oracle9I Database: Performance Tuning

Aug 99 - Jul 02                                Osmania University                                    Hyderabad, INDIA

Master of Computer Applications                                                                 Aggregate: 78.6 %

 Nov 96 - May 99                              Osmania University                                    Hyderabad, INDIA

B.Sc, Computer Science                                                                                 Aggregate: 64.2 %

Nov 97 - Aug 01                                        NIIT                                                      Hyderabad, INDIA

Professional Diploma in Network Centered Computing

Excellent Performance with Aggregate: 82.0%

Jun 02 – Jul 02                      Wilshire Software Technologies                          Hyderabad, INDIA

ORACLE DBA

Operating Systems            MS DOS, UNIX, Windows NT/ 2000, Windows 95/98/ME

Languages                         C++, C

Visual Languages              Visual Basic 6, Visual C++ with COM/DCOM & D2K.                      

Web Based Languages     HTML, JAVA, JDBC, Servlets, RMI, EJB, CORBA,JAVA

                                            BEAN, ASP                                                                                 

RDBMS                            ORACLE, SYBASE, SQL Server and MS Access

Applications                       MS OFFICE

Administration                  Windows 2000, Solaris

Database Administration  SQL Server 2000, ORACLE 9i

Database Administrator

ORACLE / SQL Server DBA              Omeir Travel Agency                 Oct 2003-Present

                                                                  Abu Dhabi, U.A.E.   

Responsibilities Involving

  Ø Installation of SQL Server 2k / Oracle 9i and Adding new patches.

  Ø Implemented Oracle’s & SQL Server logical disk-striping on server by spreading tablespaces and file group across disk-drives.

  Ø       Create new users and manage privileges.

  Ø       Manage and control user access to database.

  Ø       Performance tuning of Oracle 9i database on Server (includes Oracle init.ora, Oracle SGA, I/O balancing and memory tuning.

  Ø       Performance tuning for history tables to access the data faster.

  Ø       Suggested Backup Strategies for implementation of nightly backups using Cold and Hot Backups on    tape and disk.

  Ø       Daily backup of SQL Server Database.

  Ø       Customized the SGA (two init.ora files) for different types of requirements during the days & nights.

  Ø       Documentation of the dataflow and system design.

  Ø       Maintenance of Omeir Holidays and Omeir Call Center CRM packages.

  Ø       Adding new Developer forms to Omeir Accounts package.

  Ø     Maintenances of all Omeir Holidays and Omeir Call Center CRM dlls on Citrix Server

  Ø     System Analyst of Omeir Holidays CRM during modification.

  Ø    Coordinate with other companies for licenses related issues.

  Ø     Coordinate with other companies for approval of newly developed programmed.

  Ø     Complete Maintenance of Omeir Travel Agency Web Site.

  Ø    Responsible for giving Training to entire Omeir Holidays staff & Data entry on Omeir Holidays  CRM  software.

Note : Involved in Database Administration of Omeir Holidays Database and Omeir Call Center Database using SQL Server 2000. And Database Administration of Omeir Accounts Database using ORACLE 8.

Software Development

1. Software Developer        Onyx Interactive (P) Ltd.            March 2002-April 2003

Responsibilities involving 

      ·         System Analyst

      ·         Designing Workflow

      ·         User-Interface Designing

      ·         Database Designing

      ·         Module In charge

      ·         Module/System Testing and Debugging

·        Database Administrator

  Ø       Install Oracle 9i.

  Ø       Designed and developed table structures, PL*SQL stored procedures and database triggers to   implement business rules.

  Ø       Implemented Oracle’s logical disk-striping on server by spreading tablespaces across disk-drives.

  Ø       Create new users and manage privileges.

  Ø       Manage and control user access to database.

  Ø       Performance tuning of Oracle 9i database on Server (includes Oracle init.ora, Oracle SGA, I/O  balancing and memory tuning.

  Ø       Performance tuning for history tables to access the data faster.

  Ø       Suggested Backup Strategies for implementation of nightly backups using Cold and Hot Backups on tape and disk.

  Ø       Customized the SGA (two init.ora files) for different types of requirements during the days & nights.

  Ø       Documentation of the dataflow and system design.

  Ø       Training programmers with SQL, PL*SQL and Oracle Browser to create various reports for  weekly sales by store etc.

Note : Involved in complete Life Cycle of Onyx Estates System and Airways Management (Sharief Tours & Travels) as a DBA.

Worked on the projects using C++, Visual Basic 6.0, Java 2 with MS SQL Server 7.0 and ORACLE 9i.

2. Software Developer(Part Time)       M.V. Agencies       July 1999-February 2002

Responsibilities involving User-Interface Designing, Database Designing, Module in-charge, Database Administrator, Module/System Testing and Debugging. Worked on the projects using C++, Visual Basic 6.0, MS Access, SQL Server and ORACLE.

Graduate Tutor (Part Time)

Responsibilities included teaching BCA and Engineering Students in C, C++, Java and ORACLE DBA.

#1. Onyx Estates System

Software                        : Visual Basic 6.0.

Database                      : ORACLE 9I

Team Size                     : 4

Role                               : Analyst, Database Designer, DBA, Customer & Collection

                                         Agent Module In charge, System Testing and Debugging. 

Operating System        : Windows NT

Technologies Used      : ODBC

The project involved automation of Onyx Real Estates. Maintaining details of Venture, Scheme, Plots, Investors, Land Owner, Broker, Director, Architect Engineer, Inquirer, Site Visit, Travel Agency, Customer, Collection Agent and Agent. Over all it is totally integrated with Accounts maintaining day-to-day ledgers, Journal, Payments, Receipts. Reports need to be generated as and when required. Backup of entire data on incremental, cumulative and complete depending upon requirement.

#2. Airways Management (Sharief Tours & Travels)

Software                        : Visual Basic 6.0.

Database                      : ORACLE 9I

Team Size                     : 4

Role                                : Database Designer, DBA & Invoice Module In charge

Operating System         : Windows NT

Technologies Used       :  ODBC

This project is an automation of manual accounting system of Sharief Tours and Travels, which involved Invoice, Receipts, Bill Register Folio (BRF), Debtor Ledger, General Ledger, Cash Book, Credit Note Register (CNR).

#3. Invoicing System

Software            : Ms. Access

Team Size         : 2

Role                    : Project leader

This project deals with the regular maintenance of the accounts. The invoicing system further informs the availability of recourses with time-to-time enhancement of requirements and generates invoice for the customers automatically. It also gives a detailed report regarding the daily transaction along with maintaining inventory levels of the user. 

 #4. Video Library 

Software                        : VC++

Database                      : MS Access

Team Size                    : 2

Role                               : Project Leader

Operating system         : Windows NT

Technologies Used      :  ODBC

In this project we built an efficient system that maintains the summary of accounts in a video library. The rental time and the deposit of every client are recorded in the database. It also informs the daily collection including and excluding the deposits

#5. Online Banking

Software                        : Visual Basic 6.0

Database                      : ORACLE 8

Team Size                    : 1

Role                               : Project Leader

Operating System        : Windows NT

Technologies Used      : ODBC

Online banking project is a localized maintenance of all the transaction, which works as a desktop application or a distributed application as well. This application creates, alters, and maintains the account as a single system where as distributed application works for all those employees who are necessary for forwarding a transaction. It is fully secure in all aspects since it checks for intruders before logging into the network.

NOTE: The System Automation brings new life to the companies by increase in staff productivity and maximum customer satisfaction. It also helps the organization in generating accurate Reports/Information as and when required in no time.

The above-mentioned are some of the major projects on which I have worked. Furthermore, I have worked on Web Development on JAVA & ASP.

Ø Notable interpersonal skills, capacity to relate all levels of management & staff.

Ø Quick problem solving skills. 

Ø Known for best Analyst and Database Administrator.

Ø Fast Learner.

Ø Recognized for outstanding work ethic, integrity, thoroughness and commitments to corporate goals.

Ø Solid Project management skills with effective combination of assuming multiple responsibilities & innovation to consistently meet objectives.

Ø Dedicate to exceptional company service, able to cultivate positive rapport & nature relationship by offering service beyond expectation.

“….I recognize you are a loyal, dedicated individual with a positive attitude and desire to be successful. I can’t express in words my appreciation to you for all you’ve done for the company”. Mr. Reyaz Mohiuddin, Director, Onyx Interactive (P) Ltd.

Ø Best Programmer award for year 2002 Onyx Interactive (P) Ltd.

Ø Out standing student of  year 2000 NIIT, Abids Branch & year 2001 Wesley PG College.

Father Name          :    Syed Habeebullah

Date of Birth           :    10th August 1980

Marital Status         :     Single

Gender                    :     Male

Passport Details

Passport No.          :     E2996819

Date of Issue          :     07/08/2002

Date of Expiry        :     06/08/2012

Place of Issue        :      Hyderabad

Syed Samiullah,

Database Administrator,

Omeir Travel Agency,

Abu Dhabi, UAE.

Dated: 13th October 2004