DB Lead

Location - Bengaluru,Kochi,Hyderabad,Chennai

Job Description

• We are seeking a highly motivated and experienced DB Lead with a strong background in MYSQL/Oracle and technical leadership to join our dynamic team.
• The ideal candidate will have around 8+ years of experience in the IT industry, including extensive hands-on knowledge of the MYSQL/Oracle and expertise in Python and Pyspark along with AWS.

Key Responsibilities:

Roles & Responsibility

• Database Design and Architecture: Lead the design, implementation, and optimization of scalable and efficient database architectures to support business requirements.
• Data Modeling and Management: Develop data models, database schemas, and data pipelines for efficient storage, retrieval, and management of data across platforms.
• AWS Database Services: Manage AWS databases, including Aurora (PostgreSQL/MySQL) and DynamoDB, optimizing for cost, performance, and scalability.
• Python Scripting: Use Python for data manipulation, automation of database tasks, and integration with other systems.
• Database Performance Optimization: Monitor and optimize database performance, troubleshoot issues, and ensure high availability and disaster recovery.
• Documentation and Reporting: Maintain up-to-date documentation for database architectures, processes, and configurations. Generate reports on database performance, issues, and improvements.

Primary Skills (Essential):

• At least five years of professional programming experience writing performant stored procedures/functions/SQL statements
• Database Management: Expertise in database administration, tuning, and troubleshooting.
• SQL Expertise: Strong SQL skills across various database systems.
• AWS Databases: Proficiency with Amazon Aurora (MySQL/PostgreSQL) and DynamoDB, including setup, optimization, and scaling.
• Python: Strong Python skills for data manipulation, automation, and database task management.
• Data Modeling: Proficiency in designing logical and physical data models to support business processes.

Secondary Skills (Highly Beneficial):

• Snowflake: Hands-on experience with Snowflake data warehousing, data modeling, and data ingestion processes.
• ETL/ELT Tools: Familiarity with ETL/ELT processes and tools (e.g., Apache Airflow, AWS Glue) for data transformation and ingestion.
• Data Governance and Compliance: Knowledge of data governance practices, including data security and regulatory compliance standards.

Required Skills and Qualifications:

• Experience: Around 8 years of overall IT experience, with at least 5 years focused on MYSQL/Oracle and 2+ years in AWS.
• Technical Skills: In-depth knowledge of the MYSQL/Oracle, including Python, Pyspark, and Data Modeling.
• Experience with AWS
• Leadership Skills: Excellent communication, presentation, and interpersonal skills. Ability to manage multiple presales opportunities simultaneously and work in a fast-paced environme
• We are seeking a highly motivated and experienced DB Lead with a strong background in Python and technical leadership to join our dynamic team.
• The ideal candidate will have around 8 years of experience in the IT industry, including extensive hands-on knowledge of the MYSQL/Oracle and expertise in Python .