8 + years DBA experience with ASE 15, Sybase 12.x.
Expert understanding of the ASE architecture, administration and security.
Understanding of Solaris operating systems.
Expert in Stored Procedures and SQL Coding.
Expert in query, index and Database IO performance tuning.
Expert understanding of Database design principals.
Understand the concepts of current hardware systems, RAID and SAN, NAS commonly used in fault tolerant production environments.
Ability to proactively identify, troubleshoot and resolve database systems issues.
Ability to manage all database maintenance plan activities including backups, indexing, integrity, reorganization and consistency checks, etc.
Experience running and supporting large databases under high transaction rates.
Plan, implement and maintain security at the database level.
Strong troubleshooting and analytical skills.
Strong ksh/ sh scripting skills.
Good verbal and written communication and interpersonal skills.
Strong team player, customer focused, service minded and self-motivated.
Knowledge of trading systems in equity markets a major plus.
Ability to prioritize, multi-task and work under stressful situations.
Should have handled data migration/ system integration projects.
Identifying scope for automations
Ability to work in Global Teams
Very good in Planning & Organizing & Handling critical issues
Very good interpersonal skills
Primary Technical Skills
Sybase ASE / IQ / Replication installation & Configuration 15.X
Strong in Replication, Performance tuning and Trouble shooting
SQL & T-SQL & Shell & Perl scripting.
Roles & Responsibilities
Handle all (Production and Non-Production) the environments.
Should be working on on-call rotational basis
Applying Sybase ASE patches on the installed Sybase ASE software.
Upgrade from lower to higher versions of Sybase ASE server.
Accountable for the assigned Changes, work requests.
Willing to work in shifts (no night shifts)
Handle RCAs and providing resolutions
Mentoring Team & Providing help / Technical recommendations / suggestions to team / business