SQL / Oracle DBA

This job is no longer active. View similar jobs.

POST DATE 8/10/2016
END DATE 12/19/2016

HCL America Charlotte, NC

Company
HCL America
Job Classification
Full Time
Company Ref #
28700259
Location
Charlotte, NC
Job Type
Regular
AJE Ref #
575844092

JOB DESCRIPTION

POSITION : SQL/ORACLE DBA

DURATION : FULL TIME

LOCATION : CHARLOTTE, NC

JOB DESCRIPTION:

MSSQLResponsibilities:

* Strong experience in Database Administration in SQLServer ( 2014 to 2000)
* Experience in High availability
* Experience in troubleshooting 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 SQLServer related CPU,memory,I/O, disk space and other resource contention.
* Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
* Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
* Knowledge of SQLServer tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
* Solid acquaintance with windowsserver, security delegation, SPNs, storage components.
* Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
* SQLDatabase Operational support to QA and development team

OracleResponsibilities:

* Database administration 11g, 12c
* Knowledge on RAC,GRID,Data gaurd and ASM.
* knowledge on Exadata Metrics and Alerts Architecture
* Generating report through monitoring Tools such as exachk, Exa/oswatcher, sundiag, sosreport,ILOM snapshot and its analysis
* Exadata machine maintenance tasks such as shut/start, power off/on whole and individual components
* Backup and recovery process of databases and Exadata components.
* Shell scripting to monitor the Infrastructure using the dcli and impitool packages on Exadata.
* Troubleshooting various issues on Exadata and communication between various
* Database upgrades
* Experience in global delivery

* *Typical database administrative tasks include: monitoring, performance tuning, trouble-shooting, back-up and recovery, installations and configurations on as needed basis as well as applying patches and upgrades.
* Responsible for managing Development, Test, QA and Production databases and implementing future Oracle enhancements to meet the business needs of the end users.
* *Develop, manage and test back-up and recovery plans and procedures during quarterly or as desired by business, Disaster Recovery exercise
* *Responsible for implementation and release of database changes as submitted by the development team
* *Provide capacity planning for production/non-production database using SQLreports
* Knowledge on Exadata Database Machine Architecture and its components
* Knowledge on Exadata Networking-ib listeners, scan, bonded interfaces.
* Well aware on various failover scenarios of Exadata