Senior SQL Database Administrator

$116,000 - $156,000/Yr

Wedbush Securities - Los Angeles, CA

posted 3 months ago

Full-time - Mid Level
Los Angeles, CA
51-100 employees
Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

Wedbush Securities is one of the largest securities firms and investment banks in the nation, providing innovative financial solutions through its Private Client Services, Capital Markets, and Clearing & Execution divisions. The company is headquartered in Los Angeles, California, with over 100 offices and more than 80 correspondent offices. The commitment to providing relentless, customized service is the foundation of Wedbush's consistent growth. The Los Angeles office is seeking a Senior SQL Database Administrator who possesses expertise in managing diverse database environments, including Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server. The ideal candidate will have a deep understanding of database architecture, performance tuning, and disaster recovery strategies across multiple platforms. This role is critical in designing, implementing, and maintaining the organization's database infrastructure to efficiently support business needs. The Senior SQL DBA will be responsible for managing and administering databases across multiple platforms, performing installations, configurations, and upgrades while adhering to best practices and security standards. The role involves monitoring database performance, optimizing queries, troubleshooting performance issues, and implementing security measures. Additionally, the DBA will design database schemas, tables, and indexes, work closely with developers to enhance application performance, and implement high availability solutions for mission-critical databases. The position also requires developing and maintaining backup and recovery strategies, managing databases in Azure Cloud environments, and documenting configurations and procedures for reference and training purposes.

Responsibilities

  • Manage and administer databases across multiple platforms, including Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server
  • Perform database installation, configuration, and upgrades following best practices and security standards
  • Monitor database performance, optimize queries, and troubleshoot performance issues to ensure optimal performance and scalability
  • Implement and maintain database security measures, including user access controls, encryption, and auditing
  • Design database schemas, tables, and indexes for optimal performance and scalability
  • Work closely with developers to optimize database queries and improve application performance
  • Implement database partitioning, sharding, and replication strategies to distribute data and improve availability
  • Implement high availability solutions such as failover clustering, Always On Availability Groups, and database mirroring for mission-critical databases
  • Develop and maintain database backup and recovery strategies to ensure data integrity and minimize downtime in the event of failures or disasters
  • Perform regular database backups, test restore procedures, and implement disaster recovery drills
  • Manage databases in Azure Cloud environments, including Azure SQL Database, Azure Database for PostgreSQL, and Azure Cosmos DB
  • Implement Azure services for data storage and analytics, such as Azure SQL Managed Instance, Azure Blob Storage, and Azure Data Lake
  • Monitor Azure resources, analyze performance metrics, and optimize database configurations for cost-efficiency
  • Document database configurations, procedures, and troubleshooting guides for reference and training purposes
  • Maintain up-to-date documentation of database inventory, configurations, and change management processes
  • Perform other duties as required and assigned

Requirements

  • Bachelor's degree from an accredited university required, preferably in Computer Science, Information Technology, or a related field
  • Minimum of 5 years of experience in database administration, with expertise in Azure SQL Database, PostgreSQL, MongoDB, and MS SQL Server
  • Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate, PostgreSQL Certified Professional, MongoDB Certified DBA, or Microsoft Certified: Azure Solutions Architect Expert are highly preferred
  • Strong proficiency in SQL query optimization, database performance tuning, and troubleshooting
  • Experience with database security, encryption, and compliance standards (e.g., GDPR, CCPA)
  • Familiarity with cloud computing platforms such as Azure Cloud and AWS
  • Excellent problem-solving skills, attention to detail, and ability to work independently or as part of a team
  • Strong communication and interpersonal skills, with the ability to effectively interact with diverse stakeholders

Nice-to-haves

  • Experience with additional database technologies or platforms
  • Knowledge of data warehousing and ETL processes
  • Familiarity with DevOps practices and tools
  • Experience in financial services or investment banking environments

Benefits

  • Comprehensive medical, dental, and vision coverage with multiple health plan options
  • Health Savings Account (HSA) with company-sponsored contributions
  • Flexible Spending Accounts (FSA) traditional and dependent care
  • Pre-Tax Commuter Benefits
  • 401(k) Plan: competitive discretionary company matching and profit-sharing contributions
  • Tuition reimbursement ($5,250 max per year)
  • Paid Vacation, Sick Time, Holidays, Volunteer Time Off
  • Paid Leave: Parental Bonding, Jury Duty, Military, Disability, etc.
  • FINRA and Professional License Sponsorship
  • Charitable Donation Matching Contributions
  • Travel & Employee Assistance and Employee Discount Programs
  • Discretionary compensation based on the colleague's and the firm's performance
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service