Oracle/PostgreSQL DBA

$83,200 - $93,600/Yr

Anchor Point Technology Resources - Indianapolis, IN

Full-time - Mid Level

Indianapolis, IN

Professional, Scientific, and Technical Services

About the position

The Oracle/PostgreSQL DBA position is responsible for developing detailed logical data designs and metadata content, focusing on complex database design, development, and support activities. The role includes ongoing support for business data analysis, data quality testing, and enhancement of metadata, while also providing technical configuration and troubleshooting for database management systems. The DBA will ensure optimal performance of PostgreSQL environments and support development teams from a database design and development perspective.

Responsibilities

• Creates and populates metadata and participates in unit testing for data validation.
• Evaluates test results to ensure fulfillment of all data requirements.
• Develops 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 institutes all required changes.
• Provides ongoing support to the business, including ongoing data analysis, data quality testing, and enhancement of metadata.
• Reviews SQL code and offers tuning suggestions.
• Provides DBMS technical configuration and troubleshooting.
• 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.
• Supports development teams from a database design and development perspective.
• Ensures optimal performance of PostgreSQL environments.
• Responsible for the installation, maintenance, configuration, and integrity of PostgreSQL architecture.
• Performs query performance tuning.
• Provides support to application developers, including data refresh, SQL/PLSQL performance tuning, and best practice recommendations.
• Conducts code reviews with application developers.
• Ensures that long-term requirements of system operations and administration are included in the overall database systems planning.
• Performs functions such as designing, implementing, and maintaining new databases, backup/recovery, and configuration management.

Requirements

• Bachelor's degree in Information Technology, Computer Science, or related field.
• Minimum of 3 years of experience with Oracle database administration or equivalent experience.
• 3+ years of experience as a DBA or developer for complex, high-volume data warehouse projects.
• AWS certification.
• Strong PL/PGSQL or PL/SQL experience is a plus.
• Experience in PostgreSQL and AWS RDS Aurora PostgreSQL.
• Hands-on experience with Postgres database administration, performance tuning, and production support in a high-volume, customer-facing environment.
• Data modeling experience.
• Experience working in Agile/Scrum programs with multi-disciplinary development teams.
• Excellent written, verbal, and interpersonal communication skills.
• Strong attention to detail and task completion.
• Must be able to obtain a U.S. Federal Position of Trust clearance designation.

Nice-to-haves

• Strong PL/PGSQL or PL/SQL experience is a plus.
• Experience in PostgreSQL and AWS RDS Aurora PostgreSQL.