Junior Sybase DBA

Location: New York, NY

Department: Technology

Type: Full Time

Min. Experience: Entry Level

Responsible for the monitoring, maintenance and operational support of Sybase database management systems for a leading bond trading firm. This position maintains the reliability, stability and performance integrity of the databases, as well as data feeds, internal administrative web pages, and internal Perl reports.

Job Description

  • Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required.
  • Maintain internal PHP reports, Perl datafeeds, and Perl batch reports.
  • Sybase installation, upgrades, migrations and configuration.
  • Perform ad-hoc database backups and restores.
  • Monitors relational databases to optimize database performance, resource use, and physical implementations of databases; addresses a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
  • Maintains development, test, and production relational database management system environments.
  • Recommends testing and evaluation of new procedures, software, and hardware.
  • Maintains currency of knowledge with respect to relevant state-of-the-art technology, equipment, and/or systems.
  • Will participate on a team providing 24-hour on-call support.

Skills & Requirements

  • UNIX scripting
  • Perl scripting (DBI, FTP, SCP, AWS, Secure Sockets, MQ)
  • PHP (Sybase, Javascript, AJAX)
  • Transact-SQL stored procedures
  • Data modeling/physical data design
  • Excellent written communications skills, detail oriented
  • Ability to analyze and solve problems, prioritize and organize, work under pressure, and know when/how to ask for help.
  • Must be able to work off hours (nights and weekends) as part of balancing 24/7 support.
  • Can walk through a simple Sybase installation process.  (Start, Stop, Devices, Databases, Tables, SQL, DDL, monitoring Scripts, Backup/Restore, etc.)
  • Interest in financial markets
  • BS or MS degree in Computer Science or a related technical field

Nice-to-Haves

  • Replication Server
  • Adaptive Server Clustering
  • Disk Array Technology

About TMC Bonds L.L.C.

Culture

TMC has a strong commitment to respect of our team members both in the office and out of it.  Unlike most finance IT firms TMC is not about pointlessly putting hours in.  TMC has a results oriented culture but we strongly believe in a work life balance and plan our projects accordingly.  We are also not above the occasional (or not so occasional) light hearted practical joke.

Benefits and Perks

TMC is located in the heart of midtown east Manhattan with easy access restaurants, bars and transportation.  TMC offers highly competitive salaries, 401(K) with employer match, and a comprehensive package of benefits (including medical, dental, FSA/HSA, transit, company paid life & disability, etc.).  Of course TMC also offers free drinks and snacks.  You will work with a dedicated and talented team of software engineers focused on building the best fixed income trading platform on the street.  For superior candidates, we will sponsor H-1 visas.

About TMC Bonds

TMC Bonds is a leading fixed income trading platform based upon cutting-edge technology serving institutional clients and B2B partners. TMC Bonds is an independent private company with 75 employees based in mid-town Manhattan. TMC’s ownership includes a consortium of leading financial services firms including Bank of America Merrill Lynch, Citi Global Markets, Morgan Stanley, and Assured Guaranty. Fixed income markets served include Certificates of Deposit, CMOs, Corporate Bonds, Municipal Bonds, $-Denominated International & Sovereign Debt, Structured Products, US Government Agencies and Treasuries.

Forward this Position
Recipient email address (one)
Your name
Your email address
Enter a message (optional)
Human Check*
Apply for this Position
* Required fields
First name*
Last name*
Email address*
Phone number*
Resume*

Attach resume as .pdf, .doc, or .docx (limit 2MB) or paste resume

Paste your resume here or attach resume file

What’s your highest level of education completed?*
Website, blog or portfolio:
Can you work weekends?*
Can you work evenings?*
Have you ever been convicted of a felony?*
In 150 characters or fewer, tell us what makes you unique. Try to be creative and say something that will catch our eye!*
Are you okay to participate on a team providing 24-hour on-call support?*
How many years of the 1-3 years, which we seek, have you worked with Sybase?*
What is your preferred unix shell?*
In the context of Sybase what are sysobjects and a primary key?*
What’s the difference between OLTP & OLAP?*
What file streams might a database support or data load script monitor?*