Unclassified - Boca Raton, FL

posted 3 months ago

Full-time - Mid Level
Boca Raton, FL

About the position

The position of SQL DBA/Systems Administrator at a well-known financial conglomerate involves a comprehensive set of responsibilities centered around the management and optimization of SQL Server databases. The ideal candidate will be tasked with creating, monitoring, backing up, recovering, and tuning SQL Server 2008 R2 databases within a multi-platform environment. This role requires a deep understanding of High Availability solutions and replication techniques to ensure database reliability and performance. In addition to database management, the candidate will utilize various tools such as Data Collection, Performance Monitor, and Extended Events to effectively manage CPU and memory resources across multiple instances of SQL Server. Proficiency in copying and migrating SQL Server 2008 R2 databases is essential, as is the ability to analyze performance using SQL Server Profiler to fine-tune database operations. The role also demands expertise in providing production support for over 20 instances of SQL Server (2005, 2008, and 2008 R2) running on Windows Server 2003, 2008, and 2008 R2. The candidate will be responsible for 24x7 monitoring, maintenance, troubleshooting, and performance tuning of SQL databases. Familiarity with Windows, Great Plains, Investran, and QuickBooks 2008 R2 is preferred, along with banking and financial experience. The successful individual will work closely with the Accounting department and senior executives, including the Senior Vice President of Fund Accounting, CFO, and CEO, making this an excellent career opportunity with competitive compensation and great benefits.

Responsibilities

  • Create, monitor, backup, recover, and tune SQL Server 2008 R2 databases in a multi-platform environment.
  • Implement and manage High Availability solutions and replication for SQL Server databases.
  • Utilize Data Collection, Performance Monitor, and Extended Events to manage CPU and memory resources across multiple SQL Server instances.
  • Copy and migrate SQL Server 2008 R2 databases as needed.
  • Analyze SQL Server performance using SQL Server Profiler to optimize database operations.
  • Provide production support for over 20 SQL Server instances (2005, 2008, 2008 R2) running on Windows Server 2003, 2008, and 2008 R2.
  • Conduct 24x7 monitoring, maintenance, troubleshooting, and performance tuning of SQL databases.
  • Support the Accounting department and senior executives including the SR VP of Fund Accounting, CFO, and CEO.

Requirements

  • Experience in creating, monitoring, backup, recovery, and tuning SQL Server 2008 R2 databases.
  • Knowledge of High Availability solutions and replication techniques.
  • Proficiency in using Data Collection, Performance Monitor, and Extended Events for resource management.
  • Experience in copying and migrating SQL Server databases.
  • Ability to utilize SQL Server Profiler for performance tuning.
  • Expertise in production support for multiple SQL Server instances (2005, 2008, 2008 R2).
  • Familiarity with Windows Server 2003, 2008, and 2008 R2 environments.
  • Experience in 24x7 monitoring, maintenance, and troubleshooting of SQL databases.

Nice-to-haves

  • Banking and financial experience.
  • Familiarity with Great Plains, Investran, and QuickBooks 2008 R2.
  • Experience in a VMware environment.
  • Citrix SAN compliance.

Benefits

  • Excellent compensation package.
  • Great benefits including health insurance and retirement plans.
  • Opportunities for career advancement.
  • Supportive team environment.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service