13 Dec
EDW Architect/DBA/Business Analyst
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
- 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
- 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.
- 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
Vacancy expired!