Sr. Database Administrator
MARSExtonUpdate time: December 10,2021
Job Description

About Bentley Systems

Bentley Systems (Nasdaq: BSY) is the infrastructure engineering software company. We provide innovative software to advance the world's infrastructure – sustaining both the global economy and environment. Our industry-leading software solutions are used by professionals, and organizations of every size, for the design, construction, and operations of roads and bridges, rail and transit, water and wastewater, public works and utilities, buildings and campuses, mining, and industrial facilities. Our offerings include MicroStation-based applications for modeling and simulation, ProjectWise for project delivery, AssetWise for asset and network performance, Seequent's leading geosciences software portfolio, and the iTwin platform for infrastructure digital twins. Bentley Systems employs more than 4,000 colleagues and generates annual revenues of more than $800 million in 172 countries.

www.bentley.com

 

 

 

Job Responsibilities:  

  • Work closely with the Enterprise Information Management Teams to rollout and maintain/support the Azure/On-Premises Data Warehouse, SAP, and corporate infrastructure environments.
  • Troubleshooting, problem resolution and issue management for all SQL Server problems and issues.
  • Perform Tuning and Optimization on Azure SQL DB, Azure/on-premises database/server and services.
  • Perform automation, audits, and review.
  • Collaborating with development teams to implement solution from development to QA to production.
  • Utilize ITIL based tools and change management processes – promote changes to QA and production.
  • Participate in on-call rotation (Provide 24x7 support for critical production systems).
  • Assisting Bentley’s NOC team to provide monitoring for Azure/On-Premises SQL database environments

 

Essential Skills:

  • Minimum of 10+ years of experience supporting Microsoft SQL Server in a production environment is required. Must have Technical skills/experience in:
  • Manage and administer SQL Server databases, monitor system health and performance in Development/QA/Production environments.
  • Hands on Experience with High Availability (HA) and Disaster Recovery (DR) for SQL Server (AlwaysOn, Clustering, Replication, Mirroring, Log Shipping).
  • Install, configure, and administer clustered and stand-alone SQL Servers, SQL databases, SQL Agent jobs and alerts, database mail, linked servers, database/server security, and connectivity.
  • In-depth knowledge on database performance optimization, troubleshooting, problem resolution, root cause analysis, issue management.
  • Create and implementing backup/recovery strategy to meet requirements of RPO (Recovery Point Objective) and RTO (Recovery Time Objective).
  • Upgrade and migration of databases to new platform/server and maintain consistency between environments.
  • Develop automation for repeatable process.
  • Perform scheduled maintenance and support release deployment activities.
  • Knowledge of SQL Server development areas includes T-SQL, Stored Procedures, Functions, Triggers, and other objects with best practices and adopted standards.
  • Independent problem-solving skill.

 

Desired Skills:

  • Work with ITIL based Change Management tools and processes.
  • Knowledge of Microsoft Azure cloud data components such as Azure SQL, Azure Synapse Analytics, Azure Data Factory, Azure Storage (Blob/Data Lake), Azure migration.
  • Knowledge of cloud-based data-warehousing and tools: Snowflake, ThoughtSpot.
  • Experience with industry standard privacy and SOX related compliances.
  • Microsoft SQL Server version 2008 to current version.
  • Experience on SSIS/SSRS, TSQL, Power Shell Scripting.
  • Ability to detect and troubleshoot on SQL Server related CPU, memory, I/O, disk space issue.
  • Implementing and utilizing supported features with SQL Server like in-Memory, Change Data Capture, DReplay, Query Store, Full Text Indexing, Partitioning, Encryption etc.
  • Develop SSIS Packages, knowledge of Reporting (SSRS) and Analysis Services (SSAS).

#LI-KF1

 

Executive Order 1402, Ensuring Adequate COVID Safety Protocols for Federal Contractors

During the COVID-19 pandemic, Bentley has implemented several safety protocols to protect our colleagues, users, and wider communities. To ensure compliance with President Biden’s Executive Order 1402, Ensuring Adequate COVID Safety Protocols for Federal Contractors, all U.S. colleagues, regardless of work location or employment type, will be required to be fully vaccinated against COVID-19 by January 4th, 2022 as a condition of employment. Exemption is available as a reasonable accommodation for those who are unable to meet the vaccination requirements due to a disability/medical condition or sincerely held religious belief.

 

Equal Opportunity Employer

Bentley is an equal opportunity employer and considers all qualified applicants for employment without regard to race, color, sex, sexual orientation, gender identity, disability, protected veteran status, religion, national origin, age, or any other protected characteristic.  This commitment extends to all aspects of employment, including, but not limited to, hiring, placement, promotion, compensation, and training. EEO is the Law and EEO is the Law Supplement documents provide additional information about your rights as an applicant under the law.

 

Bentley Policy on EEO, Affirmative Action and Pay Transparency Non-Discrimination https://prod-bentleycdn.azureedge.net/-/media/files/documents/careers/bentley-eeoaa-statement-of-policy.pdf?la=en&modified=20211005082651

 
Bentley participates in e-Verify / Bentley participa en e-Verify / Right to Work Notice 
https://prod-bentleycdn.azureedge.net/-/media/files/documents/careers/e-verify-poster.pdf?la=en&modified=20210929150033

 
Request an Accommodation

As an Equal Opportunity Employer, Bentley is committed to providing reasonable accommodations to applicants with disabilities. We encourage you to request a reasonable accommodation if you are not able to fully use or access our online application system.   You can make an accommodation request by calling 610-458-5000 or sending us an email at disabilityrequest@bentley.com.

Get email alerts for the latest"Sr. Database Administrator jobs in Exton"