SQL DBA

IT

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

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