Postgres SQL EDI Database Administrator II

United Global Technologies

Postgres SQL EDI Database Administrator II

Denison, TX
Full Time
Paid
  • Responsibilities

    Responsible for the maintenance of production, test and development databases.
    • Brings solid understanding of database administration.
    • Supports development team from a database design and development perspective.
    • Responsible for database administration or engineering activities, ensure optimal performance on PostgreSQL environments.?
    • Responsible for the installation, maintenance, configuration, and integrity of PostgreSQL architecture.?
    • Performance tuning of the queries.
    • Provide support to the application developers, including, but not limited to data refresh, SQL and PL/pgSQL performance tuning and best practice recommendations.
    • Conduct code reviews with application developers.
    • Ensure the long-term requirements of systems operations and administration are included in the overall database systems planning of the organization.?
    • Perform many related database functions across one or more teams, including designing, implementing, and maintaining new databases, backup/recovery and configuration management.
    Required Qualifications
    • Bachelor’s degree
    • 3+ years of experience as a DBA / developer for complex and high-volume data warehouse projects.?
    • AWS certification
    • Strong PL/PGSQL or PL/SQL experience is a plus.?
    • Experience in PostgresSQL, AWS RDS Aurora PostgreSQL.?
    Hands-on experience with Postgres database administration, performance tuning and production support in a high volume, customer-facing apps/environment.?
    • Data modeling experience
    • Experience working in Agile/ Scrum programs with multi-disciplinary development teams
    • Excellent written, verbal, and interpersonal communication skills
    • Manages time extremely well, can quickly sense when issues need to be addressed
    • Strong attention to detail and focus on task completion.

    • ***Able to obtain a U.S. Federal Position of Trust clearance designation. ***
    Qualifications
    • Experience with health IT systems with Electronic Data Interface (EDI) processing
    • Experience with 270/271 transactions and/or other X12 data formats
    • Experience with healthcare data, specifically Medicare/Medicaid
    • 5+ years of experience as a DBA / developer for complex and high-volume data warehouse projects.?

    5000 Brittonfield Parkway, Suite 100 East Syracuse NY 13057 pay $50
    2400 Thea Drive, Suite 3B Harrisburg PA 17110 zone 5 $71.34 pay $48
    2245 Rolling Run Drive, Suite 9 Baltimore MD 21244 4616 pay $53

    Hwy 75, Suite 240 Denison TX 75020 pay $48
    75 SGT. William B. Terry Drive, Suite 2012 Hingham MA pay $53
    220 Virginia Ave, Indianapolis, IN, 46204 pay $50
    2 Gannet Dr. South Portland, Maine 04106 zone pay $48