Vaco - Tampa, FL

posted 3 months ago

Full-time - Mid Level
Tampa, FL
Administrative and Support Services

About the position

The Database Administrator (DBA) plays a critical role in ensuring the availability and performance of the core Oracle and SQL databases within a 24x7x365 operational environment. This position is essential for maintaining the integrity and efficiency of database systems that support day-to-day operations. The DBA will provide technical guidance on query optimization and best practices to engineering teams and other departments, ensuring that all database-related activities align with organizational goals and standards. In this role, the DBA will focus on improving operational efficiencies related to database schema, settings, SQL queries, backup and recovery processes, change data capture, and disaster recovery procedures. The DBA will also be responsible for monitoring core production system services, ensuring proper disk and CPU utilization, and researching new products and upgrades to enhance database performance and security. Documentation is a key aspect of this position, as the DBA will be tasked with documenting and improving existing departmental procedures, policies, and workflows. Additionally, the DBA will closely monitor and manage security-related aspects of the Oracle and SQL databases, ensuring compliance with security protocols and audit requirements. The role also includes maintaining development, test, and UAT database systems, providing data maintenance services, and performing necessary data refreshes. Performance tuning and optimization will be required as needed to ensure the databases operate at peak efficiency.

Responsibilities

  • Provides technical guidance on query optimization and best practices to engineering teams and other departments.
  • Improves operational efficiencies of database schema, settings, SQL queries, backup/recovery processes, change data capture, and disaster recovery procedures.
  • Monitors the core production system services for proper disk and CPU utilization.
  • Researches new products and upgrades to enhance database performance and security.
  • Documents and improves existing departmental procedures, policies, and workflows.
  • Closely monitors and manages security-related aspects of the Oracle & SQL databases.
  • Maintains development, test, and UAT database systems and provides data maintenance services and refresh as necessary.
  • Documents database design, integration processes, and disaster recovery processes.
  • Performs performance tuning and optimization as required.

Requirements

  • 6+ years experience as Oracle & SQL Database Administrator in a high transaction environment.
  • 2+ years experience with Postgres Databases.
  • Solid understanding of relational database management systems, SQL queries, and table schema design.
  • Working knowledge of PL/SQL, Linux, and Java.
  • Understanding of networking, firewalls, security procedures, and audit requirements in relation to database systems.
  • Experience with performance tuning, partition, database design, data warehouse, and encryption.
  • Working knowledge of storage in relation to database.

Benefits

  • Hybrid Work in Tampa, FL
  • Employer Matched 401K (Up to 10% of Employee Salary)
  • Company Paid Medical Insurance Option for Employee and Dependent Children
  • Company Paid Dental Insurance for Employee
  • Company Paid Vision Insurance for Employee
  • Company Paid Long and Short-Term Disability
  • Company Paid Life and AD&D Insurance
  • 18 Paid Vacation Days a Year
  • Six Paid Holidays
  • Employee Recognition Programs
  • Holiday Bonus
  • Incentive Compensation
  • Community Outreach Opportunities
  • Business Casual Dress Code
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service