Database Administrator - (BI 0006OA)

  • Jacobs
  • Primary Location: United States-Illinois-Chicago-US IL Chicago - Civil - Chicago
  • Dec 01, 2020
Full time Construction

Job Description

Description
 
Our People & Places Solutions business – reinforces our drive to improve the lives of people everywhere and epitomizes the "why" of what we do – the tremendous positive impact and value our solutions bring to our communities and society as a whole. From facilities delivering life-saving therapies and ensuring clean water to enabling the connection of people through all modes of transportation and providing access to technology – we're integrating a multitude of these solution elements to build the smart environments of tomorrow.
 
At Jacobs, we’re transforming intangible ideas into innovative solutions designing the future-today. As a Database Developer in Chicago, you will too.
 
You will be responsible for the effective design, architecture, and development of enterprise wide databases in support of our client's programs. This position will leverage Oracle and Microsoft SQL Server platforms, related engines and management tools. This position is responsible for identifying innovative approaches and solutions in a rapid application development environment. The candidate should be able to provide high quality support for the production, test, and development environments by implementing, managing, monitoring, and maintaining multiple database servers and databases. 
 
Bring your technical skills and abilities to work independently or under only general direction in a fast-paced and flexible environment with tight deadlines 
and changing priorities. Demonstrated ability to translate technical database issues, requirements, limitations and parameters for management and staff, and understand business work processes and business impact.
 
•Design stable, reliable and effective database objects and procedure based on customer requirements
•Modify database objects according to requests and perform tests
•Ensure data quality and integrity in database development techniques 
•Liaise with system analysts and business owners to improve applications and establish best practices
•Prepare design specifications and functional documentation for assigned database projects
•Gather user requirements and identify new features
•Develop technical and training manuals
•Provide data management support to users
•Knowledge of software development and user interface web applications
•Participate in all stages of the development life cycle, from concept planning to build, testing, delivery debugging and documentation
•Work closely with stakeholders and other developers to dynamically link the backend databases to the web interfaces.
•Provides support to application developers in designing and implementing database solutions 
•Writes, debugs and unit tests for complex stored procedures and triggers
•Reviews, develops, and designs data models using standard diagramming techniques, in conjunction with application development teams; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures
•Responds to occasional requests for Production to resolve any database related customer issues
•Provides technical support for enterprise (on-premise) systems, middleware and administration tools
 
 
 
 
 
Qualifications
 
What You'll Need:
  • B.S. in the field of Computer Science or relevant field of study
  • At least 2 years of related experience 
  • Experience with SQL Server 2014/2016, SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) 
  • Experience with Oracle 11g or 12c, Oracle SQL Developer 
  • Ability to effectively troubleshoot system problems by identifying and implementing software or process changes that allow business applications to operate with minimal risk 
  • Knowledge and experience writing complex queries for ad-hoc requests and data analysis, developing stored procedure, triggers, and functions across varied platforms with PL-SQL and T-SQL 
  • Oral communication skills to effectively explain technical concepts required.
  • Be able to perform and develop ETL processes in the context of multiple integrations systems 
  • Exceptional problem-solving skills combined with analytical skills to analyze data, perform research, and diagnose and solve problems 
  • Present understanding of troubleshooting, root-cause analysis, application design, solution development, human factors/usability design, and implementation of medium sized projects 
  • Experience with business process implementation in the design and implementation of systems and using database management systems and their integration 
  • An ability to understand front-end users’ requirements and problem-solving attitude 
  • Must be highly motivated and enjoy working in a team environment.
 
Ideally You'll Also Have:
  • M.S. in the field of Computer Science or relevant field of study 
  • At least 4 years of related experience
  • Experience with Visual Studio solution deployment utilizing Team Explorer / Team Foundation Server (TFS) 
  • Experience working with Enterprise Asset Management (EAM) systems such as Infro or IBM Maximo 
  • Knowledge or experience in business intelligence and reporting platforms such as PowerBI or SAP Business Objects
 
At Jacobs, we help prepare people for new opportunities and challenges. With positions at every level, openings in multiple disciplines, expertise in a range 
of markets and offices around the globe, we create an environment where you can learn, grow, and thrive. From our competitive benefits program to our Health and Safety initiative of Beyond Zero workplace injuries, we believe that you'll find a flourishing career here at Jacobs.
 
#BIA
 
 
 
 
 
 
 
 
 Jacobs is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other characteristics protected by law. Jacobs is a background screening, drug-free workplace. 

Primary Location

: United States-Illinois-Chicago-US IL Chicago - Civil - Chicago

Travel

: No

Job Posting

: Nov 24, 2020, 11:05:57 PM

Job

: Information Technology

Organization

: PPS

Job Type

: Experienced
Job Classification: Full-Time Regular

Work Locations

: 
US IL Chicago - Civil - Chicago 
525 W. MONROE  
 Chicago 60661
Capabilities: Water Resources and Ecosystems Management