Infoways→

SQL DBA at Infoways in Brampton, Ontario, CA

Mid LevelOn-siteContractBrampton, Ontario, CA

Skills

sql servermssqlt-sqlunixwindowsssrsssisdatabase architecturelogshippingreplicationmirroringclusterser diagramscommunicationdocumentationcustomer handlingproblem solvingadaptabilityother rdbmsdatabase migrationinstallationupgradespatchingdatacenter understanding

Job Description

Company Description

Job Description

Role: SQL DBA Location: Brampton, ON Duration: 6+ Months

BGV will be done for the selected candidates.

Responsibilities :-

```
  Adhering to SLAs
```

  Reporting to the Track Lead / Team Lead

```
  Handling tickets / requests
```

  Troubleshooting technical issues with help of Other Team members

  Ensuring that the processes are adhered to

  Responsible for Monitoring and basic day to day Activities

  Ensure maximum uptime according to the SLA

  Making sure initial Troubleshotting is done before escallation to the Next level of DBA

  Doing the Daily Checks and initial level of investigation for the Errors.

Able to do the basic tickets and capabilities of Learning to the next level

Technical Requirements

  Availibility Management for Databases.

```
  Monitoring and Basic Troubleshoting.
```

  Having Basic knowledge about Databases and OS (Unix and Windows)

  Good in Concepts of Database Architecture and Daily Activities like startup/Shutdown.

  Can take up daily activities based on SOP(Standard Operating Procedures)

```
  Managing Logins/User Accounts.
```
Skill to manage SQL Network configuration
Diagnosing Backup Failure and Starting a failed Backup
Starting and Stoping a SQL Services
Identifying job history, Starting and Stoping a job
Should be able to check MSSQL Alert log and Windows Logs

  Capable of Moving to L2 with assitance.

```
  knowledge of SSRS & SSIS
```

  Good Understanding of Roles and Privs and should be capable of Doing the job of Junior DBA.

 Should monitor the Daily Backups/Threshold Mails and do the basic checks on the Database.

Soft Skills

  Excellent communication and conversation skills (Verbal and Written)

```
  Good documentation skills
```
```
  Good working knowledge of MS OFFICE
```

  Should have a good customer handling skills

```
  Able to handle unforeseen situations
```
```
  High level of acceptance
```

  Can drive HCL’s value and its methodology

Other Skills / Experience

```
 Worked on Production systems
```

  Experience with Database Migration, Installation, Upgrades and Patching

Datacenter understanding
```
  Knowledge of Other RDBMS is a Plus
```

  Experience in T-SQL and worked on ER Diagrams.

  Working Knowledge on Clusters,Logshipping,Replication & Mirroring

Additional Information

All your information will be kept confidential according to EEO guidelines.