CTG IT Tech Specialist I in Pittsburgh, Pennsylvania
IT Tech Specialist I
Jul 18, 2022Post Date
Apply for JobShare this JobSign Up for Job Alerts
CTG is seeking to fill anIT Tech Specialist Iopening in Rochester, MN.
Location: Rochester, MN
Duration: 11 months
CTG’s client has an opening for a Data Warehouse DBA to provide support for the Administrative Data Warehouse (ADW). The ADW contains INFOR ERP data and related ancillary system data and is used for a wide variety of enterprise wide operational and strategic reporting and analytical purposes. The ADW is a large Microsoft SQL Server environment comprised of multiple database servers and databases, ETL code and processes, data marts, OLAP cubes, Business Objects universes, and .Net applications.
Responsibilities of this position include working with a team of DBAs, data integration specialists, and data delivery specialists in the ongoing development, implementation, and support of the existing SQL Server data warehouse. This also includes efforts related to an ongoing project to transition to Oracle ERP. The successful candidate will support custom data driven processes that control database backup and recovery operations, optimizations, ETL, and data presentation. The individual will also be responsible for schema migrations, database space and file management, performance monitoring and tuning, database security administration, database refreshes, and job automation. Participation in a formal 24x7 on call rotation is required. The successful candidate must commit to meeting challenging deadlines and priorities, including working off-hours occasionally as needed, must function as part of a highly skilled technical team, be self-directed, and must exercise sound judgment when making decisions that could have large impacts on rigorous service level requirements.
A bachelors degree and at least 3 years of professional technical experience in database design, development, implementation, and support; or an associates degree and at least 5 years of professional technical experience in database design, development, implementation, and support; or at least 7 years of professional technical experience in database design, development, implementation, and support.
A bachelors degree in Computer Science or related field is preferred. Demonstrated experience providing comprehensive database support is required. Direct experience working with recent versions of SQL Server is preferred. Experience supporting large SQL Server data warehousing production environment with rigorous service level agreements is preferred. Strong problem solving, teamwork, customer service, and communication skills are required.
To be considered, please apply directly to this requisition using the link provided.
CTG’s Benefits Plan allows you to select insurance coverage that best suits your lifestyle, and take part in our savings programs and educational plans. We offer Flexible Spending Accounts, a 401(k) Retirement Plan, and an Employee Stock Purchase plan. Our educational plan comprises access to more than 2,000 web-based technical, professional and business development courses.
CTG is a leading provider of digital transformation solutions and services that accelerate clients' project momentum and achievement of their desired IT and business outcomes. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG has operations in North America, South America, Western Europe, and India. For more information, visit www.ctg.com.
Our culture is a direct result of the people who work at CTG, the values we hold, and the actions we take. In other words, our people are the culture. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. Part of our mission is to cultivate a workplace that attracts and develops the best people, reflected by our recognition as a Great Place to Work-certified company across many of our global operations.
CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.
CTG is an Equal Opportunity and Affirmative Action Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. Our Affirmative Action program serves to promote occupational equality and diversity through good faith efforts. CTG is fully committed to promoting employment opportunities for members of protected classes.
Job Function: Data Warehousing
Education Level: Associate's Degree/College Diploma (±13 years)
Work Remote: Yes