DBA/SQL Developer

Corporate Infotech (CIPL); Dehradun; On-site; INR 900,000 - 1,400,000; Full time

Job summary

Corporate Infotech (CIPL) is seeking a DBA/SQL Developer to install, configure, and maintain database servers, and design, develop, and optimize SQL queries to support applications. You will monitor performance, manage security, perform maintenance, and participate in DR planning.

The role requires collaboration with developers, admins, and engineers to ensure data integrity and compliance, along with data migration from legacy systems. Certifications are preferred.

Responsibilities

• Install, configure, and maintain database servers and associated software including backups and recovery.
• Design, develop, and optimize SQL queries, stored procedures, triggers, and functions to support application requirements.
• Monitor database performance and tune SQL queries, indexing, and server parameters to ensure optimal performance.
• Manage database security including user roles, permissions, and encryption measures.
• Perform routine database maintenance including patching, upgrades, and applying fixes.
• Set up and manage high availability solutions, failover, and disaster recovery processes.
• Ensure data integrity, audit compliance, and data migration processes from legacy systems.
• Collaborate with software developers, system administrators, and network engineers to implement end to end solutions.
• Troubleshoot and resolve database issues in a timely manner.
• Participate in database design review and capacity planning.
• Implement data profiling, cleansing, and validation using ETL tools.
• Develop and maintain comprehensive database documentation.
• Certifications:- Essential certifications for a database administrator

Job description

DBA/SQL Developer

• Install, configure, and maintain database servers and associated software including backups and recovery.
• Design, develop, and optimize SQL queries, stored procedures, triggers, and functions to support application requirements.
• Monitor database performance and tune SQL queries, indexing, and server parameters to ensure optimal performance.
• Manage database security including user roles, permissions, and encryption measures.
• Perform routine database maintenance including patching, upgrades, and applying fixes.
• Set up and manage high availability solutions, failover, and disaster recovery processes.
• Ensure data integrity, audit compliance, and data migration processes from legacy systems.
• Collaborate with software developers, system administrators, and network engineers to implement end-to end solutions.
• Troubleshoot and resolve database issues in a timely manner.
• Participate in database design review and capacity planning.
• Implement data profiling, cleansing, and validation using ETL tools.
• Develop and maintain comprehensive database documentation.
• Certifications:- Essential certifications for a database administrator