Database Performance Engineer
FADEL
This job is no longer accepting applications
See open jobs at FADEL.See open jobs similar to "Database Performance Engineer" MEVP.Amman, Jordan
Posted on Thursday, March 21, 2024
Database Performance Engineer
Responsibilities
- Build a library of knowledge on the databases in use in all applications that are in scope for performance testing and engineering.
- Analyze designs and in-development databases for performance problems and suggest design improvements accordingly.
- Perform query execution analysis and provide fixes for poorly performing queries on the application critical path.
- Provide guidance and support to project teams including architects, developers, and DBAs on high-performance, efficient, and scalable database design, jobs, and queries.
- Participate in performance testing of applications and assist with analyzing operational database issues encountered during testing.
- Provide guidance on data strategy and mechanisms for loading data in the test environments as per the test requirements.
Location
- Amman, Jordan
Requirements
- Advanced SQL experience.
- Should have extensive knowledge in SQL – tables, indexes, partitions, DB links, and Pl/SQL – Procedures, Packages, Triggers.
- Understand and analyze execution plans and trace logs.
- Experience in Database monitoring tools and reports analysis like AWR, ASH….
- Experience in Database Performance Engineering, of handling multiple production
performance issues related to database, queries, storage. - Experience in Database migration and purge process in large volume databases.
- Experience in load simulation tools and shell scripting.
- Experience in ER diagram designs, normalization techniques, and data architecting & modelling is considered a plus
This job is no longer accepting applications
See open jobs at FADEL.See open jobs similar to "Database Performance Engineer" MEVP.