Job Title: Database Specialist - Microsoft SQL Server Location: Remote Job Type: Contract (as-needed) We are seeking an experienced Database Specialist with a deep understanding of Microsoft SQL Server to troubleshoot database configurations. The ideal candidate will have extensive experience in licensing, installation, and configuration of various SQL Server editions, including SQL Express. This role requires an immediate start to address critical installation and configuration issues, ensuring optimal database performance and reliability. Responsibilities: * Evaluate and troubleshoot SQL Server installations and configurations, with a focus on SQL Express. * Provide expert consultation on SQL Server licensing options and best practices. * Optimize SQL Server settings and configurations for enhanced performance and reliability. * Collaborate with IT and development teams to streamline database integration and deployment. * Document technical procedures and configurations related to SQL Server installations. * Offer recommendations for database strategies, including upgrades and migrations. Requirements: * Proven experience as a Database Specialist or similar role with a focus on Microsoft SQL Server. * In-depth knowledge of SQL Server licensing, installation, and configuration across various editions, particularly SQL Express. * Demonstrable ability to troubleshoot and optimize SQL Server environments. * Excellent problem-solving skills and attention to detail. * Strong communication and documentation skills. * Available to start immediately and tackle urgent SQL Server configuration and performance issues. Preferred Qualifications: * Certifications in Microsoft SQL Server are highly desirable. * Experience with other database technologies and migrations is a plus.

We are looking for a SAP HANA Native Developer full-time, would you be interested in this role?

Technically minded IT professional with 20+ years of experience across multiple sectors, focusing on designing, implementing, and managing robust database systems. Specialized in installing and maintaining Oracle 19c/12c/11g/10g/9i/8i databases on a variety of Windows server operating systems. Adept at developing and testing storage strategies, disaster recovery plans, maintaining network system, and data availability. Proven expertise in optimizing database performance, ensuring data integrity, and implementing effective backup and recovery strategies. Well-versed in spearheading system upgrades and implementing robust security policies, reliability and high availability. A strategic thinker with a deep understanding of Oracle technologies, consistently delivering high-quality solutions to meet organizational objectives.

Job Description: We are seeking a seasoned Senior SQL Server Reporting Services Administrator to lead the management, support, and expansion of our reporting services infrastructure. With a significant environment comprising over 400 reports, multiple databases, 500+ views, and 300+ stored procedures, we require an individual with a profound understanding of SQL Server architecture and optimization techniques, particularly in the context of reporting services. Additionally, experience with the Power BI platform will be indispensable for this role. Responsibilities: 1. Lead the administration and maintenance of our SQL Server Reporting Services (SSRS) environment, ensuring optimal performance and reliability. 2. Enhance and manage our extensive library of over 400 reports, collaborating with stakeholders to meet dynamic business requirements. 3. Develop innovative reports and reporting solutions utilizing SQL queries, stored procedures, and other relevant technologies. 4. Implement and fine-tune SQL Server databases and structures to support seamless reporting operations. 5. Execute performance tuning and query optimization to enhance the speed and efficiency of reporting processes. 6. Provide expert technical support and troubleshooting assistance for SSRS-related issues, ensuring prompt resolution. 7. Establish and maintain SQL Server replication for efficient data distribution and high availability across multiple servers. 8. Formulate and execute robust backup and disaster recovery strategies for SQL Server databases, ensuring data integrity and availability. 9. Stay abreast of the latest advancements in SQL Server technologies and reporting tools, integrating best practices into our environment. 10. Collaborate closely with cross-functional teams, including data analysts and developers, to seamlessly integrate reporting solutions into our business processes. 11. Mentor and empower junior team members, imparting SQL Server administration and reporting services best practices. Requirements: 1. Bachelor's degree in Computer Science, Information Systems, or a related field. 2. Minimum 5 years of hands-on experience as a SQL Server Database Administrator, with a proven track record of optimizing query performance. 3. Extensive experience supporting reporting services in a large-scale environment for at least 2 years, demonstrating the ability to manage a sizable reporting base. 4. Profound knowledge of SQL Server architecture, administration, and optimization techniques. 5. Expertise in crafting complex SQL queries and optimizing database performance. 6. Hands-on proficiency with SQL Server Reporting Services (SSRS) and Power BI. 7. Exceptional problem-solving skills and meticulous attention to detail. 8. Outstanding communication and collaboration abilities, with a keen focus on customer satisfaction. 9. Ability to effectively manage multiple priorities and adapt to evolving requirements in a fast-paced environment. 10. Familiarity with data visualization principles and best practices is advantageous. If you are a results-driven professional with a passion for optimizing SQL Server reporting environments and driving data-driven decision-making, we invite you to apply for this pivotal role. Join us in leveraging technology to unlock the full potential of our data assets and propel our organization toward greater success.

We have a dedicated Windows Server 2022 VM running SQL Server 2019 Standard. The server has 250G of RAM. According to Performance Monitor, only 160G is in use. However, we see the following repeatedly in the SQL Server event log: "A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 288011 seconds. Working set (KB): 560004, committed (KB): 2753428, memory utilization: 20%." To summarize: Duration: 80 hrs. Working Set: 560M Committed Memory: 2.7G. Those numbers don’t make sense to us. Why would the working set and committed memory be so low for so long, and yet there’s a ton of fee memory? Note that there are many other databases on the server that never throw errors, but they are in the default instance. The errors above are for a database that was deployed in a named instance. We need someone to figure out why we're getting these messages and what we can do about it.

This job is for a full time SQL developer/Administration position. Developer will work closely with Business analysts, web developers and other stake holders to create cutting edge health care solutions using the latest health care data formats and API technologies. Required Skills and Experience • 3-5 years of experience as T-SQL Database Developer using MSSQL 2016 or above • Experience writing and troubleshooting advanced T-SQL queries. • Ability to understand complex business requirements, and how to fulfill those requirements utilizing various dataset within a health care database • Ability to access very large datasets in a way that is both thorough and performant • Ability to break down data access, manipulation, and presentation logic for both reporting and ETL processes • Experience troubleshooting errors and analyzing performance bottlenecks using native MSSQL tools • Experience using SSIS for data imports from multiple data sources including text files, Excel, JSON, XML, and using SSIS package deployment methodology. • Experience using SSIS script tasks, and script component tasks • An ability to understand front-end user requirements and a problem-solving attitude