Database Admin - Vancouver
Database Admin - Vancouver
Posted on :
26-08-2024
Employer Active
1 Vacancy
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Note: This position does not offer any visa sponsorships.
We are seeking a skilled and experienced Database Administrator (DBA) to manage and maintain our database systems ensuring their performance availability and security.
Job Summary: As a Database Administrator you will be responsible for the installation configuration maintenance and performance of critical database systems. You will work closely with IT teams to support development production and reporting environments ensuring optimal performance and reliability of database services.
Key Responsibilities:
- Install configure and maintain database management systems (DBMS) including SQL Server Oracle MySQL or PostgreSQL.
- Monitor database performance implement changes and apply new patches and versions when required.
- Perform database tuning and optimization to ensure high performance and availability of the databases.
- Develop implement and maintain database backup and recovery procedures.
- Ensure the security of databases including data integrity access controls and audit trails.
- Troubleshoot and resolve databaserelated issues ensuring minimal downtime.
- Design and implement database schemas tables views indexes and stored procedures.
- Collaborate with development teams to design and optimize database solutions that meet application requirements.
- Conduct capacity planning and performance analysis to anticipate future database needs.
- Implement and manage data replication clustering and other high availability solutions.
- Manage and monitor database storage memory and other resource usage.
- Prepare and maintain documentation including data standards procedures and definitions for the data dictionary.
- Ensure compliance with industry regulations and company policies regarding data management.
Qualifications:
- Bachelor s degree in Computer Science Information Technology or a related field.
- 5 years of experience as a Database Administrator with a strong understanding of database architecture management and performance tuning.
- Proficiency with one or more DBMS such as SQL Server Oracle MySQL or PostgreSQL.
- Experience with database backup recovery and security procedures.
- Strong knowledge of SQL and experience with writing complex queries stored procedures and triggers.
- Familiarity with database design normalization and data modeling techniques.
- Experience with database monitoring and performance tuning tools.
- Knowledge of scripting languages (e.g. Python PowerShell) for automation tasks.
- Strong problemsolving and analytical skills.
- Excellent communication and collaboration skills with the ability to work effectively in a team environment.
Preferred Qualifications:
- Experience with cloudbased database solutions (e.g. AWS RDS Azure SQL Database).
- Familiarity with DevOps practices and tools related to database management.
- Relevant certifications (e.g. Microsoft Certified: Azure Database Administrator Oracle DBA Certification).
- Experience with data warehousing ETL processes and big data technologies.
Qualifications: Bachelor s degree in Computer Science, Information Technology, or a related field. 5+ years of experience as a Database Administrator, with a strong understanding of database architecture, management, and performance tuning. Proficiency with one or more DBMS, such as SQL Server, Oracle, MySQL, or PostgreSQL. Experience with database backup, recovery, and security procedures. Strong knowledge of SQL and experience with writing complex queries, stored procedures, and triggers. Familiarity with database design, normalization, and data modeling techniques. Experience with database monitoring and performance tuning tools. Knowledge of scripting languages (e.g., Python, PowerShell) for automation tasks. Strong problem-solving and analytical skills. Excellent communication and collaboration skills, with the ability to work effectively in a team environment. Preferred Qualifications:
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
