Source description
About the role
Skills: Job Title: Database Administrator (DBA) with Development Experience 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 mnimal 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. Robust 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 settings. 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 solid DBA expertise with development experience, eager to contribute to database optimization, maintenance, and overall performance. .
More at Cogniter Technologies