Database Administrator

World class company seeks a Database Administrator to assist in the design, testing, implementation, maintenance and control of the provisioning of logical and relational databases across multiple platforms and computing environments including host based, distributed systems, and client/server. . In this role, you will implements established standards, performs capacity management and planning, and performs implementation and reconfiguration. Supports the activities related to database planning and development.

Responsibilities

• Support design work for internal and commercial product developers to insure appropriate and efficient use of the specific infrastructure environment.
• Assist efforts related to the identification and analysis of corporate-wide information flows, interfaces between business processes and the development of logical data base designs, detailed data models and relational data base designs.
• Install and upgrade the database and applications, or other databases systems as directed.
• Create primary database structures upon completion of an application design and modify database structures from information provided by application developers.

Requirements

• Bachelor's degree in Computer Science or Computer Engineering or equivalent work experience.
• Six to eight (6-8) years of extensive experience installing and supporting Postgres, Microsoft SQL/Server, open source database solutions, and related technologies.
• Detailed knowledge of hardware and software issues on Linus/Unix and Microsoft servers, SQL/Server and Postgres databases.
• Experience working with commercial developers, internal developers, and customers on the deployment and support of Postgres, Microsoft SQL/Server, open source database solutions, and current Oracle applications software.
• Proficient in installation, configuration, and maintenance of PostgreSQL databases.
• Proficient in setting up and managing streaming replication and/or logical replication, and failover mechanisms.
• Proficient in designing and implementing backup strategies using pg_dump, pg_basebackup and/or pgBackRest and point-in-time recovery.
• Knowledge of role-based access control.
• Experience in partitioning and managing large datasets.
• Experience with extensions.
• Proficient in scripting with Bash, Python, or Perl for automation of DBA tasks (e.g., maintenance scripts, monitoring).