Senior PostgreSQL Database Administrator (DBA) in Franklin, TN at APEX Systems

Date Posted: 8/16/2019

Job Snapshot

Job Description

Job #:  988593
Apex Systems, the 2nd largest IT Staffing and Consulting Firm in the Nation, is searching for qualified candidates for a new Senior PostgreSQL Database Administrator (DBA) opportunity with one of our top clients in the greater Nashville, TN area.
If you are interested in this opportunity, and having your profile submitted to the hiring manager please send your up to date resume, and contact information to Reece Belmondo via rbelmondo@apexsystems.com
 
Title: Senior PostgreSQL Database Administrator (DBA)
Location: Greater Nashville, TN
Length: 6 Month Contract To Hire (Based on performance)
Compensation: Competitive and negotiable based on experience
Benefits: Overview provided upon request
 
Senior PostgreSQL Database Administrator (DBA) Responsibilities:
  • Utilize a blend of experience between PostgreSQL DBA and Oracle DBA to review Oracle systems and help with performance problems, and support processes that occur to move data over to PostgreSQL Data warehouse.
  • Provide guidance on the ETL process and Foreign Data Wrappers (FDWs).
  • Support upgrades from PostgreSQL 9.6 to PostgreSQL 11.
  • All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery.
  • Proficiency with network troubleshooting tools and techniques.
  • Responsible for evaluating patch releases from Postgres and patching requests from development, and communicating constraints, issues, and timelines for deployment.
  • Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
  • 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), preventative action follow-through, and participation in weekly operations reviews.
  • Proactive database monitoring and issue resolution.
  • Database and PL/SQL and PL/pgSQL optimization including performance tuning, query optimization and supportability; experience with Oracle 11g/12c and Postgres 11.
  • Actively participate and contribute to projects involving enterprise systems enhancements
  • Participate in project design and Oracle database design decisions. Refine and troubleshoot the design.
  • Create and maintain appropriate documentation about the database and the data architecture.
  • Regular proactive capacity planning and tending reviews of all oracle databases. Producing weekly, monthly management reports.
  • Project Estimation process - including attending project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates.
  • Develop and implement Database security policies and procedures, in line with corporate objectives.

 
 Senior PostgreSQL Database Administrator (DBA) Requirements:
  • 7+ years of combined professional experience as an Oracle and PostgreSQL DBA.
  • Must have at least 2+ years of professional experience with PostgreSQL DBA experience.
  • Understanding of PostgreSQL 11 new features and their impact on analytic queries and/or ETL processing.
  • Expert knowledge on creating/debugging/tuning PL/SQL and PL/pgSQL Procedures.
  • Experience working with Foreign Data Wrappers (FDWs) for PostgreSQL specifically.
  • Desire to learn and support other platforms.

 
 Senior PostgreSQL Database Administrator (DBA) Pluses:
  • Experience in data modeling.
  • Understanding of or experience supporting J2EE application.
  • Understanding of or experience with virtual environments.
  • Goldengate, SQL Server 2008/2012/2014, MongoDB

 
 
 
 
 
 
 
 
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178-6178.