QA Engineer

🚀 Hiring: Postgres DBA at Deqode

⭐ Experience: 6+ Years

📍 Location: Pune & Hyderabad

⭐ Work Mode:- Hybrid

⏱️ Notice Period: Immediate Joiners

(Only immediate joiners & candidates serving notice period)

Looking for an experienced Postgres DBA with:-

✅ 6+ years in Postgres & strong SQL skills

✅ Good understanding of database services & storage management

✅ Performance tuning & monitoring expertise

✅ Knowledge of Dataguard admin, backups, upgrades

✅ Basic Linux admin & shell scripting

Good experience in the Extraction, Transformation, and Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager,

Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Connect as ETL tool on Oracle, and SQL Server Databases.

 Knowledge of Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations teamed with

project scope, Analysis, requirements gathering, data modeling, ETL Design, development,

System testing, Implementation, and production support.

 Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts

and Dimensions

 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,

Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

 Developed mapping parameters and variables to support SQL override.

 Created applets to use them in different mappings.

 Created sessions, configured workflows to extract data from various sources, transformed data,

and loading into the data warehouse.

 Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

 Modified existing mappings for enhancements of new business requirements.

 Involved in Performance tuning at source, target, mappings, sessions, and system levels.

 Prepared migration document to move the mappings from development to testing and then to

production repositories

 Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex

SQL queries using PL/SQL.

 Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica

/Talend sessions as well as performance tuning of mappings and sessions.

 Experience in all phases of Data warehouse development from requirements gathering for the

data warehouse to develop the code, Unit Testing, and Documenting.

 Extensive experience in writing UNIX shell scripts and automation of the ETL processes using

UNIX shell scripting.

 Experience in using Automation Scheduling tools like Control-M.

 Hands-on experience across all stages of Software Development Life Cycle (SDLC) including

business requirement analysis, data mapping, build, unit testing, systems integration, and user

acceptance testing.

 Build, operate, monitor, and troubleshoot Hadoop infrastructure.

 Develop tools and libraries, and maintain processes for other engineers to access data and write

MapReduce programs.

Senior Oracle Database Administrator

Experience and CTC: 7 to 10 Years (20 LPA- 25 LPA)

Educational Qualification: B.Tech/ MCA

Location: Noida

Notice Period: Immediate to 20 Days

Required Skillsets:

DBA, RAC , RMAN, Perfromance tuning, Backup & recovery, Data guard

Primary Responsibilities

• Oracle database administration and basic understanding of performance Tuning
• Instance tuning, schema management, space management, disaster recovery, data replication, database refresh, and SQL programming and tuning
• Basic Understanding of Oracle RAC
• Basic Understanding of Oracle Data guard
• Understanding of UNIX shell scripting
• Knowledge of upgradation and Migration to higher version
• Should be ready for travel in India and abroad and open for working in any shift
• Good troubleshooting skills required and ability to handle production support
• Sound knowledge of Oracle Database Performance tuning
• Sound knowledge of RMAN backup and recovery procedure
• Ability to work across multiple global sites and working teams is imperative
• Experience with Grid Control, Performance Tuning and Diagnostic packs
• Should have worked on big Oracle development/UAT and production databases
• support across multiple hardware and software platforms including Solaris and AIX, HP-UX, LINUX is desired
• Ability to perform DBA activities that span multiple phases of database application life cycle
• Good understanding of Database performance tuning Oracle 11g & 10g
• Maintain standards and strategies for security, database objects and backup/recovery
• Validate that all physical database designs satisfy business requirements and meet standards to database objects, data integrity, security, performance and recoverability
• Understanding of Operating system like HP-UX, AIX, Solaris, Linux and storage
• Inventory of Best Practices , Automation scripts, SLA and KPI benchmark
• Must be self- motivated and well- organised

Responsibilities

• Developing new user-facing features using ReactJS
• Building reusable components and front-end libraries for future use
• Translating designs and wireframes into high quality code
• Optimizing components for maximum performance across a vast array of web-capable devices and browsers
• Understand business requirements and translate them into technical requirements
• Building robust applications that can handle both unexpected errors and heavy load

• 3+years experience in Reactjs
• Strong proficiency in JavaScript and Typescript
• Strong Knowledge of Redux/React Context/Hooks
• Strong Knowledge of frontend end technologies such as HTML/CSS
• Experience developing with responsive applications
• Knowledge of modern authorization mechanisms, such as JSON Web Token
• Familiarity with modern front-end build pipelines and tools like Webpack or Create React App
• Familiarity with Git