Job Details
Skills
Job Title: Database Administrator (DBA) with Development Experience
Job Description:
We are seeking 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 should have deep expertise in query optimization, performance tuning, high availability & disaster recovery (HADR), data migration, log shipping, and database development.Key Responsibilities:
- Fine-tune and optimize queries to enhance database performance and efficiency.
- Perform indexing, partitioning, and query execution analysis to boost performance.
- Ensure high availability and disaster recovery (HADR) solutions, including log shipping, replication, and failover clustering.
- Manage and conduct database migrations and upgrades with minimal downtime.
- Implement backup, restore, and recovery strategies to safeguard data integrity.
- Monitor and troubleshoot database performance issues, including locks, deadlocks, and slow queries.
- Collaborate with developers to refine database schema design and implement best practices.
- Automate routine database maintenance tasks using SQL scripts and automation tools.
- Ensure database security, access control, and adherence to industry standards.
- Stay current with evolving database technologies, tools, and trends.
Required Skills & Qualifications:
- 5+ years of experience as a DBA with a focus on SQL development.
- Strong expertise in query optimization, performance tuning, and indexing strategies.
- Hands-on experience with high availability, disaster recovery, log shipping, and replication.
- Proven experience in database migration, backup, and restoration across different environments.
- Proficiency in working with MSSQL database engines.
- Deep understanding of stored procedures, triggers, views, and functions.
- Experience with ETL processes and data integration.
- Familiarity with monitoring tools like SQL Profiler, Performance Monitor, and DMVs.
- Knowledge of cloud-based database solutions, including AWS RDS and Azure SQL.
- Strong collaboration skills with development teams to optimize database queries and performance.
This role is perfect for someone who combines strong DBA expertise with development experience, eager to contribute to database optimization, maintenance, and overall performance. If you are passionate about database management and development, this opportunity could be a great fit!