Job Description
Job Objective
Objective of this job is to administer databases (Oracle Technologies) for IT projects; conduct preventive and corrective steps for DB upkeep; Evaluate Technical architectures and provide recommendations ; collaborate with DCO /CT teams at data centre, software development teams, Infrastructure outsourcing team, DBAs , network administrator as a consortium (Centre of Excellence) ; Participate & own data centre upkeep and expansion plans, Liaison with user departments for state data centre usage, upkeep of client assets, own & drive Archival/ back up/ Restoration policies. Track SDC (state data centre compliance for conducted tier 2 audits and certifications from norms adherence and renewal stand-point). Benchmark new technologies; work on continuous upgradation of technical artifacts
Core Responsibilities:
- Candidates with strong database administration experience on Oracle 11g/12c & onwards and need to updated himself/herself in latest version.
- Strong understanding of – Oracle 11g / Oracle 12c / onwards database
- Data structures / DB schema - advise on DB tables /data storage & retrieval - optimize performance
- Help application teams identifying work flow optimizations - proactively
- Maintain and share web analytics & reporting - application and DB
- DB issues troubling shooting & Optimization of DB issues - run time /periodic DB activities - monitoring indexes/ DB health
- Data backup and recovery, Archival and Restoration
- Database Access and privileges,
- Monitoring high cost DML operation and providing Optimization and Tuning
- Root cause analysis of issues and resolving, coordinating with team
- Assisting application teams in migration scripts and writing web-services (push/pull data) from/to other databases
- Advise application teams on data archival/ purging techniques/Recovery
- Devise methodology of central DB repositories like data centres.
- Must have administered DB volumes in excess of 500 GB - for client/server and web-based applications.
- Exposure to Linux , Shell Scripts and Cron Jobs
- Oracle Forms and Reports, SQL/My-SQL DB exp.
- Design and Develop OLTP and OLAP Systems
- Conversant with HP-UX, TRU 64 Unix, Linux ( Red-Hat/SCO), Windows Potential candidate should working knowledge on below :
- Data modeling techniques, Traditional, Dimensional Modeling - Star and Snowflake Schema
- Weblogic – application servers
- Designing techniques and supporting tools
- Legacy Application/data Migration - operational and implementation
- Application Integration - DB/code driven compatibilities