3 Database Tuning jobs in India

• Use T-SQL to develop and implement procedures and functions.
• Analyze existing SQL queries for performance improvements.
• Develop procedures and scripts for data migration.
• Help write and optimize in-application SQL statements
• Ensure performance, security, and availability of databases
• Writing complex SQL queries for data retrieval and manipulation
• Optimizing database performance and ensuring data integrity
• Troubleshooting and resolving database-related issues
• Collaborating with cross-functional teams to gather requirements and implement solutions
• Creating and maintaining database documentation
• Implementing and maintaining database security measures
• Proficiency in writing complex queries
• Memory management for database systems.
• Fix any issues related to database performance and provide corrective measures.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Strong proficiency in T-SQL code.
• Strong proficiency in understanding data descriptions, data types.
• Experience in handling live projects that have been in place for at least one year.
• Experience in handling database management software like MSSQL, MYSQL.
• Strong understanding of data structures and algorithms.
• Understanding of database security best practices and regulations.
• Familiarity with data warehousing and ETL processes
• Excellent communication and teamwork skills
• Attention to detail and data accuracy
• Ability to work independently and meet deadlines
• Continuous learning and adaptability to evolving technologies
• Master's /Bachelor's degree in Computer Science, Engineering, or related field 5+ Years Experience

Role Overview :

• The ideal candidate will have hands-on experience and an SME in maintaining databases, with a primary focus on performance, optimization, troubleshooting, high availability, disaster recovery, and automation. With deep expertise in Open Database technologies of PostgreSQL, Redis and MongoDB with additional expertise in containerization and orchestration tools like Docker and Kubernetes.

Key Responsibilities :

Database Maintenance & Administration :

• Perform routine maintenance tasks including backup, recovery, patching, and performance tuning.
• Conduct standard database maintenance and administration tasks with attention to detail.
• Monitor database activity, health, and performance, using database management system software and tools to collect performance statistics.
• Optimize database performance, plan for forecast resource needs, and recommend corrective actions.
• Ensure database high availability, replication, failover, and clustering.
• Develop and configure tools to automate database administration tasks, enhancing efficiency and minimizing downtime.
• Maintain procedures and documentation for databases, ensuring compliance with standards for definition, security, and integrity of database objects.
• Implement disaster recovery strategies and maintain data integrity across environments.

Incident Management & Troubleshooting :

• Handle critical escalations and complex troubleshooting for database issues.
• Diagnose performance bottlenecks, slow queries, deadlocks, and replication issues.
• Collaborate with DevOps, infrastructure, and application teams for RCA (Root Cause Analysis).

Backup, Recovery & Disaster Recovery :

• Design and implement backup strategies and disaster recovery plans.
• Ensure data integrity, redundancy, and compliance with RPO/RTO requirements.

Containerization & Orchestration :

• Manage databases using Docker and Kubernetes to ensure scalability and resilience.
• Optimize containerized database solutions for performance optimization.
• Implement CI/CD pipelines for automated deployment and maintenance of databases within containerized environments.

Collaboration & Communication :

• Work closely with application teams to ensure seamless integration and optimal performance by understanding business logic, data models, and query patterns.
• Optimize database schema and queries for application performance improvement.
• Interact with customers, suppliers, and partners to deliver effective database maintenance.

Documentation & Reporting :

• Maintain comprehensive documentation of database architectures, processes, maintenance plans, and troubleshooting guides.
• Prepare reports detailing system health, performance metrics, and improvement plans.

Required Skills and Qualifications :

• Database Technologies : Deep knowledge of PostgreSQL, Redis and MongoDB.
• Containerization & Orchestration : Hands-on experience with Docker and Kubernetes for deploying and managing databases.
• Infrastructure and Application Integration : Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows.
• Performance Tuning & Optimization : Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms.