Loading

Banner Image
  • Location

    Atlanta, Georgia

  • Job title:

    Senior Database Administrator

  • Sector:

    Technology

  • Job type:

    Direct Hire

  • Job ref:

    5698

Senior Database Administrator

JOB SUMMARY

Are you a Database Administrator on the lookout for exciting and new challenges in the SQL Server and PostgreSQL  landscapes? Are you looking to apply your talent and development experience to provide solutions to complex problems? Are you the type of person that can develop the grand plan and then get your hands dirty in its implementation? If you’re ready to spearhead the design, development, implementation and maintenance of our client’s databases, reporting solutions, and data warehouses, you’ve found the perfect role!

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

 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

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

4 + years TSQL and PL/pgSQL development experience

3+ 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

#LI-TP1
ehire.com/jobs

Our Company is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations. It is our intent to maintain a work environment which is free of harassment, discrimination, or retaliation because of sex, gender, race, religion, color, national origin, physical or mental disability, genetic information, marital status, age, sexual orientation, gender identity, military service, veteran status, or any other status protected by federal, state, or local laws. The Company is dedicated to the fulfillment of this policy in regard to all aspects of employment, including but not limited to recruiting, hiring, placement, transfer, training, promotion, rates of pay, and other compensation, termination, and all other terms, conditions, and privileges of employment.