New Requirement of Database Administrator (DBA)

Skills

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

  Position Overview:

  We are seeking a highly skilled Database Administrator (DBA) with a solid development background to oversee, optimize, and ensure the performance and scalability of our database systems. The ideal candidate will bring expertise in query optimization, performance tuning, high availability and disaster recovery (HADR), data migration, and database development to the role.

  Key Responsibilities:

  • Query Optimization: Enhance database query performance and efficiency through careful tuning and optimization.
  • Indexing & Partitioning: Implement indexing, partitioning, and query execution analysis to further boost database performance.
  • High Availability & Disaster Recovery (HADR): Design, implement, and maintain HADR solutions, including log shipping, replication, and failover clustering, to ensure continuous database availability.
  • Database Migrations & Upgrades: Manage database migrations and upgrades, ensuring minimal downtime and seamless transitions.
  • Backup & Recovery: Develop robust backup, restore, and recovery strategies to protect data and ensure business continuity.
  • Performance Monitoring: Regularly monitor and troubleshoot performance issues (locks, deadlocks, slow queries) to maintain optimal database operation.
  • Developer Collaboration: Work closely with development teams to refine database schema designs and implement best practices for database structure and query performance.
  • Automation: Automate routine database maintenance tasks using SQL scripts and other automation tools to increase efficiency.
  • Security & Compliance: Ensure strong database security practices, access control, and compliance with industry standards and regulations.
  • Stay Updated: Continuously update your knowledge of the latest database technologies and trends to maintain cutting-edge practices.

  Required Skills & Qualifications:

  • Experience: 5+ years as a DBA with a strong focus on SQL development and optimization.
  • Query Optimization & Tuning: Deep expertise in query performance tuning, indexing strategies, and optimization techniques.
  • High Availability & Disaster Recovery: Hands-on experience implementing HADR solutions like log shipping, replication, and failover clustering.
  • Database Migration: Proven track record of managing database migrations, backups, and restoration processes across different environments.
  • MSSQL Expertise: Strong proficiency in MSSQL database engines, including working with stored procedures, triggers, views, and functions.
  • ETL & Data Integration: Experience with ETL processes and data integration workflows.
  • Monitoring Tools: Familiarity with monitoring tools (SQL Profiler, Performance Monitor, DMVs) for troubleshooting and resolving performance issues.
  • Cloud Databases: Knowledge of cloud-based database solutions, such as AWS RDS and Azure SQL.
  • Team Collaboration: Strong communication and collaboration skills for working with development teams on database optimization and performance enhancements.

  Why Join Us?

  If you're a DBA with a passion for optimization and database performance, this is an exciting opportunity for you! This role allows you to contribute your development skills while overseeing and enhancing the efficiency of high-performance, scalable database systems. Join our team and play a key role in driving the reliability and performance of our database environment.