A3 Logics India - Database Developer - SQL (5-10 yrs)

Role Overview :

We are seeking an experienced Database Developer with a strong background in database design, development, and management.

The ideal candidate will be responsible for designing and maintaining complex database systems, optimizing database performance, and ensuring data integrity.

The role requires a proactive individual with a passion for data and advanced technical skills.

Key Responsibilities :

- Architect, develop, and maintain database objects including tables, views, procedures, functions, and packages.

- Perform complex relational database queries using SQL (AWS RDS for PostgreSQL) and Oracle PL/SQL.

- Optimize database performance through tuning and monitoring.

- Collaborate in ETL processes using tools like AWS Batch and AWS Glue.

- Set up and manage CI/CD Pipelines, Jenkins Deployment, and Git Repositories.

- Monitor and manage databases using AWS CloudWatch, ensuring secure services with minimal downtime.

- Document processes and collaborate using Confluence.

- Create database diagrams and flowcharts using SmartDraw.

- Use Python libraries such as Pandas and NumPy for data manipulation and transformation.

- Develop database connectivity and interaction using libraries like SQLAlchemy and PyODBC.

- Participate actively in Agile/Scrum methodologies for project management and development.

Required Skills :

Must-Have :

- Proven experience in data modeling and database design.

- Proficiency in SQL and PL/SQL for complex queries.

- Hands-on experience with AWS RDS, AWS Glue, and AWS Batch.

- Expertise in CI/CD Pipelines and Jenkins Deployment.

- Familiarity with AWS Aurora's scaling and replication capabilities.

- Advanced skills in database performance tuning and maintenance.

- Proficiency in Python programming and its associated libraries (Pandas, NumPy, SQLAlchemy, PyODBC).

- Strong experience with AWS CloudWatch for monitoring and setting up alerts.

- Excellent documentation and collaboration skills using Confluence.

- Proficiency in creating visual representations of data models using SmartDraw.

- Strong communication skills (spoken English and clarity of thought).

Good to Have :

- Experience with Big Data, data mining, machine learning, and natural language processing.

Qualifications :

- Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.

- 5-10 years of relevant experience in database development and management.

- Proven expertise in working with large-scale databases and complex data environments.

Why Join Us?

- Opportunity to work with cutting-edge database technologies in a remote setup.

- Collaborative and agile work environment