Postgres Database Developer

Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company databases. Implements data models and database designs, data access and table maintenance; resolves database performance issues, database capacity issues, replication, and other distributed data issues.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Extensive knowledge of DBMS systems.
• Support of Oracle, SQL Server, and MySQL Databases.
• Maintain production, staging, development, and test database instances.
• Administer and maintain policies and procedures to ensure the security and integrity of all databases.
• Server and workstation HW/SW system installations, configuration, upgrades, patches, and maintenance.
• Maintenance of configuration documentation and system procedures.
• Ability to troubleshoot problems quickly, as well as, work the issue resolution to completion.
• Must be available to support a flexible work schedule.
• Participate in a scheduled on call rotation with other DBA team members.
• Provide assistance to developers and data analysts in the creation and tuning of SQL statements.
• Provide leadership, technical support, user support, technical orientation, and technical education activities to project teams and less senior staff.
• Manage change requests between development, staging, and production environments.
• Update and modify database structure and data while ensuring database integrity, stability, and system availability.
• The application of system analysis techniques and procedures, including consulting with users, to determine hardware, software, database, or system functional specifications.
• Research, develop, implement, and maintain backup and recovery procedures for database systems.
• Manage capacity planning, disaster recovery and performance analysis, develop and maintain database objects, structures for data storage, retrieval and reporting, test database design and functionality, tuning, system performance, and trouble shooting.
• Perform other duties as assigned.

QUALIFICATIONS To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION AND/OR EXPERIENCE Bachelor's Degree (B. A.) from four-year college or university.

In-depth understanding of all aspects of database technology with minimum five years experience in database administration or equivalent job experience.

Experience with UNIX, Linux, and Microsoft Windows operating systems.

LANGUAGE AND COMMUNICATION SKILLS Ability to read, write, follow directions, and possess above average listening skills. Strong interpersonal skills and a sensitivity to understand customer needs. Excellent written and oral communications skills are essential. The ability to prepare written materials in a clear and concise format and in proper English is required

MATHEMATICAL SKILLS This position requires the ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume as well as the ability to apply concepts of basic algebra and geometry.

REASONING ABILITY This job requires the ability solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists and the ability to interpret a variety of instructions furnished in written, oral, diagram or schedule form.

PHYSICAL DEMANDS The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand and walk. The employee is occasionally required to sit and reach with hands and arms. The employee is required to sit at a desk and work on a computer for long periods of time.

WORK ENVIRONMENT The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is occasionally exposed to moving mechanical parts and high precarious places. Occasionally handles emergency or crisis situations; frequently subject to interruptions, and multiple calls and inquiries. The noise level in the work environment is usually moderate.

OneMagnify is an equal opportunity employer.