Database Administrator

$114,400 - $156,000/Yr

Bayside Solutions - Martinez, CA

posted about 2 months ago

Full-time
Martinez, CA
Sporting Goods, Hobby, Musical Instrument, Book, and Miscellaneous Retailers

About the position

The Database Administrator will play a crucial role in developing, modifying, and maintaining database models that are based on logical models, designs, and requirements. This position requires a strong focus on documentation and communication, ensuring that any changes in database models are clearly articulated. The successful candidate will review data models created by other information systems professionals and provide recommendations for modifications to enhance efficiency and effectiveness. It is essential that the logical and physical data models adhere to established standards for naming, metadata, and other common data structures. In addition to model development, the Database Administrator will participate in systems analysis, design, implementation, and maintenance. This role involves providing advice and consultation to application programmers during systems analysis, ensuring that all aspects of the database management system environment and associated application developments are aligned with best practices. The position also entails installing, upgrading, and maintaining software and patches for standard database management systems, as well as establishing and implementing procedures for database security, backup methods, policies, and disaster recovery solutions. Monitoring and optimizing database performance is a key responsibility, as is responding to any system problems that may affect the database. The Database Administrator will also consult and assist with software implementation, program and maintain business logic for application integration, and ensure that data extraction, transformation, and load processes are efficient. Furthermore, the role requires establishing plans for system capacity, technology succession planning, technology modernization, system upgrades, and migrations to ensure the database remains accessible and scalable to meet system availability needs.

Responsibilities

  • Develop, modify, and maintain database models based on logical models, designs, and requirements.
  • Document and communicate changes in database models.
  • Review data models developed by other information systems professionals and recommend modifications.
  • Assure logical and physical data models meet standards for naming, metadata, and other common data structures.
  • Participate in systems analysis, design, implementation, and maintenance.
  • Provide, advise, and consult with application programmers during systems analysis.
  • Develop standards and preferred methodologies for using the database management system environment and associate application developments.
  • Install, upgrade, and maintain software and patches for standard database management systems.
  • Establish and implement procedures for database security, backup methods, policies, and disaster recovery solutions.
  • Monitor and optimize database performance and respond to system problems affecting the database.
  • Consult and assist with the software implementation.
  • Program and maintain business logic for application integration, data extraction, transformation, and load.
  • Ensure database accessibility and scale for system availability needs.
  • Establish plans for system capacity, technology succession planning, technology modernization, system upgrade, and migration.

Requirements

  • A Bachelor's degree in information systems, computer science, or a closely related field
  • 4+ years of experience; 2+ years of database administration experience
  • Skilled in Python and Powershell
  • DevOps and Visual Studio Administration
  • SSIS Development experience
  • Knowledge of Azure SQL Integration
  • SQL Server Administration
  • Principles and practices of database administration
  • Methods and techniques of database design
  • Operational characteristics of information systems environments
  • Methods and techniques of applications development
  • Principles and practices of software installation
  • Principles and practices of system installation and administration
  • ETL development software
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service