SQL Database Administrator with legacy experience
- Location
- North Miami, FL
- Listed
- Yesterday
How well does your resume fit this job?
Upload your resume to see your score for this Ask IT consulting role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
This project is to refresh the current client’s Workers Compensations System and supporting applications to updated technology and supported client standards. This includes updating the user interface, application and database. The project will be completed using ASP.NET, MVC 5, C# and SQL with an MS-SQL backend database. This resource, under client’s direction, will be responsible for database work related to the solution.
They will help to perform design and review tasks related to the WORCS web portal with focus on database, conversion and data synchronization. They will do initial data conversion between the current WORCS database (Mainframe) and the WORCS refresh database (SQ) using SQL server integration services.
They will execute tasks as defined in the client’s Project Management Methodology (PMM) as well as the Systems Engineering Methodology (SEM). The senior resource MUST take ownership of the database and associated processes. They will work with the architect and business analyst but will maintain responsibility for database integrity, synchronization across environments, performance and adherence to standards.
This resource must also be proactive in improving the database, technical processes and customer relationships.
Specific tasks may include, but are not limited to: Assist with the design of a highly available fault tolerant database infrastructure, assist with technical design activities, including optimizing data access for a web portal application, leveraging features in SQL to reduce latency and providing insights that could improve application performance, create and maintain application projects (ex. type of tables and indexes, partition types, keys, foreign keys/constraints, segment type and size etc.), create processes to replicate production databases (de-normalized to normalized), help with layout application schemas and database files, define and maintain database roles and permissions for application objects, develop and execute statistics collection plan for application objects depending on volume and type of queries (ex. timing of statistics collections, lock statistics, enable/disable HISTOGRAM, etc.), review back up policy with management and senior staff members and help suggest schedule/timings to avoid conflict with application processes, review SQL execution plans on critical application queries, help with application code testing during application releases or database upgrade/migration to avoid SQL performance issues, bulk data uploads, assist with infrastructure optimization and design, including identifying bottlenecks, improving responsiveness and reducing single points of failure, develop SQL server integration services packages to facilitate conversion of data from legacy system into SQL server relational database.
Qualifications & Requirements
Experience with database development with SQL server management studio including creating models, designing database objects (tables, indexes, etc.)
- Required
- 5
- Years
- Experience writing database procedures, functions and triggers
- Required
- 5
- Years
Additional information
Experience developing solution architecture from business requirements, information architecture and technical architecture
- Required
- 5
- Years
Advanced SQL knowledge, software configuration and setup of the SQL translations needed between the legacy and refresh database,
- Required
- 5
- Years
- Advanced SQL knowledge with data modeling and version control
- Required
- 5
- Years
Must understand SQL server database projects and how they are applied across environments and how it is used in the version control process
- Required
- 5
- Years
MS-SQL database administrator experience including creating models, designing DB objects and how it is used in version control process
- Required
- 10
- Years
Experience with SQL server integration services for ETL including creating complex multi step packages and optimizing drivers for high performance
- Required
- 5
- Years
Experience as a database architect developing solution architecture from business requirements, information and technical architecture
- Required
- 5
- Years
Experienced in SQL knowledge, writing and maintaining large complex stored procedures, tuning SQL for optimum performance
- Required
- 5
- Years
- Experience creating and maintaining proper indexes
- Required
- 5
- Years
Experience with version control - using s source control system to maintain a history - TFS (Team Foundation Server) preferred
- Required
- 5
- Years
Experience monitoring application related jobs and data replication activities:
- Required
- 5
- Years
Additional Information
All your information will be kept confidential according to EEO guidelines.
From Ask IT consulting's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this SQL Database Administrator with legacy experience role at Ask IT consulting, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
- Sql Database AdministratorTEKsystems · Wichita, KS
- SQL Database AdministratorTech Tammina · La Crosse, WI
- SQL Database Operations DBAJobsbridge · Miami, FL
- SQL database adminstratorDellfor Technologies · Albany, NY
- SQL Database Administrator (DBA)Integrated Resources · Irving, TX
- SQL Database Developer - Strictly no H1B or OPT EAD's pleaseUSM Business Systems · Washington, DC · $40 – $45/hr
More at Ask IT consulting
All Ask IT consulting jobsCommon questions
Where is the SQL Database Administrator with legacy experience job at Ask IT consulting located?
This SQL Database Administrator with legacy experience position at Ask IT consulting is located in North Miami, FL. Always check Ask IT consulting's application page for specific state eligibility or relocation policies.
How do I apply for the SQL Database Administrator with legacy experience position at Ask IT consulting?
This listing links directly to Ask IT consulting's SmartRecruiters application page. You can apply directly on Ask IT consulting's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.