Database Developer

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.