SQL DBA Walkins in Chennai | HCL Technologies Ltd | 8th October 2011

HCL Technologies Ltd. (www.hcl.com)







(Experienced) Walk-In : Employee Referral : Database Administration (Oracle & MSSQL) - L3 @ Chennai

..................................................

Employee Reference Details

Employee Name : Harish Sharma K
Employee ID : 51395696

Note: If you meet the Eligibility Criteria, You can write these Employee Reference Details at the top of your resume and attend the Walk-In. You can also fill in these details in Recruitment Application Form.

..................................................

Job Position : Oracle DBA / MSSQL DBA

Walk-In Location : Chennai, Tamilnadu

Job Location(s) : Chennai, Tamilnadu

Desired Qualification : BE / B.Tech / MCA / B.Sc / B.Com

Desired Experience : 6+ Years (Mandatory)

Job Description for Oracle DBA :
• Minimum 6 yrs relevant experience on 11g / 10g Oracle Database Administration
• Should have worked extensively on Production systems
• Experience with Database Migration, Installation, Upgrades and Patching
• Experience on HA
• Database Cloning
• Backup and Recovery Strategies using RMAN
• Flash Recovery Features & Flash back query
• Managing Alerts and Notifications
• Black-out Administration
• Cross platform transportable Tablespaces
• Proficient with Oracle RAC (Real Application Clusters)*
• Cluster Maintenance (Failover / Fail-back) at the Operating System Level
• Knowledge of Data Guard / Gateways

Job Description for SQL DBA :
• Minimum 6 yrs relevant experience on SQL Server Database Administration
• Should have worked extensively on Production systems
• Installation & Configuration of MS SQL Server 2005
• Performance monitoring (SQL profiler, Performance dashboard, Perfmon, Spotlight, etc)
• Performance tuning existing code with developers .
• Database fragmentation & compression
• Apply Patches & Hot fix
• Database Mirroring (Build, Roll, maintenance & troubleshooting)
• Replication (Transactional & Peer to Peer)
• Clustering ,Backups & restores
• Server monitoring (MOM, Tivoli, etc)
• Data modeling
• SQL Server Integration Services (SSIS)
• experience on operational incident and project case
• Experience on SQL Server 2008 would be added advantage

Please Carry (mandatory) :
• Updated Resume Copy
• Photo ID proof
• Latest Pay Slips

Walk-In Date : On 8th October 2011 (Saturday) : 10 AM to 4 PM

Walk-In Venue : 
HCL Technologies Ltd.,
SEZ Unit, ETA Techno Park,
4th Floor, Block–1, No. 33,
Old Mahabalipuram Road,
Navalur Village, Chengalpet Taluk,
Kancheepuram Dist,
Chennai - 603103

SQL DBA Walkin at TCS Chennai on 9th October 2011

Interview with TCS Chennai for SQL DBA on 9/10/2011(Sunday)

Tata Consultancy Services (TCS)

3 - 8 Years

Location:

Chennai

Education:

UG - Any Graduate - Any Specialization,Graduation Not RequiredPG - Any PG Course - Any Specialization,Post Graduation Not Required

Industry Type:

IT-Software/ Software Services

Role:

System Admin

Functional Area:

Systems, EDP, MIS

Posted Date:

03 Oct

Job Description

Greetings from TCS!!!

We have immediate opening for SQL Database Administrator.

Experience: 3 - 8 yrs

Interview Location: Chennai

Job Location: Chennai

Candidates should have hands on experience with:

Monitoring:

Scheduled job monitoring

Backup monitoring

SQL Server monitoring

Replication monitoring

Backup and Recovery:

Setting up backups for new databases

Recovery of databases from backups

Install and upgrades:

SQL Server Software Installation Support

SQL Service pack and patches Update

Database creation and file group allocation

Linked Server Creation and issues

Sql Server upgradation.

Performance Tuning:

Trace Analysis

Query Optimization and Query Execution plan Analysis

Database parameters tuning

Security:

SQL Login, database user creation and granting access

Schema creation and granting access

Managing user privileges

Scheduled Maintenance:

Re-Indexing

Update Statistics

Shrink Database

Removal of trace files/old log files

Miscellaneous:

Addressing database space issues

Incident management and Change Management

Database shutdown / restart for any scheduled maintenance tasks not related to database (like OS/SAN maintenance activities)

Permanent fixes for repetitive problems

Non-Production environment refreshes(backup/restore)

Troubleshooting space issues like transaction log full,data file full,clearing the drive space

Troubleshooting deadlock and blocking issues.

Database mirroring, Log shipping, Database snapshots and clusters.

Capacity Planning:

Analysis of database growth and recommendations for additional capacity (hardware, memory etc)

 

Interview Date:9th October 2011(Sunday)

Interview Time: 9.30 am - 1.00 pm

Contact Person: Julie

Interested candidate please find the below venue:.

Tata Consultancy Services

165/ 1A, Velachery – Taramani 100 Feet Road,

Velachery,

Chennai 600042

Regards,

Julie

Tata Consultancy Services

165/1A, Velachery – Taramani 100 Feet Road, Velachery,

Chennai - 600 042

Contact No:04466167426

Website: http://www.tcs.com