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

Detailed Job Description:

Candidate should possess hands on experience in working on relational and non-relational databases (DynamoDB, Redshift, PostgeSQL) on AWS (amazon web services) infrastructure. He should be able to well versed in data modelling concepts with experience in backup, restore and refresh of databases. He should also monitor and report database health check reports along with supporting the database migration as part of release management. He should be good in communication and work along with offshore team to deliver value to the clients. He should be proactive in proposing ideas and solutions to the clients.

Primary skills required:

DynamoDB, SQL Server Secondary skills: Redshift, PostgreSQL, Snowflake DB administration Nice to have: Lambda programming

AWS specific duties/skills needed:

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

Core Data Base Administrator ( DBA ) responsibilities:

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