Sybase Database Administrator
- Xploretech Global
- 3 to 8 Yrs
- Bengaluru
- 5 years ago
- Email to a friend
- Report this job
Job Description
RESPONSIBILITIES:
Build new 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.
Develop lsquobest practicesrsquo standards for server development and management.
Maintain Sarbanes- Oxley security practices and standards.
SKILLS AND EXPERIENCE:
Previous experience with Database Methodology, Database Management tools, current Database Standards, Data Modeling, Data Modeling tools and Meta Data Management
Proven knowledge of the relational database modeling and solid theoretical knowledge of relational database techniques
Proven knowledge of T- SQL development methodologies, with data models, market data feeds, Reuters and Bloomberg.
Proven knowledge of Sybase performance tuning for server and application support.
Proven knowledge of various Sybase support tools
Previous experience in logical and physical database design, hands- on data modeling techniques, and development methodology; physical schema design of table spaces, rollback segments, and data files
Proven knowledge of database normalization techniques
Demonstrated ability to work independently, handle multiple tasks simultaneously and adapt quickly to changes
Demonstrated excellent communication (verbal and written) and interpersonal skills, and ability to gather and understand requirements in the financial sector
TECHNICAL KNOWLEDGE/ SKILLS:
ASE
IQ
Linux
Replication Server
Shell Scripting
Solaris
Sun Sparc Solaris
Sun Solaris10x86 (Intel/ AMD chipsets)
SQL
Sybase
UNIX
Trading Applications
,
Employement Category:
Employement Type: Full timeIndustry: IT - Software
Role Category: Network / System Administration
Functional Area: Not Applicable
Role/Responsibilies: Sybase Database Administrator
Contact Details:
Company Name: LoreLocation(s): Bengaluru
Similar positions
Xploretech Global
IT/ITES Consultant, with a Payroll and recruiting domain,currently serving multiple clients in regards to manpower services.
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in
