Description
Who We Are
BGIS is a leading provider of customized facility management and real estate services. With our combined team of over 6500 globally we relentlessly focus on enabling innovation through the services we deliver while actively looking for new opportunities that will enable innovation for our clients businesses. Globally we manage over 320 million square feet of client portfolios across 30000 locations in North America Europe Middle East Australia and Asia. Further information is available at
SUMMARY
TheDatabase 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 DBAs 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 reliabilityCollaborate with development teams to design and implement database solutionsTroubleshoot and resolve database-related issues promptlySupport code or release deployment processPerformance Tuning :
Perform system and query tuning to optimize database performanceAnalyze and resolve performance bottlenecksImplement best practices for database performance and scalabilityPatching and Security :
Plan and support internal projects such as database patching migrations and upgradesAccountable for database security and integrityEnsure compliance with security policies and standardsAssist in designing backup recovery and DR strategiesInvestigate and implement new features within continuous service improvements processFacilitate audit discoveries and remediation activitiesMonitoring and Maintenance :
Utilize and maintain SQL monitoring toolsConduct regular health checks and performance assessmentsConduct capacity planning and growth projectionsPropose and develop automated solutions for routine database processes tasks and procedures to improve efficiencyAdditional :
Follow operational policies and processes that are compliant with ITIL standardsTrack projects and system incidents through to resolution via the IT ticket tracking system and the various IT LogsParticipate in project and team meetings - interacting and collaborating with team members and other departments as requiredMaintain qualifications and continuous learning relevant to your roleOther duties as assignedKNOWLEDGE & SKILLS
2-5 years of proven experience as a Database AdministratorPost-Secondary education in IT or related disciplineExtensive hands-on experience building and managingMS SQL servers and databasesProficiency with one or more of the following database systems : Oracle MongoDB MySQL MariaDB PostgreSQL and / or otherExperience designing configuring and managing High Availability (HA) and Disaster Recovery (DR) database solutionsExperience in performance tuning monitoring backup and recoveryExtensive hands-on experience with the following MS SQL Server database technologies : SSRS SSIS SSAS and T-SQLKnowledge of various types of file and data structures understanding of concepts relating to Data WarehousesProficient in dimensional modeling application design and developmentPossess strong security practices with regards to authentication authorization compliance and encryptionExperience managing database systems on physical virtual and cloud environmentsExperience with Windows and Linux operating systemsFamiliarity with Azure or AWS services is a plusKnowledge of scripting languages (e.g. Python Shell scripting) for automationKnowledge 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 deadlinesAbility to work both independently with minimal supervision and in a team environmentWillingness to learn and adapt in a fast pace dynamic environmentExcellent customer service skills with a clear understanding of customer impact and business requirementTechnical writing including documentation of proceduresLicenses and / or Professional Accreditation
Certificate in MS SQL database administrationCertificate in one or more additional database systems (e.g. Oracle MongoDB MySQL MariaDB PostgreSQL) PreferredMS Azure SQL certifications PreferredITIL Foundation - PreferredAt BGIS we believe that diversity and inclusion is a key business driver such that we never lose sight of its importance as it is woven into the fabric of our organization. We are committed to maintaining a barrier-free recruitment process by providing equal employment opportunities through recruiting and retention of individuals of all backgrounds. We recognize that promoting diversity is an essential component of our continuing pursuit for organizational success!
BGIS is an equal opportunity employer and we welcome you to apply for a position with us! If you require accommodation during the recruitment process please contact us at askHR . Upon request for accommodation we will consult with the applicant in question and provide or arrange for the provision of a suitable accommodation in a manner that takes into account the applicants accessibility needs due to disability.
#LI-Hybrid
Required Experience :
Unclear Seniority
Key Skills
Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle
Employment Type : Full-Time
Experience : years
Vacancy : 1