sql-server developer

job summary: The Senior SQL Server Developer will be responsible for multiple planned SQL Server projects for our departmental data warehouse and reporting solution based on Microsoft technologies (SSIS, SSAS, SSRS and MS SQL Server 2012). The main responsibilities are technical upgrade projects which involve technical assessment, evaluation, technical project planning, T-SQL developments, technical testing, UAT and rollout in all relevant satellite systems of Microsoft Business Intelligence Stack and to newer version of SQL Server 2019/2022. Additionally, they will plan, re-design, implement, test and rollout new developments.   location: Bridgewater, New Jersey job type: Contract salary: $90 - 100 per hour work hours: 8am to 4pm education: Bachelors   responsibilities: Full responsibility with supervision of new development tasks to enable future functionality of current data warehouse and reports in newer technology for above projects.Organizing technical and end user testing for final deployment to different technical environments.Creating and maintaining technical and end user documentation.   qualifications: Experience level: ManagerMinimum 10 years of experienceEducation: Bachelors (required)  skills: SQL Server (10 years of experience is required)SQL Server (10 years of experience is required)SQL Server (10 years of experience is required)SQL Server (10 years of experience is required) Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). Applications accepted on ongoing basis until filled.

job summary: Required Skills - 5+ years of MS SQL Server administration and development Installing, maintaining, and performance turning of MS SQL databases Exposure to Snowflake Cloud Database Admin Database Security Data Modeling Cloud Technologies Backup Management Job Duties -Collaborate with a compact team of developers to conceptualize, develop, and deploy both prototype and production-ready database solutions that meet required functionality. Design and implement efficient database structures to support organizational requirements, ensuring they align with business goals and operational needs. Monitor and maintain database performance, stability, security, and scalability to ensure optimal system functionality and reliability. Develop, implement, and support comprehensive backup and recovery strategies, safeguarding critical data assets against potential threats and losses. Conduct regular database audits to identify and address potential issues, maintaining stringent data integrity and compliance standards. Communicate effectively with cross-functional teams, including developers, analysts, and business stakeholders, to ensure clear and proactive information exchange. Translate complex business requirements into robust technical solutions, supporting data-driven decision-making and strategic initiatives within the organization. Perform database capacity planning and forecasting to prepare for future growth and ensure efficient resource allocation. Implement and maintain rigorous database security measures, including user access controls and data encryption, to protect sensitive information. Lead and contribute to all stages of database project implementations, from inception through deployment, ensuring milestones and objectives are met. Troubleshoot and resolve database-related issues promptly to minimize downtime and enhance system performance. Stay current with industry best practices and emerging technologies, continuously refining database management techniques and adopting innovations that enhance business operations. Provide technical expertise and guidance to team members, fostering a culture of collaboration, innovation, and knowledge sharing. Design and implement solution architectures tailored to the technical needs of internal tools, leveraging advanced technologies like AWS-RDS SQL Server and Snowflake for cloud-based database management. Serve as the Technical Subject Matter Expert (SME) for database components, adapting strategies to meet evolving business requirements and integrating data from diverse sources using ETL scripting and BI reporting tools. Utilize expert SQL skills to design and optimize data models, schemas, and table structures for efficient querying and data analysis within a variety of database environments. 1. Collaborate with a compact team to support MS SQL databases as utilized by network monitoring tools platforms such as SolarWinds Orion and LiveNX. 2. Design and implement efficient database structures to support organizational requirements. 3. Monitor and maintain database performance, ensuring optimal stability, security, and scalability. 4. Develop, implement and support backup and recovery strategies, safeguarding critical data assets. 5. Conduct regular database audits to identify potential issues and maintain data integrity. 6. strong communication and collaboration skills: The database administrator should be able to effectively communicate with cross-functional teams, including developers, analysts, and business stakeholders. The candidate must be capable of understanding and translating business requirements into technical solutions and working collaboratively to support data- driven decision-making within the organization. 7. Perform database capacity planning and forecasting to support future growth and resource allocation. 8. Implement and maintain database security measures, including user access controls and data encryption. 9. Spearhead and contribute to all stages of the database implementation within projects, spanning from inception to deployment. 10. Troubleshoot and resolve database-related issues to minimize downtime and maintain system reliability. 11. Stay up-to-date with industry best practices and emerging technologies, continuously improving database management techniques. 12. Provide technical expertise and guidance to team members, fostering a culture of collaboration and knowledge sharing. 13. Design and implement solution architectures that cater to database-related technical needs of internal tools, leveraging AWS-RDS SQL Server as the primary cloud-based database. 14. Serve as the Technical Subject Matter Expert for database components of the solution, adapting to evolving business requirements concerning data acquisition from diverse sources, data normalization, aggregation through ETL scripting, and compatibility with BI reporting tools. 15. Utilize strong SQL skills and expertise in designing and optimizing data models, schemas, and table structures to support efficient querying and data analysis within the Snowflake and other database environment. 16. Design and implement MS SQL Always-ON Clustering. 17. Design SQL queries in SSMS as well as PowerShell scripts for maintenance of tooling platform data. Job Requirements -Minimum 5 years of hands-on experience with MS SQL Server in an enterprise environment. Proven expertise in SQL database performance tuning, job automation, backups, and clustering. Extensive knowledge in managing cloud-based database systems, preferably with experience in AWS-RDS SQL Server or Snowflake. strong understanding of Snowflake strong understanding of database security protocols and disaster recovery techniques. Bachelor's degree in Computer Science, Information Technology, or related field. US citizenship required. Excellent communication skills, with a capability to lead projects and mentor junior team members. - Ability to work autonomously, proactively, and remotely within a cross-functional organization. - Exceptional written and verbal communication skills in English. - Comprehensive experience with database server technologies, performance tuning, scripting with MS SQl Server. - Experience and familiarity with Snowflake's unique features is desirable. - Functional programming experience in PowerShell is considered an asset. - Familiarity with Agile working environments. - Management of personal knowledge base tools is advantageous. - Prior experience in a consultative role, handling intricate, customer-facing projects. - Adaptable to learning new technologies as needed. - Capable of educating and training small groups. - US Citizen - Minimum of 5+ years of experience designing and developing enterprise class application databases & applications. - Bachelor's Degree - ideally in computer science, engineering, or other STEM discipline. Desired Skills & Experience -Familiarity with NoSQL databases like MongoDB. Experience with Snowflake's data warehousing and BI tools integration. Proficient in Agile project management methodologies. Functional programming skills, particularly in PowerShell. Previous consulting experience or role in customer-facing projects.   location: Dallas, Texas job type: Contract salary: $60 - 66 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: Required Skills -Snowflake MS SQL Server SQL Performance Tuning Cloud Database Admin Database Security Data Modeling Cloud Technologies Backup Management Job Duties -Collaborate with a compact team of developers to conceptualize, develop, and deploy both prototype and production-ready database solutions that meet required functionality. Design and implement efficient database structures to support organizational requirements, ensuring they align with business goals and operational needs. Monitor and maintain database performance, stability, security, and scalability to ensure optimal system functionality and reliability. Develop, implement, and support comprehensive backup and recovery strategies, safeguarding critical data assets against potential threats and losses. Conduct regular database audits to identify and address potential issues, maintaining stringent data integrity and compliance standards. Communicate effectively with cross-functional teams, including developers, analysts, and business stakeholders, to ensure clear and proactive information exchange. Translate complex business requirements into robust technical solutions, supporting data-driven decision-making and strategic initiatives within the organization. Perform database capacity planning and forecasting to prepare for future growth and ensure efficient resource allocation. Implement and maintain rigorous database security measures, including user access controls and data encryption, to protect sensitive information. Lead and contribute to all stages of database project implementations, from inception through deployment, ensuring milestones and objectives are met. Troubleshoot and resolve database-related issues promptly to minimize downtime and enhance system performance. Stay current with industry best practices and emerging technologies, continuously refining database management techniques and adopting innovations that enhance business operations. Provide technical expertise and guidance to team members, fostering a culture of collaboration, innovation, and knowledge sharing. Design and implement solution architectures tailored to the technical needs of internal tools, leveraging advanced technologies like AWS-RDS SQL Server and Snowflake for cloud-based database management. Serve as the Technical Subject Matter Expert (SME) for database components, adapting strategies to meet evolving business requirements and integrating data from diverse sources using ETL scripting and BI reporting tools. Utilize expert SQL skills to design and optimize data models, schemas, and table structures for efficient querying and data analysis within a variety of database environments. 1. Collaborate with a compact team to support MS SQL databases as utilized by network monitoring tools platforms such as SolarWinds Orion and LiveNX. 2. Design and implement efficient database structures to support organizational requirements. 3. Monitor and maintain database performance, ensuring optimal stability, security, and scalability. 4. Develop, implement and support backup and recovery strategies, safeguarding critical data assets. 5. Conduct regular database audits to identify potential issues and maintain data integrity. 6. strong communication and collaboration skills: The database administrator should be able to effectively communicate with cross-functional teams, including developers, analysts, and business stakeholders. The candidate must be capable of understanding and translating business requirements into technical solutions and working collaboratively to support data- driven decision-making within the organization. 7. Perform database capacity planning and forecasting to support future growth and resource allocation. 8. Implement and maintain database security measures, including user access controls and data encryption. 9. Spearhead and contribute to all stages of the database implementation within projects, spanning from inception to deployment. 10. Troubleshoot and resolve database-related issues to minimize downtime and maintain system reliability. 11. Stay up-to-date with industry best practices and emerging technologies, continuously improving database management techniques. 12. Provide technical expertise and guidance to team members, fostering a culture of collaboration and knowledge sharing. 13. Design and implement solution architectures that cater to database-related technical needs of internal tools, leveraging AWS-RDS SQL Server as the primary cloud-based database. 14. Serve as the Technical Subject Matter Expert for database components of the solution, adapting to evolving business requirements concerning data acquisition from diverse sources, data normalization, aggregation through ETL scripting, and compatibility with BI reporting tools. 15. Utilize strong SQL skills and expertise in designing and optimizing data models, schemas, and table structures to support efficient querying and data analysis within the Snowflake and other database environment. 16. Design and implement MS SQL Always-ON Clustering. 17. Design SQL queries in SSMS as well as PowerShell scripts for maintenance of tooling platform data. Job Requirements -Minimum 5 years of hands-on experience with MS SQL Server in an enterprise environment. Proven expertise in SQL database performance tuning, job automation, backups, and clustering. Extensive knowledge in managing cloud-based database systems, preferably with experience in AWS-RDS SQL Server or Snowflake. strong understanding of Snowflake strong understanding of database security protocols and disaster recovery techniques. Bachelor's degree in Computer Science, Information Technology, or related field. US citizenship required. Excellent communication skills, with a capability to lead projects and mentor junior team members. - Ability to work autonomously, proactively, and remotely within a cross-functional organization. - Exceptional written and verbal communication skills in English. - Comprehensive experience with database server technologies, performance tuning, scripting with MS SQl Server. - Experience and familiarity with Snowflake's unique features is desirable. - Functional programming experience in PowerShell is considered an asset. - Familiarity with Agile working environments. - Management of personal knowledge base tools is advantageous. - Prior experience in a consultative role, handling intricate, customer-facing projects. - Adaptable to learning new technologies as needed. - Capable of educating and training small groups. - US Citizen - Minimum of 5+ years of experience designing and developing enterprise class application databases & applications. - Bachelor's Degree - ideally in computer science, engineering, or other STEM discipline. Desired Skills & Experience -Familiarity with NoSQL databases like MongoDB. Experience with Snowflake's data warehousing and BI tools integration. Proficient in Agile project management methodologies. Functional programming skills, particularly in PowerShell. Previous consulting experience or role in customer-facing projects.   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors (required)  skills: AWS RDS SQL (3 years of experience is preferred)Snowflake (3 years of experience is preferred)NoSQLMongoDBMySQLRESTful APIsPythonnodeJSSQL (6 years of experience is required)SQL Server (6 years of experience is required) Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). Applications accepted on ongoing basis until filled.

