The Database Administrator III provides expert-level production support for various database issues and performs general duties across all database servers in the enterprise. Performs ad-hoc data pulls to answer business questions, creates reports, and monitors database server health.
Responsibilities
- Monitoring system performance and identifying problems that arise.
- Protecting the database against threats or unauthorized access.
- Ensuring that the database is adequately backed up and able to be recovered in the event of memory loss.
- Reporting on metrics regarding usage and performance.
- Suggesting changes and improvements for database maintenance or protection.
- Regularly liaising with IT project managers and database programmers.
- Responsible for installation, configuration, maintenance, monitoring, administration, and performance & tuning of database hardware and software.
- Manage day-to-day operational support of development, test and production database environments including backup and recovery of production systems and cloning of database to non-production systems on a scheduled and ad hoc basis as required.
- Responsible for query analysis and performance and tuning recommendations including plan analysis, index recommendations and database server configuration.
- Collaborate with application teams in the design and implementation of database schemas to meet business objectives& technical requirements.
- Monitor and report project status to ensure that projects are completed on time and within budget.
- Configure monitoring utilities for databases to keep false alarms to a minimum.
- Manage business intelligence objects, with a lighter role in the creation of these objects.
- Creates reporting using SSRS and/or report builder.
- Ability to provide on-call assistance to urgent production database matters in a 24x7 environment.
- Comfortable with working in a fast-paced environment with multiple databases simultaneously
Requirements
- Bachelor’s degree in information systems or equivalent work experience/certification
- Minimum 7 years professional experience in Database administration
- 5+ years of experience with Microsoft SQL Server in a corporate environment, supporting production, as well as QA/DEV/Test environments.
- Advanced knowledge of Microsoft SQL Server {2019), including SQL data types, table definitions, stored procedures, SQL queries, SQL Server Integration Services (SSIS) and SQL Server Reporting Services {SSRS)
- Strong command of T-SQL, leveraging SQL Server tools, and other database management tools for maintaining MySQL and PostgreSQL database environments
- Proficient knowledge of database security, backup and recovery, and performance monitoring standards
- Skilled in the following database technologies {TSQL, SSIS, DTS, SSRS)
- Familiarity with HA/DR technologies such as clustering and replication
- Able to translate business requirements from non-technical users into technical solutions.
- Display an eagerness to learn new technologies and have a can-do attitude and the desire to provide complete solutions rather than simple fixes.
- Excellent communication and customer service skills
- Ability to mentor and guide team members in both soft skills and technical knowledge.
- Ability to complete projects that exceed expectations with little to no supervision
Who We Are
Welcome to arrivia . We specialize in making brands better through the power of travel. With more than 55 years of combined experience, we’re a merger of three powerhouse brands (in case you’ve heard of us in the travel industry) combining ICE, SOR Technology and WMPH Vacations. With offices on both coasts of the US and around the world, we embrace diversity and a passion for travel across our global staff.We’re focused on building a customer-first culture, fueled by the best travel experiences for all our members at every point in their journey.
Grow with us, as we continue our path to deliver innovative solutions and take charge of change. The adventure is only beginning. We’re on a mission to help people around the world travel better and experience more. Our team members bring world-class skills to the table to create extraordinary memories for our partners and members.
Our Core Values
Here at arrivia we…
- Stay Curious - Explore new challenges and make space to learn, grow and improve
- Keep it Real - Earn trust through open, honest and clear communication
- Own it - Seek ways to make an impact and take action.
- Win Together - Create a culture of connection and inclusion where everyone can be their best
