Our Client Currently looking for ERP Database Administrator (DBA)
CORE RESPONSIBILITIES
Database Management, Modeling and Development:
· Administer and maintain the P21 databases (SQL) to ensure optimal performance, availability, and security.
· Create and maintain logical and physical data models to ensure data integrity and efficient use of resources.
· Implement database structures based on application requirements and best practices.
· Monitor database performance, troubleshoot issues, and implement solutions to enhance efficiency.
· Collaborate with cross-functional teams to understand data requirements and provide effective database solutions.
· Manage user access and permissions to databases, ensuring compliance with security policies and regulatory requirements.
· Plan and execute database upgrades, patches, and migrations while minimizing downtime and impact on business operations.
· Oversee SQL Server Reporting Services (SSRS) to design, develop, and deploy reports for various stakeholders across the organization.
· Create/Maintain SSIS packages used for importing/exporting/updating data.
Data Security and Integrity:
· Implement and maintain robust security measures to protect sensitive data.
· Perform regular data integrity checks and implement measures to address any discrepancies.
· Implement and maintain database security measures to protect sensitive data.
· Regularly audit and update user permissions and access controls.
Performance Tuning & Query Optimization:
· Conduct regular performance tuning and optimization of database systems for efficient and fast query execution.
· Collaborate with the data science team to optimize SQL queries and improve overall system performance.
· Write efficient, tuned, and well-documented SQL queries to extract, update, and manipulate data.
Backup, Recovery and Documentation:
· Collaborate with the technology team to develop and implement backup and recovery strategies to safeguard critical data.
· Test and verify backups to ensure the ability to restore systems in case of data loss.
· Maintain comprehensive documentation of database configurations, procedures, and troubleshooting steps.
· Develop and update documentation for database-related policies and best practices.
Are you interested in this position?
Apply by clicking on the “Apply Now” button below!
#AlbionarcJobs#FintechJobs
#AsiaJobs#MiddleEastCareers
#TechTalent#FintechRecruitment
#FinanceOpportunities#
