Kerja Sepenuh Masa, Database Programming Engineer | Penang di Commerz Global Service Solutions Pulau Pinang - Maukerja

Job Purpose:

• In the Cluster Delivery Organization, Business Specialists, Business Experts, Engineer Specialists, Engineers, and Product Owners work together in a team. Agile methods help employees perform their functions by enabling a fast and flexible response to changing conditions and customer needs through an iterative approach and continuous development of new solutions.
• End-to-end Database Tools Programming and Integration (for Oracle / MS-SQL / PostgreSQL) to design, develop and optimize data architecture including writing complex data handling stored procedures, packages, functions and covering database performance analysis using "SQL,PL/SQL,PL/pgSQL,T-SQL,Python,Perl,API, Power Shell" programming tiers, crash diagnostics and 3d level support, collaboration on Database automation workflows on Linux and Windows platforms, technical guidance during infrastructure maintenance or platform migrations. and acts in the role of the Cell Member together with Database Administration and Database Automation engineers.
• The engineer has an agile and digital mindset that always adapts to the current requirements using the appropriate development options.
• This role requires working EMEA hours (3:00 pm – 12:00 am), with a shift allowance provided.

Key Activities:

• Database Development: Design and implement robust database structures, including tables, views,, indexes, packages, stored procedures and functions, using SQL technologies for (Oracle / MS-SQL / PostgreSQL) and their needed integration services.
• Back-end Logic: Write, debug, and optimize complex stored procedures, functions, and triggers
• Design database schemas, indexing and partitioning strategies for enterprise application modules and develop SQL/PLSQL for optimized critical workloads.
• Data integration: Build and maintain ETL pipelines to migrate data between disparate systems including the design of data transfer interfaces ( Linked servers or database links).and loading data into the database using the API calls and external data stores.
• Work closely with Database Infrastructure and Database Automation Engineers to integrate back-end code in the automation pipelines and assist in API development
• Collaborate with database operations, database infrastructure engineers to automate the provisioning, patching and removal of Database software components on Linux or Windows systems using the standard automated processes and pipelines.
• Leverage Automation Platform tools and their features or cloud provider tool kits and APIs to manage and scale automation workflows for database products deployments across multiple environments (on-premise and cloud).
• providing advanced support for relevant systems, data maintenance, reporting and authorization management
• Adherence to security and development standards and ensure stable operation with respect to products, services processes and systems

Formal Education:

• University/University of Applied Sciences or equivalent professional experience
• At least 5 years of professional experience
• Experience in IT operations; has own responsibility for systems and/or complex processes

Qualifications & Experience:

• Technical Mastery in minimum 2 of : SQL, PL/SQL, PL/pgSQL, T-SQL
• Technical skills in scripting using languages like Python and API
• Sufficient programming scripting skills in Bash, Windows Power Shell
• Deep understanding of relational database design, normalization, and indexing strategies.
• Familiarity in Database administration is strongly preferred
• Familiarity with Software Development lifecycle, testing concepts, version control systems, and release management in Linux or Windows systems
• Experience in provisioning and patching of Oracle database software and Grid Infrastructure software ( OPatch / AutoUpgrade)
• Experience in code optimization tools and performance monitoring (e.g EXPLAIN ANALYZE, Profiler, AWR, ASH, ADDM, SQL Trace, and execution-plan analysis to resolve critical production bottlenecks and improve reliability.
• Demonstrated ability to troubleshoot complex performance issues and deliver effective solutions.
• Excellent problem-solving skills, attention to detail, and ability to work independently and collaboratively within a team.
• Certifications related to cloud platforms and automation tools are of advantage
• Experience with advanced application deployment strategies.
• Familiarity with agile development methodologies and practices.
• Knowledge of best practices for security and compliance.

Skills:

Essential Skills

• Extensive experience in scripting with Python, Bash, or PowerShell
• Extensive experience in 2 of : SQL, PL/SQL, PL/pgSQL, T-SQL
• Extensive experience in provisioning and patching of Oracle database software and Grid Infrastructure ( OPatch / AutoUpgrade / GridSetup)
• Strong understanding in CI/CD and Service Broker pipelines or similar
• Extensive Knowledge of Software development lifecycle
• Extensive experience in IT security

Personal Skills

• Very high load capacity
• Very good skills for innovation
• Very good skills for cooperation
• Very high result and goal orientation
• Very high service orientation
• Very good analytical skills
• Very good conceptual skillls

Critical Skills

• Advanced standard knowledge
• Mastery of the entire lifecycle of the topic
• High productivity and quality of work
• Quick familiarization with new topics
• Structured disclosure of information to third parties
• Ability to direct other employees