Database Developer

Job Description:

• Independently manages and administers research databases of the institute; supports enterprise research data management at a high level.
• Co-leads the development of novel standards-based data architecture for the Survey. Works within the earth and water sciences and provides institutional data management support by developing, deploying, and administering databases and database applications.
• Performs database backup, restore, and recovery.

• Responsibilities:

• Delivers and reports on data through the development of stored procedures, trigg
• ers, functions, and views; creates database queries, indexes, and writes data load scripts; designs, tunes, and indexes data tables.
• Troubleshoots issues and develops normalized database solutions; reviews monitoring tools and query execution plans to maintain or increase query efficiency; performs root cause analysis on query performance issues.
• Creates and maintains documentation for all database development projects and/or activities.
• Researches and stays current with database development trends and best practices; recommends database standards, policies, and procedures.

Key Skills:

• Excellent oral and written communications skills.
• Excellent analytical skills.
• Thorough knowledge of physical database design and data structures.