SQL Database Administrator
Tri-Force Consulting Services Inc
Dice Job Match Score™
🔗 Matching skills to job...
Job Details
Skills
- AWS Database Migration Service
- Amazon DynamoDB
- Amazon RDS
- Amazon S3
- Amazon Web Services
- Data Lake
- Analytics
- Archiving
- Cloud Computing
- DMS
- Dashboard
- Data Engineering
- Data Migration
- Data Modeling
- Data Processing
- Data Quality
- Data Validation
- Database
- Database Administration
- Database Migration
- Extract
- Transform
- Load
- Microsoft SQL Server
- Migration
- Performance Monitoring
- Performance Tuning
- PostgreSQL
- Python
- Remote Desktop Services
- Reporting
- SQL
- Screening
- Scripting
- Snow Flake Schema
- Testing
Summary
- 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.
- 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
- 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
- Experience with AWS Schema Conversion Tool (SCT)and data migration service (DMS)
- Experience working with large datasets and ETL pipelines
- Knowledge of data lake architecture
- Experience with PostgreSQL, SQL Server, Dynamo Db
- Experience supporting application data environments
- 5+ years in Database Administration, Data Engineering, or similar role
- 3+ years of AWS and Snowflake experience.
- Support migration of on-prem databases to AWS
- 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
- Dice Id: 10115907
- Position Id: 8913885
- Posted 10 hours ago
Company Info
Since 2000, Tri-Force Consulting Services has been an MBE/SDB certified IT consulting firm in the Philadelphia region. Tri-Force specializes in IT staffing, software development (web and mobile apps), systems integration, data analytics, system automation, cybersecurity, and cloud technology solutions for government and commercial clients. Tri-Force works with clients to overcome obstacles such as increasing productivity, increasing efficiencies through automation, and lowering costs. Our clients benefit from our three distinguishing core values: integrity, diligence, and technological excellence. Tri-Force is a six-time winner among the fastest-growing companies in Philadelphia and a four-time winner on the Inc. 5000 list of the nation's fastest-growing companies.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs