IT Database Administrator
Share
Job Location:
Indaiatuba - Brazil
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
As a DBA you will be responsible for building and maintaining database systems and ensuring data security. Your role will also entail deploying optimisation troubleshooting issues in our database management software and providing quick resolution. Youll be required to work individually as well as collaborate with Developers IT Operations and end-users to maintain databases. Thus your ability to communicate fluently in one or more database management languages will be vital for project-related analyses.
Tasks:
- Design install configure and maintain database systems including monitoring tuning and troubleshooting issues.
- Provide a seamless flow of information by keeping the database running smoothly in collaboration with the Group CoC Database team.
- Ensure data security and integrity including implementation of access controls backups and recovery plans.
- Execute disaster recovery plans and procedures to ensure database availability during system outages or dysfunction.
- Establish the needs of users and monitor user access and security.
- Monitor performance and manage parameters to provide fast responses to front-end users.
- Map out the conceptual design for a planned database.
- Consider both back-end organisation of data and front-end accessibility for end-users.
- Refine the logical design so that it can be translated into a specific data model.
- Further refining the physical design to meet system storage requirements.
- Install and test new versions of the database management system (DBMS).
- Maintain data standards including adherence to the Data Protection Act.
- Write database documentation including data standards procedures and definitions for the data dictionary (metadata).
- Control access permissions and privileges.
- Develop manage and test back-up and recovery plans (import/exports/DB reorganizations etc.).
- Ensure that storage and archiving procedures are functioning correctly.
- Carry out capacity planning.
- Work closely with IT project managers database programmers (database development teams)
- Communicate regularly with technical applications and operational staff to ensure database integrity and security.
- Commission and install new applications and customise existing applications to make them fit for purpose.
- Manage the security and disaster recovery aspects of a database.
- Create and manage database reports visualizations and dashboards.
- Create automation for repeating database tasks.
- Be available for on-call support as needed.
Ownership:
- Develop and maintain database documentation including data standards procedures and definitions for data elements and tables in the company.
- Identify and implement database requirements for new or existing applications by working collaboratively with other teams.
- Optimise database performance and efficiency by evaluating and recommending new database technologies.
- Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.
- Execute regular database maintenance tasks including database defragmentation backups and database replication.
Qualifications :
Mandatory Experience:
- Bachelors degree in Computer Science Information Technology or a related field.
- 5 years experience in database deployment tuning and administration.
- Experience in database backup disaster recovery planning performance optimisation and data security.
- Very good knowledge of database management systems in particular Oracle and PostgreSQL.
- Strong analytical and problem-solving skills to provide quick solutions to issues.
- Outstanding communication and collaboration skills to work in a team environment.
Nice to Have:
- Experience of migration from Oracle to PostgreSQL
- Working in a multi geographic environment
Specific skills and certifications:
- Ability to automate Database administrative tasks
- Relevant database administration certificates such as Oracle Certified Professional (OCP) Microsoft Certified Database Administrator (MCDBA) or Postgres Certification (CPSDBA).
- Experience in cloud database technologies like Amazon RDS or Microsoft Azure.
Additional Information :
Professional working proficiency in English is a requirement including the ability to read write and speak in English.
Remote Work :
No
Employment Type :
Full-time
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
About Company
Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and the environment safer, healthier and more sustainable. From the food you eat to the medicines you rely on, Eur ... View more
