SQL DBA

2 weeks ago

Brampton, Canada Info-Ways Full time

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.

#J-18808-Ljbffr

  • SQL DBA: Uptime

    2 weeks ago

    Brampton, Canada Info-Ways Full time

    A technology solutions provider in Peel Region, Brampton, is seeking a SQL DBA for a role that focuses on monitoring and troubleshooting databases while adhering to service level agreements (SLAs). The ideal candidate will have strong communication skills and be knowledgeable in database architecture and administrative tasks. Responsibilities include...

  • SQL Database Administrator

    6 days ago

    Brampton, Canada Cloudvital Technologies Full time

    A growing GTA based dynamic organization is looking to scale up its IT infrastructure with cloud Architecture and best in class security **Location**: The Office is located at the boundary of Mississauga and Brampton and the job requires presence in the Office, a few days every week. We are looking for an experienced Senior MSSQL Database Senior...