Source description
About the role
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
More at Logic Planet