Glenn Partners Staffing Solution


Go Back To Job Listing


Job ID1125
Job TitlePostgreSQL DBA Contactor
Permanent/Contract Contract
Travel (%)0
Date Posted 2017-09-27
CityToronto
State/Province ON
CountryCanada
Job Description A bank in Downtown Toronto is looking for a PostgreSQL DBA. 1 year contract.The main function of a Database Administrator is to provide database support for PostgreSQL with some exposure to MSSQL Job Responsibilities: • Provide on-site and remote database and system support 24x7 • Monitor the system, and act upon system and application automated alerts • Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems) • Plan and perform software installation, configuration, upgrade and patching • Plan and perform database configuration, maintenance, upgrade and patching • Perform and manage system and database backups • Perform manual switch to redundant system / database components, in case of system failure
Job Requirements Must Have Skills: 1) Over 5 years of experience as a DBA (Postgre SQL is key) 2) Experience with PostgreSQL 9.5/9.6 Deployment and Administration is a must 3) Experience on Linux RHEL 6.5/7.2 administration of disks, mailx, crontab, shell programming, etc. 4) Experience on PostgreSQL Stream replication, Table replication, database links, Table 5) Experience with database security TLS 1.2, SSL, LDAP configuration and maintenance. Nice to have • Experience with MSSQL services (SSRS/SSAS/SSIS) and SQL Mirroring/Always-On • Experience on Windows server 2012/2008R2/2008 • Experience with application side tuning versus server side tuning. • Experience with Linux shell , VB, C#, Power shell, SQL • Experience in Agile, CiaD, Puppet, Docker Qualifications: • Bachelor's degree in a technical field such as computer science, computer engineering or related field required • Over 5 years Database Administration experience • Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution • Experience with PostgreSQL 9.5/9.6 Deployment and Administration is a must. • Experience on Linux RHEL 6.5/7.2 administration of disks, mailx, crontab, shell programming, etc. • Experience on PostgreSQL Stream replication, Table replication, database links, Table partition • Experience with database security TLS 1.2, SSL, LDAP configuration and maintenance. • Experience with MSSQL services (SSRS/SSAS/SSIS) and SQL Mirroring/Always-On • Experience on Windows server 2012/2008R2/2008 • Experience with application side tuning versus server side tuning. • Experience with Linux shell , VB, C#, Power shell, SQL • Experience in Agile, CiaD, Puppet, Docker DB technology. i.e. PostgreSQL is the main and key skills we are looking MSSQL is secondary and nice to have.
     
Click here to upload your resume, and remember to list the Job ID(s).
Copyright © 2008 Glenn Partners Staffing Solution Inc. postmaster@glennpartners.com