Duties & Responsibilities:
- Perform all administrative tasks, such as planning and building new database servers, ASM disk management, backup and restore, user account and data security management, capacity planning.
- Perform Disaster Recovery implementations based on Oracle Dataguard.
- Work with infrastructure team on upgrades, patching and resolution of cross functional issues.
- Participate in system audits, adhere to the internal security standards.
- Provide deployment support for database objects in production and UAT environments.
- Provide 24x7 production database support and willing to work after office hours / weekends.
Skills & Experience Requirements:
- At least 2 years of experience working as production database administration supporting Oracle, QL Server and MySQL databases.
- Strong skills in Oracle/MS-SQL/MySQL database administration supporting large database environments.
- Proficient in Database installation, configuration on UNIX (Solaris & AIX) / Linux / Windows platforms.
- Good database performance tuning, troubleshooting skills and locating bottlenecks at both server and database level.
- Experienced with standard database monitoring tools.
- Experience in Database High Availability setup using Oracle RAC/Dataguard, SQL Server Failover Cluster/AlwaysOn Availability Groups, MySQL InnoDB Cluster/NDB Cluster.
- Experience in database install, upgrade, plan and execute critical database migration using Oracle Goldengate/Shareplex.
- Well versed with Database optimizer changes, database internals and troubleshoot production issues.
- Knowledge on Oracle JDBC, ODP.Net, UCP, TAF, FCF and MySQL Connectors.
- Good skills in UNIX shell scripting and Oracle PL/SQL programming preferred.
- Oracle certification - OCP on Oracle 11g/12c/18c/19c preferred.
- Familiar with database partitioning design, TDE encryption and implementing security standards to secure critical environments.
- Good communication and presentation skills and be able to interact with multiple teams at various levels.
