Hybrid to Augusta, ME- schedule will depend on candidate location - Northeast candidates preferred 6 month contract - long-term extensions
Practical experience developing fully automated ETL processes
○ Preferably flat file & DB sources
○ Experience more important tools - could be okay with SQL Server
Kimble Method - Dimensional Modeling
Oracle - moving to cloud - OAC
○ Will be the SME on the team
○ Oracle doesn't really have an SSIS equivalent
Someone who can mentor team
Losing someone who has a lifetime of Oracle experience
Local?
Preference for candidate to make it in office occasionally
Once a week - open to once a month or quarter
How much is architect vs DBA?
No server-side responsibilities on DBA side
More of an Architect role - will be writing code - hands-on
Business brings problem - they will design how to address it Top 3 Skills:Developing automated ETLDesigning & Implementing Enterprise class data repositories built upon Oracle on prem and cloud hosted databasesExpertise in dimensional modeling and ability to act as a technical mentorMuch of the work will focus on data modeling and developing automated ETL processes that pull data from a variety of data sources. However, data assignments will not be limited to these areas. They will be expected to develop, monitor, and maintain a variety of automated DB processes. They will be expected to research and resolve database issues as they arise. They will be assigned a variety of database management and maintenance tasks. They will serve as a trusted technical advisor and serve as a technical mentor to other IT staff. They will collaborate with other developers, analysts, and DBAs. They will work closely with IT vendors, IT leadership, and business partners.They will play a key role in upcoming system migrations, system expansions, and data modernization efforts. Has extensive practical experience with the modern Oracle platforms and technologies. This includes the following:Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.Practical experience utilizing API calls for automated data refreshes.Practical experience with Oracle Analytics Cloud (OAC)Mastery of SQL and PL/SQL and the ability to develop complex procedures, functions, views, and scripts.Expertise in dimensional modeling.Experience with tabular data models.Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust, performant, scalable, reliable, and expandable. Demonstrates a disciplined approach to process and error logging.Maintains excellent work habits when it comes to coding comments, system documentation, and metadata creation.Ability to serve as a technical mentor to both senior and junior IT staff.Ability to develop architectural diagrams and system documentation, and train others on the content.Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.Skillsautomated ETL, data repositories, Oracle, dimensional modeling, Oracle Analytics Cloud, SQL, PL/SQLTop Skills Detailsautomated ETL,data repositories,Oracle,dimensional modelingAdditional Skills & Qualificationsmust be a northeast candidate willing to travel on-site Experience LevelIntermediate LevelPay and BenefitsThe pay range for this position is $75.00 - $80.00Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)Workplace TypeThis is a hybrid position in Augusta,ME.Application DeadlineThis position will be accepting applications until Jan 15, 2025.About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.