Database Administrator at MSM Technology, LLC

Fort Rucker, Alabama, United States -

Full Time

Start Date

Immediate

Expiry Date

15 Apr, 26

Salary

0.0

Posted On

15 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Administration, Automation Solutions, Issue Diagnosis, Documentation Development, Change Validation, User Account Administration, Technical Assistance, Data Governance, Data Warehousing, Business Intelligence, SQL, Shell Scripts, Data Migration, Performance Monitoring, Capacity Planning, Database Security, Big Data

Industry

IT Services and IT Consulting

Description

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. Requirements Attain and maintain a secret clearance IAT II certification 2+ years’ experience with database administration

Responsibilities

The Database Administrator implements the full lifecycle of enterprise database systems and maintains automation solutions to streamline management tasks. They also diagnose complex issues, assist developers, and provide monthly reports on database activities.