Amazon Web Services (AWS), Analysis Skills, Auditing, Data Warehousing, Database Administration, Database Programming, Payment Processing, Performance Management, Pharmaceutical Data, PostgreSQL, Query Optimization
E-logic is seeking a hybrid Database Developer and Administrator to maximize the performance, structure, and integrity of our primary analytical data warehouse environment for the Office of Personnel Management (OPM), Office of Inspector General (OIG).This role will be hybrid in Washington DC area, as needed.
Key Responsibilities
- Administer and develop for Amazon Redshift (RA3 nodes) and Amazon PostgreSQL databases within a FedRAMP High pre-production and production framework.
- Build, optimize, and maintain complex relational structures, Raw History tables, and staging schemas.
- Identify and eliminate performance bottlenecks associated with high-volume incremental health claim data loads.
Qualifications
- Advanced expertise in AWS Redshift administration, PostgreSQL database development, and query optimization.
- Experience managing complex structures related to medical/pharmaceutical data elements (providers, subscribers, payment processing rules).
- 3+ years in database administration/development supporting data warehouse environments for analytics or auditing.
Important Notice:
This role is part of a proposal for the Office of Personnel Management (OPM), Office of Inspector General (OIG). Hiring is contingent upon the selection of the consultant. Selected candidates will be included in the proposal and must authorize the use of their resume for submission.