SQLPostgress DBA

Setup maintain monitor and tune databases in a 24x7 highavailability environment.

Work closely with developers on application design query performance and troubleshooting.

Write efficient SQL and tune SQL for possible better performance.

Backup restore and recover databases. Create and maintain standby databases.

Create and support SQL scripts and shell scripts for use in daily maintenance and troubleshooting tasks.

Automate repeatable tasks by developing code to enforce standards and efficiency.

Implement and support database security standards.

Follow procedures identified by SOX and PCI standards and understand auditing requirements.

Participate in a production support oncall rotation when needed.

Actively participate in project teams and manage several different projects at once.

Create appropriate change control documentation for production maintenances.

Provide proper scrutiny to DDL submitted by developers for future releases. Plan accordingly for DDL application in production environment especially if the DDL requires a special maintenance window.

Practice important or complex database changes in a nonproduction first to eliminate surprises.

Test script and process changes in a nonproduction environment before production deployment.

Document support issues and resolutions in the Digital River Support Log (DRSL).

Organize work environment and make measured and methodical changes to prevent unintended interruptions to the production environment.