Job
Description
Job Details Job Details Hiring for Database Administrator (DBA) (Job Code: CHDDBA) 3-5 Years 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. News and Events News and information of our company, projects, partnerships, staff and community. Feb 2025 Friday, February 7, 2025 Today, we at Cogniter proudly celebrate a remarkable milestone - 20 incredible years of dedication, leadership, and excellence by Col. R.S. Sandhu! Friday, February 7, 2025 Oct 2024 Wednesday, October 30, 2024 The Cogniter family came together to celebrate Diwali, filling our office with festive joy, laughter, and vibrant energy. The entire workspace transformed into a colorful spectacle, radiating warmth and positivity as we embraced this festival.
