Senior Database Administrator

Role Overview

Join our Digital Engineering Solutions team as a Senior Database Administrator, responsible for designing and implementing cloud-based solutions, ensuring software development and operations teams work collaboratively, and showcasing exceptional abilities in implementing solutions for AEC initiatives.

What You Will Do

Take ownership of projects, design database schema and data models, establish security measures, monitor database performance, develop disaster recovery strategies, implement data governance procedures, and manage and maintain databases.

Why It Might Be a Fit

Ideal candidate will be a critical thinker, proactive, and highly interested in new technologies and methods, with extensive background in application development, security, scaling, integration, and application migration.

Requirements

• 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 of high-volume instances of Azure SQL configurations that feature high availability
• 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 are applied to the management of all database instance
• 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 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 controls systems (DevOps, GitHub, SVN, or TFS)
• Working Knowledge in Release management, and Bug tracking tools
• Knowledge with OWASP security principles, security compliance tools
• Proficient in documenting, communicating, and coordinating, and capable of working efficiently under pressure

Benefits

• Competitive salary
• Opportunities for professional growth and development
• Collaborative and dynamic work environment
• Access to cutting-edge technologies and tools
• Opportunities for innovation and creativity