Requirement of Database Administrator (DBA)

Skills

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

  Job Overview:
  We are looking for an experienced Database Administrator (DBA) with a strong development background to manage, optimize, and ensure the performance and scalability of our databases. The ideal candidate will have expertise in query optimization, performance tuning, high availability & disaster recovery (HADR), data migration, log shipping, and database development.

  Key Responsibilities:

  • Query Optimization: Fine-tune and optimize database queries to improve performance and efficiency.
  • Indexing & Partitioning: Perform indexing, partitioning, and query execution analysis to boost database performance.
  • High Availability & Disaster Recovery (HADR): Implement and maintain HADR solutions, including log shipping, replication, and failover clustering, to ensure database uptime.
  • Database Migrations & Upgrades: Manage and execute database migrations and upgrades with minimal downtime, ensuring smooth transitions.
  • Backup & Recovery: Develop and implement backup, restore, and recovery strategies to protect data integrity.
  • Performance Monitoring: Monitor and troubleshoot database performance issues, such as locks, deadlocks, and slow queries, ensuring optimal operation.
  • Collaboration with Developers: Work closely with development teams to refine database schema design and apply best practices for database structure and query performance.
  • Automation: Automate routine database maintenance tasks using SQL scripts and other automation tools to improve efficiency.
  • Security & Compliance: Ensure database security, access control, and adherence to industry standards and best practices.
  • Stay Updated: Keep up-to-date with evolving database technologies, tools, and industry trends to continuously improve practices.

  Required Skills & Qualifications:

  • Experience: 5+ years as a DBA, with a strong focus on SQL development.
  • Query Optimization & Tuning: Expertise in query optimization, performance tuning, and indexing strategies.
  • High Availability & Disaster Recovery: Hands-on experience with HADR solutions such as log shipping, replication, and failover clustering.
  • Database Migration: Proven ability to manage database migration, backup, and restoration processes across different environments.
  • MSSQL Expertise: Proficiency with MSSQL database engines, including stored procedures, triggers, views, and functions.
  • ETL & Data Integration: Experience with ETL processes and data integration workflows.
  • Monitoring Tools: Familiarity with monitoring tools like SQL Profiler, Performance Monitor, and DMVs to identify and resolve performance issues.
  • Cloud Databases: Knowledge of cloud-based database solutions such as AWS RDS and Azure SQL.
  • Team Collaboration: Strong collaboration skills to work effectively with development teams to optimize database queries and performance.

  Why Join Us?

  This is an excellent opportunity for someone who combines strong DBA expertise with development skills. If you're passionate about database management and optimization, and want to contribute to maintaining a high-performance, scalable database environment, this role is a perfect fit for you! Join us and play a key role in driving the performance and reliability of our database systems.