Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
S tevens Capital Management LP (SCM) is committed to a workplace that values and promotes diversity, inclusion and equal employment opportunity by ensuring that all employees are valued, heard, engaged and involved at work and have full opportunities to collaborate, contribute and grow professionally. W e are seeking a highly motivated and intellectually curious Database Administrator to join a research and trading development team responsible for developing and deploying leading edge mission critical financial trading applications. You will join in the management of proprietary and Sybase database systems to that facilitate management of large scale time series databases. As this environment continues to grow we seek a Database Administrator to work on all aspects of our databases, from high performance online transaction processing (2000tps) to data warehousing (250G+ servers) issues. This is a fast-paced/demanding environment. The user base consists of 20 technical and 20 non-technical users. SCM's selective hiring process considers only highly talented individuals with a history of exceptional professional and academic achievement, and solid real-world experience. P rimary
Responsibilities:
A dminister, maintain, monitor, and optimize database systems to ensure performance, availability, and reliability.
D esign and support relational database structures using sound database design principles and best practices.
P erform database backup, restore, disaster recovery planning, and recovery operations.
C onduct capacity planning and proactively manage storage growth and infrastructure needs.
M onitor and tune database and server performance to maximize efficiency and system responsiveness.
M anage database security, including user administration, permissions, and access controls.
T roubleshoot database issues and perform root-cause analysis for incidents and performance bottlenecks.
D evelop and maintain scripts and automation tools for administration and monitoring tasks.
S upport and administer alternative data storage technologies and platforms.
C ollaborate with development and infrastructure teams to ensure database solutions align with business and technical requirements.
R equirements:
S olid understanding of S QL, relational database fundamentals, and database design principles.
E xperience administering
S AP ASE
(Sybase/SAP) or other enterprise database systems.
S trong experience with database platforms such as M icrosoft SQL Server and/or S ybase/SAP ASE.
W orking knowledge of:
B ackup and Restore procedures
C apacity Planning
S erver Performance Tuning
U ser Administration and Security Management
E xperience with database performance monitoring and troubleshooting.
K nowledge of programming in both l ower-level languages and s cripting languages for automation and tooling.
A bility to administer and support alternative data storage technologies including:
K afka
P ostgreSQL
M ySQL
S trong analytical and problem-solving skills with attention to detail.
E xcellent communication and collaboration skills. T