Data Warehouse/middleware Database Administrator

3 weeks ago

Pune Maharashtra, India Stantec Full time

We’re active members of the communities we serve. That’s why at Stantec we always design with community in mind. We believe growing a great design company happens from the inside out. We look for people who are drawn to use every talent they possess, plus creativity, determination and a drive to do the extraordinary.

The Stantec community unites approximately 22,000 employees working in over 400 locations across six continents. We collaborate across disciplines and industries to bring projects to life. Our work as architects, engineers, and consultants from initial project concept and planning through design, construction and commissioning is built on a solid history of success. So, when we take on a project, we see the opportunity to make a lasting connection with the people and places where we live and work. Redefine your personal best. Join us

Role: Data Warehouse/Middleware Database Administrator

Experience/ Career level: 2 to 10 Years of experience (career level - 3/4)

Job Overview:
DBA is mainly responsible for installing, configuring, and maintaining DW/BI environments, also include ensuring data security, tuning performance, implement DB backup/recovery strategies, planning storage capacity for scalable database growth, implement high availability, keep system up to date by quarterly patching / upgrades.

Another important task of BI DBA is support ETL processing, which includes monitoring ETL jobs, troubleshooting issues, automating error handling, and optimizing the processes for better performance and support the BI Developers to develop and enhance the ETL and query processes.

Key Responsibilities:

- Install and support all different components of Oracle Business Intelligence Applications (OBIA), Oracle Analytics Server (OAS), Oracle Data Integrator (ODI), Essbase, Weblogic Servers and related Oracle Databases.
- Oracle Databases Monitoring, Tuning, Patching, Cloning, Upgrade, Backup/recovery and DR/Standby maintenance.
- Manage/Administer Backup, Restore and Disaster Recovery policies and procedures for DW/BI systems
- Administer cloning procedures for dev/test DW/BI Systems
- Configure and support ETL processes and SQL queries
- Monitor performance and tune OAS and OBIA components. Develop processes for reporting on platform’s utilization, availability and performance.
- Develop support scripts for OBIEE/OBIA products using Linux shell scripts, WLST, WLDF, PLSQL
- Work on stabilizing overall Stantec DW/BI environment, setup monitoring and reporting as required, keep system up-to-date by patching/upgrade, performance analysis and tuning as and when required
- Document DBA processes and procedures

Additional Duties:

- Collaboration with different teams or groups within IT as and when required - Development team, Unix, Project Management, EBS/Middleware DBA, Network team etc.
- Follow Oracle Standards, Coding standards, time-to-time review DB/Application security and extend support to different teams to implement the same.

Qualifications:

- College diploma or university degree in computer systems design or computer science, and/or 3+ years in depth experience with infrastructure operations d and database technologies
- Minimum of 2/3 years experience providing Oracle Data Warehouse database administration, support using Oracle Data Integrator is preferable
- Experience with any Unix/RHEL is mandatory
- Experience in Oracle WLST is mandatory
- Familiarity with OAM/OID and Oracle SSO are definite assets
- Experience with partitioning, materialized views and parallel execution is considered desirable
- Experience with WebLogic Diagnostic Image Framework (WLDF) is nice to have
- Experience with Oracle Enterprise Manager will be considered an asset.

Please note that this position will require after-hours and on-call work. We are looking for team players that can work in a very dynamic and challenging environment.

**Primary Location**: India | Pune

**Organization**: Stantec IN Business Unit

**Employee Status**: Regular

**Job Level**: Nonmanager

**Travel**: No

**Schedule**: Full time

**Job Posting**: 05/06/2024 06:06:36

