DBA - Netezza, MySQL, Postgres, Greenplum

Posted 4 years ago By: claudia

Category: DBA

Salary: 2000 - 4000 USD

Location: Mexico

Experience: 3 - 5 Years

Skills

SQL

ORM

Key Responsibilities

Responsibilities includes installation, administration, operations, support, and maintenance, monitoring & upgrading of database servers to ensure availability, security with optimal performance primarily.

Recommends solutions and follows standards on database physical structure, functional capabilities, security & backups.

Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements.

Maintains quality of service by establishing and enforcing organization standards.

Responsible to perform query optimization, database design optimization in addition to providing assistance/reviews/feedbacks to stakeholders in writing complex queries, stored procedures/functions, views, DDL/DML script.

Troubleshoot complex database issues in accurate and timely manner ensuring compliance to SLAs / OLAs.

Ensuring Data Security & Encryption, controlling authorization/authentication, and adherence to the security compliance standards i.e. ISO, Data Protection Act, GDPR, Internal InfoSec etc.

Maintain database operational, disaster recovery, backup procedures/processes to ensure continuous availability and speedy recovery.

Responsible to maintain a good, healthy & friendly team environment.