Job Seekers, Please send resumes to resumes@hireitpeople.com

Must Have Skills:

Exp. in Dynamo Database Administration on AWS Cloud Exp. in SQL Database Administration on AWS Cloud CloudFormation scripting

Must have skills (Any 2 are required)

Redshift Administration on AWS Cloud PostgreSQL Database Administration on AWS Cloud Snowflake Database Administration on AWS Cloud Lambda programming

Primary skills required:

DynamoDB, SQL Server

Secondary skills:

Redshift, PostgreSQL, Snowflake DB administration

Nice to have:

Lambda programming

Detailed Job Description:

Overall experience and understanding of Amazon (AWS) cloud infrastructure. Able to support RDS database such as Dynamo DB, Resdhsift, Postgres database and SQL server Database Able to support Non-RDS database on EC2 such as Postgres database, MS SQL, Dynamo DB and Redshift databases Able to support activities related to Snowflake administration. Monitoring and auditing using CloudWatch (alerts) Developing CloudFormation scripts Manage database security and ensure data and databases are fully secured and comply with CAP cybersecurity policy. Experience with DB platform transactional management, indexing strategies and maintenance, backup and recovery models, and performance tuning. Apply latest DB patches for non-RDS databases as deemed necessary. Proactive monitoring and performance tuning from AWS cloud infrastructure, database level and query tuning. Core Infrastructure activities will be out of scope (except for DB configuration using CLI) as the DB servers will be hosted on cloud

Responsibilities you would expect the Subcon to shoulder and execute*:

Extensive experience with Data Modelling Experience with AWS CLI and CloudFormation for DB operations Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. Refine and automate regular processes including, but not limited to (like DB errors, lock contention, space issues, any other Azure specific issues), track issues, and document changes Database backup, restore and refresh activities Extensive hands-on experience with SQL tuning and Stored Procedures tuning. Troubleshoot and correct various problems that arise in day-to-day work. Independently analyze, solve and correct issues in real time and providing problem resolution end-to-end, conducting root cause analysis. Perform scheduled maintenance outside CAP business hours and during Release