| |  | | Senior SQL Database Administrator | | Contractual | New York | | Posted on 09/02/2025 | | | | | | Job ID | DEW - 2504 | | Job Title | Senior SQL Database Administrator | | Location | Rochester, NY, New York USA | | | Job Description | | Senior SQL Database Administrator Location: Remote, must work in EST
Duration: 12+ Months
Required skills, experience, etc.: 6+ years of MS SQL DBA experience, experience in healthcare claims environment; Microsoft certifications: MTA, MCSA, MCSE, ITIL or equivalent
Interview process: 2 rounds after screening, 1 CAI side, and 1 client side Job Description We are looking for a Senior SQL Database Administrator to join our team. What You’ll Do - Maintain, improve, and create new complex Microsoft SQL database objects including but not limited to stored procedures and functions
- Troubleshoot and resolve database performance issues
- Design, document, create, unit and system test, deploy, and maintain databases including data warehouses
- Collaborate with the business and other teams to develop and implement business rules for the data warehouse
- Support the development team with database-related issues
- Develop reference and workflow documents for documentation purposes
- Identify and evaluate industry trends in database systems to advise the Data Manager, Director of Business Systems, and/or Chief Information Officer
- Review project requests describing database user needs to estimate time and cost required to accomplish tasks
- Discover and contribute to the development, implementation, and maintenance of Informatics functional architecture and systems design to deliver IT outcomes
- Other duties as assigned
What You'll Need Required: - Minimum 6 years of experience or equivalent higher education. Preferred experience in healthcare claims environment and reporting development, n-tier development and support, and Microsoft SQL database development including relational and star schema data warehouses
- Microsoft data systems certifications such as MTA, MCSA, MCSE, ITIL v3, or equivalent
- 2-year degree required. Applicable certifications may substitute equivalent degree requirements
- Advanced knowledge of SQL and MS SQL Server operating systems
- Experience with Visual Studio for database projects (currently on 2019 Pro or Enterprise)
- Expertise in database development, maintenance, and execution of mission-critical large-scale system upgrades
- Advanced knowledge in ETL (Extract, Transform, Load) processes and data warehousing
- Understanding of Application Lifecycle Management (ALM) and Software Development Life Cycle (SDLC) principles
- Familiarity with Azure Dev Ops as a platform for demand repository, workflow management, and source control/code promotion
- Proficiency in Agile methodologies, including User Stories, Continuous Integration, Continuous Delivery, Continuous Deployment, and Automated testing
- Strong problem-solving skills
- Effective communication skills for interaction with various stakeholders
- Ability to work independently and unsupervised, setting and adjusting priorities as needed
Physical Demands - Ability to safely and successfully perform the essential job functions consistent with ADA and other federal, state, and local standards
- Sedentary work involving sitting or remaining stationary most of the time with occasional movement around the office.
- Ability to conduct repetitive tasks on a computer using a mouse, keyboard, and monitor
| |  | DEW Softech, Inc is a Global IT consulting firm specializing in staff augmentation/staff selection, solution development, solution outsourcing, and software development. Dew Softech, Inc assists our clients in defining, evaluating, selecting, and implementing solutions that advance the goal and objectives of their company, creating a competitive advantage. Dew Softech, Inc also specializes in ERP Consulting.
Dew Softech, Inc consultants are highly qualified professionals whose skills provide value, quality, and exceptional performance. Dew Softech, Inc team has the breadth of services and technical savvy to help our clients conceive, execute and support integrated solutions from browser portal all the way through to their core enterprise and legacy systems. Our employees are driven to deliver results and are the primary way in which customers benefit from Dew Softech, Inc for their staff augmentation and selection needs.
Dew Softech, Inc strives to be the best information systems consulting, software development and permanent placement firm in the business. We pride ourselves on our relationships with all of our customers, and the value we bring to each relationship. | | | | |
