Oracle DBA

Global Computer Services Corp. LLC

Oct 16 2019

Position Review Responsible for the 24x7 availability and smooth functioning of several databases serving highly mission-critical Healthcare System that helps to run 250+ paperless health institutions under the Ministry. Work closely with enterprise, database, and application architects and project managers. Understand the impact of design decisions on the overall effort. Responsibilities: Identify the changing Business Drivers to implement technologies of future. Explore, recommend and implement new technologies and tools to provide a highly-available, scalable, secure and reliable database and application system environment. Ensure the 24x7 availability of the Databases. Device and manage disaster recovery solutions to handle unforseen system crashes to avoid potential impact on business. Plan, Design, Implement, Tune and Troubleshoot clustered (Active like RAC and Passive) database architectures. Allocate system storage and plan the future database storage requirements for application systems. Fine Tune Database, Applications, Network, Memory, IO and Storage. Tune and optimize Operating Systems for optimal database performance. Install, Configure and manage Database, Application and Web Servers and Tune and troubleshoot performance and configuration problems. Device a Backup and Recovery plan and schedule Backups. Monitor database for potential problems and take immediate corrective steps if necessary. Recover/Restore database in case of database crashes with a minimum impact on the smooth functioning of the organization. Write and incorporate database triggers and procedures and packages. Maintain LDAP and database users, profiles, policies, and resource limits. Audit Database activities and troubleshoot security issues and protect data confidentiality. Mentor the application development team in database technology and help them solve critical data design and implementation issues. Work closely with Applications architects to define application design and development requirements. Evaluate and incorporate new tool, technologies and standards in database and related technology. Document the database/cluster architectures, designs, configuration, migration and installation plans and procedures, and other technical documentation according to established standards. Perform code reviews with analysts and Application architects and developers. Develop performance test plans, design test environments and perform tests. Technical Skills: Minimum 1 year of expertise in Oracle Database Administration in all aspects of administration jobs and solid experience in Database versions 8i through 11g. Proven experience in managing Databases in Linux, MS-Windows operating systems. Minimum 1 year experience in: Installing, configuring, maintaining and tuning complex database systems. Cluster Installation, Administration, Tuning, Service Management, Load- Balancing, and Transparent-Application-Failover, are added advantages. Active-Passive clustering technologies like Windows Cluster Server and oracle Failsafe, RedHat Cluster Manager, Oracle Cluster One-Node etc. Configuring and managing oracle data guard environments (physical and logical standby databasesin guaranteed, instant, rapid and delayed protection modes, active dataguard, etc.). backup and recovery using RMAN and OS methods and sound knowledge in backup and recovery planning, strategizing, automatic scheduling, backup verification and monitoring procedures and processes. Management of Oracle ASM, OCFS and other Cluster File Systems. multi-master and materialized view replication, distributed databases, etc. Below skills will be added advantages: strong backup and recovery concepts and the recovery scenarios like online/offline backups, logical/physical backups, partial/full backups, flashback database, partial/full point-in-time recovery, recovery from different failure scenarios, user errors, logical block corruptions etc. Database Tuning, Application Tuning, Storage and Space Management, Users, Security, Profile, and Resource Management etc. Strong knowledge in Data warehousing concepts and technologies like schema designs, OLAP, Cubes, ETL, Analytics, and Query Tuning etc. handling complex concurrency, performance, scalability, Internationalization, data privacy, confidentiality and security issues Provable Working Experience in the Administration of very large Databases. Attributes: Excellent Team Player, Detail and Deadline Oriented. Demonstrates a passion and a responsibility for consumer. Desire to own decisions and take responsibility for outcomes. Willingness to continually embrace personal and professional development. Demonstrated exceptional written and oral communication skills. Education & Work Experience: Bachelor's Degree in Computer Science or Related Fields. Preferable working experience in healthcare domain.

Jasmine Complex 4th Floor – Office No 401 & 402, Near Radisson Hotel, Al-Khuwair | Sultanate of Oman

1 - 2

Oct 20 2019 - Oct 27 2019