SQL DBA

Info-Ways; Brampton; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology solutions provider is seeking a SQL DBA in Brampton, ON for a 6+ month role. Responsibilities include monitoring SQL services, troubleshooting technical issues, and ensuring adherence to SLAs. Ideal candidates will have basic database knowledge and excellent communication skills. Experience with database migration and customer handling is preferred. This position provides an opportunity to develop skills and work within a supportive team environment.

Qualifications

• Experience in Database Migration, Installation, Upgrades and Patching.
• Working Knowledge on Clusters, Logshipping, Replication & Mirroring.
• Excellent communication and documentation skills.

Responsibilities

• Monitor and troubleshoot technical issues with team assistance.
• Ensure adherence to SLAs and processes.
• Manage SQL services, backups, and user accounts.

Skills

Communication skills

Basic knowledge of Databases and OS (Unix and Windows)

SQL Network configuration

Knowledge of SSRS & SSIS

Customer handling skills

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.