Loading...

MS SQL Database Administrator

Date: Apr 8, 2021

Location: Bethlehem, PA, US

Company: Dover Corporation

For over 125 years, OPW has led the way in designing and manufacturing world-class retail fueling, fluid handling and car wash system solutions for the safe and efficient handling and distribution of fuels and critical fluids. OPW makes above ground and below ground products for both conventional, vapour recovery and clean energy applications in the retail and commercial markets. Additionally, OPW supplies loading arms, valves and dry-break couplings, tank truck equipment, rail car valves and equipment, and car wash systems. OPW has manufacturing operations in North America, Europe, Latin America and Asia Pacific, with sales offices around the world. OPW is part of the Dover Corporation, which is publicly traded on the New York Stock Exchange under 'DOV'. To learn more about OPW’s 125 years of providing industry-leading solutions, visit our website at www.opwglobal.com.

Dover is a diversified global manufacturer with annual revenue of over $7 billion. We deliver innovative equipment and components, specialty systems, consumable supplies, software and digital solutions, and support services through five operating segments: Engineered Products, Fueling Solutions, Imaging & Identification, Pumps & Process Solutions and Refrigeration & Food Equipment. Dover combines global scale with operational agility to lead the markets we serve. Recognized for our entrepreneurial approach for over 60 years, our team of approximately 24,000 employees takes an ownership mindset, collaborating with customers to redefine what's possible. Headquartered in Downers Grove, Illinois, Dover trades on the New York Stock Exchange under "DOV." Additional information is available at dovercorporation.com.

Innovative Control Systems (ICS) is part of OPW VWS, a leader in the Vehicle Wash Manufacturing industry. ICS brings expertise and technology leadership in POS MGT Systems, Payment Terminals, Car Wash Controllers, Accessories, and other Car Wash Equipment. We have an immediate need for an MS SQL Database Administrator at our Bethlehem offices. Excellent benefits package with health, dental, vision, disability & life insurance. Paid time off, including community service days as well as an on-site Cafeteria and Employee Fitness Center.

 

Essential Duties and Responsibilities:

  • MS-SQL Administration:
    • Installation, configuration and upgrading MS-SQL server, SSRS, SSIS and IIS, Web services and related products.
    • Troubleshooting and problem solving of MS-SQL server and databases
    • Periodic monitoring of the databases.
    • Performance improvements on the databases
    • Improvements and maintenance of databases to include rollout and updates
  • Data driven Web Services for IIS, WCF and MS-SQL
  • Troubleshooting and problem solving of MS-SQL server and databases
  • Work closely with management, engineering and support to provide direction in identifying and resolving database related problems.
  • Requirements collection from internal, external clients and documentation
  • Design, development, optimize, performance tuning of custom applications
  • Unit testing and debugging of applications in various stages of development life cycle
  • Work collaboratively with peers in all the stages of development life cycle
  • Write, review and recommend optimization techniques for SQL queries and stored procedures
  • Write complex MS-SQL scripts for database merge or fixes.
  • Write efficient procedures for search routines and complex business logic.
  • Develop Business Intelligence package using SQL SSIS by collecting requirements from the customer.
  • Develop SQL Reports collecting requirements from customer.
  • Design, development, optimize, performance tuning of ICS database.
  • Investigate, recommend and help implementing industry best practice ETL process for ICS database.
  • Write, review and recommend optimization techniques for SQL queries and stored procedures.
  • Write, review and recommend reports optimization to gain maximum performance.
  • Produce documentation for support to troubleshoot MS-SQL issues.
  • Work as security officer implementing MS-SQL database security as per requirements for customer databases.
  • Train support staff on basic MS-SQL commands and procedures.
  • Help testing, troubleshooting the developed custom software for SQL related issues.
  • Provide project, server and required status update to manager routinely and/or on demand.

 

Requirements:

  • Bachelors’ degree or equivalent combination of education and training.
  • Practical experience in troubleshoot/repair corrupted MS-SQL databases.
  • Practical experience in monitoring and tuning MS-SQL server/databases to provide fast and reliable service to customers
  • Minimum 5 years’ experience in software development using C#, .NET Framework, and MS-SQL.
  • Proficient in C# using MS Visual Studio
  • Proficient in MS-SQL, Entity framework, LINQ (SQL commands, Triggers, Stored Procedures)
  • Hands on experience with MS-SQL commands, stored procedures and triggers.
  • Proven track record of developing Business Intelligence using SSIS package or stored procedures
  • Hands on experience in developing reports on SSRS.
  • Hands on experience with report optimization techniques on SQL server.
  • Hands on experience in optimizing SQL queries and stored procedures.
  • Hands on experience in allocating hardware resources and configurations needed in MS-SQL installation.
  • Hands on experience with MS-SQL commands, stored procedures and triggers.
  • Experience in installation, troubleshooting IIS and MS-SQL reporting services.
  • Experience in managing MS-SQL database security
  • Knowledge of implementing disaster recovery strategy.
  • Understanding of network security
  • Good organizational and verbal communication skills

 

Desired Characteristics:

  • Experience with overall system administration

 

All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, genetic information, or any other factors prohibited by law.

This position may be located in: Americas : United States : Pennsylvania : Bethlehem

Sub Division : VWS - North America

Job Requisition ID : 36133


Nearest Major Market: Allentown

Job Segment: System Administrator, Database, SQL, DBA, Engineer, Technology, Engineering