About this role
SUMMARY
The Database Administrator (DBA) will possess extensive knowledge and practical experience in supporting enterprise database environments with MS SQL, along with proficiency in one or more of the following: Oracle, MongoDB, mySQL, MariaDB, PostgreSQL. The DBA’s responsibilities include managing database operations such as installations and upgrades, data access and migration, high availability, monitoring, and troubleshooting. Furthermore, they will provide technical leadership in areas including database design and solutioning, security, performance tuning, and capacity planning to ensure robust support for business-critical applications.
KEY DUTIES & RESPONSIBILITIES
Database Management:
- Manage all database instances, including creation, configuration, and monitoring
- Proactively ensure optimal availability and performance of the database systems
- Ensure 24x7 operations of customer-critical database systems
- Implement and support cloud-based database solutions
- Provide guidance on data modelling, database design and infrastructure
- Design and implement highly available, redundant database solutions
- Generate standard operating procedures for database operations in order to standardize all relevant database activities
Database Application Support:
- Provide support for database applications, ensuring optimal performance and reliability
- Collaborate with development teams to design and implement database solutions
- Troubleshoot and resolve database-related issues promptly
- Support code or release deployment process
Performance Tuning:
- Perform system and query tuning to optimize database performance
- Analyze and resolve performance bottlenecks
- Implement best practices for database performance and scalability
Patching and Security:
- Plan and support internal projects such as database patching, migrations and upgrades
- Accountable for database security and integrity
- Ensure compliance with security policies and standards
- Assist in designing backup, recovery and DR strategies
- Investigate and implement new features within continuous service improvements process
- Facilitate audit discoveries and remediation activities
Monitoring and Maintenance:
- Utilize and maintain SQL monitoring tools
- Conduct regular health checks and performance assessments
- Conduct capacity planning and growth projections
- Propose and develop automated solutions for routine database processes, tasks, and procedures to improve efficiency
Additional:
- Follow operational policies and processes that are compliant with ITIL standards
- Track projects and system incidents through to resolution via the IT ticket tracking system and the various IT Logs
- Participate in project and team meetings - interacting and collaborating with team members and other departments as required
- Maintain qualifications and continuous learning relevant to your role
- Other duties as assigned
KNOWLEDGE & SKILLS
- 2-5 years of proven experience as a Database Administrator
- Post-Secondary education in IT or related discipline
- Extensive hands-on experience building and managing MS SQL servers and databases
- Proficiency with one or more of the following database systems: Oracle, MongoDB, MySQL, MariaDB, PostgreSQL, and/or other
- Experience designing, configuring and managing High Availability (HA) and Disaster Recovery (DR) database solutions
- Experience in performance tuning, monitoring, backup and recovery
- Extensive hands-on experience with the following MS SQL Server database technologies: SSRS, SSIS, SSAS and T-SQL
- Knowledge of various types of file and data structures, understanding of concepts relating to Data Warehouses
- Proficient in dimensional modeling, application design and development
- Possess strong security practices with regards to authentication, authorization, compliance, and encryption
- Experience managing database systems on physical, virtual and cloud environments
- Experience with Windows and Linux operating systems
- Familiarity with Azure or AWS services is a plus
- Knowledge of scripting languages (e.g., Python, Shell scripting) for automation
- Knowledge of SQL monitoring tools (e.g., Redgate SQL Monitor, SolarWinds, Oracle Enterprise Manager, dbWatch)
- Good verbal and written communication skills (English)
- Ability to work effectively under pressure and manage multiple, concurrent and conflicting priorities and deadlines
- Ability to work both independently with minimal supervision and in a team environment
- Willingness to learn and adapt in a fast pace, dynamic environment
- Excellent customer service skills, with a clear understanding of customer impact and business requirement
- Technical writing including documentation of procedures
Licenses and/or Professional Accreditation
- Certificate in MS SQL database administration
- Certificate in one or more additional database systems (e.g. Oracle, MongoDB, MySQL, MariaDB, PostgreSQL) – Preferred
- MS Azure SQL certifications – Preferred
- ITIL Foundation - Preferred
This is a regular, full-time position with a salary range of $73,600 - $92,000 per annum. The starting salary will be based on the successful candidate’s competencies, including but not limited to experience, education, professional designations and performance related to this role.
#LI-Hybrid
We value transparency in our hiring processes. Please note, artificial intelligence may be used in certain stages to screen, assess, or select applicants, however, a human reviewer makes all final decisions. This posting is for an existing vacancy.
BGIS is a global leader in integrated facility management services. With a combined team of over 10,000 globally, BGIS relentlessly focuses on delivering innovative service solutions that create value for its clients. Globally, BGIS manages over 50,000 facilities totaling more than 600 million square feet across several markets including government, higher education, utilities, telecommunications, financial services, oil & gas, healthcare and cloud enterprise. In addition to managing a diverse portfolio of corporate offices, retail, colleges, hospitals and industrial assets, BGIS is a world leader in the management of data centers and other critical environments.
Other facts
About BGIS
BGIS is a global leader in integrated facility management services.
With a combined team of over 10,000 globally, BGIS relentlessly focuses on delivering innovative service solutions that create value for its clients. Globally, BGIS manages over 50,000 facilities totalling more than 600 million square feet across several markets including government, higher education, utilities, telecommunications, financial services, oil & gas, healthcare and cloud enterprise. In addition to managing a diverse portfolio of corporate offices, retail, colleges, hospitals and industrial assets, BGIS is a world leader in the management of data centers and other critical environments.
-
BGIS est un leader mondial des services de gestion intégrée des installations. Plus de 600 millions de pieds carrés de portefeuilles clients répartis sur plusieurs marchés, notamment ceux des gouvernements, de l’enseignement supérieur, des services publics, des télécommunications, des services financiers, du pétrole et du gaz, des soins de santé et de l’information dans les nuages. En plus de gérer un portefeuille diversifié de bureaux, de commerces de détail, de collèges, d'hôpitaux et d'actifs industriels, BGIS est un leader mondial de la gestion de centres de données et d'autres environnements critiques.
What you'll do
- The Database Administrator will manage database operations including installations, upgrades, and troubleshooting while ensuring optimal performance and availability. They will also provide technical leadership in database design, security, and capacity planning.
Ready to join BGIS?
Take the next step in your career journey