SAP Sybase ASE DBA - multi-server enterprise environments - Associate

Job description

Team Profile:

A position has arisen for an SAP Sybase ASE DBA with experience supporting multi-server enterprise environments. You would join the L3 global distributed database service team who provide follow the sun 24x7 firm-wide “container-level” support for mission critical databases across the production, QA and test environments.

Your primary responsibility will be to provide SAP Sybase ASE DBA expertise however the position will also require you to assist in providing support for other database products including IBM DB2 LUW, and Oracle. On the job and formal training can be provided for these technologies.

Role Profile:

·  You will provide SAP Sybase ASE and Replication Server technical expertise
·  You will be responsible for outage/incident management – from initial troubleshoot/ resolution though to root cause analysis and driving subsequent corrective measure implementation.
·  You will provide consultancy services to application support groups/developers
·  You will be responsible for performance and tuning
·  You will handle L3 escalations from L1 and L2 groups
·  You will be responsible for project work including migrations, version upgrades, operational acceptance testing for products being delivered by the database engineering group etc.
·  You will define /review operational best practise and writing standard operational procedure documentation
·  You are involved in scripting, automation and bug fixes
·  You will be required to participate in the weekend on-call support rota

Desired profile

Skills required:

·  Strong database administration of SAP Sybase ASE versions 12.5.4 – 15.7 ideally in a Linux/Unix environment
·  Exposure to MPP setups with DB2 DPF (Database Partitioning Feature)
·  Exposure to Replication Server and administering large scale complex replication topologies
·  Performance and tuning:
·  Ability to use tools such as sysmon and MDA tables to identity instance level bottlenecks and provide corresponding configuration recommendations
·  Ability to read and understand query plans, understand optimizer decisions and provide recommendations for SQL / Index tuning.
·  Strong TSQL language knowledge
·  Working knowledge of Unix /Linux
·  Must be able to work with command line tools
·  Ability to work in a high pressure environment on mission critical production databases systems
·  Excellent communication skills (including strong written and spoken English)
·  Ability to multi-task / Excellent problem solving skills
·  Service focused with ability to build relationships with customers of the DBA group
·  Willingness to expand RDBMS knowledge and also work on/learn IBM DB2 LUW
·  Exposure to MSA/ HADR high availability solutions
·  Advanced ASE Optimizer Troubleshooting
·  Intermediate Perl / Shell or another scripting language
·  Knowledge of another RDBMS product ideally IBM DB2 LUW
·  Knowledge of ITIL frameworks

Company Profile:

Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services. The Firm's employees serve clients worldwide including corporations, governments and individuals from more than 1,200 offices in 43 countries.

As a market leader, the talent and passion of our people is critical to our success. Together, we share a common set of values rooted in integrity, excellence and strong team ethic. Morgan Stanley can provide a superior foundation for building a professional career - a place for people to learn, to achieve and grow. A philosophy that balances personal lifestyles, perspectives and needs is an important part of our culture.

Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximize their full potential.*LI-LT1