Associate Software Engineer (DB, SQL, AWS) Job in Hyderabad at CDK Global

CDK Global is hiring for the Role of Associate Software Engineer (DB, SQL, AWS)!

Responsibilities of the Candidate:

• Database Management & Maintenance:
  • Manage, monitor, and optimize AWS Aurora RDS databases.
  • Perform routine maintenance tasks such as backups, patching, and upgrades.
  • Ensure high availability, fault tolerance, and performance of databases in production environments.
• SQL Development & Optimization:
  • Write, optimize, and troubleshoot SQL queries for performance and efficiency.
  • Work on database schema design, indexing strategies, and data migration.
  • Perform query tuning and optimization to enhance database performance.
• Database Administration (DBA) Activities:
  • Assist in database provisioning, configuration, and monitoring on AWS Aurora RDS.
  • Handle user access management, security, and compliance tasks.
  • Assist in database health monitoring, alerting, and disaster recovery planning.
• AWS Cloud Technologies:
  • Leverage AWS services, including Aurora, RDS, S3, Lambda, and others to support a robust cloud infrastructure.
  • Participate in cloud-based data infrastructure management and scaling.
  • Assist in implementing cost optimization strategies for database operations on AWS.
• Collaboration & Continuous Improvement:
  • Work closely with cross-functional teams, including software engineers, data engineers, and operations, to ensure efficient database usage and high-quality code.
  • Contribute to database-related best practices and automation initiatives.
  • Participate in on-call rotations for database support, as needed.
• Modern Data Platform Support:
  • Work with large-scale, distributed data systems and support the continuous evolution of our data platform.
  • Support data integration, ETL pipelines, and data processing workflows.

Requirements:

• Bachelor’s degree in Computer Science, Engineering, Information Technology, or related field (or equivalent experience).
• Proficiency in SQL, with a strong understanding of database design, normalization, and optimization.
• Experience with AWS cloud services, particularly AWS Aurora RDS.
• Basic knowledge of database administration tasks (e.g., backups, replication, patching, performance tuning).
• Familiarity with AWS cloud infrastructure and services such as EC2, S3, Lambda, CloudWatch, IAM, and VPC.
• 2 - 3 years of experience working with relational databases (preferably AWS Aurora RDS or MySQL, PostgreSQL).
• Familiarity with database monitoring tools and techniques.
• Hands-on experience with version control tools (e.g., Git) and CI/CD pipelines is a plus.
• Experience with NoSQL databases (e.g.,ElasticSearch, MongoDB) or big data technologies (e.g., Apache Kafka, Hadoop, Spark).
• Familiarity with Infrastructure as Code (IaC) tools like Terraform or CloudFormation.
• Experience with containerization and Kubernetes for deploying database services.