The client database team is looking for a SAP/Sybase IQ expert, to work in a fast paced environment, providing both production & development support. This position will work closely with various development groups across the firm, and should demonstrate his/her ability as a technical expert on the team.
â¢ 10+ yearsâ experience as an SAP/Sybase IQ Administrator. Do not apply if you do not have IQ experience.
â¢ Experience in use of T-SQL for SQL Code and stored procedures are required.
â¢ Experience in shell scripting is required.
â¢ Experience in architecting multi-terabyte systems, including a proven track record of physical optimization, query optimization and capacity planning.
â¢ UNIX (specifically Linux) skills including but not limited to volume management, kernel parameter analysis, shell scripting, understanding of networking concepts.
â¢ Proven track record of SQL and database tuning on VLDBs.
â¢ Outstanding problem solving and analytical skills.
â¢ Good communication skills.
â¢ Good interpersonal skills; able to build consensus and work closely with fellow DBAâs.
â¢ Bachelorâs Degree in Computer Science/Engineering, Management Information Systems, or equivalent.
â¢ Provide production support, solutions and expertise for SAP IQ.
â¢ Ability to support SAP ASE, Microsoft SQL Server in a backup capacity.
â¢ Ability to troubleshoot difficult production issues quickly.
â¢ Work closely with various development teams across the firm to ensure proper use of Oracle features, best practices, and adherence to client database standards.
â¢ Train and mentor developers in methodology and best practices.
â¢ Participate in the DBA team on call rotation.
â¢ Tune complex SQL proactively & reactively as required. Be able to rewrite SQL queries where necessary.
â¢ Design, implement, and maintain capacity planning for client database systems.
â¢ Perform Database Upgrades as required.
â¢ Help design, maintain, improve and implement monitoring tools.
â¢ Handle your share of DBA tickets, user requests, routine support and maintenance.
â¢ Ability to work off hours / weekends as required.