TEKsystems - Martinez, CA

posted 3 months ago

Full-time - Mid Level
Martinez, CA
10,001+ employees
Professional, Scientific, and Technical Services

About the position

As a Database Administrator at TEKsystems, you will be responsible for applying principles and practices of database administration, which includes the installation, upgrades, and maintenance of database management systems. Your role will involve utilizing methods and techniques of database design to develop, modify, and maintain database models based on logical models, designs, and requirements. You will also need to understand the operational characteristics of information systems environments to effectively participate in systems analysis, design, implementation, and maintenance. In addition to database administration, you will employ methods and techniques of applications development to program and maintain business logic for application integration, data extraction, transformation, and load (ETL). Your responsibilities will also include implementing principles and practices of software installation, ensuring that all necessary patches and updates are applied to maintain system integrity and security. As part of your duties, you will manage system installation and administration, establishing procedures for database security, backup policies, and disaster recovery solutions. You will utilize SQL database language and ETL development software to monitor and optimize database performance, troubleshoot issues, and ensure database accessibility and scalability. Effective communication and collaboration with colleagues and stakeholders will be essential, as you will need to communicate clearly and concisely, both orally and in writing, to establish effective working relationships.

Responsibilities

  • Apply principles and practices of database administration, including installation, upgrades, and maintenance of database management systems.
  • Utilize methods and techniques of database design to develop, modify, and maintain database models based on logical models, designs, and requirements.
  • Understand the operational characteristics of information systems environments to participate in systems analysis, design, implementation, and maintenance.
  • Employ methods and techniques of applications development to program and maintain business logic for application integration, data extraction, transformation, and load (ETL).
  • Implement principles and practices of software installation, ensuring all necessary patches and updates are applied.
  • Manage system installation and administration, establishing procedures for database security, backup policies, and disaster recovery solutions.
  • Utilize SQL database language and ETL development software to monitor and optimize database performance, troubleshoot issues, and ensure database accessibility and scalability.
  • Communicate clearly and concisely, both orally and in writing, and establish effective working relationships with colleagues and stakeholders.

Requirements

  • Experience as a Database Administrator with a strong understanding of SQL Server and SQL.
  • Proficiency in PowerShell and Python for scripting and automation tasks.
  • Experience with Azure and SSIS for data integration and management.
  • Strong skills in performance tuning and database management.

Nice-to-haves

  • Familiarity with ETL processes and tools.
  • Experience in applications development and business logic programming.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service