Apply Now





   

 

Thank you for Applying!



Your application has been successfully submitted. You will also receive an email with more information.


Close
DBA / Teamcenter Development for Reporting and Analytics
Job ID:24339
Erie, Pennsylvania

RESOLVIT

Bringing Solutions That Make Business Better

Join Resolvit as a DBA Teamcenter Development for Reporting and Analytics and be part of a creative, forward-thinking team. Our success at deploying skilled, highly knowledgeable experts has landed us on the Inc. 5000 list of America’s fastest-growing companies four times – and we’re just getting started.

As the DBA/Teamcenter Development for Reporting and Analytics, you will design and code Teamcenter reports against the TC11 database as required by the business to support the existing implementation in engineering and services and upcoming implementations in manufacturing. You will design and code queries to pass the Informatica team for transfer to OBIEE team. You will also build and maintain a close partnership with Data Architect(s) and Production Support DBA(s) to define and document consistent database conventions, processes, and software development standards as it relates to the application database. Additionally, you will:

  • Partner with Support DBA to prioritize database enhancements and continuous improvement initiatives and align on appropriate owner for each initiative
  • Establish consistent goals and standards that will improve the overall performance, maintainability, and stability of the Production Application database(s)
  • Work to ensure both support teams and product build teams are adhering to the same standards and CI/CD processes (with respect to the database-related processes) so that a true DevOps culture grows
  • Maintain close communications with support team when any new database changes are being pushed and ensure the team is aware and capable of supporting the new changes

What You’ll Need to be Successful:

  • Proven work experience on the Teamcenter database and application
  • Proven work experience as a RDMS DBA, ideally for cloud-hosted (AWS) custom software (Java) application environments
  • Expert knowledge of ANSI SQL especially custom software development with SQL, including integration with CI/CD development processes
  • Experience with capacity planning
  • Experience supporting new module or feature development for a critical production application
  • Experience with database administration for software application databases 
  • Solid SQL tuning/optimization skills and practiced techniques
  • Experience working with or as a database architect
  • Understanding and respect for database modelling and how it affects software development and the database itself
  • Experience and focus on ensuring all database changes are scripted and maintained consistently across multiple development environments.
  • AWS (EC2, RDS) familiarity
  • Ability to clearly/accurately communicate with our functional product owners when discussing new user story requirements
  • Ability to convey technical ideas and perspectives to technical peers and applicable details to non-technical individuals

Great Additional Skills:

  • Experience with Data Extraction, Transformation, and Loading
  • Experience and/or understanding of the Oracle EBS application schema 

Benefits:

At Resolvit, you’ll be given the support you need to grow in your consulting career. In addition to opportunities for advancement, we offer:

  • Medical, dental, and vision insurance
  • Life insurance coverage
  • Long-term and short-term disability coverage
  • 401(k) retirement plan with matching
  • Professional support from our Client & Employee Optimization Specialist

We currently have more than 100 open career opportunities across the country, so be sure to mention the appropriate Job Code with any correspondence!

About Resolvit:

Resolvit is an international technology consulting firm with industry-leading customers in the financial services, high tech, manufacturing, retail, life sciences, and government sectors. Through its partnerships, Resolvit delivers highly impactful, innovative solutions across five core areas: Infrastructure Modernization, Application Development Services, Enterprise Data Management & Analytics, Knowledge & Content Management, and Strategic Staffing.