SQL Database Administrator (DBA)
About The Position
The Database Administrator (DBA) handles multifunctional database projects. You will administer development/ test databases. You will be primarily responsible for performing many related database functions across one or more teams. This may include: designing, implementing and maintaining new databases, backup/recovery and configuration management. You are able to install database management systems (DBMS); related software tools, and have working knowledge of operating systems. You should be also able to submit input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.
Requirements
- Must have 2 to 3 years overall SQL Server DBA experience supporting large-scale production systems, or equivalent.
- experience with MS SQL Server Administration for on-premise
- Atleast 2+ years SQL HA Clustering, Availability Groups, Mirroring, Log Shipping
- 2-3 years of experience with SQL programming and performance tuning
- Experience in writing T-SQL scripts and development of views, stored procedures, UDFs.
- 2-3 years of experience in Backup/Recovery
- 2-3 years of experience with shell scripting (Windows)
- Good experience building new system environments
- Must have eligibility for Reliability Clearance.
- English is required for this position as this role will regularly interact with stakeholders across Canada, US and other countries across our Global footprint where English is the common language.
Nice To Haves
- Relevant DB certification
- Cloud experience (AWS, Oracle, Azure, Google)
- Experience with other DB platforms including open source and No-SQL DB (Oracle, SQL, DB2, Sybase, MYSQL, Postgres, MongoDB, etc.)
Responsibilities
- Installation, configuration and patching of SQL server in clustered environments.
- Backup and restore of the databases.
- Performance tuning and optimization.
- Install database management systems (DBMS); related software tools, and has a working knowledge of operating systems.
- Should be able for on-call 24/7 support of the databases.
- Able to submit input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.
Benefits
- Information on benefits is here.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
