Database Performance Architect
Posted on :
10-03-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 2609263
-
About the job
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.
-
Requirments
- 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
Employment Type
Full Time
Company Industry
Department / Functional Area
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
