Postgres DBA with AWS

Roles & Responsibility

Mandatory Primary Skill RDS PostgreSQL

Secondary MySQL

Good to have Dynamo and MS SQL

Responsibilities

1 Database Installation and Configuration

    Install and configure database software

    Ensure proper settings for optimal performance

2 Database Design

    Contribute to the design and layout of databases

    Work with developers to optimize data models

3 Data Security

    Implement and manage security measures to protect data

    Define and control user access to databases

4 Backup and Recovery

    Establish and execute regular backup procedures

    Develop and test recovery plans in case of data loss

5 Performance Monitoring and Tuning

    Monitor database performance and identify areas for improvement

    Optimize queries and database structures for better efficiency

6 Data Migration

    Plan and execute data migration between different systems

    Ensure data integrity during migration processes

7 Troubleshooting

    Diagnose and resolve database related issues

    Provide support in case of system failures or performance issues

8 Capacity Planning

    Estimate future data growth and plan for additional storage

    Scale the database infrastructure as needed

9 Documentation

    Maintain comprehensive documentation of database configurations and procedures

    Keep records of changes and updates

10 Collaboration

     Work closely with developers’ system administrators and other IT staff

     Collaborate on projects involving database integration

11 Patch Management

     Apply patches and updates to keep the database software current

     Test and validate changes to ensure system stability

12 Automation

     Implement automation for routine tasks to improve efficiency

     Scripting for database maintenance and monitoring

13 Compliance and Standards

     Ensure that databases comply with industry regulations and standards

     Stay informed about changes in regulations affecting data management

Requirements