Database Administrator Advisor

$118,000 - $118,000/Yr

GovCIO - Pierre, SD

Full-time

Remote - Pierre, SD

About the position

The Database Administrator Advisor at GovCIO is responsible for ensuring the smooth operation and physical design of databases, particularly in support of a newly awarded customer contract. This fully remote position involves performance tuning, security maintenance, and the formulation of database management policies. The role also includes administering various database systems, developing standards and procedures, and assisting in the creation of SQL and web-based databases.

Responsibilities

• Implements and maintains smooth operation and physical design of databases.
• Conducts performance tuning of indexes and databases.
• Reviews database design and integration of systems, provides backup recovery, and makes recommendations regarding enhancements.
• Maintains security and integrity controls.
• Formulates policies, procedures, and standards relating to database management.
• Monitors transaction activity and utilization.
• Develops stored procedures and/or triggers.
• Administers a variety of database systems, such as Microsoft SQL Server.
• Develops and enforces database administration and user standards and procedures.
• Audits, modifies, and amends data in systems using SQL commands.
• Oversees the scheduling of database projects, backups, notifications, and database replication.
• Assists Database Designers/Information System Analysts in the development of SQL and web-based databases.
• Reviews technical designs, reports, and documentation produced by staff.
• Creates and maintains high-level reporting systems using products such as Crystal Reports.

Requirements

• Bachelor's degree with 8+ years of experience in database administration or commensurate experience.
• 8 years of database administration experience.
• Active HUD Public Trust clearance required.