Database Administrator

Insight Global - Indianapolis, IN

Full-time

Indianapolis, IN

Administrative and Support Services

About the position

The position involves creating and managing metadata, participating in unit testing for data validation, and providing ongoing support for business data analysis and quality testing. The role requires evaluating test results, developing database designs, and reviewing SQL code while ensuring compliance with data requirements.

Responsibilities

• Create and populate metadata and participate in unit testing for data validation.
• Evaluate test results for fulfillment of all data requirements.
• Develop conceptual or general designs, including logical design of databases, access methods, and metadata presentation.
• Detail all aspects of functional designs, including record layouts, pseudo-code, and detailed data mapping.
• Provide ongoing support of business, including ongoing data analysis, data quality testing, and enhancement of metadata.
• Review SQL code and provide DBMS technical configuration and troubleshooting.
• Provide 24x7 production and non-production DBA on-call support.

Requirements

• 3-5 years of experience with database management systems (DBMS) support for Oracle and PostgreSQL.
• Experience working with PL/SQL.
• Knowledge of Python for managing and monitoring jobs.
• Experience utilizing DBMS management tools and implementing new DBMS features.
• Experience working within Medicare claims or for CMS (Centers for Medicare & Medicaid Services).
• Experience with Oracle Enterprise Manager (OEM).