AECOM Database Warehouse Architect/Administrator (Database Administrator) in Kennedy Space Center, Florida
Requisition/Vacancy No. 152044BR
Position Title Database Warehouse Architect/Administrator (Database Administrator)
Job Category Information Technology
Business Line Government
Country United States of America
State/Province/Region USA - Florida
City Kennedy Space Center
Why Choose AECOM? AECOM is a premier, fully integrated professional and technical services firm positioned to design, build, finance and operate infrastructure assets around the world for public- and private-sector clients. With nearly 100,000 employees — including architects, engineers, designers, planners, scientists and management and construction services professionals — serving clients in over 150 countries around the world, AECOM is ranked as the #1 engineering design firm by revenue in Engineering News-Record magazine’s annual industry rankings, and has been recognized by Fortune magazine as a World’s Most Admired Company. The firm is a leader in all of the key markets that it serves, including transportation, facilities, environmental, energy, oil and gas, water, high-rise buildings and government. AECOM provides a blend of global reach, local knowledge, innovation and technical excellence in delivering customized and creative solutions that meet the needs of clients’ projects. A Fortune 500 firm, AECOM companies, including URS Corporation and Hunt Construction Group, have annual revenue of approximately $19 billion. More information on AECOM and its services can be found at www.aecom.com.
About the Business Line
AECOM works with national and local governments around the world to manage and support critical programs in the areas of defense, security and intelligence; energy and climate change; environmental cleanup and waste management; infrastructure development, protection and resilience; and international development. Our global operations and connected expertise enable us to provide cutting-edge, relevant and cost-effective solutions that help our clients safeguard and enrich society and the world we live in.
The Database Warehouse Architect/Administrator is responsible for the performance, scalability, security and support of the data warehouse databases along with technical support of the associated ETL processes, data analytics, data models and business intelligence reporting solutions. This position is located at Kennedy Space Center, Florida.
Provide technical support in the definition, design, and development of a multi-user data warehouse database environment.
Development of technical strategies and solutions as related to Database, Data Model & ETL (Extract, Transform & Load). Includes responsibility for data warehouse architecture and design and development of data model & ETL requiring multiple technologies.
Collaborate with data modeler, metadata specialist, business analysts and ETL team members to resolve complex data design issues/provide optimal solutions that meet business requirements/benefits system performance.
Researches and evaluates alternative solutions and recommends the most efficient and cost effective solution.
Monitor business use and performance of the data warehouse and provides feedback on data warehouse architecture, as well as provides mentoring and assistance in tuning to business partners and users.
Troubleshoots and resolves user and database issues to ensure the data warehouse meets service level requirements.
Collaborate with other DBA teams, Architecture and external vendors in planning, testing, configuration and execution of installations, upgrades and migration.
Assist applications development staff and users on database solutions to business problems, data architectures, database management system facilities and capabilities, and the operation and tuning of databases.
Perform all other position related duties as assigned or requested.
Bachelor degree in computer science, management information systems, or related field, or equivalent experience, and two to four years minimum of related experience is required. Good written and oral communication skills and familiarity with word processing, database, spreadsheet programs and integrated software applications are required.
Extensive technical knowledge and experience in multiple core technology areas and integration, along with strong planning and analytical skills a plus. Must have proven competency in the following areas: working with large multi terabytes of data warehouse, performance tuning of database & SQL queries, designing & developing databases to support multiple users and complex ETL packages. Experience with Microsoft SQL Server Analytical Databases – Tabular and experience with SharePoint Server Administration a significant plus.
Must be able to obtain and maintain the required security clearance. US Citizenship required for unescorted access to assigned work area(s). Must be able to successfully pass a National Agency Check w/Inquiries.
LOCAL CANDIDATE - NO RELOCATION AVAILABLE
Microsoft SQL Server Analytical Databases - Tabular experience preferred
Experience with SharePoint Server Administration a significant plus.
What We Offer
AECOM is a place where you can put your innovative thinking and business skills into high gear and work alongside other highly intelligent and motivated people. It's a place where you can apply your skills to some of the world's most challenging, interesting, and meaningful projects worldwide. It's a place that values the diversity of our areas of practice and our people. It's what makes AECOM a great place to work and grow.
AECOM is an equal opportunity employer and Minorities, Females, Veterans, and Disabled persons are encouraged to apply. For further information, please click here at http://www.aecom.com/content/wp-content/uploads/2016/01/EEO-is-the-Law-poster-supplement.pdf to view the EEO Is The Law poster.
NOTICE TO THIRD PARTY AGENCIES:
Please note that AECOM does not accept unsolicited resumes from recruiters or employment agencies. In the absence of a signed Recruitment Fee Agreement, AECOM will not consider or agree to payment of any referral compensation or recruiter fee. In the event a recruiter or agency submits a resume or candidate without a previously signed agreement, AECOM explicitly reserves the right to pursue and hire those candidate(s) without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted to hiring managers, are deemed to be the property of AECOM.