Location: Addison, TX
Company: Resolve Tech Solutions
MS SQL Server databases. Monitor the operation of the assigned database applications, and respond to problems by diagnosing and correcting errors in logic and coding. Review user requirements and needs for existing and new database applications, such as vendor price search engine, and vendor historical pricing database.
Perform analysis, design, implementation, installation, and technical and process documentation related to new applications developed and/or acquired, including designing data models for new business requirements. Assist with real-time troubleshooting, anomaly resolution, and system recovery as necessary. Optimize database systems and e-commerce website: increase response
time by modifying SQL queries based on customer feedback, work on relational architecture of database to data warehouse structure; etc.6 months of experience in Provide technical expertise and responsibility for developing, monitoring, and maintaining multiple databases and applications; monitor database/ application growth and server resources to ensure optimum performance and availability of data.
Database development includes installing, configuring, tuning, patching, and managing My SQL Server databases; Monitor the operation of the assigned database applications, and respond to problems by diagnosing and correcting errors in logic and coding. Review user requirements and needs for
existing and new database applications, such as vendor price search engine, and vendor historical pricing database.
Perform analysis, design, implementation, installation, and technical and process documentation related to new applications developed and/or acquired, including designing data models for new business requirements. Assist with real-time troubleshooting, anomaly resolution, and system recovery as necessary. Optimize database systems and e-commerce website: increase response time by modifying SQL queries based on customer feedback, work on relational architecture of database to data warehouse structure, and use historical data to create and improve the model for forecasting product backorders.
Manage and create resources and tools including central databases, dashboards, presentation decks and reporting tools. Using various internal systems, collect historic firm-wide data, and analyze and manipulate data to present business intelligence reports and draw meaningful conclusions. Monitor and report on e-commerce website performance using Google Analytics and provide data insight to management. Design and develop best-practices for queries and stored procedures. Reporting work includes the creation, maintenance, and optimization of stored procedures, views, and scheduled jobs, as well as writing and modifying SQL SSRS.
Ensure the rigorous application of information security/information assurance policies, principles, and practices; monitor system and maintenance routines, perform backups and update data schemes, and provide input for planning and developing new policies and standards for use of the database. Guide to best practices for database usage, high availability and business continuity. Analyze existing database applications to migrate into or improve the functioning on the platform. Maintain databases, including all production, backup and development files.
Bachelor? s degree in Computer Science or Information Technology Management Please copy and paste your resume in the email body do not send attachments, we cannot open them and email them at candidates at with reference #435116 in the subject line. Thank you.
including print, electronic and mobile platforms.
Lanvera has a strong presence in the Financial Services industry and is expanding into other vertical markets. THE POSITION: Seeking an experienced SQL DBA with expertise in T-SQL development, troubleshooting and optimization.
The Senior SQL DBA will manage Microsoft SQL Server databases, services, and tools running in an on-prem environment as well as participate in building a database presence in the cloud (hybrid solution). In this role you will maintain database uptime, stability, performance, and security to ensure the highest customer service levels. You will also leverage your passion for data engineering to design, develop,
and implement ETL solutions, involving close collaboration with development and business intelligence stakeholders. RESPONSIBILITIES: Review, analyze and debug T-SQL code Optimize data workloads across cloud and/or on-prem environments to stay ahead of business demand while minimizing costs Develop complex SQL scripts, functions and stored procedures Participate in architecture planning to prepare the business for significant future growth Manage production database servers to ensure robust security, high availability and performance Actively monitor databases and take preventive or corrective action to swiftly resolve issues that arise Support and enhance db's running on Azure Managed SQL Instance(s)
Implement policies and procedures for database backups, DR, security protocols, and data integrity Maintain lower-level development, QA, and staging database environments to support efficient development throughout the SDLC Create comprehensive diagrams and documentation that accurately captures database state Support development groups with database setup, configuration, optimization, and other modifications Bring a passion to stay current on industry database trends and related technology Adept at collaborating with leadership and technical stakeholders throughout the organization Adhere closely to change control and related ITIL practices Work in a highly collaborative software development environment that is primarily onsite ADDITIONAL RESPONSIBILITIES: Provide best practice guidance on the design of data models and database structures across relational database platforms Assist in development, support, and implementation of data engineering projects such as data pipelines and warehouses Assist in development of methods to manipulate large, complex data sets to be effectively consumed and interpreted within reporting toolsets REQUIRED SKILLS: Bachelor's Degree in Computer Science or commensurate experience 5+ years' experience supporting SQL Server databases in production environments that utilize Always On Availability Groups and Windows Clustering 5+ years' experience in writing complex T-SQL to develop a variety of database objects (schemas, tables, stored procedures, triggers) 4+ years' experience in database tuning and query optimization through analysis of Execution Plans and Dynamic Management Views, and usage of Extended Events 3+ years' experience with developing packages within SQL Server Integration Services (SSIS) 2+ years' experience with developing reports within Power BI and/or SQL Server Reporting Services (SSRS) DESIRED SKILLS: Experience with Windows and Linux Server administration Familiarity with automating processes using Powershell or similar scripting language COMPANY BENEFITS: Lanvera offers excellent benefits including three weeks of PTO, Health Insurance, 401K with dollar matching, profit sharing, and long-term disability.
to meaningful real-world projects which will be implemented during your internship. In addition to tackling practical business and technical problems, you will have access to a variety of mentors and senior leaders within the team. KEY RESPONSIBILITIES: Support the IT/Development team in maintaining systems, software, and limited hardware.
Create Power BI dashboards to optimize business decisions through the use of enhanced business analytics. Participate in Sagent's company-wide " digitalization" effort. Participate in DLL modification and documentation projects. Support IT/Development team in areas such as cybersecurity, programming, analytics, data center management, and
resource accountability Other duties as assigned by appropriate Sagent leadership. SKILLS/KNOWLEDGE/EXPERIENCE REQUIRED: Must be pursuing a degree in Computer Science (with AI), Computer Engineering, and Business Computer Information Systems Minimum GPA of a 3.0 Familiar with AI, Python, C#, C++, SQL,Net, etc.
Knowledge of Microsoft Stack (Power BI) Strong verbal and written communication Excellent analytical and problem-solving skills Ability to work well in teams. Strong work ethic and attention to detail Energetic, self-motivated interpersonal skills and communication skills with the ability to interact with various management levels. PHYSICAL DEMANDS WORK ENVIRONMENT: The physical
demands and work environment described here are representative of those that must be met by an employee to successfully perform the essential functions of this position.
Reasonable accommodation may be made to enable individuals with disabilities to perform the functions. Environment: Fully on-site role in a standard office setting with exposure to computer screens. Physical: Primary functions require sufficient physical ability to work in an office setting; stand or sit for prolonged periods of time; operate office equipment including extensive use of a computer keyboard. Vision: See in the normal visual range with or without correction; vision sufficient to read computer screens and printed documents.
Hearing: Hear in the normal audio range with or without correction.
with excellent problem- solving and analytical skills. @New York, NY Florham Park. . Net Developer C2C, H1 Transfer with valid US work authorization, Strong with the C#,Net Framework,Net Core SQL Server development experience, Strong experience with Microsoft Applicaiton Developement Tools (Visual Studio 2013-2019, SQL development tools) @Peapack, NJ (Onsite role).
Online Training Java / Python from foundation to Advance Azure architect C2C, H1 Transfer with valid US work authorization. Hands-on experience with Hadoop, Kafka, Rabbit MQ, My SQL, or similar technologies. @ST Louis (100% Remote). ASP. NET Engineers C2C, H1 Transfer, We are looking for 6 yrs of very senior ASP. Net consultants with real time. Reach me at / +1 972945xyz X (USA)
monitors critical network functions, and performs repairs and upgrades on computer hardware and software. As a Level II technical support representative, you will be responsible for monitoring the following products 24 hours a day: Wireless/VOIP T1's POTS DSL You'll also be responsible for reporting any network issues to management within the time line allotted by company procedures 24 hours a day and escalating as necessary, along with the following: - Handling calls from residential and commercial customers to resolve any technical issues on all products provided.
- Making follow up courtesy calls once the reported trouble is resolved to ensure customer satisfaction. - Reporting troubles
with our partnered service providers after hours and on weekends. - Having a thorough understanding of all products offered to ensure that reps are comfortable and confident with any issue that arises.
- Diagnosing / repairing customer's personal computers that have been brought in for billable labor. - Learning and understanding the functions of other departments to be able to execute them after hours. - Monitoring ACD queues and managing talk times to ensure hold times are minimal. - Communicating with customers and resolving any issues reported via the support email account. Provisioning / de-provisioning the following services: Wireless/VOIP DSL Email Dial-up Hot Spot Users - Handling
account suspends and restores. - Maintaining monitoring software and making sure all data contained therein is correct and up to date.
- Reports monthly on wireless network capacity. Provide exceptional technical support for all commercial calls to ensure our level of customer service remains unmatched by our competitors. - Submitting tickets to be worked by our field services and managed services departments. - All other duties as assigned. Qualifications Must have a minimum of a high school diploma, Associates Degree in CIS preferred Comp Tia A+ certification is preferred Experience with computer repair, software/hardware preferred Experience with Microsoft OS Experience in troubleshooting Outlook and other email applications, including mobile email applications 2 years related IT/Help Desk experience preferred Must demonstrate computer knowledge with the ability to learn new software General understanding of Webhosting preferred Experience with ESI or Shoretel Vo IP phones a plus Experience in Metaswitch or CSX a plus Telecommunications experience is a plus Skills Ability to thrive in a fast paced environment and respond accordingly to high priority situations is essential Must work well with others, as part of a team as well as individually Must possess and demonstrate excellent communications skills Must demonstrate excellent organizational skills Must be enthusiastic and self-motivated Proven customer support professional with at least three years of call center experience preferred Ability to speak Spanish preferred Benefits We offer a compensation plan including excellent benefits with 401K, health insurance, and a competitive starting salary.
