Description :

Job Description :

The individual will be part of the Development group within the Digital Engineering Solutions team, helping design and implement cloud-based solutions, facilitating the CI/CD pipeline, and ensuring that software development and operations teams work collaboratively.

An ideal candidate will be a critical thinker, proactive, and highly interested in the application of new technologies and methods. This individual must demonstrate exceptional ability to implement solutions for AEC initiatives involving cutting-edge technologies. As a member of the Digital Engineering Solutions team, the Development group will be engaged in research and development.

The following are the Key responsibilities for this position :

- Take ownership of the project and work independently in a collaborative environment.

- Engaged in the project workshops, collaborating with stakeholders and software developers to design the database schema and data models.

- Establish security measures for safeguarding private data, including encryption and access controls, and conduct routine database audits to find any possible vulnerabilities.

- Consistently monitors database performance and identifies bottlenecks that may impact the application's performance and responsiveness.

- Develop and oversee a strategy for disaster recovery (DRM) to protect and prevent data loss in the event of disasters or system failures.

- Implement data governance procedures and ensure that pertinent data regulations and standards are followed.

- Understanding the project's data security requirements, encryption techniques, and compliance regulations such as GDPR, CCPA, or HIPAA, and creating a strategy to support the project.

- Manage and maintain databases, conduct routine maintenance tasks, and ensure data availability and integrity.

- Collaborate with data analysts to provide them with well-structured data and insights needed for business intelligence and analytics.

- Creating, implementing, and evaluating database-driven applications while following security and performance best practices.

- Supporting Azure SQL, NoSQL, and other database needs for the project.

- Programming skills such as SQL, Python, PowerShell, and others to interact with databases and incorporate them into applications.

- Conduct continuous R&D to provide the team with innovative database features, capabilities, and applications that will enhance the solutions.

Skills and Abilities :

- Extensive and proven DBA expertise in large-scale SQL Server settings, including Azure managed instance databases.

- Proficient in delivering high- and low-level design (HLD and LLD) for projects, including ER diagrams, data models, and data pipeline flow.

- Proficient in the principles of database design, including managing high-volume instances of Azure SQL configurations that feature high availability, including the use of database performance optimisation and monitoring tools.

- Exceptional analytical and problem-solving abilities, enabling the rapid identification of the root cause of a problem.

- Proficiency in creating best practice policies and procedures for data security and integrity, along with the monitoring and restriction of database access.

- Experience managing data warehouses, data lakes, data bricks, and other cloud-based data storage solutions.

- Experience in the Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) of disaster recovery is applied to the management of all database instances.

- Proficiency with SQL, Python, PowerShell scripting, or related technologies for creating application dashboards for proactive monitoring and authoring automation scripts.

- Proficiency in overseeing cloud-based data storage systems, including data warehouses, data lakes, and data bricks.

- Experience with the principles and practices of master-slave replication and database storage engines.

- Proficiency with container technologies, Docker, Kubernetes, Azure DevOps pipelines, CI/CD, and data pipelines in cloud environments.

- Strong understanding of database security best practices.

- Knowledge of Azure cloud infrastructure and its capabilities.

- Working knowledge of the Agile/Waterfall approach and how the data pipeline fits into it.

- Working knowledge of microservices, monolith architecture, and web apps based on MVC, MVVM, and SPA.

- Knowledge of security regulations, such as Identity & Access Management (IAM), Customer Identity & Access Management (CIAM), and security authentication technologies.

- Working knowledge of development IDEs (Visual Studio, Eclipse, etc.).

- Experience with source control systems (DevOps, GitHub, SVN, or TFS).

- Working Knowledge of Release management and Bug tracking tools.

- Knowledge of OWASP security principles, security compliance tools.

- Proficient in documenting, communicating, and coordinating, and capable of working efficiently under pressure.

- Passion to remain competitive in the market by enhancing abilities with cutting-edge technologies.

Minimum Qualifications :

- Bachelors degree.

- 5 years of related experience.

- Equivalent additional directly related experience will be considered instead of a college degree.

Preferred Qualification :

- Azure certifications DP-300/DP-900 and accreditation preferred.

- Bachelors degree in software development, Engineering, or related industry