Database Administrator

Ustring Solutions LLC

10+ Years

Data Management

United States, Texas, Bedford

Job description

Creating and maintaining database standards and policies.

• Supporting database design, creation, and testing activities.
• Managing the database availability and performance, including incident and problem management.
• Installing and configuring database software (MySQL, PostgreSQL, MongoDB, Oracle, AWS RDS, Azure DB) to meet performance and scalability requirements
• RAC installation, configuration, and administration (Grid Infrastructure) for clustering and high availability
• Upgrading databases across versions (10g, 11g, 12c, 19c) and applying PSU patches (RDBMS, GRID)
• Designing efficient database architecture and schemas to support millions of users and video metadata
• Monitoring and tuning database performance to ensure smooth playback and fast query responses
• Implementing backup and recovery strategies using RMAN, Data Pump, cloning, and disaster recovery procedures
• Enforcing robust security management, including Oracle Advanced Security and transparent data encryption for tablespaces
• Supporting Oracle SQL, PL/SQL code functionalities and assisting developers with query optimization
• Capacity planning and scalability analysis to forecast storage and compute needs
• Managing data migration and integration across platforms and environments
• Performing database housekeeping, such as tuning, indexing, etc.
• Monitoring usage, transaction volumes, response times, concurrency levels, etc.
• Implementing security measures and frameworks, while ensuring compliance.
• Identifying, reporting, and managing database security issues, audit trails, and forensics.
• Designing database backup, archiving, and storage strategy.
• Installing upgrades and patches to various apps.
• Managing database analytics, cloud integration, monitoring, troubleshooting, and compliance in AWS environments
• Handling cloud cost management, clustering technologies, and data migration from on prem to RDS and between RDS instances
• Performing rehydration and ensuring optimized use of computing resources (CPU, memory, storage)
• Managing Google Cloud Platform (GCP) database services (Cloud SQL, BigQuery, Firestore) for scalable analytics, integration, and cost optimization.