Please forward resumes for, Job Title: Sybase Admin/Support Location: Lansing MI. Duration: 6 Months
Job Description / Required Skills: Sybase Admin/Support (Upgrade from ASE 12 to ASE 15) Provide database administration support and operations for Sybase ASE databases. In order to fully provide those services, an expert in Sybase ASE databases is required to assist in upgrading from ASE 12 to ASE 15. This includes implementing partitioning; optimize performance, updating any stored procedures or triggers that are required as a result of the upgrade, streamline operations, and document operating processes. Responsibilities include establishing base operating guidelines and best practices. Database Server Hardware/ Software: E25K, Sun Solaris 10, Sybase ASE 12, Sybase ASE 15 * 5 years of experience in Sybase ASE database administration including performance evaluating and tuning. * 5 years of experience developing analyzing and tuning SQL Statements * Experience in upgrading between Sybase versions * Experience with ASE 15 upgrades and partitioning preferred. * Establish a step-by-step plan for the testing, migration, and optimization of the update from ASE 12 to ASE 15. This includes implementing partitioning, encryption, and optimizing operations after the upgrade of each system. The upgrade plan should include all environments: test, QA and production. * Coordinates physical changes to computer databases; and codes, tests, and implements physical database, applying knowledge of data base management system: Designs logical and physical databases, reviews description of changes to data base design to understand how changes to be made affect physical database (how data is stored in terms of physical characteristics, such as location, amount of space, and access method). * Establishes physical database parameters. Codes database descriptions and specifies identifiers of database to data base management system or directs others in coding data base descriptions. * Calculates optimum values for database parameters, such as amount of computer memory to be used by database, following manuals and using calculator. * Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. Specifies which users can access data bases and what data can be accessed by user. * Tests and corrects errors, and refines changes to data base. * Enters codes to create production data base. Selects and enters codes of utility program to monitor data base performance, such as distribution of records and amount of available memory. Thanks & Regards, Anderson Sr. Technical Recruiter
