13 Dec
EDW Architect/DBA/Business Analyst
Georgia, Sanantonio , 78209 Sanantonio USA

Vacancy expired!

Position: EDW Architect/DBA/Business Analyst Location: San Antonio, TX Duration: 12 Months Our client, a worldwide leader in mobile communications is seeking a Data Solutions Architect/Developer who will serve in a multifaceted role which include Database Administration, Enterprise Data Warehouse Architect and Business Analyst. The position will operate as a team lead for a team of SQL/MicroStrategy resources doing complex analytics and reporting.

Responsibilities: Multi-faceted role comprising 3 key functional areas: DBA role
  • Create/modify databases to support new data requests
  • Troubleshoot poorly performing queries
  • Monitor database sizes and performance to ensure efficient use of disk space and server resources
  • Create/modify all server objects including agent jobs, linked servers, credentials/aliases, logins and database users, and permissions.
  • Responsible for promoting objects from development to production
  • Troubleshoot failed jobs
Enterprise Data Warehouse Architect role
  • Overall responsibility to create data warehouses and repositories to meet the reporting/analytic needs of the business.
  • Responsible for design of tables, columns, partitioning schemes, data sizing/estimation, ETL flow, and documentation
  • Responsible for meeting with the business to solicit business requirements and translating those into functional/technical requirements for developers
  • Responsible for setting and meeting project deadlines and managing resource conflicts
Business Analyst role
  • Review reporting for accuracy and applicability
  • Work with business to establish metric definitions and display actions/flow
  • Troubleshoot failed reporting
  • Create/modify new file exchanges both inside and outside of AT&T. Should be familiar interacting with web APIs using cURL or similar tool and SFTP.

Required skills:
  • Should be familiar with column store indexes, partitioned tables, index builds/performance, query execution plans, troubleshooting query performance, and have a deep knowledge of SQL development
  • SQL development, database administration, query tuning, SSIS development, performance monitoring, security admin
  • Planning a solution, documenting the solution, soliciting business requirements, generating functional/technical requirements
  • Planning reports including requirements

Education: Bachelor's degree in Engineering or Computer Science

Vacancy expired!


Report job