· Ensure performance tunings system parameters are set to provide fast query response to users by understanding their requirement and analyze long term database performance trends to optimize database and application performance, gather reports to monitor performance of database system as per defined SLA's and share these reports with the user and business units.

· Ensure optimal performance and uptime is maintained by planning regular database maintenance activities including database storage sizing, defragmenting databases, purging logs, applying security patches, cloning database and tracking of patches, updates & vulnerabilities, configuring alert using Enterprise tools or by developing customize monitoring scripts wherever Enterprise tools are not applicable also work closely with technical operations team on database capacity planning and designing.

· Ensure that all application designs and codes are produced with proper integrity, security, and performance.

· Plan to identify dependencies for changes are well documented and make sure impact analysis of the changes are performed.

· Validate technical and user documentation and troubleshooting methodologies to review technical scripts for deploying changes to the database and implement change plan ensuring backup and rollback plan are in place.

· Responsible for the setup, patching, debugging, upgrading and installation of software applications and tools which relate to application users.

· Knowledge transfer among the team, by updating the documents and submitting new documents as per DBA team standard procedures.

· Directly interacting with the vendor in case of critical issues, or escalation is needed if issues are not resolved with minimal time frame by raising service requests to the vendor and perform root cause analysis.

· Perform Periodic Database and Application security administration and audits.

· Analyze system logs to identify potential security breaches/issues in applications and database and perform periodically database access review and ensure security policy is implemented.

· Review Critical security patch updates (CPU) from Oracle/Microsoft quarterly along with

performing OS pre-requisites, prepare a risk assessment report to the management, and applying the latest CPUs.

· Develop scripts for monitoring disaster recovery site and troubleshoot or identify problems related to database synchronization or replication.

· Plan and built Disaster recovery (DR) site and make sure Business Continuity plan (BCP)is updated and DR drills are performed regularly.

· Ensure cluster and high availability functionality are tested and with all the integrated applications.

· Ensure the database recovery and archiving strategy including conducting backup/recovery procedures and test drills have been tested.

· Ensure optimal performance and uptime by accessing database maintenance procedures and methodologies.

· Work closely with the technical operations team on database capacity planning and designing.

· Perform routine audits of systems and analyze system logs to identify potential issues with applications.

· Maintain and enforce best practices in database management including design standards, processes and methodologies, performance, and scalability.

· Effective management of Linux based workloads hosted on-prem and on-cloud

· Manage the Middleware applications and provide the support to the application team on configuring and deploying applications.

· Conduct periodic review of the applications and databases and suggest the upgrade/update to maintain the compatibility, reliability and availability

Essential Job Qualifications

Bachelor’s degree in computer sciences

Knowledge of Application Setup

Oracle Cloud Infrastructural Architect Professional

ITIL Certified

Expert Knowledge of MS SQL Server & MySQL

Expert knowledge of Oracle Access Manager, Oracle Identity Manager, E-business Suite,

JBOSS, WebLogic, Oracle Discoverer and SOA Suite.

12+ Years of experience in similar position.

Available for 24X7 support.

Preferred Technical certification:

Oracle Certified Database Professional

Oracle Certified E-business Suite Professional