Back to Job Search

Senior SQL Developer

  • Location: Atlanta, 30319
  • Job Type:Contract

Posted 2 months ago

UJO 9/28- This job order replaces JO 201504.  Would prefer US Citizens in Atlanta or San Antonio but remote acceptable.
 

Position: Senior SQL Developer

Location: Atlanta, GA

Duration: 12 Months

Our client, a worldwide leader in mobile communications is seeking a Senior SQL Developer who will serve in a multifaceted role which includes blend of design, development and administration. The position will operate as a critical member of a team of resources who are doing complex analytics and reporting for our client.  This is a great opportunity for someone with broad client facing SQL design, development and administration experience, who thrives in a smaller team environment.

Daily Responsibilities:

  • Monitor the state of the client database
  • Troubleshoot poorly performing queries and failed jobs
  • Monitor disk consumption and database performance
  • Perform database performance tuning and stored procedures
  • Create/modify all server objects including agent jobs, linked servers, credentials/aliases, logins and database users, and permissions.
  • Create database backups and restores
  • Create/modify new file exchanges both inside and outside of client. Should be familiar interacting with web APIs using cURL or similar tool and SFTP.
  • Responsible for User Acceptance Testing of ETL Flows and Reports
  • Work with business to establish metric definitions and display actions/flow
  • Guiding solution for new processes or new data based on business needs
  • Determining data size and structure based on history and performance
  • Determine logical architecture based on data pipelines and data models
  • Determine implementation architecture including data location and data partitioning
  • Determine data model including new joins, disks or additions to database
  • Development, performance testing and troubleshooting of ETL packages

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/ETL packages, performance monitoring
  • 5 plus years of experience planning a solution, documenting the solution, soliciting business requirements, generating functional/technical requirements for changes to data models, ETL processes and database structure
  • 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

 


 

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer and provides reasonable accommodations for qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual with a disability, you may request a reasonable accommodation under the American Disability Act (ADA) by emailing MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.