Apply

Senior Database Administrator

Posted 16 days agoViewed

View full description

💎 Seniority level: Senior, 7+ years

📍 Location: United States

💸 Salary: 135000.0 - 145000.0 USD per year

🔍 Industry: Software Development

🏢 Company: Caret👥 1-10💰 $1,291,130 Seed about 4 years agoPropTechCommercial Real EstateSaaSAppsProperty Management

🗣️ Languages: English

⏳ Experience: 7+ years

🪄 Skills: SQLMicrosoft SQL ServerNosqlData modeling

Requirements:
  • 7+ years of SQL Server DBA experience
  • Expert level skills in SQL Development
  • Expert knowledge in creating complex SQL queries, performance tuning and optimization
  • Expert knowledge of indexes, index management and statistics
  • Proficient with Query Store or equivalent tools
  • Experience with Azure SQL/Azure Elastic Pools
  • Understanding of DevOps concepts including Azure DevOps framework and tools
  • PowerShell scripting skills
Responsibilities:
  • Monitor database, identify bottlenecks and implement optimization strategies
  • Develop and implement stored producers and functions
  • Collaborate with development teams to optimize SQL queries
  • Perform database design, data modeling and schema management
  • Perform database maintenance and management
  • Identify, design, and develop data archiving strategies
  • Develop and/or publish key performance metrics
  • Assist in educating developers
  • Provide and insure data availability, data integrity and data security.
  • Performing and automating routine database administration functions including database capacity planning, pro-active performance monitoring and tuning, executing security procedures and backup and recovery processes.
Apply

Related Jobs

Apply

📍 Australia, Austria, Bangladesh, Belgium, Brazil, Canada, Colombia, Costa Rica, Croatia, Czech Republic, Denmark, Egypt, Estonia, Finland, France, Germany, Ghana, Greece, India, Indonesia, Ireland, Israel, Italy, Kenya, Mexico, Netherlands, Nigeria, Peru, Poland, Singapore, South Africa, Spain, Sweden, Switzerland, Uganda, United Arab Emirates, United Kingdom, United States of America, Uruguay

🧭 Full-Time

💸 $109,047 - $169,455 per year

🔍 Nonprofit Organization / Free Knowledge Projects

🏢 Company: Wikimedia Foundation👥 251-500💰 $2,100,000 Grant about 5 years ago

  • Advanced level of experience with MariaDB or MySQL database administration and replication topologies at scale.
  • Proficiency in SQL.
  • Experience with debugging query performance and schema design.
  • Experience with MySQL high availability and replication management tooling.
  • Knowledge of Linux and IO/data storage concepts, internals and troubleshooting.
  • Experience with managing remotely both bare-metal servers and virtualized environments.
  • 5+ years experience in a hands-on DBA role as part of a team.
  • Experience with high traffic and highly available website architectures and operations.
  • Strong English language skills.
  • Ability to work independently in a fast paced environment, as an effective part of a globally distributed team, including ticket tracking systems and asynchronous communication tools.
  • B.Sc. or M.Sc. in Computer Science or equivalent work experience.
  • Implementation, maintenance and troubleshooting of relational database systems in production and staging environments.
  • Handling database version upgrades, testing and working with upstream on bug identification and resolution.
  • Configuring replication, designing schema optimizations and running schema changes.
  • Monitoring, debugging and improving query performance.
  • Improving observability (alerting, metrics, monitoring) of database infrastructure.
  • Multi-datacenter replication topology design, capacity and infrastructure planning.
  • Taking part in incident response, diagnosis and follow-up on system outages or alerts across Wikimedia’s production infrastructure and participating in an on call rotation.

SQLMySQLLinux

Posted 4 months ago
Apply