Sky Solutions ยท 17 hours ago
Database Administrator
United States
Full-time
Remote
Mid, Senior Level
5+ years expSky Solutions is a trusted partner in government contracting, empowering federal agencies with cutting-edge IT solutions. They are seeking a skilled Mid-Level Database Administrator to drive the transition from legacy DB2 platforms to a modern, AWS-hosted PostgreSQL environment, focusing on database migration, performance engineering, and automation.
Cloud Data ServicesInformation TechnologySoftwareTechnical Support
Hiring Manager
Vinit Dogra
Responsibilities
Execute the end-to-end migration of legacy DB2 workloads to AWS PostgreSQL (RDS/Aurora) using schema conversion and data validation tools
Conduct deep-dive SQL and database tuning to ensure optimal performance on the PostgreSQL platform
Create and maintain Enterprise Data Models, ERDs, and comprehensive Data Dictionaries using Erwin
Develop and manage automated database deployment pipelines utilizing Jenkins and CI/CD best practices to ensure seamless production releases
Implement and manage complex data transformations and Materialized Views utilizing the dbt (data build tool) framework
Maintain production release "Run Books" and provide on-call support for weekend releases and critical system incidents
Support UAT (User Acceptance Testing) by managing automated data refreshes and environment provisioning
Support data validation efforts by developing data comparison scripts using SQL
Qualification
Required
5+ years of hands-on DBA experience with PostgreSQL and legacy experience with IBM DB2
Proficiency in managing AWS database services (Amazon RDS, Aurora)
Strong experience with Jenkins for pipeline automation and dbt for data transformation
Expert-level proficiency with Erwin Data Modeler for physical and logical schema design
Advanced knowledge of SQL performance tuning, indexing strategies, and query optimization
Experience with version control (Git) and automated deployment of database changes
Proficient in engineering high-performance, optimized SQL queries to ensure maximum data retrieval efficiency and system scalability
Preferred
Experience with AWS SCT (Schema Conversion Tool) and DMS (Database Migration Service)
Scripting proficiency in Python or Shell to automate repetitive tasks
Ability to translate complex legacy DB2 logic into modernized PostgreSQL structures
Strong communication skills for collaborating with cross-functional development and DevOps teams
PMP, SAFe, CSM, or similar certifications
Experience with Snowflake, Airflow, dbt, Kafka/OpenFlow
Experience with data governance, master data, or UDM concepts
Knowledge of CI/CD pipelines and cloud security frameworks
Company
Sky Solutions
Sky Solutions provides digital process automation, no-code development, agile application development, and cloud services.
51-200 employees
H1B Sponsorship
Sky Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (12)
2024 (12)
2023 (11)
2022 (10)
2021 (18)
2020 (11)
Funding
Current Stage
Growth StageRecent News
Washington Technology
2025-12-13
2025-09-25
Company data provided by crunchbase