Chelsoft Solutions Co.
Database Administrator_only local to Austin, Texas
Chelsoft Solutions Co., Austin, Texas, us, 78716
Overview
Database Administrator
– Local to Austin, Texas Position requires on-site work in Austin, TX. Candidates should have proven experience with Microsoft Access and cloud SQL migrations, as well as data integration and reporting tools. Responsibilities
Design, develop, and maintain advanced MS Access databases, including normalized table structures, sophisticated queries, intuitive data entry forms, and comprehensive reports. Translate Access data models into scalable SQL schemas and perform expert-level relational database design, normalization, ER modeling, and schema refactoring. Migrate legacy databases to major cloud SQL services (Azure SQL Database/Managed Instance, PostgreSQL, AWS RDS for SQL Server/MySQL). Utilize ETL tools (SSIS, Azure Data Factory, AWS DMS or equivalent) to support data integration, batch processing, and data ingestion monitoring. Create migration runbooks, data dictionaries, and technical documentation; deliver training or knowledge-transfer sessions. Support and administer RDBMS tools (TOAD, SSMS, SQL Developer) and optimize query plans and performance. Configure data integration workflows in Azure Data Factory and/or SSIS; monitor and optimize data ingestion processes. Prepare and execute data migration from legacy to target databases. Qualifications
Required
– Proven experience with MS Access (table design, complex queries, forms, reports) and VBA for custom functionality. Required
– Experience migrating databases to cloud SQL services (Azure, PostgreSQL, AWS RDS). Required
– ETL experience with SSIS, Azure Data Factory, AWS DMS, or equivalent; ability to create runbooks and technical documentation. Required
– Experience with RDBMS admin/console tools (TOAD, SSMS, SQL Developer); ability to review query plans and optimize performance. Required
– Configuring and monitoring data integration/batch processing in Azure Data Factory and/or SSIS. Required
– Experience migrating data from legacy to new target databases. Preferred
– CI/CD with GitHub, JIRA; data visualization/reporting tools (Power BI, Tableau); Agile methodologies. Preferred
– Healthcare or Public Health experience; experience with state agency environments. Seniority level
Mid-Senior level Employment type
Contract Job function
Information Technology Industries
IT Services and IT Consulting Austin, TX candidates: compensation ranges and postings may be listed externally; verify current details during application.
#J-18808-Ljbffr
Database Administrator
– Local to Austin, Texas Position requires on-site work in Austin, TX. Candidates should have proven experience with Microsoft Access and cloud SQL migrations, as well as data integration and reporting tools. Responsibilities
Design, develop, and maintain advanced MS Access databases, including normalized table structures, sophisticated queries, intuitive data entry forms, and comprehensive reports. Translate Access data models into scalable SQL schemas and perform expert-level relational database design, normalization, ER modeling, and schema refactoring. Migrate legacy databases to major cloud SQL services (Azure SQL Database/Managed Instance, PostgreSQL, AWS RDS for SQL Server/MySQL). Utilize ETL tools (SSIS, Azure Data Factory, AWS DMS or equivalent) to support data integration, batch processing, and data ingestion monitoring. Create migration runbooks, data dictionaries, and technical documentation; deliver training or knowledge-transfer sessions. Support and administer RDBMS tools (TOAD, SSMS, SQL Developer) and optimize query plans and performance. Configure data integration workflows in Azure Data Factory and/or SSIS; monitor and optimize data ingestion processes. Prepare and execute data migration from legacy to target databases. Qualifications
Required
– Proven experience with MS Access (table design, complex queries, forms, reports) and VBA for custom functionality. Required
– Experience migrating databases to cloud SQL services (Azure, PostgreSQL, AWS RDS). Required
– ETL experience with SSIS, Azure Data Factory, AWS DMS, or equivalent; ability to create runbooks and technical documentation. Required
– Experience with RDBMS admin/console tools (TOAD, SSMS, SQL Developer); ability to review query plans and optimize performance. Required
– Configuring and monitoring data integration/batch processing in Azure Data Factory and/or SSIS. Required
– Experience migrating data from legacy to new target databases. Preferred
– CI/CD with GitHub, JIRA; data visualization/reporting tools (Power BI, Tableau); Agile methodologies. Preferred
– Healthcare or Public Health experience; experience with state agency environments. Seniority level
Mid-Senior level Employment type
Contract Job function
Information Technology Industries
IT Services and IT Consulting Austin, TX candidates: compensation ranges and postings may be listed externally; verify current details during application.
#J-18808-Ljbffr