Database Administrator

Description

• Implements the full lifecycle of enterprise database and application server systems, services, and solutions, ensuring quality, stability, recoverability, and security.
• Maintains automation solutions and scripts to streamline complex database and application server management tasks across multiple environments.
• Diagnoses and resolves complex issues across large, multi-system environments.
• Develops and maintains documentation for systems, services, processes, and procedures.
• Reviews and validates changes to ensure they do not negatively impact database security or integrity.
• Assists application developers and functional users with database-related problems and requests.
• Serves as a resource for database integration issues, including migrations between disparate databases, data conversion, capacity planning, and new application deployments.
• Provides a Monthly Database Report detailing unscheduled downtime for production and non-production databases, capacity usage, and database activities.
• Performs full database maintenance activities, including patching, upgrades, managing table spaces and redo logs, data migrations, performance monitoring, and tuning.
• Administers user accounts for employees and authorized contractors, including creating, granting, and revoking privileges and roles; resetting passwords; locking/unlocking accounts; setting quotas; and managing default table spaces.
• Provides technical assistance to developers and end users for connecting client software to databases, developing SQL and shell scripts, importing/exporting schemas, answering database questions, terminating processes/threads, and migrating data.
• Works with data owners and the ISSO to ensure personally identifiable information (PII) is encrypted in enterprise databases.
• Supports data governance policies by ensuring data accuracy, accessibility, consistency, and completeness.
• Implements future DBMS requirements, including strategies for big data, relational, dimensional, and unstructured databases.
• Supports data warehousing and business intelligence initiatives, including data mining and data movement, as implemented by the customer.
• Performs other related duties as assigned.

• Attain and maintain a secret clearance
• IAT II certification
• 2+ years’ experience with database administration