**Req ID**: 1000359

  • Database Administrator

    7 days ago

    Pune, Maharashtra, India Data Axle Full time

    **About Data Axle**: Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based technology platform...

  • Database Administrator

    6 days ago

    Pune, Maharashtra, India Data Axle Full time

    **About Data Axle**: - Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based technology...

  • Database Administrator

    6 days ago

    Pune, Maharashtra, India Data Axle Full time

    **About Data Axle**: - Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based technology...

  • System Administrator, Middleware

    2 months ago

    Pune, Maharashtra, India Softenger Full time

    **Job Profile**: - System Administrator, Middleware**Job Location**: - Pune**Experience Required**: - 3-4 yrs- General Middleware Tasks (Patching, Hot fix, SP, SSL admin, log file rotation etc) Task List - Application restart - Log purging activity - Manage & communication with OEM - Application monitoring based on the capabilities of the tools - VA open...

  • System Administrator, Middleware

    2 weeks ago

    Pune, Maharashtra, India Softenger Full time

    **Job Profile**: - System Administrator, Middleware**Job Location**: - Pune**Experience Required**: - 3-4 yrs- General Middleware Tasks (Patching, Hot fix, SP, SSL admin, log file rotation etc) Task List - Application restart - Log purging activity - Manage & communication with OEM - Application monitoring based on the capabilities of the tools - VA open...

  • Middleware Administrator

    5 days ago

    Pune, Maharashtra, India Softenger Full time

    #Middleware Administrator #WeblogicGeneral Middleware Tasks(Patching, Hot fix, SP, SSL admin, log file rotation etc) Task List Application restart Log purging activity Manage & communication with OEM Application monitoring based on the capabilities of the tools VA open points based on the sop provided by the soc team provided by CUSTOMER Middleware...

  • Database Administrator

    5 days ago

    Pune, Maharashtra, India Data Axle Full time

    Job DescriptionAbout Data Axle:Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based technology...

  • Database Administrator

    1 week ago

    Pune, India Data Axle Full time

    Job DescriptionAbout Data Axle:Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based technology...

  • Database Administrator

    4 weeks ago

    Pune, India Data Axle Full time

    Job DescriptionAbout Data Axle:Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based technology...

  • Database Administrator

    4 weeks ago

    Pune, India Data Axle Full time

    Job Description About Data Axle: Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based...

  • Database Administrator

    3 weeks ago

    pune, India Data Axle Full time

    Job Description About Data Axle: Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary...

  • Database Administrator

    4 weeks ago

    pune, India Data Axle Full time

    Job Description About Data Axle: Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary...

  • Database Administrator

    3 weeks ago

    Pune, India Data Axle Full time

    Job Description About Data Axle: Data Axle Inc. has been an industry leader in data, marketing solutions, sales, and research for over 50 years in the USA. Data Axle now has an established strategic global centre of excellence in Pune. This centre delivers mission critical data services to its global customers powered by its proprietary cloud-based...

  • Database Administrator

    6 days ago

    Pune, Maharashtra, India Oracle Full time

    We are looking for a highly capable, self-motivated and independent Database Administrators based in India. If you are passionate out Oracle database technology as well as cloud computing, this is the ideal role you've been waiting for.Our DBA team supports databases which are available both on-premise and on Cloud. In this role, you will be asked to...

  • Pntppd - Telefonica - Junior Middleware / Database

    3 weeks ago

    Mumbai, Maharashtra, India Capgemini Full time

    SERVICE OVERVIEW: Junior Middleware/Database Administrator Experience: - More than 1 year of experience in Applications servers administration: JBOSS, Weblogic, WebSphere - More than 1 year of experience in web servers: apache, IIS, NGINX, Oracle HTTP Server. - More than 1 year of experience in Oracle Database Administration. - Experience in repetitive tasks...

  • 0ateiv - Telefonica - Junior Middleware / Database

    3 weeks ago

    Mumbai, Maharashtra, India Capgemini Full time

    Description: SERVICE OVERVIEW: Junior Middleware/Database Administrator Experience: - More than 1 year of experience in Applications servers administration: JBOSS, Weblogic, WebSphere - More than 1 year of experience in web servers: apache, IIS, NGINX, Oracle HTTP Server. - More than 1 year of experience in Oracle Database Administration. - Experience in...

  • Middleware Administrator

    4 days ago

    Mumbai, Maharashtra, India ThinkResource Infosolutions Pvt Ltd Full time

    **Middleware(L2&L3)** - Degree BE/B.Tech/MCA in IT/Computer Science/ Electronics & Communication/Electronics or higher/Diploma in Computer Science with minimum 5 years’ experience - Experience in DevOps Open Source Middleware technologies/tools and automation development - Pioneer new technologies in collaboration with Product Development and Enterprise...

  • Middleware Administrator

    4 days ago

    Mumbai, Maharashtra, India ThinkResource Infosolutions Full time

    **Middleware Admin(L2&L3)** **Experience**:Min. 5 Years - Degree BE/B.Tech/MCA in IT/Computer Science/ Electronics & Communication/Electronics or higher/Diploma in Computer Science with minimum 5 years’ experience - Experience in DevOps Open Source Middleware technologies/tools and automation development - Pioneer new technologies in collaboration with...

  • Fusion Middleware Administrator

    6 days ago

    Pune, Maharashtra, India manogna it services private limited Full time

    ROLE :Fusion Middleware Admin ( SOA ) 11g/12cTECHNOLOGY :Fusion Middleware Admin ( SOA ) 11g/12cLOCATION :PUNE ,BANGALORE ,HYDERABADEXPERIENCE :5 TO 9+ YEARSJOB DESCRIPTION : Min Experience Years. Require expert knowledge in Oracle Fusion Middleware, Weblogic administration Experience in building and maintaining DEV, QA and PROD and Disaster Recovery...

  • Senior Database Administrator

    3 weeks ago

    Pune, India Oracle Full time

    We are looking for a highly capable, self-motivated and independent Database Administrators based in India. If you are passionate out Oracle database technology as well as cloud computing, this is the ideal role you’ve been waiting for.Our DBA team supports databases which are available both on-premise and on Cloud. In this role, you will be asked to...