Back to Job Search

SQL DBA

  • Location: Atlanta, Georgia, 30319
  • Job Type:Contract

Posted about 1 month ago

Position: EDW DBA/Business Analyst

Location: Atlanta, GA

Duration: 12 Months

Our client, a worldwide leader in mobile communications is seeking a EDW DBA/Business Analyst who will serve in a multifaceted role which include Enterprise Data Warehouse  Database Administration and Business Analysis. The position will operate as a critical member of a team of SQL/MicroStrategy/PowerBI resources doing complex analytics and reporting.

Responsibilities:

Multi-faceted role comprising 2 key functional areas:

DBA role

  • Create/modify databases to support new data requests
  • Troubleshoot poorly performing queries
  • Responsible Physical design of tables
    • Columns Data Types
    • Partitioning schemes
    • Data sizing/estimation
    • Indexing
  • 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.
  • Backup and restore
  • Responsible for promoting objects from development to production
  • Troubleshoot failed jobs
  • 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.
  • Windows Batch
  • Linux Corn Shell

Business Analyst role

  • Responsible for User Acceptance Test of ETL flows and Reports
  • Work with business to establish metric definitions and display actions/flow
  • Responsible for meeting with the business to solicit business requirements and translating those into functional/technical requirements for developers
    • ETL flow
    • Documentation
  • Troubleshoot failed reporting

Required skills:

  • 5 plus years of experience with column store indexes, partitioned tables, index builds/performance, query execution plans, troubleshooting query performance, and have a deep knowledge of SQL development
  • 5 plus years of experience with SQL development, database administration, query tuning, SSIS development, performance monitoring, security admin
  • 5 plus years of experience planning a solution, documenting the solution, soliciting business requirements, generating functional/technical requirements
  • 3-5 years of experience with planning reports including requirements
  • Previous telecom experience required/AT&T telecom experience preferred
  • Previous experience with SQL Server Version 13
Preferred Experience:
  • 2 plus years of previous experience working with MicroStrategy and PowerBI
  • Previous DBA experience with AT&T strongly preferred
  • Previous experience with Oracle, Teradata or Vertica