Database Solutions Architect

Job Description

We are seeking a skilled Database Solutions Architect to join our team.

The successful candidate will support database operations, including performance monitoring, query optimization, code deployments, access management, and database analysis. They will operate in Oracle and Exadata database re-platforming efforts.

Key Responsibilities :

• Support ongoing efforts and provide technical support for multiple database re-platforming efforts to Exadata.
• Review and implement data loading scripts related to Golden Gate data replication.
• Optimize and tune SQL queries and indexes in Oracle.
• Work knowledge of Oracle 12c / Oracle 19c / Exadata added capabilities and functionality.
• Strong programming / development skills using PL / SQL (package, procedures, functions, triggers) a plus.
• Proficient in performance tuning (PL / SQL) using SQL Trace, Explain Plan, Indexing, and Hints.
• Strong knowledge of database triggers, indexes, and partitioning.
• Expertise in Oracle architecture.
• Proficient in reading Query Execution Plans with the ability to evaluate and improve performance characteristics of SQL.
• Manage database objects like tablespace, users, indexes, roles, privileges, profiles, and synonyms.
• Monitoring of the database performance as it relates to memory usage, proper backups, active sessions, long-running queries, tablespace configuration, and space allocations.
• Coordinate with data architects and analysts on the building of schemas, tables, functions, views, stored procedures, and roles.
• Coordination with the automation team for the scheduling of various AWA / RMJ jobs to be executed on multiple databases.
• Provide DBA supervision and Oracle best practices guidance for custom application development and routine database administration efforts.