SQL DBA

GSK Solutions

Not Interested
Bookmark
Report This Job

profile Job Location:

Richmond, VA - USA

profile Monthly Salary: Not Disclosed
Posted on: 4 hours ago
Vacancies: 1 Vacancy

Job Summary

Job Title:

SQL DBA (Hybrid Onsite)

Location:

Richmond VA

Duration:

3 months

Pay Rate:

$75/hr on C2C / 1099 all inclusive (OR) $70/hr on W2

Interview Process:

Both Web Cam and In Person Interview

Note:

ON SITE: 2-3 days a week ON SITE and then as requested by Mgr

Job Description

We are seeking a Database Administrator / Data Engineer with strong experience in migrating on-premises databases to AWS. The candidate will support data platform modernization by assisting with database migration Python-based data processing and building AWS data pipelines supporting applications using Amazon RDS and DynamoDB.

Responsible for supporting SQL Server/Cloud BAU operations. supports production stability and performance monitoring by building operational metrics and dashboards for database performance. Develop data quality and performance dashboards to monitor system efficiency and ensure reliable data for reporting and analytics.

The role requires hands-on experience in database migration data modeling and AWS data services.

Must Have Skills (Screening Required)

  • On-Prem SQL server to AWS and snowflake source Data Migration experience

  • Experience migration/archiving databases from on-premises environments to AWS

  • Experience with AWS Database Migration Service(DMS) or similar tools preferred

AWS Database Technologies

Strong experience with:

  • Amazon RDS

  • DynamoDB

Python for Data Processing

  • Experience developing Python scripts for data creation transformation and data loads

Data Pipeline Development

  • Experience building AWS-based data pipelines

Familiarity with services such as:

  • S3 Glue Lambda

Data Modeling

  • Experience designing logical and physical data models

  • Ability to support application teams with schema design

Preferred Skills

  • Experience with AWS Schema Conversion Tool (SCT)and data migration service (DMS)

  • Experience working with large datasets and ETL pipeline

  • Knowledge of data lake architecture

  • Experience with PostgreSQL SQL Server Dynamo Db

  • Experience supporting application data environments

Experience Required

  • 5 years in Database Administration Data Engineering or similar role

  • 3 years of AWS and Snowflake experience

Responsibilities

  • Support migration of on-prem databases to AWI

  • Develop Python scripts for data generation and bulk loads

  • Build and maintain AWS-based data pipelines

  • Design and support data models

  • Support application teams using RDS and DynamoDB

  • Assist with data validation migration testing and performance tuning

Top Skills & Years of Experience

Required/Desired Skills

Skill

Required /Desired

Amount

of Experience

On-Prem SQL server to AWS and snowflake source Data Migration experience

Required

5

Years

Experience migration/archiving databases from on-premises environments to AWS

Required

5

Years

Experience with Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) or similar tools preferred

Required

5

Years

Experience developing Python scripts for data creation transformation and data loads

Required

5

Years

Experience building AWS-based data pipelines using s3 Glue Lambda

Required

5

Years

Experience supporting application data environments Experience with PostgreSQL SQL Server Dynamo Db

Required

5

Years

Hands on experience in using AWS db services including S3 RDS postgres DynamoDB and Snowflake.

Required

5

Years

Core experience of configure data management practices on AWS using native services such as AWS Glue AWS Data Zone AWS Glue Data CatalogAPI Gateway

Required

5

Years

Familiarity with version control using tools like Github and AWS Code Pipeline

Required

5

Years

5 years in Database Administration Data Engineering or similar role (AWS Snowflake) and Sql server

Required

5

Years

Recruiter Details:

Kris- Seven one nine- Two three nine- Five five nine nine

Lokesh - Eight three two - Nine nine zero -Two four two six

Sameer - Seven one nine two three nine Five five five five

About US:

GSK Solutions Inc. is a premier information technology services company dedicated to delivering exceptional consulting solutions and staff augmentation to our valued clients. With an unwavering commitment to quality timeliness and budgetary considerations we consistently strive to exceed client expectations building a strong reputation through our reliable execution. Our expertise spans commercial and custom product development covering information security software development consulting and IT audits. We excel in managing critical time-sensitive projects for Fortune 500 clients nationwide ensuring their success is always at the forefront of our mission.

Job Title: SQL DBA (Hybrid Onsite) Location: Richmond VA Duration: 3 months Pay Rate: $75/hr on C2C / 1099 all inclusive (OR) $70/hr on W2 Interview Process: Both Web Cam and In Person Interview Note: ON SITE: 2-3 days a week ON SITE and then as requested by Mgr ...
View more view more

Key Skills

  • Databases
  • SQL Server Management Studio
  • SQL
  • .NET
  • Microsoft SQL Server
  • ssrs
  • TFS
  • Database Design
  • Performance Tuning
  • SSIS
  • T Sql
  • Data Warehouse