About AAA Colorado:
At AAA Colorado, our mission is to create a culture that nurtures members for life by exceeding their expectations through valuable products and legendary service. We know that this is best achieved by inspiring employees to be innovative, compassionate and confident as they deliver the peace of mind that our members have come to rely upon. You not only make a difference; you ARE the difference.
Our club originated in 1922 and today serves more than 650,000 members through retail branches and fleet facilities in more than 11 locations across the state along with a centralized 24/7 call center based at our headquarters in Denver. We provide roadside assistance and battery service, as well as many specialized services such as Insurance, Road-trip planning, Domestic & International Travel, Discount & Reward Programs and Auto Buying to name a few. AAA is a key advocate for issues impacting the traveling public, such as highway safety, road maintenance and related legislation. As a AAA Colorado employee, you will make valuable contributions to our workplace, the lives of our members and the community around you.
AAA Colorado offers medical, dental, life insurance, paid time off, and 401(k) with a company match.
The primary purpose of all jobs in our organization is to serve our members. This is either done by direct contact with our members or supporting those employees who do. PURPOSE OF POSITION: The Database Administrator will be responsible for the install and configure of SQL Server instances. Design, build, implement, maintain and administer SQL Server relational databases for use by business units. Build, schedule, and monitor ETL jobs to import data from outside sources as needed. Work with the IT Security Architect to create and implement policies and procedures for ensuring the security and integrity of SQL Server instances and databases. Monitor database performance, capacity, data replication, and other distributed data items and resolve issues. Work with the BI Developer/Analyst on the development and maintenance of the Enterprise BI Application and Reporting Services. Provide recommendations to management and development teams for various hardware/software solutions. ESSENTIAL RESPONSIBILITIES Perform complex data processing using stored procedures and automates processes for providing data feeds using scripting languages. (25%) Design, build, implement, maintain, and administer databases and ETL processes on defined schedules and following business requirements. (20%) Resolve database performance issues, database capacity issues, data replication, and other distributed data issues for analytical dataset applications. (15%) Perform technical tasks to include computer programming associated with software installations, system modifications, system integration, and application maintenance. (15%) Provide technical assistance to business lines and analysts. (15%) Create and implement policies and procedures for ensuring the security and integrity of databases. This includes user access. (5%) Perform feasibility studies and research on technical issues. (5%) EDUCATION AND/OR EXPERIENCE Bachelor s degree in computer science or related field and three (3) years' experience in relational database design and administration in a multi-user environment including in depth involvement in system analysis, design, development, and implementation. Thorough knowledge of database development, data integration, data transformation and project management. MS SQL Server 2012/2014 Administration Experience.
◦Data Definition Language, Data Manipulation Language, Standard Query Language, SQL Server Integration Services, and VBscript.
◦Physical Database Design Concepts and Implementation Experience.
◦Database Performance Tuning.
◦Relational Data Modeling and Logical Database Design.
◦Security. Experience in Windows Server user and rights management. Experience with programming in a structured programming language or other relational database experience. Data analysis skills using tools or other high-level languages. Thorough understanding of most common business processes and functions. Demonstrated ability as a team leader for highly complex projects that have high impact. Demonstrated leadership in providing technical expertise, guidance, and work direction to team members. Excellent oral and written communication skills. Excellent organization and interpersonal skills. Excellent time management skills. WORK ENVIRONMENT and PHYSICAL DEMANDS Office environment.
20% walking, standing, bending, etc. While performing the duties of this position, the employee is regularly required to sit, speak, stand, walk and listen. The employee frequently is required to use hands, fingers and arms. The employee is regularly required to sue multiple forms of technology including a PC.