CL-Database Administrator – Senior (Production Support Services) – Edmonton

  • Company:
  • Location:
  • Salary:
    negotiable / monthly
  • Job type:
  • Posted:
    10 hours ago
  • Category:

The successful candidate will be responsiblefor building, maintaining, and performance tuning production databases to deliver databases with appropriate levels of data availability and performance. This role is also responsible for developing, implementing, and overseeing database procedures and standards. Job Responsibilities: Provide technical expertise in database management systems to support systems development and operational activities. Create and maintain the logical and physical structures of databases and related structures required by database applications. Monitor database applications, databases and DBMS statistics and make the appropriate changes to improve performance. Maintain database authorization requirements. Maintain and enforce database security standards and procedures. Evaluate application and user requirements and make appropriate database modifications. Provide technical expertise to development teams, Application Maintenance Services and business teams. Perform troubleshooting activities for database problems, database software problems and database application problems. Perform DBMS software installations, plan and test upgrades. Plan, test and implement software patches and application updates or upgrades. Disaster recovery preparation and testing. Develop and maintain technical documentation. Develop and automate system related procedures. Perform problem diagnosis, troubleshooting and resolution. Monitor on-going operations and perform on-going system administration tasks: release new versions; database tuning; capacity planning; historical archiving; database consistency and integrity checking; log file analysis; job scheduling; scripting; indexes; reorganizations; change control; and server requirements analysis. Requirements University graduate of information management or related discipline & 4 years DBA experience or; 2 year diploma in information systems or a related discipline from a recognized post-secondary institution & 6 years DBAexperience or; Currently active professional certification or accreditation in a related discipline from a recognized issuing body & 7 years DBA experience or; 8 years of DBA experience 8 years ofDemonstrated DBA experience within a large complex environment of similar size and complexity to our client. This would mean an environment consisting of multiple versions of SQL Server existing in both development and production environments 8 years of experience withany version of SQL Server 2 years of experiencewith SQL Server 2016 6 years of experience with T-SQL 4 years of experience with SQL Server Integration Services 4 years of experience with SQL Server replication 4 years of experience with SQL Server Reporting Services 4 years of Experience as a SQL Infrastructure DBA(Backups, replication, installation, configuration) Desired Skills: 4 years experience working in a Help Desk type of environment where the work is delivered through a ticket or email 4 years experience working in an multi-tenancy environment where developers do not have access to secured environments like User Acceptance Test or Production 2 years demonstrated experience troubleshooting performance issues within SQL Server 2012 or higher If you are interested in this opportunity, please apply with an updated resume in MS Word Format. Due to the volume of resumes wereceive, only those applicantswhose skill set match our requirements will be contacted. All applicants must have legalauthorization to work in Canada for an unlimited period of time.