Send me more jobs like this

DBA Technical Associate

2 - 4 years
Posted: 2019-02-26

Industry
IT/ Computers - Software
Function
IT
Role
Software Engineer/ Programmer
Posted On
26th Feb 2019
Job Ref code
07721933
Job Description

ROLE AND RESPONSIBILITIES - Oracle
1. Should have advanced level SQL Performance tuning skillset.
2. Should be expert in in tuning SQL queries & Database
3. Ability to diagnose the performance issues from SQL to Application to Database to System to Storage
4. Expert level understanding of Oracle database architecture
5. Expert knowledge in ASH and AWR objects
6. Ability to improve SQL performance on packaged software
7. Experience in creating and executing performance testing strategy using SQL Performance Manager & Real Application Testing
8. Identify and resolve performance bottlenecks at DB & at session / program level
9. Should have experience & ability to work with various teams to resolve performance issues (development, storage administrators, network administrators, system administrators and business users)
10. Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
11. Implements and enforces security for all the Databases.
12. Performs database re-organization as required to assist performance and ensure maximum uptime of the database.
13. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
14. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
15. Provides technical support to application development teams and end-users of packaged third party applications within the organization.
16. Able to translate business requirements in technical solutions.
17. Efficient in writing DB queries, schedulers and configuration management,
18. Proven ability to raise/followup SRs with vendors/ OEMs and work through SRs with Oracle for efficient closure of critical issues
19. Ability to work effectively with team and share knowledge
20. Knowledge of PL/SQL & Operating System(s) Windows/ Linux/ AIX along with Perl & Shell scripts.
21. Tool Knowledge Oracle Enterprise Manager, Toad for Oracle, Remedy ITSM

ROLE AND RESPONSIBILITIES -SQL
1. Should have advanced level SQL Performance tuning skillset.
2. Should be expert in in tuning SQL queries & Database
3. Should work closely with application team to understand requirement and query performance issues
4. Ability to diagnose the performance issues from SQL to Application to Database to System to Storage
5. Expert level understanding of SQL server database architecture
6. Expert knowledge in SQL profiler, Distributed replay ,Database engine tuning advisor, DMVs
7. Ability to improve SQL performance on packaged software
8. Good to have knowledge of share point
9. Experience in creating and executing performance testing strategy using SQL profiler & Distributed Replay
10. Identify and resolve performance bottlenecks at DB & at session / program level
11. Should have experience & ability to work with various teams to resolve performance issues (development, storage administrators, network administrators, system administrators and business users)
12. Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
13. Implements and enforces security for all the Databases.
14. Performs database re-organization as required to assist performance and ensure maximum uptime of the database.
15. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
16. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
17. Provides technical support to application development teams and end-users of packaged third party applications within the organization.
18. Able to translate business requirements in technical solutions.
19. Efficient in writing DB queries, stored procedures & functions
20. Proven ability to raise case with MS support for efficient closure of critical issues
21. Ability to work effectively with team and share knowledge
22. Knowledge of Transact SQL & Operating System(s) Windows (Mandatory)/ Linux (desired)
23. Tool Knowledge Fog light, IDERA SQL diagnostic manager, remedy

Mphasis is looking for DBA Technical Associatefor Bengaluru, India:-
APPS GENERIC SKILLS - DATA ENGINEERING-ORACLE DBA
Primary Comp & : Data Engineering - Oracle DBA
Skill Percentage - 100
Skill Version -
Proficiency - Intermediate(>2 &

About Company

Mphasis is a leading IT solutions provider, offering Applications, Business Process Outsourcing (BPO) and Infrastructure services globally through a combination of technology knowhow, domain and process expertise. The accolades we have been garnering can be attributed to our undeterred focus in delivering quality solutions across verticals that meet the challenging requirements of our esteemed customers. We have been recently felicitated by the economic times as the most distinguished digital company 2015. We have also been ranked 29 of 100 largest financial technology vendors by American Banker and BAI in the FinTech Forward Top 100 rankings.
Similar Jobs
View All Similar Jobs


Walkin for you