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