SQL DBA in Atlanta, GA at MDI Group

Date Posted: 9/17/2019

Job Snapshot

Job Description


SQL DBA
Sandy Springs, GA
Direct Hire

DUTIES & RESPONSIBILITIES – First 90 days

Within the first 30 Days

• Become familiar with existing SQL Server DB architecture including the movement of data between systems

• Design and/or provide analysis of stored procedures (both TSQL and PL/pgSQL)

• Maintain and enhance data recovery process, ETL processes, and cube deployment processes

• Complete tasks as assigned in JIRA using expected work-flow conventions

• Participate in standups, retrospectives, reviews, and sprint planning sessions

Within the first 60 days

• Work with the development team on redesign of legacy SQL Server schema for PostgreSQL

• Understand NexTraq’s partitioning architecture and handle issues that arise in production or development environments

• Understand NexTraq’s DR setup and architecture and handle DR scenarios

• Monitor databases and related systems to identify capacity and performance issues

• Script and automate regular tasks

• Work with current DBA to develop and implement performance and capacity remediation plans

Within the first 90 days

• Work with the development team on migration strategy of legacy SQL Server data to PostgreSQL

• Handle feature support through entire development life-cycle with little assistance

• Understand and participate in the software release process

• Document existing and future database architectures and processes as needed

Requirements:

• BS in Computer Science or related degree, or equivalent work experience

• Excellent verbal and written communication skills

• 10+ years of SQL Database Administration in both SQL Server 2012 and PostgreSQL 11 (or similar versions)

• 10 + years TSQL and PL/pgSQL development experience

• 5+ years of experience with ETL and SSAS (Development and Support), as well as SSIS and SSRS

• Experience working in a production environment (database supports 24x7 Web based nationwide application)

• Proven ability to work to and meet strict project timelines

Bonus Skills:

• SQL clustering/HA configurations knowledge

• Dynamic Table Partitioning/Splitting experience

• Experience in Large scale/Volume SQL configurations (Maintenance, Backup & Recovery etc.)

• Experience with large scale data processing with tools such as Spark

• Experience with time series databases such as TimescaleDB


A GREAT PLACE FOR GREAT PEOPLE TO WORK

Search IT Jobs