Description
Summary We are seeking an experienced AWS Database Developer to design, develop, and implement a scalable, secure, and high-performance database solution on Amazon Web Services (AWS). The ideal candidate will have hands-on experience with AWS database services such as Amazon RDS, EC2, and Amazon S3, along with strong SQL and database administration skills. **Scope of Work:** * Design and deploy a relational database on AWS (MySQL, PostgreSQL, or SQL Server). * Configure and optimize the database for performance, scalability, high availability, backup, and security. * Develop an automated process to ingest and import CSV files from Amazon S3 or other sources into the database. * Create database schemas, tables, indexes, stored procedures (if required), and SQL views to support reporting and analytics. * Implement ETL/data import workflows using AWS services, scripting, or automation tools. * Monitor database performance and optimize queries for efficiency. * Configure backup, recovery, and access controls following AWS best practices. * Document the database architecture, deployment process, and automation workflows. **Required Skills:** * Strong experience with AWS (RDS, EC2, S3, IAM, CloudWatch). * Expertise in MySQL, PostgreSQL, or Microsoft SQL Server. * Experience automating CSV data imports using Python, AWS Lambda, AWS Glue, or similar technologies. * Advanced SQL skills, including creating views, indexes, and query optimization. * Experience with database migration, backup, recovery, and security best practices. * Familiarity with Infrastructure as Code (CloudFormation or Terraform) is a plus. The successful candidate will deliver a fully functional AWS-hosted database solution with an automated CSV ingestion process and optimized SQL views that are ready for reporting and future scalability.