Database Developer

Role & responsibilities

Database Platforms: Good exposure on PostgreSQL, MySQL, SQL Server

Operating System: Experience in Ubuntu, CentOS

Roles and Responsibilities:

Database Performance Tuning: Optimize database performance by fine-tuning SQL queries, indexing strategies, and database configurations. Monitor database performance metrics and identify bottlenecks. Data Security: Implement and manage database security measures, including user access controls, encryption, and audit logs. regularly update security protocols to protect against unauthorized access and breaches. Database Troubleshooting: Diagnose and resolve database-related issues such as performance bottlenecks, data corruption, and

connection problems. Provide support for database-related incidents and outages. Database Design and Modeling:

Work with development teams to design and model databases that meet business requirements. Ensure database designs adhere to best practices for normalization, indexing, and storage efficiency. • Configure Database jobs

Data Migration and Integration: Plan and execute data migration projects, including moving data between different DBMS platforms or

environments. Integrate databases with other systems and applications. Compliance and Regulatory Adherence: • Ensure databases comply with relevant industry regulations and standards (e.g., GDPR, HIPAA). • Maintain proper documentation and audit trails for compliance purposes. Automation and Scripting: • Develop scripts and use automation tools to automate routine database tasks such as backups, monitoring, and reporting. • Implement automated alerts for database performance and security issues. Capacity Planning: • Monitor database growth and resource utilization to anticipate future needs. • Plan for and implement database scaling strategies as necessary. Collaboration with Development Teams: • Work closely with developers to optimize database queries, troubleshoot issues, and implement changes. • Provide guidance on database best practices and performance optimization. Documentation: • Maintain comprehensive documentation of database configurations, procedures, and policies. • Document changes to the database environment, including upgrades, patches, and configuration modifications. Maintain Release Notes

User Support and Training: • Provide support to end-users for database-related issues and queries. • Train users and other IT staff on database systems, tools, and best practices. Stay Updated with Industry Trends: • Keep up-to-date with the latest developments in database technologies and best practices. • Recommend and implement new technologies or practices to improve database management.