What are the responsibilities and job description for the Database Administrator position at RouteOne?
The Database Administrator is responsible for all aspects of database administration, configuration and deployment of Oracle databases and database build packages in the Production environment as well as other non-production environments. The Database Administrator will collaborate with internal and external teams to optimize and update database operations and ensure continuous improvement in monitoring and performance.
Job Responsibilities
Job Responsibilities
- Performs all work in accordance with company's quality programs, standards and procedures.
- Provides technical leadership to the development team in resolving development and implementation issues related to the database infrastructure.
- Responsible for participation in determining strategic architecture direction.
- Review technical documents to ensure consistency, accuracy and compliance with enterprise directions and security standards.
- Devise plans for patching and upgrading the database infrastructure.
- Develop and maintain all standards pursuant to data structures and models, review data models and frameworks/blueprints.
- Responsible for performance tuning of data retrieval and data loading program units.
- Responsible for capacity planning and performing Volumetric Analysis.
- Work with clients, business analysts, technical staff, and project team members to plan, design, develop, implement, and enhance applications, scripts, procedures, and metadata for relational databases.
- Provides full-life cycle product roadmaps for the database infrastructure.
- Reviews operational data structures and recommends optimizations and reconfigurations as warranted.
- Identify potential strategic data-related technology partners, evaluate and/or assess potential data-related tools and technologies. Work closely with 3rd party vendors to integrate selected packages. Recommend and evaluate new tools and methodologies.
- Conduct proof of concept and evaluate new features available for Oracle or related Database technologies and perform cost benefit analysis as applicable.
- Maintain safety, security, and privacy standards throughout all areas of responsibility.
- The candidate is normally drawn from technology but must have significant understanding of the business.
- Prior experience working as a data architect with good exposure to logical data modelling.
- Logical/physical database design experience.
- Expertise establishing system-wide standards, policies, procedures and methods.
- Solid, quantifiable experience in: Metadata standards, Data modeling, ERD & Dimensional.
- Participation in large Enterprise Data Warehouse deployments in the role of leading data migration projects in an Oracle RAC or Exadata environment.
- Experience in Web based Architecture with exposure to high availability and large-scale technologies such as clustering, load balancers, etc.
- Experience configuring and managing Oracle RAC and Exadata solutions, including cluster configuration, storage optimization, Smart Scans, Offloading, and High Availability and Disaster Recovery solutions.
- Experience working in containerized environments and with cloud-based infrastructure, middleware, and server solutions.
- Proficient in Microsoft Office products, including but not limited to: Microsoft Word, PowerPoint, Excel, Outlook, and Visio.
- 4 years of experience with all aspects of ETL tool configuration and build deployments.
- Experienced in RDBMS administration and configuration for large projects.
- Prefer knowledge of the STAR and eb XML standards.
- Excellent verbal and written communication skills.
- Ability to think critically and problem solve using industry standard methodologies.
- Ability to manage time and multiple priorities.
- Ability to document and update standard operating procedures.
- Disciplined, detail-oriented, and well organized with a strong background in operational methodology.
- Ability to interface and work with varied positions and levels of technical knowledge both within the department and with other departments in the company.
- Solid analytical and troubleshooting skills to quickly determine root causes of problems and drive towards solutions.
- Must foster a collaborative and collegial atmosphere within a dynamic and fast-paced work environment.
- Bachelor's degree in Computer Science, Information Systems, or other related field, or equivalent work experience.
- 5 years of experience as an Oracle RAC or equivalent Database administrator in an RDBMS, MDDB environment.