Job Details

Skills

• Job Title: Database Administrator (DBA) with Development Experience

  Position Overview:

  We’re looking for an experienced Database Administrator (DBA) with a strong development background to manage and optimize our database systems. If you’re skilled in query optimization, performance tuning, and high availability, and have experience in database migrations, security, and development, we’d love to have you join our team. Your expertise will help ensure our databases run efficiently, scale seamlessly, and remain highly available.

  Key Responsibilities:

  • Query Optimization: Optimize database queries for performance and efficiency, ensuring smooth operations.

  • Indexing & Partitioning: Implement indexing and partitioning strategies to improve query execution and database performance.

  • High Availability & Disaster Recovery (HADR): Design, implement, and manage HADR solutions like log shipping, replication, and failover clustering for continuous availability.

  • Database Migrations & Upgrades: Oversee database migrations and upgrades, ensuring smooth transitions and minimal downtime.

  • Backup & Recovery: Develop and manage robust backup, restore, and disaster recovery strategies to ensure business continuity.

  • Performance Monitoring: Regularly monitor databases for performance issues such as locks, deadlocks, or slow queries and resolve them efficiently.

  • Developer Collaboration: Work closely with development teams to optimize database schema and enhance query performance.

  • Automation: Automate routine database maintenance tasks with SQL scripts and tools to boost productivity.

  • Security & Compliance: Maintain strong security practices, ensure data access control, and meet compliance standards.

  • Stay Updated: Keep up-to-date with the latest database technologies and best practices to maintain cutting-edge database management.

  Required Skills & Qualifications:

  • Experience: 5+ years of DBA experience with a strong background in SQL development and optimization.

  • Query Optimization & Tuning: Expertise in query tuning, indexing strategies, and performance optimization.

  • High Availability & Disaster Recovery: Hands-on experience with HADR solutions such as log shipping, replication, and failover clustering.

  • Database Migration: Proven experience with database migrations, backups, and restoration across environments.

  • MSSQL Expertise: Advanced proficiency in MSSQL, including working with stored procedures, triggers, views, and functions.

  • ETL & Data Integration: Experience with ETL processes and data integration.

  • Monitoring Tools: Familiarity with monitoring tools (SQL Profiler, Performance Monitor, DMVs) for diagnosing performance issues.

  • Cloud Databases: Knowledge of cloud-based databases (AWS RDS, Azure SQL).

  • Team Collaboration: Strong communication and collaboration skills to work effectively with development teams.

  Why Join Us?

  If you’re a DBA who thrives on optimizing performance and ensuring smooth database operations, this role is an exciting opportunity for you! You’ll leverage your development skills while overseeing high-performance, scalable database systems. Join us and contribute to the reliability, performance, and growth of our database infrastructure.