Database Engineer - Python/AWS (8-14 yrs)

Role : Sr. Database Engineer

Experience : 7+ years

Location : Bangalore/Mysore/Coimbatore

Key Responsibilities :

• Design, develop, and maintain relational and NoSQL databases, Datawarehouse and datalakes to support application, analytics and AI/ML needs.
• Implement and optimize database schemas, indexes, and queries for performance and scalability.
• Design, develop and maintain ETL/ELT processes and data pipelines.
• Monitor databases, Datawarehouse and data pipelines performance and implement tuning techniques to enhance efficiency.
• Analyze and resolve database and data pipelines bottlenecks, latency, and slow-running queries.
• Manage databases, Datawarehouse and data lake provisioning, configuration, and maintenance.
• Ensure high availability, disaster recovery, and backup strategies are in place and tested.
• Maintain database patches, upgrades, and security updates.
• Provide technical guidance and mentorship to junior team members.
• Implement and enforce database security measures, including encryption and access control.
• Create and maintain documentation for database/ Datawarehouse structures, data pipelines, processes, and configurations.
• Establish and enforce database/ Datawarehouse and data pipelines standards and best practices.
• Perform rigorous testing to ensure data accuracy and integrity.

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• Experience in data engineering, development, or administration.
• Expertise in relational databases (e.g., SQL Server, PostgreSQL, MySQL) and NoSQL databases (e.g., MongoDB, Cassandra).
• Strong proficiency in SQL and database/ Datawarehouse optimization techniques.
• Experience with big data technologies such as Hadoop, Spark Snowflake.
• Experience in implementing Cloud-based Data Solutions in AWS Cloud.
• Experience building data pipelines using Pyspark to process complex Json and other large datasets that are in TB and real-time data streaming.
• Familiarity with database replication, clustering, and high-availability solutions.
• Hands-on experience with database monitoring and diagnostic tools.
• Strong understanding of data security practices and compliance requirements.