• Will report to General Manager (Software Development) directly.
• Responsible to manage Databases of all types and all projects unders maintennce / Development
• Responsible to Manage three teams i.e. Oracle backend Development, Performance Tunning, Database Administration etc.
• Must have at least 10 years hands-on post-qualification experience in Database Administration, with a reputed IT organization, including at least 3 years experience in designing, configuring, installing and managing Oracle RDBMS/ORDBMS 8i, 9i, 10g, 11g and 12c on Windows, Linux and Unix platforms, with 24/7 availability through HA solutions like Streams and Dataguard, in single instance/RAC VLDBs, shared storage like NAS and SAN, OCFS, ASM and OMF
• Must have profound knowledge of Normalization, DFDs, ERDs, EERDs and Toad Modeler, MS Visio or anyother known modeling tools
• Concept of Data Warehousing, Shell Scripting, Data Mining, and ETL Tools, SQL Loader, Star Schema is preferd
• Must have extensive expertise in planning, testing and implementing user managed, full / incremental, backup/disaster recovery solutions, techniques, procedures, policies and tools like Oracle Import/Export, Data Pump, RMAN, Vertitas, NetBackup, etc.
• Must have extensive expertise in oracle logical and physical database structures management, maintenance, growth estimation, performance tuning, reading/analyzing Logs, Hints, Joins, Wait Events, Statistics, Histograms, etc. using tools like Oracle Optimizer, Oracle Trace, Explain Plan, TKProf, etc.
• Must have high proficiency in complex SQL queries and PL-SQL procedures/ functions/packages
• Must have very good communication, leadership and team management skills