Job Description:
Responsibilities
- Develop detailed logical data designs and metadata content. Works on more complex database design, development and support activities.
- Creates and populates metadata and plans and participates in unit testing for data validation.
- Evaluates test results for fulfillment of all data requirements.
- Develop conceptual or general designs, including logical design of databases, access methods, metadata presentation, etc.
- Details all aspects of functional designs, including record layouts, pseudo-code, detailed data mapping, etc.
- Productionalizes data-related project components and institute all required changes. Provides ongoing support of business, including ongoing data analysis, data quality testing, enhancement of metadata, etc.
- Provides user management and DBMS security support. 24x7 production and non-production DBA on-call support.
- 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 PLSQL 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. Knowledge of Oracle 19c+, Database Management Systems Tools, Linux Operating Systems, Solaris Operating Systems, PLSQL, Bash, Cron, Python. Monitoring Tools such as Oracle Enterprise Manager, DynaTrace, Oracle Real User Experience Interface (RUEI), Oracle File Watcher. Familiar with DISA STIGs and Nessus.
Qualifications:
• 3-6 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
• Experience with health IT systems, Gentran and Direct Connect
• Experience with healthcare data, specifically Medicare/Medicaid
• ***Able to obtain a U.S. Federal Position of Trust clearance designation. *** (REQUIRED)
