Job Search
Senior DBA IRC246901
Job: | IRC246901 |
Location: | India - Bangalore |
Designation: | Associate Consultant |
Experience: | 5-10 years |
Function: | Engineering |
Skills: | DBA, MariaDB, MySQL, PostgreSQL |
Work Model: | Hybrid |
Description:
**Responsibilities:**
– **Query Development:** Write, optimize, and maintain complex queries to support various business needs.
– **Data Analysis:** Analyze data requirements and create efficient queries to extract, manipulate, and report data.
– **Performance Tuning:** Optimize query performance and troubleshoot slow-running queries.
– **Backup and Recovery:** Develop, manage, and test backup and recovery plans to ensure data integrity and availability.
– **Security:** Implement and maintain database security (user roles, permissions, etc.) and ensure compliance with data protection regulations.
– **Optimization:** Optimize database performance through indexing, query optimization, and other techniques.
– **Documentation:** Document query logic, processes, and best practices.
– **Testing:** Develop and execute test plans to ensure data accuracy and query performance.
– **Support:** Provide support for database-related issues and assist in data migration projects.
**Requirements:**
– **Experience:** Proven experience in writing and optimizing MySQL queries with MySQL, PostgreSQL, and MariaDB
– **Technical Skills:** Strong knowledge of SQL and MySQL database management.
– **Problem-Solving:** Excellent analytical and problem-solving skills.
– **Communication:** Strong verbal and written communication skills.
– **Education:** Bachelor’s degree in Computer Science, Information Technology, or a related field.
**Good to have:**
– Familiarity with data warehousing and ETL processes.
– Knowledge of scripting languages (e.g., Python, Bash) for automation.
– Experience with database performance tuning and indexing strategies.
Requirements:
**Responsibilities:**
– **Query Development:** Write, optimize, and maintain complex queries to support various business needs.
– **Data Analysis:** Analyze data requirements and create efficient queries to extract, manipulate, and report data.
– **Performance Tuning:** Optimize query performance and troubleshoot slow-running queries.
– **Backup and Recovery:** Develop, manage, and test backup and recovery plans to ensure data integrity and availability.
– **Security:** Implement and maintain database security (user roles, permissions, etc.) and ensure compliance with data protection regulations.
– **Optimization:** Optimize database performance through indexing, query optimization, and other techniques.
– **Documentation:** Document query logic, processes, and best practices.
– **Testing:** Develop and execute test plans to ensure data accuracy and query performance.
– **Support:** Provide support for database-related issues and assist in data migration projects.
**Requirements:**
– **Experience:** Proven experience in writing and optimizing MySQL queries with MySQL, PostgreSQL, and MariaDB
– **Technical Skills:** Strong knowledge of SQL and MySQL database management.
– **Problem-Solving:** Excellent analytical and problem-solving skills.
– **Communication:** Strong verbal and written communication skills.
– **Education:** Bachelor’s degree in Computer Science, Information Technology, or a related field.
**Good to have:**
– Familiarity with data warehousing and ETL processes.
– Knowledge of scripting languages (e.g., Python, Bash) for automation.
– Experience with database performance tuning and indexing strategies.
Job Responsibilities:
**Responsibilities:**
– **Query Development:** Write, optimize, and maintain complex queries to support various business needs.
– **Data Analysis:** Analyze data requirements and create efficient queries to extract, manipulate, and report data.
– **Performance Tuning:** Optimize query performance and troubleshoot slow-running queries.
– **Backup and Recovery:** Develop, manage, and test backup and recovery plans to ensure data integrity and availability.
– **Security:** Implement and maintain database security (user roles, permissions, etc.) and ensure compliance with data protection regulations.
– **Optimization:** Optimize database performance through indexing, query optimization, and other techniques.
– **Documentation:** Document query logic, processes, and best practices.
– **Testing:** Develop and execute test plans to ensure data accuracy and query performance.
– **Support:** Provide support for database-related issues and assist in data migration projects.
**Requirements:**
– **Experience:** Proven experience in writing and optimizing MySQL queries with MySQL, PostgreSQL, and MariaDB
– **Technical Skills:** Strong knowledge of SQL and MySQL database management.
– **Problem-Solving:** Excellent analytical and problem-solving skills.
– **Communication:** Strong verbal and written communication skills.
– **Education:** Bachelor’s degree in Computer Science, Information Technology, or a related field.
**Good to have:**
– Familiarity with data warehousing and ETL processes.
– Knowledge of scripting languages (e.g., Python, Bash) for automation.
– Experience with database performance tuning and indexing strategies.
What We Offer
Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.
Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!
Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.
Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.
Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.
Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!