Responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues. Also transform the data for various reporting and migration needs.
Responsibilities :
- Install and maintain the performance of databases.
- Develop processes for optimizing database security.
- Set and maintain database standards.
- Create and manage database reports, visualizations, and dashboards.
- Create and manage data warehouses for custom reports via third party APIs like Power BI, Holistics, Metabase, Mode Analytics
- Must guarantee that data is stored securely and optimally
- Manage database access.
- Performance tuning of database systems.
- Install, upgrade, and manage database applications.
- Use high-speed transaction recovery techniques and backup data
- Minimize database downtime and manage parameters to provide fast query responses
- Diagnose and troubleshoot database errors / queries.
- Recommend and implement emerging database technologies.
- Create automation for repeating database tasks.
Requirements
Database Administrator Qualifications / Skills :
Strong command of SQL and SQL server toolsAdvanced knowledge of database security, backup and recovery, and performance monitoring standardsUnderstanding of relational and dimensional data modelingStrong mathematical and statistical knowledgeExcellent written and verbal communication skillsImpeccable attention to detailEducation and Experience Requirements :
Bachelor’s degree in computer science or a related fieldThree to five years of experience in database administration, information technology, database architecture, or a related fieldProven working experience as a Database AdministratorHands-on experience with database standards and end user applicationsExcellent knowledge of data backup, recovery, security, integrity and SQLFamiliarity with database design, documentation and codingExperience with Windows(required) and Linux(optional) Server environmentsExtensive experience with database technologies (MS SQL required) - (MySQL, PostgreSQL Oracle, MongoDB optional)Experience with cloud services (AWS, Microsoft Azure) a plus