job summary: Highly proficient in T-SQL or comparable relational database development skillsExperience with a modern object-oriented language such as C# or Java Basic knowledge of software version control systems, preferably GitVerbal and written communication skillsTechnical and problem-solving skillsAbility to adapt to changing priorities in an Agile environmentA bachelor's degree with a academic record or equivalent work experience1+ years experience with software development lifecycle to include designing, coding, testing and supporting web and database applications Preferred: Experience in ISO (Insurance Services Office) statistical reportingExperience in WCSTAT (Workers Compensation Statistical Reporting Specifications) reportingKnowledge of Financial/Insurance Reporting SystemsExperience developing .NET web applications using C# and MVCFront-end development experience using HTML, CSS, JavaScript, and jQuery   location: Parsippany, New Jersey job type: Permanent salary: $70,000 - 80,000 per year work hours: 8am to 4pm education: Bachelors   responsibilities: Modify existing software to correct errors or to improve its performance. Design, develop and modify software systems to improve efficiency and accuracy of reporting. Collaborate with systems analysts, programmers and others to design system enhancements and to obtain information on project limitations and capabilities, performance requirements and interfaces. Analyze user needs and software requirements to determine feasibility of design. Must feel comfortable working in a dynamic and flexible environment with changing requirements in a business casual environmentDevelopment of high quality database solutionsDevelop, implement and optimize stored procedures and functions using T-SQLReview and interpret statistical reporting requirementsResearch required dataAnalyze existing SQL queries for performance improvementsDevelop and maintain technical documentation, including data dictionaries, database schemas, flow diagrams, etc.All other duties as assigned   qualifications: Experience level: ExperiencedMinimum 2 years of experienceEducation: Bachelors (required)  skills: SQL (1 year of experience is required).NET (1 year of experience is required) Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). Applications accepted on ongoing basis until filled.