Senior Oracle DBA needed for on site role .
Responsibilities -
· Perform all aspects of Database operations and administration services in accordance with established processes and guidelines. These
include, but are not limited to:
· Install, configure, and maintain database instances / servers with the versions required by the client.
· Enhance database performance by query and process optimization.
· Maintain integrity of the database by having proper backup and recovery processes.
· Apply database changes according to change management procedures.
· Carry out regular capacity planning activities.
· Perform database refresh and cloning as required by the respective application teams.
· Participate actively in all aspects of infrastructure projects and technical upgrades.
· Provide database provisioning and technical support services to application development projects.
· Perform supporting services for clients reporting and batch process control platform.
· Perform Database Backup and Restore activities in close coordination with clients teams.
· Participate in security audits and compliance initiatives. Ensure the database environment is fully compliant with client security policies
and internal controls.
· Provide 24/7 incident response for client production environment
· Provide periodic and ad-hoc status reports including KPIs as requested by client delivery lead.
· Perform periodic performance tuning of applications and capacity planning.
· Participate in coding of stored procedures and triggers, using SQL as needed for the operations.
· Provide infrastructure support for Oracle, SQL Server, PostgreSQL, MongoDB, Dremio etc., and database environments.
· Provide support of the Dremio infrastructure for data engineering needs of clients.
· Provide support of IT operations using an onsite/offshore delivery model.
Minimum Requirements:
· Overall 12+ years of IT industry experience
· 7+ years of experience as DBA in Oracle 11g/12c/18c/19c in Red Hat Linux using ASM storage and ext3 file systems.
· Experience in PostgreSQL and SQL Server is also mandatory (at least 1 year).
· Unix Shell Scripting experience is required (at least 1 year).
· Experience in Oracle Transparent Data encryption.
· Knowledge of Azure data services is a plus.
· Extensive experience in Oracle RAC.
· Experience in operating Oracle in the Cloud is a plus.
· Experience with Oracle Exadata is required.
· Relevant experience with Oracle RAC in Red Hat Linux platform.
· Relevant experience with Oracle ASM file system.
· Relevant experience with RMAN for backup and recovery.
· Relevant experience in use of ITIL processes.
· Relevant experience for SOX/ICFR compliance of critical financial systems