Database Engineer/Administrator - SQL/PL-SQL (4-5 yrs)

JOB OVERVIEW :

Database Engineer / Administrator is a technical role tasked with managing multiple databases that hold business critical data and support business operations. The individual in the role brings knowledge of modern database technologies and data structure design best practices.

They will also provide strategic guidance and implementation of the corporate Business Intelligence solution and the corresponding data feeds. This role is an opportunity to be part of a dynamic high performing team and to be in the forefront of innovative technology.

ESSENTIAL DUTIES AND RESPONSIBILITIES :

- Analyze the needs of the organization and produce an effective database system according to their needs and specifications.

- Participate in the development and maintenance of strategic, architectural and tactical plans for the database and data warehouse environments

- Be conversant with, and cognizant of, the future direction of systems, how that direction impacts the company and how future and current database systems can be utilized for the companys benefit.

- Provide technical leadership on database systems and solutions.

- Provide individual mentoring and training on databases and tools.

- Recommend, test, and evaluate new technologies, software tools; recommend and implement improvements.

- Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.

- Ensure the efficiency of database code, the integrity of data structures, and the quality of data content.

- Write scripts to ensure data movement between various databases and ensure the scripts written are fault-tolerant and

extensible.

- Set and maintain database standards.

- Monitor database performance and identify and implement optimization opportunities .

- Ensure the organization Disaster Recovery and Business continuity plans are robust and are staying up to date with the

changing application and infrastructure landscape.

- Keep up to date with current trends in computing, application architecture, and cloud computing services.

- Ensure deliverables meet customer expectations for speed, quality, and value.

- Other duties as assigned.

TECHNICAL COMPETENCIES (Knowledge, Skills & Abilities) :

- Expert-level knowledge of SQL, PL/SQL, including stored procedures, functions, triggers, and views.

- Extensive experience working with Oracle database and with query tuning and troubleshooting.

- Ability to efficiently write database code without compromising data quality, privacy, or security.

- Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation

levels.

- Experience utilizing various high availability (HA) and disaster recovery (DR) options for Oracle Database.

- Knowledge of both relational and non-relational (NoSQL) databases.

- Experience with cloud technologies is good to have .

- Experience with backup/recovery best practices .

- Experience with Oracle Rac 19c , Exadata and Exacc/Exacs management (Mandatory Skill).

- Experience with Oracle cloud Interface.

- Familiarity with Dataguard 19c , Linux and Rman.

- Experience with database tuning , SQL and sql profiles/SPM.

- Problem-solving and attention to details.

- Experience with OEM 13c , Exachk, Exawatcher and DBAascli.

- Experience with Weblogic server , OID/OIM (Good to have).

EDUCATION AND EXPERIENCE :

- Bachelors degree in Computer Science, Engineering or equivalent combination of education and related work experience.

- Eexperience working with Oracle databases.

- Experience with version control systems, DevOps, continuous delivery, and continuous integration practices required.

- Experience of managing, owning and delivering high quality projects to objectives and within time scales required.