Has 5+ years' experience in Oracle Database Management ( 9i/10g/11g/12c )
• Experience in Backup / Recovery
• CLOUD EXP MUST.
• Hands on experience in Installation of high availability Oracle RAC environment (2/3/4 node clusters)
• Proven expertise in supporting Grid Infrastructure (Clusterware, ASM, Disk Groups), Private Network for Interconnect and Public Network (VIP, SCAN),
• OCR and Voting Disk, Cluster verify utility (cluvfy)
• Installation, Configuration, administration and operations support of Oracle Golden Gate
• Knowledge in supporting Exadata Database Machine
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, OEM Grid Control and manual scripts.
• Install, configure and manage Oracle on Unix & MicroSoft Windows.
• Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle in 24 X 7 environment
• Database administration for a critical Oracle Exadata
• Strong Experience of RMAN, Data Guard, Grid Control
• Experience evaluating and installing new software releases, patches and system upgrades
• Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage
• Experience developing and executing database security policies, procedures and auditingexperience with database authentication methods, authorization methods, and data encryption techniques
• Establish and maintain documentation and standards
• Work as part of a team and provide 24x7 support when required
MSSQL:
• 2+ years of experience in database management and support in MS SQL Server environments.
• Strong experience in Database Administration in SQL Server ( 2005, 2008, 2012 & 2014 )
• Experience on Clustering, Database mirroring, Replication and log shipping configuring and troubleshoot issues.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues,
• Replication issues, log shipping issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands
• Expert experience in implementing operational automation.
• Strong knowledge of indexes, index management, integrity checks, configuration, patching, statistics, created and managed effectively.
• Knowledge of SQL Server tools ( Profiler, DTA, SSMS, DAC)
• SQL Development ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
• Solid acquaintance with windows server, security delegation, SPNs, storage components.
• Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
• SQL Database Operational support to tech users"
Job Type:
Contract
Contract length: 12 months
Schedule:
• Monday to Friday
Experience:
• Cloud
DBA:
3 years (preferred
