Database Administrator

Description

Ronin Capital is seeking to hire a Database Administrator with expertise in Sybase ASE, Replication Server, and data warehousing products. This position entails creating and maintaining data models, structures and stored procedures for missioncritical trading applications. This position will be located in our Chicago, IL office. Responsibilities Installing and maintaining Sybase ASE & ReplicationServer instances Creating and maintaining Sybase databases Monitoring of all Sybase databases, products and events to ensure 24 x 365 uptime for missioncritical databases Ensuring that database replication and backups happen in a timely fashion Ensuring that data access meets compliance and security model requirements Ensuring that physical data models optimally implement logical data models Continually measuring & improving database performance Developing & promoting standards and tools for data ingest, access Maintaining dialog with data vendors, staying appraised of changes to data semantics. Working with developers in refactoring data models and processes as required Documenting systems and procedures Applying patches and upgrades to database servers and host platforms Building & maintaining symmetric development / QA / production database environments Developing and testing for disaster recovery scenarios Performing index optimization and database performance tuning Providing ongoing capacity planning for future projections of hardware requirements and/or configuration changes Developing applications, reports, and web queries for endusers Providing troubleshooting and real time database performance monitoring Tuning database parameters for optimal systems performance Ensuring proper setting of system configuration parameters Ensuring that databases have optimal data file and log file sizes Developing and maintaining Unix/Windows scripts that support database functions Providing, or identifying domain expertise for data in the databases Assisting with MSSQL Server & MYSQL DBA support as required Ensuring that the proper tool is used for each task (e.g. decision support, reporting, etc.) Developing & supporting enduser data access tools Participating in secondtier support rotation Performing related duties as assigned