Sybase and Sql Server DB Admin

Job Details

Technical/Functional Skills

Sybase and Sql Server DB Admin

Experience Required

8 years of experience on Sybase Administration (preferably OCP)

Build new Sybase ASE database servers in support of both production and QA needs.

Upgrade servers to newest supported revs of Sybase including latest EBFs.

Determine and test tuning parameter settings and trace flags required to provide optimal server performance.

Maintain a database housing all relevant information about production and QA servers; including their Solaris OS or Linux OS versions and settings and Sybase configuration information.

Coordinate with UNIX System Administrators to insure new servers hardware specifications meet current requirements - including CPU, disk array, disk drive and solid state devices.

Interface with peers in Sybase user groups and symposiums to insure industry experience is available to ITG.

Respond to server or database software outage on a 24 x 7 rotation.

Open and follow-up Sybase cases resulting from outages.

Assist application administration with production releases where database issues are involved, including but not limited to migration of data from old to new schemas.

Recover corrupted databases from backups and source data.

Evaluate software acquisition targets in development and QA environments.

Evaluate alternatives when multiple products are available.

Recommend and justify acquisition as appropriate

Assist UNIX System Administrators with releases of software to target servers.

Review server performance statistics and report trends to application groups.

Perform real-time monitoring of databases in distress.

Analyze server performance and recommend appropriate remediation when required.

Insure development production plans are in place for all significant server change projects

Review all development production plans for supportability and insure compliance with accepted best practices.

Create new database server plans and schemas to insure efficiency and supportability.

Responsible for identification and mitigation of risks and vulnerabilities

Prepare disaster recovery (DR) plan and demonstrate successful functioning of DR

Should have exposure in SQL database administration

Must be able to

Lead the participate in outage calls

Create the Standard Operating Procedure and update the knowledge database documentation whenever required

Participate in daily/ weekly/ monthly/ customer / internal meetings and provide activities report.

Follow Compliance and Regulation policy of TCS and Customer

Understand the SLA and ensure the SLAs are met as per the TCS agreement with customer

Keep the Inventory up to date for global locations

Work with offshore team and ensure deliverables are delivered on time

Good understanding of Incident, Asset, Problem and Change Management (ITIL)

ITIL Certification