Closed listing
SQL DBA
- Brampton, ON, Canada
On-site
Contract
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Contract
- Workplace
- On-site
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Company Description
IT
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.
More about this job
Responsibilities
The SQL DBA at Info-Ways will monitor databases daily, handle support tickets and escalate issues to the next DBA level. The work covers backups, logins, SQL services and jobs, all under SLAs and standard procedures.
Requirements
Candidates need basic knowledge of databases and Unix and Windows, plus working SQL Server skills such as backups, logins, services and T-SQL. Strong written and verbal communication and documentation skills are also required.
Skills
- SQL Server
- T-SQL
- SSRS
- SSIS
- Database monitoring
- Backup and recovery
- Login and user management
- SQL Server Agent jobs
- SQL Server services
- MSSQL alert log
- Windows Event Logs
- Unix
- Windows Server
- Log shipping
- Replication
- Database mirroring
- Clustering
- Database migration
- Database upgrades and patching
- ER diagrams
- Ticket handling
- Incident troubleshooting
- Standard operating procedures
- Microsoft Office
- Documentation
Categories
- Technology
- Software
- Data & Analytics
Keywords
- SQL Server
- MSSQL
- T-SQL
- Database Administrator
- DBA
- SSRS
- SSIS
- SQL DBA
- Database monitoring
- Backup and restore
- Log shipping
- Replication
- Database mirroring
- Clustering
- Unix
- Windows
- Database migration
- Patching
- Production support
- SLA
Seniority
Entry level
Tools
- MS Office
Languages
- English