Sign upLog in

SQL Database Administrator

Apollo Technology Solutions LLC

Richmond, VA

Apply
JOB DETAILS
SKILLS
AWS Lambda, Amazon Relational Database Service (RDS), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Cloud Computing, Data Lake, Data Management, Data Migration, Data Modeling, Data Processing, Data Quality, Data Sets, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Programming, GitHub, Metrics, Microsoft SQL Server, Operational Support, Performance Analysis, Performance Tuning/Optimization, PostgreSQL, Production Support, Python Programming/Scripting Language, Reporting Dashboards, SQL Databases, Scripting (Scripting Languages), Server Support, Snowflake Schema, Software Administration, Source Code/Configuration Management (SCM), Validation Testing
LOCATION
Richmond, VA
POSTED
30+ days ago
Job Title: SQL Database Administrator
Location: Richmond, VA
Duration: 3+ Months

**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       
  1. Experience migration/archiving databases from on-premises environments to AWS       
  2. Experience with AWS Database Migration Service(DMS) or similar tools preferred       
AWS Database Technologies 
  1. Amazon RDS       
  2. DynamoDB       
Python for Data Processing       
  1. Experience developing Python scripts for data creation, transformation, and data loads      
Data Pipeline Development   
  1. Experience building AWS-based data pipelines       
  2. Familiarity with services such as:S3, Glue, Lambda       
Data Modeling       
  1. Experience designing logical and physical data models       
  2. Ability to support application teams with schema design
Preferred Skills:
  1. Experience with AWS Schema Conversion Tool (SCT)and data migration service (DMS)       
  2. Experience working with large datasets and ETL pipelines       
  3. Knowledge of data lake architecture       
  4. Experience with PostgreSQL, SQL Server, Dynamo Db       
  5. Experience supporting application data environments Experience Required       
  6. 5+ years in Database Administration, Data Engineering, or similar role       
  7. 3+ years of AWS and Snowflake experience Responsibilities       
  8. Support migration of on-prem databases to AWS       
  9. Develop Python scripts for data generation and bulk loads       
  10. Build and maintain AWS-based data pipelines       
  11. Design and support data models       
  12. Support application teams using RDS and DynamoDB       
  13. Assist with data validation, migration testing, and performance tuning

Skills:
  • On-Prem SQL server to AWS and snowflake source Data Migration experience
  • Experience migration/archiving databases from on-premises environments to AWS
  • Experience with Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) or similar tools preferred
  • Experience developing Python scripts for data creation, transformation, and data loads
  • Experience building AWS-based data pipelines using s3, Glue, Lambda
  • Experience supporting application data environments, Experience with PostgreSQL, SQL Server, Dynamo Db
  • Hands on experience in using AWS db services including S3, RDS, postgres, DynamoDB, and Snowflake.
  • Core experience of configure data management practices on AWS using native services such as AWS Glue, AWS Data Zone, AWS Glue Data Catalog,API Gateway
  • Familiarity with version control using tools like Github, and AWS Code Pipeline
  • 5+ years in Database Administration, Data Engineering, or similar role (AWS, Snowflake) and Sql server

About the Company

A

Apollo Technology Solutions LLC